After much trial and error and false starts I discovered my problem.
It is important that the web-inf/lib contain NO hibernate jar files or javassist.jar. The
original error, which was, the MySQLDialect could not be cast to Dialect was due to the
mismatched hibernate jars. So be careful here.
The final persistence.xml is:
| I believe I could live better without the class elements as this version of hibernate
will discover them.
| The c3p0 properties, even though commented out, I left in as the non-jta-data-source
should have connection and statement pooling in it not here.
| <?xml version="1.0" encoding="UTF-8"?>
| <persistence version="1.0"
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_1_0.xsd">
| <persistence-unit name="CU3JPAPU"
transaction-type="RESOURCE_LOCAL">
| <provider>org.hibernate.ejb.HibernatePersistence</provider>
|
<non-jta-data-source>java:/LuceneResumeDatasource</non-jta-data-source>
| <properties>
| <!--property name="jboss.entity.manager.factory.jndi.name"
value="java:/UpdaterEntityManagerFactory"/-->
| <!--property name="hibernate.connection.username"
value="root"/>
| <property name="hibernate.connection.driver_class"
value="com.mysql.jdbc.Driver"/>
| <property name="hibernate.connection.password"
value=""/>
| <property name="hibernate.connection.url"
value="jdbc:mysql://localhost:3306/upd"/-->
| <!--property name="hibernate.cache.provider_class"
value="org.hibernate.cache.NoCacheProvider"/-->
| <property name="hibernate.dialect"
value="org.hibernate.dialect.MySQLDialect"/>
|
| <!--property name="hibernate.c3p0.min_size"
value="5"/>
| <property name="hibernate.c3p0.max_size" value="50"/>
| <property name="hibernate.c3p0.max_statements"
value="100"/>
| <property name="hibernate.c3p0.idle_test_period"
value="3000"/>
| <property name="hibernate.c3p0.max_timeout"
value="300"/>
| <property name="hibernate.show_sql" value="false"/>
| <property name="hibernate.format_sql"
value="false"/-->
|
| </properties>
| </persistence-unit>
| </persistence>
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4266906#...
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...