Embedded Derby JDBC database connection URL This is the standard JDBC connection URL, which you can use for tasks besides connecting to a database. Database connection URLsyntax Subprotocolpart of database connection URL syntax Subsubprotocolpart of database connection URL syntax directory subsubprotocolclasspath subsubprotocol jar subsubprotocolDatabase connection URLusing jdbc:derby:[subsubprotocol:][databaseName][;attribute=value]*

Subsubprotocol, which is not typically specified, determines how looks for a database: in a directory, in a class path, or in a jar file. Subsubprotocol is one of the following:

  • directory The default. Specify this explicitly only to distinguish a database that might be ambiguous with one on the class path.
  • classpath Databases are treated as read-only databases, and all databaseNames must begin with at least a slash, because you specify them "relative" to the classpath directory.
  • jar Databases are treated as read-only databases. DatabaseNames might require a leading slash, because you specify them "relative" to the jar file.

jar requires an additional element immediately before the database name:

(pathToArchive)

pathToArchive is the path to the jar or zip file that holds the database.

You typically pass the connection URL as an argument to the JDBC DriverManager.getConnection method call. For example:

DriverManager.getConnection("jdbc:derby:sample");

You can specify attributes and attribute values to a connection URL. For detailed reference about attributes and values, see the .