File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes No suitable driver SQL Exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "No suitable driver SQL Exception" Watch "No suitable driver SQL Exception" New topic

No suitable driver SQL Exception

Gabriel Cane
Ranch Hand

Joined: Mar 27, 2001
Posts: 39
What does it mean?
I'm running a Tomcat 3.2.4 application that *attempts* to connect to a HypersonicSQL database. I've been able to run it from client-side Java programs, but it simply won't connect from tomcat.
I'm using the exact same HypersonicSQL JAR file for tomcat as I am on the client side.
This error is caused by the DriverManager.getConnection() method of my data access layer. The Class.forName() portion of my code throws no errors messages, meaning that it can find the driver classes and instantiate them, but the DriverManager somehow objects to that driver.
Could it be that the JDBC implementation in tomcat is somehow flawed? If so, how would I replace it with one that works?

Sun Certified Programmer for the Java 2 Platform
hob hartman

Joined: Mar 04, 2002
Posts: 11
I have noticed that there are a LOT of flawed tools out there. Almost every one that I use comes back with some sort of problem understanding my code. I wish someone would fix them all!
Seriously, have you seen Ming's post from a couple of days ago in this forum? His problem sounded similar. Check it out to see if putting your jar in the folder he describes might help you. I would guess that the lib folder under tomcat would be the one to try.
I agree. Here's the link:
subject: No suitable driver SQL Exception
It's not a secret anymore!