Ad:

Java Discussion Thread
Unsolved
Views: 4550

Sep 28th, 2009

Derby Connection Issues

Expand Post »

Hello, I'm using NetBeans 6.7.1, and Derby 10.5.3.0. I'm trying to learn how to write Database applications, and I'm having trouble connecting to my Database. It loads the Derby Driver (EmbeddedDriver), but won't connect to the the Database named test. I looked at tests Properties in NetBeans, and it said that it was using the org.apache.jdbc.derby.ClientDriver. I did create the Database, and give it no username or password. Below is the code that I have. If anybody could help, that would be great =D

Java Syntax (Toggle Plain Text)
package jdb.test;
import java.sql.*;
 
public class DatabaseTest {
 
    public static void main(String[] args){
        try{
            // Load the EmbeddedDriver class
            Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();
            System.out.println("Loaded Derby Driver");
        }catch(Exception e){
            e.printStackTrace();
            System.out.println("Error loading Derby Driver.  Shutting down.");
            System.exit(-1);
        }
 
        // The database located on my computer
        String database = "jdbc:derby://localhost:1527/test";
        try{
            // Connect without a username and password
            Connection conn = DriverManager.getConnection(database);
            System.out.println("Connected to "+database);
        }catch(SQLException e){
            e.printStackTrace();
            System.out.println("Could not connect to "+database);
            System.exit(-1);
        }
        System.out.println("You have connect to the selected database.");
    }
}
package jdb.test;
import java.sql.*;

public class DatabaseTest {

    public static void main(String[] args){
        try{
            // Load the EmbeddedDriver class
            Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();
            System.out.println("Loaded Derby Driver");
        }catch(Exception e){
            e.printStackTrace();
            System.out.println("Error loading Derby Driver.  Shutting down.");
            System.exit(-1);
        }

        // The database located on my computer
        String database = "jdbc:derby://localhost:1527/test";
        try{
            // Connect without a username and password
            Connection conn = DriverManager.getConnection(database);
            System.out.println("Connected to "+database);
        }catch(SQLException e){
            e.printStackTrace();
            System.out.println("Could not connect to "+database);
            System.exit(-1);
        }
        System.out.println("You have connect to the selected database.");
    }
}

This is the error that I get:

Java Syntax (Toggle Plain Text)
java.sql.SQLException: No suitable driver found for jdbc:derby://localhost:1527/test
        at java.sql.DriverManager.getConnection(DriverManager.java:602)
        at java.sql.DriverManager.getConnection(DriverManager.java:207)
        at jdb.test.DatabaseTest.main(DatabaseTest.java:22)
java.sql.SQLException: No suitable driver found for jdbc:derby://localhost:1527/test
        at java.sql.DriverManager.getConnection(DriverManager.java:602)
        at java.sql.DriverManager.getConnection(DriverManager.java:207)
        at jdb.test.DatabaseTest.main(DatabaseTest.java:22)

Similar Threads

Dell laptop won't boot windows - black screen, power issues in Windows NT / 2000 / XP
One Laptop causing Intemittent Connection Drops in Networking
Router, cable internet connection issues in Networking
Connection Issues in Windows Vista and Windows 7
Weird connection problem - I'm sure it's PC in Networking

llemes4011

Reputation Points: 41

Solved Threads: 13

Posting Whiz in Training

Offline

224 posts
since Aug 2008

Permalink

Sep 28th, 2009

Re: Derby Connection Issues

Your code is loading the EmbeddedDriver class, but using the ClientDriver network url for your connection string. The EmbeddedDriver uses the database name instead of the //servername url.

Ezzaral

Moderator

Featured Poster

Reputation Points: 3239

Solved Threads: 838

Posting Genius

Offline

6,761 posts
since May 2007

Permalink

Sep 28th, 2009

Re: Derby Connection Issues

I tried using "jdbc:derby:test" instead of ""jdbc:derby://localhost:1527/test", but it gave me this error:

(this is the entire output from the execution)

Java Syntax (Toggle Plain Text)
Loaded Derby Driver
java.sql.SQLException: Database 'test' not found.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleDBNotFound(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)
        at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
        at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
        at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
Could not connect to jdbc:derby:test
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:207)
        at jdb.test.DatabaseTest.main(DatabaseTest.java:22)
Caused by: java.sql.SQLException: Database 'test' not found.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
        ... 15 more
Loaded Derby Driver
java.sql.SQLException: Database 'test' not found.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleDBNotFound(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)
        at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
        at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
        at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
Could not connect to jdbc:derby:test
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:207)
        at jdb.test.DatabaseTest.main(DatabaseTest.java:22)
Caused by: java.sql.SQLException: Database 'test' not found.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
        ... 15 more

llemes4011

Reputation Points: 41

Solved Threads: 13

Posting Whiz in Training

Offline

224 posts
since Aug 2008

Permalink

Sep 28th, 2009

Re: Derby Connection Issues

Yes, that is just a path issue.
http://db.apache.org/derby/docs/10.5/devguide/

Ezzaral

Moderator

Featured Poster

Reputation Points: 3239

Solved Threads: 838

Posting Genius

Offline

6,761 posts
since May 2007

Permalink

Sep 28th, 2009

Re: Derby Connection Issues

I tried setting the derby.system.home property to the location where I was storing the databases, but that didn't help either. It looks like I'm structuring everything correctly... I'm sorry, I think I'm missing something really obvious >.<

llemes4011

Reputation Points: 41

Solved Threads: 13

Posting Whiz in Training

Offline

224 posts
since Aug 2008

Permalink

Sep 28th, 2009

Re: Derby Connection Issues

Well, I can only point to the docs:
http://db.apache.org/derby/docs/10.5...dvlp40350.html
and experimentation with the path you're using in the connection string.

Ezzaral

Moderator

Featured Poster

Reputation Points: 3239

Solved Threads: 838

Posting Genius

Offline

6,761 posts
since May 2007

Permalink

Sep 28th, 2009

Re: Derby Connection Issues

Thank you for all of your help

If I find anything, I'll post it here.

llemes4011

Reputation Points: 41

Solved Threads: 13

Posting Whiz in Training

Offline

224 posts
since Aug 2008

Permalink

Sep 28th, 2009

Re: Derby Connection Issues

AHA! I used the create property to create a new Database, and then searched for it using the OS's Search Program. I found the newly created database in the NetBeans project folder. I can not successfully connect to the database. I don't know how to add that new Database to the list of databases that are editable directly through NetBeans.

llemes4011

Reputation Points: 41

Solved Threads: 13

Posting Whiz in Training

Offline

224 posts
since Aug 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Java Forum Timeline: MySQL Connector

Next Thread in Java Forum Timeline: Server - Client thing

DaniWeb Message

Cancel Changes

User Name
Password