eclipse - MySQL driver problem in my dynamic web project (JPA, JSP) -


cutting case.

persistence.xml

<?xml version="1.0" encoding="utf-8"?> <persistence xmlns="http://java.sun.com/xml/ns/persistence"     xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"     xsi:schemalocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"     version="2.0">          <persistence-unit name="fishsticks" transaction-type="resource_local">             <class>model.customer</class>             <etc etc>              <properties>                 <property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.driver" />                 <property name="javax.persistence.jdbc.url" value="jdbc:mysql://127.0.0.1:3306/fishsticks" />                 <property name="javax.persistence.jdbc.user" value="user" />                 <property name="javax.persistence.jdbc.password" value="pass" />                  <!-- eclipselink should create database schema automatically -->                 <property name="eclipselink.ddl-generation" value="drop-and-create-tables" />                 <property name="eclipselink.ddl-generation.output-mode"                     value="database" />                 <property name="eclipselink.logging.level" value="off" />             </properties>         </persistence-unit> </persistence> 

eclipse build path:

enter image description here

project setup:

enter image description here

error on page: enter link description here

the page made jsp

and have no idea how fix this...

this dao-file:

import java.util.list; import javax.persistence.entitymanager; import javax.persistence.entitymanagerfactory; import javax.persistence.entitytransaction; import javax.persistence.persistence; import javax.persistence.persistencecontext; import model.customer; import model.milestone; import model.project; import model.task; import model.user;  public class jpadao implements dao {     private static jpadao dao;      public static jpadao getinstance() {         if (dao == null)             dao = new jpadao();         return dao;     }      private entitymanagerfactory emf = persistence.createentitymanagerfactory("fishsticks");      @persistencecontext(name="fishsticksem")     private entitymanager em = emf.createentitymanager();     private entitytransaction tx = em.gettransaction();      private jpadao() {         // singleton     } } 

did follow advise tomcat documentation?

before proceed, don't forget copy jdbc driver's jar $catalina_home/lib

this tomcat 6.0 , 7.0.

for tomcat 5.5: $catalina_home/common/lib


Comments