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
