Hello derby-user,
Hello
first of all sorry for my english
Derby network server should runtime starts/stops and works with databases lying
in different directories(partitions).
I start the first DB so:
String DBURL="jdbc:derby:directory:D:/Projects/warehouse/problem;create=true;"
Properties properties = new java.util.Properties();
properties.setProperty("user","cloud");
properties.setProperty("password","scape");
Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();
conn = (Connection) DriverManager.getConnection(DBURL, properties);
And the second one:
String DBURL="jdbc:derby:directory:isOK;create=true;"
The problem is:
when i am trying to connect to DB 'isOK' via ODBC (for example - test
connection in windows ODBC-manager) all is OK. But when to DB 'problem',
specifying DatabaseName='problem' i get the following error in ODBC-manager:
SQL30061N The database alias or database name "PROBLEM " was not
found at the remote node.
It seems that derby can't find DB locating in non derby.system.home location.
If I specify derby.system.home=D:/Projects/warehouse when starting up NS,
connection test passed in ODBC-manager. But i can't restart NS all the time
when i need to start another DB, furthermore there can be two working DBs in
different directories.
Thanks for any help!
--
Best regards,
zentol mailto:[EMAIL PROTECTED]
