This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC 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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "No suitable driver SQL Exception" Watch "No suitable driver SQL Exception" New topic
Author

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
Greenhorn

Joined: Mar 04, 2002
Posts: 11
Gabriel,
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.
hob
 
Consider Paul's rocket mass heater.
 
subject: No suitable driver SQL Exception
 
Similar Threads
Unsupported response content type "text/html", must be: "text/xml".
Oracle JDBC driver problem on Canada locale
applet db access mediated by jsp db access
Hibernate: Couldn't get connection pooling to work
Cannot Insert Colum Into Resultset Oracle