IntelliJ Java IDE
The moose likes Tomcat and the fly likes unable to load Mysql DB Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Products » Tomcat
Reply Bookmark "unable to load Mysql DB" Watch "unable to load Mysql DB" New topic
Author

unable to load Mysql DB

Sophia Choi
Ranch Hand

Joined: Mar 22, 2002
Posts: 106
I have programs like jsp and beans in JSWDK-1.0.1.and they connect to MySQL. They are working well.
But, after installing the latest version of Tomcat, I run the same program.Error messages are shown.
" Unable to load MySQL DB driver
java.lang.ClassNotFoundException......"
I have tried some simple JSP and beans without connecting to the database. They are working.
Any configuation I am missing ?
Thanks
Sophia Choi
Ranch Hand

Joined: Mar 22, 2002
Posts: 106
I have found the answer.
The Tomcat can't refer the mysql.jar under the directory of jdk/jre/mysql/mysql.jar.
I have copy mysql.jar to tomcat4.1\common\lib\mysql.jar.
After doing that, my program can work.
 
 
subject: unable to load Mysql DB
 
Threads others viewed
Connecting a Java app. to a MySql DB
Tomcat and MySQL on Ubuntu
loading driver in JSP
org.gjt.mm.mysql.Driver...(URGENT)
passing values of Select box from JSP to Action class thru form Bean
WebSphere development made easy
without the weight of IBM tools
http://www.myeclipseide.com