wood burning stoves 2.0*
The moose likes JDBC and the fly likes No Suitible Driver Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "No Suitible Driver Error" Watch "No Suitible Driver Error" New topic
Author

No Suitible Driver Error

Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15299
    
    6

Here is my code:

It compiles and then when I run it I just get an SQLException: No Suitable Driver
Help anyone?


GenRocket - Experts at Building Test Data
Bosun Bello
Ranch Hand

Joined: Nov 06, 2000
Posts: 1510
I am guessing it just can't find the driver for mySQL. It's either your class path is not set correctly or you have not downloaded the drivers.


Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15299
    
    6

I had figured it out over the weekend. I did download the drivers and put them in the appropriate folders. However, my JAVA Editor was over-riding my CLASSPATH that I had set. So I had to set the CLASSPATH inside my editor.
All fixed.
 
Don't get me started about those stupid light bulbs.
 
subject: No Suitible Driver Error
 
Similar Threads
ClassNotFoundException generated!
SQLException: [Microsoft][ODBC Driver Manager]
Error when not in Main()
Class.forName() for drive using Oracle 8i
Access to the Oracle database using Java Applets