Apache Derby Connection Help

RazorSQL ships with the JDBC drivers necessary to connect to both Derby Network server and Derby Embedded editions. Currently the driver version shipped with RazorSQL is version 10.5. If you are using a Derby database that is not compatible with the 10.5 drivers, you may need to download the Derby database drivers manually or using RazorSQL's auto download process available as a button click on the Derby add connection profile screen. There were some incompatibilities introduced with recent versions of Derby. For example, if a database is created with a newer version of the Derby drivers, it may not be able to be accessed using older Derby drivers. More information can be found at http://db.apache.org/derby/

There are two options when connecting to Derby databases. Users can either connect to a Derby database running as a server, also known as a Derby Network server, or to a Derby database running in embedded mode.

Derby Network Server

To connect to the network server, select the JDBC (Derby Network) connection type from the connection type list. Enter the login information and the host or ip address, port, and database name to connect to the server. For information on how to set up and install a Derby network server, check out the following link: http://db.apache.org/derby/manuals/index.html

Derby Embedded

To connect to an embedded derby database, select the JDBC (Derby Embedded) connection type from the connection type list. Enter any login information if applicable, and then specify whether to use an existing embedded database, or to have RazorSQL create a new embedded database.

If the embedded database already exists, browse to the directory of the existing database and select that directory.

If the database does not exist, type in or browse to create a new location for the derby database. This location will then serve as the parent directory of the embedded database.

Manual Derby JDBC Information

If manually configuring your connection, see the following for JDBC driver class and JDBC URL format. JDBC Information