How to access Databases-in-a-Jar in the Class Pa

DBA > Job Interview Questions > DERBY Java Database FAQs

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How to access Databases-in-a-Jar in the Class Path?

Once an archive containing one or more Derby databases has been created it can be placed in the class path. This allows access to a database from within an application without the application's knowing the path of the archive. When jar or zip files are part of the class path, you do not have to specify the jar subsubprotocol to connect to them.

To access a database in a zip or jar file in the class path:
1. Set the class path to include the jar or zip file before starting up Derby:
CLASSPATH="C:\dbs.jar;%CLASSPATH%"
2. Connect to a database within the jar or zip file with one of the following connection URLs:
jdbc:derby:/databasePathWithinArchive
(standard syntax)
jdbc:derby:classpath:/databasePathWithinArchive
(syntax with subsubprotocol)
For example:
jdbc:derby:/products/boiledfood
jdbc:derby:classpath:/products/boiledfood

(Continued on next question...)