Project JAR unable to access Derby Driver

Question

I am working on a Java project where we want to use an embedded database using JDBC for connection and Derby as the database. This is a maven project which deploys to an executable JAR.

I have included Derby as a dependency on the project. I am using Java 1.8, Maven 3.8.0, and Derby 10.8.3.0.

POM.xml

<!-- Derby for database connection -->
<dependency>
  <groupId>org.apache.derby</groupId>
  <artifactId>derby</artifactId>
  <version>10.8.3.0</version>
</dependency>

App.java

public class App {

public static void main(String[] args) {
    JOptionPane.showMessageDialog(null, "Hello World.");


    SampleDB sdb = new SampleDB();
    try {
        sdb.connectionToDerby();
        sdb.sampleDBUsabe();
    } catch (SQLException sqle) {
        System.out.println(sqle);
    }
}
}

SampleDB.java

public class SampleDB {
private Connection conn;

public void connectionToDerby() throws SQLException {
    String dbURL = "jdbc:derby:sampledb;create=true";
    conn = DriverManager.getConnection(dbURL);
}

public void sampleDBUsabe() throws SQLException {
    Statement stmt = conn.createStatement();

    //Create Table
    stmt.execute("Create Table USERS (id int primary key, name varchar(30))");
...
}

When I execute the generated .JAR file I get the error:

$ java -jar target/puzzle.game-0.0.1-SNAPSHOT.jar
java.sql.SQLException: No suitable driver found for jdbc:derby:sampledb;create=true

I suspect this is due to the Derby driver not being a part of my class path. Is there a way to do this using maven or a settings.xml file so that this happens automatically when a user runs the mvn install goal?

Yes, your problem is a CLASSPATH problem. And yes, derby.jar is designed to be embedded into your application. By the way, Derby 10.8 is VERY old. Please consider switching to Derby 10.14, which is much newer. — Bryan Pendleton, Feb 16 '19 at 18:59

Jens Dibbern · Answer 1 · 2019-02-16T19:57:40.793

1

When you start your application, you will need derby-10.8.3.0.jar in your classpath.

java -cp derby-10.8.3.0.jar;target/puzzle.game-0.0.1-SNAPSHOT.jar App

The classpath delimiter is OS dependent. You may have to adjust that.

As mentioned by Bryan Pendleton, you should use a current Derby release.

<dependency>
  <groupId>org.apache.derby</groupId>
  <artifactId>derby</artifactId>
  <version>10.14.2.0</version>
</dependency>

edited Feb 16 '19 at 19:57

answered Feb 16 '19 at 17:49

Jens Dibbern

1,434
2
13
20

When I try this I get the following output instead: `java.lang.ClassNotFoundException:org.apache.derby.jdbc.EmbeddedDriver` and `java.sql.SQLException: No suitable driver found for jdbc:derby:sampledb;create=true` – KyleAure Feb 16 '19 at 18:00
Please check your classpath. If your jar does not contain all dependencies as a fat jar, you have to add the derby jar to your classpath. – Jens Dibbern Feb 16 '19 at 18:15
The Class.forName is optional in Derby. The issue here is with the user's CLASSPATH. – Bryan Pendleton Feb 16 '19 at 18:57
The manual page you linked to is nearly 15 years old. Even Derby 10.8 is nearly a decade old. – Bryan Pendleton Feb 16 '19 at 18:58
@BryanPendleton Will do! Thank you! – KyleAure Feb 18 '19 at 05:12

score 1 · Accepted Answer · answered Feb 17 '19 at 19:23

1

See an answer to this question: Building a fat jar using maven . You need to use the maven assembly plugin in order to create a so called fat/uber jar.

answered Feb 17 '19 at 19:23

Maxim Kirilov

2,639
24
49

Project JAR unable to access Derby Driver

2 Answers2