How to connect to MySQL from a JSP?

Question

I have installed MySQL Server 4.1 and mysql-connector-java-3.0.17-ga. I have the JSP code just to establish a connection. When I try to execute it, it throws java.lang.ClassNotFoundException: com.mysql.jdbc.Driver. Which file am I missing and where should I place it? Thanks in advance.

Answer 1

WEB-INF/lib

or

your server lib

Answer 2

The server has its own library of jars at run time. You need to put the msql jdbc jar file in the WEB-INF/lib folder, so that at runtime the tomcat install can find and load it. Anyway, check which class is throwing the exception, and make that class exist in the app-server's library folder.

Answer 3

I did it but still it's throwing the same exception.

Answer 4

I got it guys. Just restarted the tomcat and its working fine. Thanks for all your responses.