Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 45201 invoked from network); 11 Mar 2005 21:37:50 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 11 Mar 2005 21:37:50 -0000 Received: (qmail 94586 invoked by uid 500); 11 Mar 2005 21:37:49 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 94564 invoked by uid 500); 11 Mar 2005 21:37:48 -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 94550 invoked by uid 99); 11 Mar 2005 21:37:48 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from i.meepzor.com (HELO Boron.MeepZor.Com) (204.146.167.214) by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 11 Mar 2005 13:37:48 -0800 Received: from [127.0.0.1] (c-24-6-128-94.client.comcast.net [24.6.128.94]) by Boron.MeepZor.Com (8.12.8/8.12.8) with ESMTP id j2BLbjK8017148 for ; Fri, 11 Mar 2005 16:37:47 -0500 Message-ID: <42320FA3.3050708@Source-Zone.Org> Date: Fri, 11 Mar 2005 13:37:39 -0800 From: Rajesh Kartha User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion Subject: Re: Derby Clarifications References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N >Problem1 >I tried a combination of relative urls to the database and cannot >connect.JRE is installed under C:\test\JRE so by right I should be >able to connect if >dbName = ../testDB .This or other combinations dont work > > > >Problem2 >Can I replace C:\test\testDB with with some thing like >localhost:port\test\testDB > > >Problem 3 > >I can run Derby in a server mode allowing muliple connections to it. >So if I create a non encrypted database in server mode providing my ip >and start it >then I can run it without hitches. > >But whenever I create a database in server mode using the additional parameter >of bootPassword. It fails complaining that the parameter for >bootPassword is incorrect. > > Here is what I tried, hope it helps answer the above questions. The ..\ or ../ in the url above is relative to the path you start your application {Network server (- network )or 'ij' (- embedded)} that boots the databases. Some examples: The Derby Network Server was started in the c:\temp\test directory (localhost and port 1527) (1) using '/' === C:\temp>java org.apache.derby.tools.ij ij version 10.1 ij> connect 'jdbc:derby:net://localhost:1527//temp/DERBY/testA;create=true;dataE ncryption=true;bootPassword=12345678:user=app;password=app;'; ij> quit; (2) using '\' === C:\temp>java org.apache.derby.tools.ij ij version 10.1 ij> connect 'jdbc:derby:net://localhost:1527/\temp/DERBY/testA;create=true;dataE ncryption=true;bootPassword=12345678:user=app;password=app;'; ij> quit; (3) using '../' === C:\temp>java org.apache.derby.tools.ij ij version 10.1 ij> connect 'jdbc:derby:net://localhost:1527/../DERBY/testB;create=true;dataEncr yption=true;bootPassword=12345678:user=app;password=app;'; ij> (4) using '..\' === C:\temp>java org.apache.derby.tools.ij ij version 10.1 ij> connect 'jdbc:derby:net://localhost:1527/..\DERBY/testC;create=true;dataEncr yption=true;bootPassword=12345678:user=app;password=app;'; ij> In all the above cases the databases testA, testB, testC were created in c:\temp\DERBY directory. Next the server was brought down and the above testB database created was booted using 'ij' from the c:\temp\test directory in the Embedded mode. ij version 10.1 ij> connect 'jdbc:derby:../DERBY/testB;bootPassword=12345678'; ij> -Rajesh