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

Easysoft ODBC-JDBC Gateway

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

Article:
00735
Last Reviewed:
18th January 2024
Revision:
2

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

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

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

  2. Add a Easysoft 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.

    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, see 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 be enabled.

    For information about other Easysoft ODBC-JDBC Gateway data source settings, see the Easysoft ODBC-JDBC Gateway documentation.

Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)