Forum Discussion

Buschfunk's avatar
Buschfunk
Frequent Contributor
13 years ago

Cannot use HSQLDB JDBC driver

Affects version: soapUI Pro 4.5.1
OS: Windows XP SP3
Database: HyperSQL (HSQLDB)

Here are the steps to reproduce this behavior. At least that's what I have done


  • Download latest version 2.2.8 from HSQLDB and setup a database server.

  • Copy the hsqldb.jar to soapUI's bin\ext folder.

  • Create a new JDBC Template with the following content:

    • HypersonicSQL/org.hsqldb.jdbc.JDBCDriver

    • jdbc:HypersonicSQL:hsql://localhost:9001/myTestDB?user=username?password=password

  • Restart soapUI.

  • Test the JDBC connection.


What happens is an exception that no suitable driver was found though I have copied the .jar file to the ext folder. Please note that there is a HSQLDB JDBC template by default but this points to a driver called org.hsqldb.jdbcDriver which is not the one as contained in the original package.

Using another SQL client I can connect to the database.
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    13 years ago
    Hi,

    hm.. can you adjust the HSQLDB driver template in the global settings "JDBC Drivers Properties" to contain the correct driver class and recreate the connection afterwards!?

    regards,

    /Ole
    SmartBear Software
  • Buschfunk's avatar
    Buschfunk
    Frequent Contributor
    13 years ago
    I have already tried that, however without any effect I can see in the soapUI log that the hsqldb.jar is loaded and it is also possible to import this class using a Groovy script:

    import org.hsqldb.jdbc.JDBCDriver