How can I fix this missing Derby ClientDriver issue?

Question

I am pretty new to Java DB, and I'm trying to set up Java DB in NetBeans IDE using this tutorial: Working with the Java DB (Derby) Database

During the step, where it tells to create database, I get such an error:

An error occurred while creating the database:
java.lang.ClassNotFoundException: org.apache.derby.jdbc.Clientdriver

How do I fix this issue?

Answer 1

Which version of Derby / Java DB are you using?

If it is 10.15.1.3, see this response: Where is org.apache.derby.jdbc.ClientDriver for version 10.15.1.3?

Within NetBeans, there seems to be the same issue with ClientDriver. As a workaround, download and use Derby 10.14.2.0 instead. A NetBeans bug report, Apache Jira Netbeans-3424 has been submitted.

Answer 2

I found it in lib\derbytools.jar\org\apache\derby\jdbc.

I copied the entire jdbc folder and pasted in lib\derbyclient.jar\org\apache\derby

Then it works.