db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rajesh Kartha <kar...@Source-Zone.Org>
Subject Re: Derby Clarifications
Date Fri, 11 Mar 2005 21:37:39 GMT

>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



Mime
View raw message