HSQLDB JDBC Driver and URL Information


Listed below are connection examples for HSQLDB:

HSQLDB Server


DRIVER CLASS: org.hsqldb.jdbcDriver

DRIVER LOCATION: Simply provide the location of the jar or zip file that contains the HSQLDB drivers. This file can be downloaded from HSQLDB. See HSQLDB's site for more information on obtaining the HSQLDB drivers.

JDBC URL FORMAT: jdbc:hsqldb:hsql://<host>:<port>

The default port for HSQLDB Server is 9001. Usually, if the default port is being used by the database server, the :<port> value of the JDBC url can be omitted.

Examples:

jdbc:hsqldb:hsql://neptune.acme.com:9001

jdbc:hsqldb:hsql://127.0.0.1:1476

HSQLDB Embedded


DRIVER CLASS: org.hsqldb.jdbcDriver

DRIVER LOCATION: Simply provide the location of the jar or zip file that contains the HSQLDB drivers. This file can be downloaded from HSQLDB. See HSQLDB's site for more information on obtaining the HSQLDB drivers.

JDBC URL FORMAT: jdbc:hsqldb:file:<filepath>