Where is org.apache.derby.jdbc.ClientDriver?

Question

I loaded the jar with the Apache Derby core engine, which also includes the built-in JDBC driver (10.9.1.0) . But this jar does not include the .class ClientDriver file in the jdbc package. Why is this? Where can I find this class file? I need this file to connect to the derby database from tomcat as a server.

Please provide a link to download the full can to get the required .class file.

Answer 1

OK: Have you viewed the Apache Derby page:

• http://db.apache.org/derby/releases/release-10.9.1.0.cgi

Download db-derby-10.9.1.0-bin.zip

It contains many files, including derby.jar and derbyclient.jar (along with a lot of documentation).

derbyclient.jar contains our friend org.apache.derby.jdbc.ClientDriver.class

Answer 2

@ Paulsm4 is right.
But keep in mind that:

org.apache.derby.jdbc.ClientDriver

which can be found inside derbyclient.jar is enough to just get a connection to the Derby DB server .

But if you want to create a built-in (in memory) database when you receive a connection, then you will have to use a different jdbc driver:

org.apache.derby.jdbc.EmbeddedDriver

which can be found inside derby.jar . In addition, you must pass an additional parameter create=true . For example:

 <property name="javax.persistence.jdbc.url" value="jdbc:derby:myApp;databaseName=myApp;create=true" /> 

Hope this helps someone.