Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 91933 invoked from network); 1 Feb 2006 18:05:38 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 1 Feb 2006 18:05:38 -0000 Received: (qmail 17725 invoked by uid 500); 1 Feb 2006 18:05:35 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 17687 invoked by uid 500); 1 Feb 2006 18:05:34 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 17676 invoked by uid 99); 1 Feb 2006 18:05:34 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Feb 2006 10:05:34 -0800 X-ASF-Spam-Status: No, hits=4.0 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,DNS_FROM_RFC_WHOIS,HTML_MESSAGE,RCVD_IN_SORBS_WEB X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [68.142.199.128] (HELO web81312.mail.mud.yahoo.com) (68.142.199.128) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 01 Feb 2006 10:05:33 -0800 Received: (qmail 13250 invoked by uid 60001); 1 Feb 2006 18:05:12 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=pacbell.net; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=Nmco45xBzt13CTlXGbVfk8WRmlY2m8tdjeQIVRRpTf7T8JB2rDdmyTRs2YzKXdAhLaJ8gZfJHgrzmKjhzrcjR+zRT3lyXrvqnE7Nt+BWpHcaf4Nk2vLq55RUHufCJWjSRjzcWfk4qjGKzmxtnQQ0MmnDTm3UK7T78HCXQ46nsRE= ; Message-ID: <20060201180512.13248.qmail@web81312.mail.mud.yahoo.com> Received: from [32.97.110.142] by web81312.mail.mud.yahoo.com via HTTP; Wed, 01 Feb 2006 10:05:12 PST Date: Wed, 1 Feb 2006 10:05:12 -0800 (PST) From: Susan Cline Subject: Fwd: Specifying the Derby Database Location To: derby-user@db.apache.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-2047212887-1138817112=:12036" Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N --0-2047212887-1138817112=:12036 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Afkham Azeez wrote: Date: Wed, 1 Feb 2006 11:26:50 +0600 From: Afkham Azeez To: derby-user@db.apache.org Subject: Specifying the Derby Database Location 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? -- Thanks in Advance Afkham Azeez Hi Afkham, I may be confused what you are trying to achieve - but let me try to answer your question. If you would like your database to be created under $MY_PROJECT, then your derby.system.home property should be set to $MY_PROJECT. Also, the location of the derby.properties file must be in derby.system.home in order for it to be read. So if you want derby.system.home to be $MY_PROJECT, then you will need to put your derby.properties file in this directory. However, you can connect to your database (or create it) from anywhere on the file system by starting the java application (or ij for instance in the example below) by issuing a command like this: java -Dderby.system.home=$MY_PROJECT org.apache.derby.tools.ij (as long as $MY_PROJECT is set as an environment variable of course.) Does this answer your question? Regards, Susan --0-2047212887-1138817112=:12036 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
Afkham Azeez <afkham@gmail.com> wrote:
Date: Wed, 1 Feb 2006 11:26:50 +0600
From: Afkham Azeez <afkham@gmail.com>
To: derby-user@db.apache.org
Subject: Specifying the Derby Database Location

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?
--
Thanks in Advance
Afkham Azeez

  Hi Afkham,

I may be confused what you are trying to achieve - but let me try to
answer your question.

If you would like your database to be created under $MY_PROJECT,
then your derby.system.home property should be set to $MY_PROJECT.

Also, the location of the derby.properties file must be in
derby.system.home in order for it to be read. So if you want derby.system.home
to be $MY_PROJECT, then you will need to put your derby.properties
file in this directory.

However, you can connect to your database (or create it) from
anywhere on the file system by starting the java application (or ij for
instance in the example below) by issuing a command like this:

java -Dderby.system.home=$MY_PROJECT org.apache.derby.tools.ij

(as long as $MY_PROJECT is set as an environment variable of course.)

Does this answer your question?

Regards,

Susan
--0-2047212887-1138817112=:12036--