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  SQLException: No suitable driver 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 " SQLException: No suitable driver" Watch " SQLException: No suitable driver" New topic

SQLException: No suitable driver

Ahamed Sharif
Ranch Hand

Joined: Aug 24, 2003
Posts: 47
I am using JBoss and Mysql. I was developing a session bean class with
JDBC APIs but when i run the client it gives runtime error.
17:39:11,453 ERROR [STDERR] ClassNotFoundException:
17:39:11,453 ERROR [STDERR] No ClassLoaders found for:
17:39:11,484 ERROR [STDERR] SQLException: No suitable driver
And I put Connector/J- lib jar file into JBoss-server-default-lib
directory and also tried in deploy directory, but it was showing the same
error .
p Walsh

Joined: Nov 13, 2003
Posts: 14
Did you check your environment variables to see if the classpaths are all in order and that it points to the jar file in the mysql driver download.
I not to sure about JBOSS never used it before ,but I have received the above error when using mysql before and it seemed to be a similar problem whereby classpaths were not set up.
Goto dos prompt and type in the word set and you be able to see what your class path is set up to.
Ahamed Sharif
Ranch Hand

Joined: Aug 24, 2003
Posts: 47
Thank you but could u explain me some more clear what class path i should set, because i already i set a classpath for running a client.
I am connector/J and i set the classpath and i pur jar files in JBoss.
Help would be appriciate,
I agree. Here's the link:
subject: SQLException: No suitable driver
It's not a secret anymore!