Menu
I downloaded the jar of Core Apache Derby database engine, which also includes the embedded JDBC driver (10.9.1.0). But that jar doesn't include the .class file of ClientDriver in the jdbc package. Why is that ? Where can i find this class file ? I need this file to connect to derby database from tomcat as the server.
Please provide the download link of the complete jar so that i get the required .class file.
524
If you want to connect to a Derby database which is running in server mode then you can use the following command. connect 'jdbc:derby://localhost:1527/c:\temp\db\FAQ\db;create=true';
Derby consists of both the database engine and an embedded JDBC driver. Applications use JDBC to interact with a database. Applications running on JDK 1.5 or earlier, must load the driver in order to work with the database. In an embedded environment, loading the driver also starts Derby.
Download the Derby database software from the Apache website at http://db.apache.org/derby/derby_downloads.html. Extract the files into the directory that you have created for the Derby database. For example: C:\Derby. Set the DERBY_HOME system variable to the location of your Derby installation.
OK: have you looked on the Apache Derby page:
Download db-derby-10.9.1.0-bin.zip
It contains many files, including derby.jar and derbyclient.jar (along with much documentation).
derbyclient.jar contains our friend org.apache.derby.jdbc.ClientDriver.class
84
@Paulsm4 is correct.
But please keep in mind also that:
org.apache.derby.jdbc.ClientDriver
which can be found inside derbyclient.jar is enough to just obtain connection to the running Derby DB server.
But if you would like to create embedded (in memory) database when obtaining connection, then you have to use different jdbc driver:
org.apache.derby.jdbc.EmbeddedDriver
which can be found inside derby.jar. Moreover, additional parameter create=true has to be passed. For example:
<property name="javax.persistence.jdbc.url" value="jdbc:derby:myApp;databaseName=myApp;create=true" />
Hope it helps somebody.
36
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
