Specifying the Database Name in a JDBC Connection URL

Database names in Derby are more than a single word, they are URL like in that they can include the URL path separator character forward slash '/'.

Database Names are either relative or absolute

An absolute path corresponds to an absolute path on your file system:

jdbc:derby:/home/fred/databases/projects/cdcollection

means the top level folder for the database is:

/home/fred/databases/projects/cdcollection

A JDBC connection URL of:

jdbc:derby:d:/home/2006/accounts

means the top level folder for the database is:

d:\home\2006\accounts

A relative path is relative to the value of the system property derby.system.home if it is set, otherwise relative the current working directory of the java virtual machine.

All these examples are different ways to connect to the cdcollection database described above, examples on windows would be similar, including use of the forward slash.

  derby.system.home=/home/fred/databases
  jdbc:derby:projects/cdcollection

  derby.system.home=/home/fred/databases/projects
  jdbc:derby:cdcollection

  current working directory = /home/fred
  jdbc:derby:databases/projects/cdcollection

  current working directory = /home/fred/databases/projects
  jdbc:derby:cdcollection

This wiki entry is originally from a post by Dan Debrunner on the derby-users mailing list on February 1, 2006.

  • No labels