Testing network server connection with ij

[Aneez Backer <an...@yahoo.com>]

Hi

I am trying to establish multiple connections to the same derby database (located at D:/JavaWorks/Database/)

The embedded connection works fine, but when I try the network connection it gives the following error:
------------------------------------------------------------------------
D:\JavaWorks\Database>java org.apache.derby.tools.ij
ij version 10.3
ij> connect 'jdbc:derby://localhost:1527//D:/JavaWorks/Database/MyDbTest;create=
true';
ERROR 08001: No suitable driver found for jdbc:derby://localhost:1527//D:/JavaWo
rks/Database/MyDbTest;create=true
------------------------------------------------------------------------

My classpath is as follows

.;C:\Program Files\Apache Software Foundation\Tomcat 5.5\common\lib\servlet-api.jar;C:\Program Files\Apache Software Foundation\Tomcat 5.5\common\lib\jsp-api.jar;%DERBY_INSTALL%\lib\derby.jar;%DERBY_INSTALL%\lib\derbytools.jar;%DERBY_INSTALL%\lib\derbynet.jar;%DERBY_INSTALL%\lib\derbyclient.jar;


Please Guide

Aneez




            














       
---------------------------------
Never miss a thing.   Make Yahoo your homepage.

Re: Testing network server connection with ij

[John Embretsen <Jo...@Sun.COM>]

Aneez Backer wrote:
> Hi
> 
> I am trying to establish multiple connections to the same derby database 
> (located at D:/JavaWorks/Database/)
> 
> The embedded connection works fine, but when I try the network 
> connection it gives the following error:
> ------------------------------------------------------------------------
> D:\JavaWorks\Database>java org.apache.derby.tools.ij
> ij version 10.3
> ij> connect 
> 'jdbc:derby://localhost:1527//D:/JavaWorks/Database/MyDbTest;create=
> true';
> ERROR 08001: No suitable driver found for 
> jdbc:derby://localhost:1527//D:/JavaWo
> rks/Database/MyDbTest;create=true
> ------------------------------------------------------------------------

Try removing the second / before the drive letter in your database path, like this:

'jdbc:derby://localhost:1527/D:/JavaWorks/Database/MyDbTest;create=true';

You only need one / to separate the port number from the path, whether it is 
absolute or relative.

See also http://wiki.apache.org/db-derby/DatabaseNamesRelativeAbsolute .

-- 
John