aspose file tools*
The moose likes JDBC and the fly likes  SQLException: No suitable driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark " SQLException: No suitable driver" Watch " SQLException: No suitable driver" New topic
Author

SQLException: No suitable driver

Ahamed Sharif
Ranch Hand

Joined: Aug 24, 2003
Posts: 47
Hello,
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:
com.mysql.jdbc.Driver
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 .
Thanks,
Sharief
p Walsh
Greenhorn

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
Hi,
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,
Thanks
Sharief
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQLException: No suitable driver