Java set up connection database

Question

I want to connect to a database on my computer. I have already created a database, but i cannot connect. I always get a classnotfoundexception. I don't know how to fix it. My database is called begindb and I want to use org.apache.jdbc.ClientDriver as driver. This is my code from my program:

private final static String JDBC_URL="jdbc:derby://localhost/begindb";
private final static String JDBC_DRIVER="org.apache.derby.jdbc.ClientDriver";
private final static String USER_ID="test";
private final static String PASSW="test";
public static void main(String[] args) {
    try{
        Class.forName(JDBC_DRIVER);
        try(Connection conn = DriverManager.getConnection(JDBC_URL, USER_ID, PASSW)){
            System.out.println("good job!!");
        }
        catch(SQLException e){
            System.out.println("Error.");
        }
    }
    catch(ClassNotFoundException e)
        System.out.println(e.getMessage());
    }
}

So the first line in the try statement won't work. Because i am getting a classnotfoundexception.

Is the JDBC connector jar in your buildpath? – ROROROOROROR Jun 18 '14 at 15:12 — ROROROOROROR, Jun 18 '14 at 15:12
I don't know, i am trying this for the first time – Lennart Jun 18 '14 at 15:13 — Lennart, Jun 18 '14 at 15:13

score 2 · Accepted Answer · edited May 23 '17 at 12:23

2

From the documentation Step 4 -

To use the Derby Network Client JDBC driver, set your CLASSPATH to include the jar files listed below:

derbyclient.jar: contains the JDBC driver

derbytools.jar: optional, provides the ij tool

Add derbyclient.jar to your project classpath.

Expand you Project.
Right-click Libraries.
Select Add Jar/Folder.
Select "derbyclient.jar"

edited May 23 '17 at 12:23

Community

1
1

answered Jun 18 '14 at 15:14

Elliott Frisch

198,278
20
158
249

Thanks a lot. This worked. After i had done this i faced another prob with the connection, but if i added my port number to my JDBC_URL it worked. Thanks – Lennart Jun 18 '14 at 15:22

score 0 · Answer 2 · answered Jun 18 '14 at 15:16

0

You should have derbyclient.jar set in the classpath to recognize the driver class (org.apache.derby.jdbc.ClientDriver) you are using.

answered Jun 18 '14 at 15:16

user3684675

381
4
8
32

Java set up connection database

2 Answers2