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

problem!! No suitable driver

Sree kanth
Ranch Hand

Joined: Feb 02, 2005
Posts: 53

I'm facin a strange problem.
When ever i execute a servlet or jsp or EJB with JDBc conncection, I am gettin an SQL Exception saying NO SUITABLE DRIVER. But if te same program is done in CORE JAVA there is no problem all DML operations are workin.
What may be te problem? Do i ave to change any configuration files.
Please help me as early as possible.

Abhishek Asthana
Ranch Hand

Joined: Sep 08, 2004
Posts: 146
Hi Sree,
Which database are you using and what server? Please give more details so that I can help you.
Sree kanth
Ranch Hand

Joined: Feb 02, 2005
Posts: 53
Hi Abhishek
I am using j2ee server and SQL Server 2000.
Please help me this is very urgent.
arunij katiliyar

Joined: Mar 09, 2005
Posts: 26
Hi ,
do you have the libraries for jdbc from SQL SERVer in the classpath of the webserver/appserver . The webserver/appserver might use a propertiery claspath setting when booting .please check this and lemme know .

If the webserver is weblogic , the classpath setting is in


else if websphere then

installroot/bin/setCLASSPATH ( I think ??)

make sure that you append the path where libraries are present to their classpath and restart .

I agree. Here's the link:
subject: problem!! No suitable driver
It's not a secret anymore!