[Db-derby Wiki] Update of "DatabaseNamesRelativeAbsolute" by SusanCline

[Apache Wiki <wi...@apache.org>]

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by SusanCline:
http://wiki.apache.org/db-derby/DatabaseNamesRelativeAbsolute

New page:
= 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 
'/'.

A database name is either relative or absolute.

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

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

   top level folder for the database is
    /home/fred/databases/projects/cdcollection


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

  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