JSP & MySQL connection

[lrrajesh]

while trying to connect to mysql from JSP, I am getting server error like

java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1407)
.......................

Can any one help to solve this error
I am using Tomcat 4.1 server
Java version is 1.3
and My SQl version is 5.0.

what shud be the driver i must use

Plsssss Help me


Regards

Raj

[Khalid Ali]

your problem is that tomcat server at run time can not locate the driver files. one way of overcoming this is that if you put the driver files in the %JAVA_HOME%/lib that way it will under the main path

[Mr. Ram]

copy the above specified file into the following path :

<TOMCAT_HOME>\common\lib