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

What settings are required to run the ODBC-JDBC Gateway with Apache Derby or IBM Cloudscape 10+?

ODBC-JDBC Gateway data source setting Value
Driver Class org.apache.derby.jdbc.ClientDriver
Class Path jarfiledir\derbyclient.jar

where jarfiledir is the directory where the Derby driver .jar file is located. For example:

c:\jars\derbyclient.jar
URL jdbc:derby://localhost/database

where database is the database you want to connect to. For example:

jdbc:derby://localhost/C:\Program Files\IBM\Cloudscape_10.1\demo\databases\toursDB

Note Ensure that there are no trailing spaces left at the end of the Driver Class value.

For direct ODBC access to Apache Derby (no JDBC driver required), use the Easysoft Apache Derby ODBC driver.