Hi there,

Tomcat is a bit tricky because it ignores the
classpath when using external jar files.
With Tomcat, all external jars are located
in the common\lib sub-directory of your tomcat
installation directory.

Copy the mysql jar file to common\lib sub-directory
of your tomcat installation directory, restart tomcat
and it should find the mysql driver.

If you have questions, feel free to ask :-)
regards
- H.Eiriksson (hte@e...)

> Hi Experts,

> I am using winnt,mysqljdbc2.0.13,tomcat3.3.1,jdk1.2.2,jsdk2.0.
W> hen i am starting tomcat it is asking for java-home and 
i>  am setting it to d:\jdk.1.2.2 ok tomcat is started.
i>  have one servlet which connects to mysql database .

> When i run that servlet it is giving me 

> "NO SUITABLE DRIVER FOUND"

> I tried all the ways in "README" file which comes with mysqljdbc driver.
I>  know that it is problem with the classpath.
I>  copyied that mysqljdbc driver in all the directories and setted the 
c> lasspath to those directories in command prompt but still it is giving 
me 
e> rror.

> 1)what is the reason for this?
2> )I have to change any files which can set the classpath to mysqljdbc 
d> river when tomcat is started.?
3> )send me all the possible solutions asap?

> I was on this problem for last week and i have to submit my project with 
i> n 3 to 4 days so please help me asap.

> It  is working in javawebserver.

> 
T> hanks