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 Java DB?

Article:
00958
Last Reviewed:
24th January 2024
Revision:
1

For embedded use:

ODBC-JDBC Gateway DSN Setting Value
Driver Class org.apache.derby.jdbc.EmbeddedDriver
Class Path jarfiledir\derby.jar

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

c:\jars\derby.jar
URL jdbc:derby:database

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

jdbc:derby:C:\javadb\testdb

For Network Server use:

ODBC-JDBC Gateway DSN Setting Value
Driver Class org.apache.derby.jdbc.ClientDriver
Class Path jarfiledir\derbyclient.jar

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

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

where database is the database you want to connect to and server is the machine where the database is running. For example:

jdbc:derby://dbserver.domain.com/C:\Program Files\JavaDB\demo\databases\toursDB

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

Applies To

Knowledge Base Feedback

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

(* Required Fields)