Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: neutral (asf.osuosl.org: local policy)
Message-ID: <43E1031F.5020903@apache.org>
Date: Wed, 01 Feb 2006 10:51:11 -0800
From: Daniel John Debrunner <djd@apache.org>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
 rv:1.7.3) Gecko/20040910
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: Specifying the Derby Database Location
References: <9b85c45f0601312126p4fb1ed82qb33ec9dc0f776f06@mail.gmail.com>
 <43E0F734.1090202@gmail.com>
In-Reply-To: <43E0F734.1090202@gmail.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Manjula G Kutty wrote:

> Afkham Azeez wrote:
> 
>> Hi Folks,
>>
>> I have my derby.properties file in $MY_PROJECT/conf directory. This is
>> the directory pointed to by the derby.system.home System property. But
>> no my database is getting created under $MY_PROJECT/conf e.g. as
>> $MY_PROJECT/conf/DATABASE.
>>
>> I need my database to be created as $MY_PROJECT/DATABASE. Is there a
>> property I can specify in the derby.properties file which will specify
>> the physical location of the Database?

This is a good candidate for a Derby FAQ.

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

HTH,
Dan.