Java.sql.SQLException: No suitable driver

Dev Shed Forums Sponsor:

March 8th, 2007, 08:09 AM

bkolts

strongbad dance now

Join Date: Oct 2004

Location: Bermuda

Posts: 324

Time spent in forums: 1 Week 2 Days 13 h 3 m 46 sec
Reputation Power: 60

Java.sql.SQLException: No suitable driver

Hi All,

I'm going through the Java DB tutorial un Sun's website, and I'm having trouble with the first example script.

my code is:

Code:

import java.sql.*;
/**
 *
 * @author bkolts
 */
public class CreateCoffees {
    
    public static void main(String args[]) {
        //jdbc:derby://localhost:1527/COFFEEBREAK
        String url = "jdbc:derby://localhost:1527/COFFEEBREAK";
        Connection con;
        String createString;
        createString = "create table COFFEES " +
                "(COF_NAME varchar(32), " +
                "SUP_ID int, " +
                "PRICE float, " +
                "SALES int, " +
                "TOTAL int)";
        Statement stmt;
        
        try {
            Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
           // Class.forName("org.apache.derby.jdbc.ClientDriver");
            
        } catch(java.lang.ClassNotFoundException e) {
            System.err.print("ClassNotFoundException: ");
            System.err.println(e.getMessage());
        }
        
        try {
            con = DriverManager.getConnection(url,
                    "admin", "admin");
            
            stmt = con.createStatement();
            stmt.executeUpdate(createString);
            
            stmt.close();
            con.close();
            
        } catch(SQLException ex) {
            System.err.println("SQLException: " + ex.toString());
        }
    }
    
}

both the emdedded driver and the client driver produce the same resulting exception:

Code:

ClassNotFoundException: org.apache.derby.jdbc.EmbeddedDriver
SQLException: java.sql.SQLException: No suitable driver found for jdbc:derby://localhost:1527/COFFEEBREAK

From what I understand, this is a badly formed url issue, but I'm not sure how to fix it. I'm running this on windows xp, using netbeans 5.5 (I've also tried from command line, same result).

I'm pretty sure I have the classpaths and paths set up correctly for Derby, UI followed the instructions on that.

I've googled this for 2 days, and I'm at a loss. Any help would be greatly appreciated!

Cheers

March 8th, 2007, 08:14 AM

Yawmark

Feelin' Groovy

Dev Shed God 11th Plane (10000 - 10499 posts)

Join Date: Aug 2001

Location: WDSMIA

Posts: 10,135

Time spent in forums: 3 Months 1 Week 4 Days 1 h 22 m 45 sec
Reputation Power: 5052

You're right about it being a URL problem (good catch!). My bet is that you're using the embedded driver, rather than the network driver. The URL format for the embedded driver is:

jdbc:derby:databaseName;URLAttributes

Try that instead, and let us know if it works. More information can be found in the Derby QuickStart Guide.

Cheers.

~

__________________
Yawmark
class Sig{public static void main(String...args){\u0066or(int
\u0020$:"vÌÈÊ\"¤¾ÀÊ²¬Æ\"v¤Î¤\"²¤¨¸¬Æ".to\u0043h\u0061rArray()
)System./*goto/*$/%\u0126//^\u002A\u002Fout.print((char)(($>>
+(~'"'&'#'))+('<'>>('\\'/'.')/\u002Array.const(~1)\*\u002F)));}}

March 8th, 2007, 08:53 AM

bkolts

strongbad dance now

Join Date: Oct 2004

Location: Bermuda

Posts: 324

Time spent in forums: 1 Week 2 Days 13 h 3 m 46 sec
Reputation Power: 60

Quote:

Originally Posted by Yawmark

thanks for pointing me in the right direction Yawmark. From what I read, having the url as jdbc:derby:dbName will work as long as the database is in the same directory as the class. so thats what I did and it worked! Now I'll read up on the url a bit more.

March 8th, 2007, 07:22 PM

bkolts

strongbad dance now

Join Date: Oct 2004

Location: Bermuda

Posts: 324

Time spent in forums: 1 Week 2 Days 13 h 3 m 46 sec
Reputation Power: 60

Ok, I've been googling how to form the url, but I've had no luck.

As I said, I can get it to work if its in the same directory as the database, but can't seem to form the proper url for the script to look in a different folder structre for the database. Anyone have any insight on this? Its on windows.

Thanks!

March 8th, 2007, 08:12 PM

bullet

Java Junkie

Join Date: Jan 2004

Location: Mobile, Alabama

Posts: 3,826

Time spent in forums: 1 Month 1 Week 6 Days 9 h 44 sec
Reputation Power: 1248

Are you still getting ClassNotFound?

March 8th, 2007, 08:22 PM

Yawmark

Feelin' Groovy

Join Date: Aug 2001

Location: WDSMIA

Posts: 10,135

Time spent in forums: 3 Months 1 Week 4 Days 1 h 22 m 45 sec
Reputation Power: 5052

I missed the ClassNotFoundException the first time! You're using a non-embedded URL along with the embedded driver, but the embedded driver isn't visible to the runtime classpath!

Thanks for pointing that out, bullet!

~

March 9th, 2007, 06:37 AM

bkolts

strongbad dance now

Join Date: Oct 2004

Location: Bermuda

Posts: 324

Time spent in forums: 1 Week 2 Days 13 h 3 m 46 sec
Reputation Power: 60

Thanks Bullet and Yawmark,

I should have stated I changed my code now:

Code:

import java.sql.*;
     
public class CreateCoffees {

	public static void main(String args[]) {
		  			  
		String url = "jdbc:derby:COFFEEBREAK";
		Connection con;
		String createString;
		createString = "create table COFFEES " +
							"(COF_NAME varchar(32), " +
							"SUP_ID int, " +
							"PRICE float, " +
							"SALES int, " +
							"TOTAL int)";
		Statement stmt;
	
		try {
			Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
			

		} catch(java.lang.ClassNotFoundException e) {
			System.err.print("ClassNotFoundException: "); 
			System.err.println(e.getMessage());
		}

		try {
			con = DriverManager.getConnection(url, 
									 "admin", "admin");
	
			stmt = con.createStatement();							
	   		    stmt.executeUpdate(createString);
	
			stmt.close();
			con.close();
	
		} catch(SQLException ex) {
			System.err.println("SQLException: " + ex.toString());
		}
	}
}
[\code]

so, from what I've read, I should have the embedded driver above, and the embedded url format.

now I have more questions though LOL.  where can I find out more infomration on emmbedded vs a client driver.  And... if my database is in a seperate directory from my java class, how do I format the url?

I tried this
[code]
String url = "jdbc:derby:c:\\DB\\COFFEEBREAK";

but I recieve this message when running:

Code:

ClassNotFoundException: org.apache.derby.jdbc.EmbeddedDriver
SQLException: java.sql.SQLException: No suitable driver found for jdbc:derby:c:\DB\COFFEEBREAK

Yawmark, I think you've given me a clue with "the embedded driver isn't visible to the runtime classpath!" but I'm bnot sure what to do about that.

Sorry for dragging this out, I really appreciate the help!

March 9th, 2007, 07:52 AM

Yawmark

Feelin' Groovy

Join Date: Aug 2001

Location: WDSMIA

Posts: 10,135

Time spent in forums: 3 Months 1 Week 4 Days 1 h 22 m 45 sec
Reputation Power: 5052

Quote:

Yawmark, I think you've given me a clue with "the embedded driver isn't visible to the runtime classpath!" but I'm bnot sure what to do about that.

You'll need to make sure that the JAR file containing that class ("derby.jar", I believe) is in the runtime classpath.

~

March 9th, 2007, 09:10 AM

bkolts

strongbad dance now

Join Date: Oct 2004

Location: Bermuda

Posts: 324

Time spent in forums: 1 Week 2 Days 13 h 3 m 46 sec
Reputation Power: 60

I think I have my user environment variables set up correctly, but I'm a rookie there to.

This is what I have:

Code:

CLASSPATH   	%DERBY_INSTALL%\lib\derby.jar;%DERBY_INSTALL%\lib\derbytools.jar;.
DERBY_INSTALL   C:\Apache\db-derby-10.2.2.0-bin
JAVA_HOME 	C:\Program Files\Java\jdk1.6.0
PATH 		%PATH%;%JAVA_HOME%\bin

does this look right?

#10

March 9th, 2007, 09:17 AM

Yawmark

Feelin' Groovy

Join Date: Aug 2001

Location: WDSMIA

Posts: 10,135

Time spent in forums: 3 Months 1 Week 4 Days 1 h 22 m 45 sec
Reputation Power: 5052

Quote:

does this look right?

Looks good to me, but please note that if you're running your application from inside an IDE or other framework, your system classpath won't matter much. That's by design. Applications such as Tomcat or Eclipse won't use the system classpath at runtime and depend on their own classloaders.

Hope this helps!

~

Comments on this post

bkolts agrees: I've almost got it now!!!

#11

March 9th, 2007, 09:30 AM

bkolts

strongbad dance now

Join Date: Oct 2004

Location: Bermuda

Posts: 324

Time spent in forums: 1 Week 2 Days 13 h 3 m 46 sec
Reputation Power: 60

Quote:

Originally Posted by Yawmark

but please note that if you're running your application from inside an IDE or other framework, your system classpath won't matter much. That's by design. Applications such as Tomcat or Eclipse won't use the system classpath at runtime and depend on their own classloaders.
~

I've been using Netbeans. However, I've also been using a text editor on the side, and I compiled and ran the class using the text editor version from the cmd prompt, and everything worked!!

So, now I will read up on classloaders in Netbeans, and see if I can get Netbeans to do what I want.

Thanks again!

#12

March 9th, 2007, 11:15 AM

Yawmark

Feelin' Groovy

Join Date: Aug 2001

Location: WDSMIA

Posts: 10,135

Time spent in forums: 3 Months 1 Week 4 Days 1 h 22 m 45 sec
Reputation Power: 5052

You're welcome. NetBeans will have an option to set runtime options. Check the project properties for starters.

Good luck!

~

#13

March 9th, 2007, 12:57 PM

bkolts

strongbad dance now

Join Date: Oct 2004

Location: Bermuda

Posts: 324

Time spent in forums: 1 Week 2 Days 13 h 3 m 46 sec
Reputation Power: 60

Quote:

Originally Posted by Yawmark

You're welcome. NetBeans will have an option to set runtime options. Check the project properties for starters.

Good luck!

~

Thats where it was! I added the derby.jar file to the libraries in the project, and bingo!

Thanks again, no I can continue with the tutorial

#14

October 3rd, 2012, 01:49 AM

OwlVision

Registered User

Join Date: Oct 2012

Posts: 1

Time spent in forums: 6 m 27 sec
Reputation Power: 0

Quote:

Originally Posted by bkolts

Thank you so much for pointing out that the database in the same directory! I have been grinding on this problem for the last two weeks now, and it's been driving me nuts. Finally got it worked out, and am eternally thankful to you.

#15

October 3rd, 2012, 07:00 AM

bkolts

strongbad dance now

Join Date: Oct 2004

Location: Bermuda

Posts: 324

Time spent in forums: 1 Week 2 Days 13 h 3 m 46 sec
Reputation Power: 60

Quote:

Originally Posted by OwlVision

Glad my 5 year old thread helped you!

Java.sql.SQLException: No suitable driver

Developer Shed Advertisers and Affiliates