db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stanley Bradbury <Stan.Bradb...@gmail.com>
Subject Re: TROUBLE CONNECTING TO SERVER USING CLIENT DRIVER
Date Fri, 11 May 2007 02:17:59 GMT
Raymond Kroeker wrote:
> Hi Dan,
>     It looks like the url you're using from the client isn't quite 
> right.  For a client/server url you want the logical database name in 
> the url after the port and not the path to the database.
>
>     So a single server can support multilple databases.  What you'll 
> want to try is something like
>
>     jdbc:derby://192.168.1.99:1527/apolloDB;create=true
>
>     instead of
>
>     jdbc:derby://192.168.1.99:1527/usr/local/derby/database/apolloDB
>
>     This too will create the db for you if it does not already exist.
=====  SNIP ====

The URL is incorrect resulting in the poor, confused client driver 
trying to find a host named 'connect' [note message: No route to 
host:connect].  Your URL needs another slash before 'usr' - the slash at 
the end of the port number is a URL delimiter then you another as part 
of the absolute path for the DB.  Note that derby.system.home is only 
meaningful to the Embedded Driver (embedded in Network Server) so has 
not effect in your client program.

And, as Bryan points out, be sure to specify the -h option 9 -h 
192.168.1.99) when starting Network server


Mime
View raw message