Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 43563 invoked from network); 22 Jul 2008 13:24:34 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 22 Jul 2008 13:24:34 -0000 Received: (qmail 3668 invoked by uid 500); 22 Jul 2008 13:24:34 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 3204 invoked by uid 500); 22 Jul 2008 13:24:33 -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 3193 invoked by uid 99); 22 Jul 2008 13:24:33 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Jul 2008 06:24:33 -0700 X-ASF-Spam-Status: No, hits=-4.0 required=10.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [192.18.43.133] (HELO sca-es-mail-2.sun.com) (192.18.43.133) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Jul 2008 13:23:37 +0000 Received: from fe-sfbay-09.sun.com ([192.18.43.129]) by sca-es-mail-2.sun.com (8.13.7+Sun/8.12.9) with ESMTP id m6MDNp1L027652 for ; Tue, 22 Jul 2008 06:23:51 -0700 (PDT) Received: from conversion-daemon.fe-sfbay-09.sun.com by fe-sfbay-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) id <0K4E00701T4GST00@fe-sfbay-09.sun.com> (original mail from Richard.Hillegas@Sun.COM) for derby-user@db.apache.org; Tue, 22 Jul 2008 06:23:51 -0700 (PDT) Received: from richard-hillegas-computer.local ([129.150.16.229]) by fe-sfbay-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTPSA id <0K4E004HHT7QNK90@fe-sfbay-09.sun.com> for derby-user@db.apache.org; Tue, 22 Jul 2008 06:23:51 -0700 (PDT) Date: Tue, 22 Jul 2008 06:23:50 -0700 From: Rick Hillegas Subject: Re: Choosing Database Location Programatically with Embedded Driver In-reply-to: <166af1cf0807220529w7057623fub149a7674c0b9876@mail.gmail.com> Sender: Richard.Hillegas@Sun.COM To: Derby Discussion Message-id: <4885DF66.2040705@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=UTF-8 Content-transfer-encoding: 7BIT References: <166af1cf0807220529w7057623fub149a7674c0b9876@mail.gmail.com> User-Agent: Thunderbird 2.0.0.14 (Macintosh/20080421) X-Virus-Checked: Checked by ClamAV on apache.org Hi Pierre, The location of database files is determined by two variables: 1) the database location in your connection URL and 2) the location of the Derby system directory indicated by the "derby.system.home" system property. For more detail, please see the section titled "Connecting to databases" in the Derby Developer's Guide: http://db.apache.org/derby/docs/10.4/devguide/ In particular, please take a look at the subsection titled "Database connection examples". Hope this helps, -Rick Shinkan wrote: > Hi there ! > > I'm really happy that I discovered Derby. It's a perfect embedded > lightweight data management system ! > As I really think that documentation is complete, it's sometimes hard > to find something precise. > > I would like to know if I can (and how), using Java JDBC Derby > Embedded Driver, choose the location my database files are stocked in. > > Thanks a lot in advance for answers ! > > -- > Pierre. > Some people, when confronted with a problem, think "I know, I'll use > XML." Now they have two problems. -- Jamie Zawinski / James Robertson