spring - Tomcat JDBC MySQL ClassNotFoundException -
i use springmvc , jpa (using hibernate) on tomcat 7 server (running locally on mac).
i able set embedded h2 database.
now switched mysql , getting following error
java.lang.classnotfoundexception: "com.mysql.jdbc.driver" org.apache.catalina.loader.webappclassloader.loadclass(webappclassloader.java:1711) org.apache.catalina.loader.webappclassloader.loadclass(webappclassloader.java:1556)
this suggests tomcat having trouble finding mysql-connector java. there multitude of tutorials on how add connector $catalina_home/lib.
after trying use maven dependency project, followed advice , copied .jar file lib directory:
$ ls $catalina_home/lib/mysql*.jar /users/david/applications/tomcat/lib/mysql-connector-java-5.1.20-bin.jar
i have read , execute permissions on directory , file.
at moment can't figure out how make tomcat aware of jar. folder included in
$catalina_home/conf/catalina.properties
and have restarted server multiple times.
thanks help.
normally, output of cnfe follows:
java.lang.classnotfoundexception: com.mysql.jdbc.driver
whereas error message shows
java.lang.classnotfoundexception: "com.mysql.jdbc.driver"
i think you've still got quotes around driver class name in config.
Comments
Post a Comment