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

Popular posts from this blog

django - How can I change user group without delete record -

java - Need to add SOAP security token -

java - EclipseLink JPA Object is not a known entity type -