access mysql databse in jsp file+eclipse

[sonali]

Hi all,

i want to access mysql database server from jsp program using eclipse editor.

for this i downloaded mysql-connector-java-3.1.14.zip

mysql-connector-java-3.1.14 folder contains mysql-connector-java-3.1.14-bin.jar
file.

then i add this jar file in to eclipse referanced lib(by using build path->java build path->add external)

after that,i started tomcat server and executed the jsp program

but i am gettting the following error
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

when i create simple java file src folder which contain db connection and run this as java application it works fine but when i used jsp file it gives me error.

if any one know how to access mysql database server using
mysql-connector-java-3.1.14 driver with eclipse,please explain me....

[travishein]

i think there is something about needing to have the mysql jar file added to the list of jar files that gets copied into the tomcat's runtime library path.
even though you are using eclipse, the tomcat instance that eclipse manages is still a tomcat instance, there will be a lib folder that we need to tell eclipse to populate with the framework kinds of jar files like this mysql jdbc driver