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
