Derby Connection Problem.
Hi all,
I am trying to establish connection with Derby(Java DB) through Service but am getting following error. "java.lang.ClassNotFoundException: org.apache.derby.jdbc.ClientDriver"
Here is the piece of my database connectivity code.
---
try
{
Connection conn;
String driver = "org.apache.derby.jdbc.ClientDriver";
Class.forName(driver).newInstance();
writer.println("Connected to the database");
conn.close();
writer.println("Disconnected from database");
}
catch (Exception e)
{
writer.println(e);
}
---
Guide me how to register my derby database. Is there any other code snipet that you may want to share.
Thanks in advance.
I am trying to establish connection with Derby(Java DB) through Service but am getting following error. "java.lang.ClassNotFoundException: org.apache.derby.jdbc.ClientDriver"
Here is the piece of my database connectivity code.
---
try
{
Connection conn;
String driver = "org.apache.derby.jdbc.ClientDriver";
Class.forName(driver).newInstance();
writer.println("Connected to the database");
conn.close();
writer.println("Disconnected from database");
}
catch (Exception e)
{
writer.println(e);
}
---
Guide me how to register my derby database. Is there any other code snipet that you may want to share.
Thanks in advance.
One answer
Are you using standalone or embedded Derby? Since you are asking the question on jazz.net forum, I suppose you are referring to the embedded Derby database of the Jazz applications. In this case, keep in mind that only one JVM can open the Derby database.
If you are working on projects not relating to Jazz, you'd better gather information from the general Derby source, such as below.
http://db.apache.org/derby/papers/DerbyTut/index.html
Derby supports multiple connections to a given database. An example of an embedded application that manages concurrent users is a Tomcat or Geronimo application server that embeds Derby. Any number of users can execute Web applications that access a database through that Web server.
Quoted from http://db.apache.org/derby/papers/DerbyTut/embedded_intro.htmlHowever, only one JVM may boot ("open") that database, so multiple applications running in different JVMs cannot access the same database. To understand this better, do the following.
If you are working on projects not relating to Jazz, you'd better gather information from the general Derby source, such as below.
http://db.apache.org/derby/papers/DerbyTut/index.html