Download ODBC Drivers for Oracle, SQL Server, Salesforce, MongoDB, Access, Derby, InterBase & DB2.

What settings are required to run the ODBC-JDBC Gateway with the hsqldb database engine?

To access hsqldb by using the Easysoft ODBC-JDBC Gateway:

  1. Download the ODBC-JDBC Gateway for the platform on which your application is installed and then install the Easysoft ODBC-JDBC Gateway.

    For installation instructions, refer to the Easysoft ODBC-JDBC Gateway documentation.

  2. Add an ODBC-JDBC Gateway data source that connects to the hsqldb JDBC driver.

    Ensure that the values for the following Easysoft ODBC-JDBC Gateway data source settings match those shown in the table.

    ODBC-JDBC Gateway data source 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 host is the IP address or host name of the hsqldb database server. The optional port setting is only necessary if the hsqldb server port is different to the default. The optional alias setting is an alias that refers to the database you want to connect to. If omitted, a connection is made to the default database instance. For more information about hsqldb URL settings, refer to the hsqldb documentation.
    With Schema OFF (Not checked or set to 0)

    The database does not support two or three part names, so this option should not turned off.

    For information about other ODBC-JDBC Gateway data source settings, refer to the ODBC-JDBC Gateway documentation.