What settings are required to run the Easysoft ODBC-JDBC Gateway with Sun Java DB?

<a href="/cgi-bin/account/login.cgi">Log In</a><a href="/cgi-bin/account/logout.cgi">Log Out</a> / <a href="/cgi-bin/account/register.cgi">Register</a>

ODBC Drivers for Oracle, SQL Server, DB2, Firebird, ISAM, InterBase, Sybase, MS Access & more.

Easysoft ODBC-JDBC Gateway

What settings are required to run the Easysoft ODBC-JDBC Gateway with Sun Java DB?

Article:: 00958

Last Reviewed:: 14th November 2006

Revision:: 1

For embedded use:

Attribute Value

Driver Class org.apache.derby.jdbc.EmbeddedDriver

Class Path

Attribute	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`

<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:

Attribute Value

Driver Class org.apache.derby.jdbc.ClientDriver

Class Path

Attribute	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`

<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

See http://developers.sun.com/prodtech/javadb/.

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

Applies To

Products
- Easysoft ODBC-JDBC Gateway
Databases
- Java DB

Knowledge Base Feedback

© 1993 - 2013 Easysoft Limited. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

Easysoft ODBC-JDBC Gateway