To access hsqldb by using the Easysoft ODBC-JDBC Gateway:
For installation instructions, see the Easysoft ODBC-JDBC Gateway documentation.
Ensure that the values for the following Easysoft ODBC-JDBC Gateway data source settings match those shown in the table.
Setting | Value |
---|---|
Driver Class |
org.hsqldb.jdbcDriver
Ensure that there are no trailing spaces at the end of the Driver Class value. |
Class Path | hsqldb.jar |
URL |
jdbc:hsqldb:hsql://host[:port][/alias]
where |
With Schema |
OFF (Not checked or set to 0)
The database does not support two or three part names, so this option should not be enabled. |
For information about other Easysoft ODBC-JDBC Gateway data source settings, see the Easysoft ODBC-JDBC Gateway documentation.