db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Manoj Koshy <koshy.ma...@gmail.com>
Subject Re: Derby Clarifications
Date Sat, 12 Mar 2005 01:26:36 GMT
Thanks all. Let me try it out and see.
Once again thanks for the help.

Manoj

On Fri, 11 Mar 2005 13:37:39 -0800, Rajesh Kartha
<kartha@source-zone.org> wrote:
> 
> >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
> 
> 


-- 
Manoj Joseph Koshy
240 Lorong Chuan,#03-03,
Chuan Park,
Singapore

Mime
View raw message