Hi i am stuck with hibernate persistence error using jboss
I am using jboss 5.1.0GA with hibernate3 and jpa and spring2.5

This is my persistence.xml

<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="SpringDemoPU" transaction-type="RESOURCE_LOCAL">
<non-jta-data-source>java:/SpringDemoDS</non-jta-data-source>
<properties>
<property name="hibernate.show_sql" value="false"/>
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
<property name="hibernate.hbm2ddl.auto" value="update"/>

<!-- hibernate performance -->
<!-- property name="hibernate.cglib.use_reflection_optimizer" value="true" / -->
<property name="hibernate.bytecode.use_reflection_optimizer" value="true"/>
<property name="hibernate.cache.use_second_level_cache" value="true"/>
<property name="hibernate.connection.pool_size" value="20"/>
<property name="hibernate.cache.use_query_cache" value="false"/>
<!-- <property name="hibernate.cache.provider_class" value="org.hibernate.cache.EhCacheProvider"></property>-->
</properties>
</persistence-unit>
</persistence>

and my login-servlet.xml file is

<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schem...-beans-2.5.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schem...ng-aop-2.5.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schem...ing-tx-2.5.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd"
default-autowire="byName">

<context:component-scan base-package="com" />
<bean class="org.springframework.web.servlet.mvc.annotat ion.DefaultAnnotationHandlerMapping"/>
<bean class="org.springframework.web.servlet.mvc.annotat ion.AnnotationMethodHandlerAdapter"/>
<bean class="org.springframework.context.annotation.Comm onAnnotationBeanPostProcessor" />

<bean name="/userLogin" class="com.example.LoginController"/>
<bean id="viewResolver" class="org.springframework.web.servlet.view.Intern alResourceViewResolver">
<property name="viewClass"><value>org.springframework.web.se rvlet.view.JstlView</value></property>
<property name="prefix"><value>/</value></property>
<property name="suffix"><value>.jsp</value></property>
</bean>

<!-- bean id="myDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName"><value>com.mysql.jdbc.Drive r</value></property>
<property name="url"><value>jdbc:mysql://localhost:3306/techfaq</value></property>
<property name="username"><value>root</value></property>
<property name="password"><value>pingpong123</value></property>
</bean> -->

<!--bean id="mySessionFactory" class="org.springframework.orm.hibernate3.LocalSes sionFactoryBean">
<property name="dataSource"><ref bean="myDataSource"/></property>
<property name="mappingResources">
<list>
<value>dao/user.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<value>
hibernate.dialect=org.hibernate.dialect.MySQLDiale ct
</value>
</property>
</bean-->

<bean id="userdao" class="com.dao.impl.UserDAOImpl">
<!-- property name="sessionFactory"><ref bean="mySessionFactory"/></property> -->
</bean>

<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverM anagerDataSource"
p:driverClassName="com.mysql.jdbc.Driver" p:url="jdbc:mysql://localhost:3306/techfaq" p:username="root" password="pingpong123" />




<!-- ADD PERSISTENCE SUPPORT HERE (jpa, hibernate, etc) -->

<bean id="entityManagerFactory"
class="org.springframework.orm.jpa.LocalContainerE ntityManagerFactoryBean">
<property name="persistenceUnitName" value="SpringDemoPU" />
<property name="dataSource" ref="dataSource" />
<property name="jpaVendorAdapter">
<bean class="org.springframework.orm.jpa.vendor.Hibernat eJpaVendorAdapter">
<property name="showSql" value="false" />
<property name="databasePlatform" value="org.hibernate.dialect.HSQLDialect" />
</bean>
</property>
</bean>

<bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionM anager">
<property name="entityManagerFactory" ref="entityManagerFactory" />
<property name="dataSource" ref="dataSource" />
</bean>
</beans>

When i deploy my war file in Jboss it gives me exception

14:46:34,558 ERROR [AbstractKernelController] Error installing to Start: name=persistence.unit:unitName=#SpringDemoPU state=Create
javax.persistence.PersistenceException: [PersistenceUnit: SpringDemoPU] Unable to build EntityManagerFactory
at org.hibernate.ejb.Ejb3Configuration.buildEntityMan agerFactory(Ejb3Configuration.java:677)
at org.hibernate.ejb.HibernatePersistence.createConta inerEntityManagerFactory(HibernatePersistence.java :132)
at org.jboss.jpa.deployment.PersistenceUnitDeployment .start(PersistenceUnitDeployment.java:301)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.reflect.plugins.introspection.Reflection Utils.invoke(ReflectionUtils.java:59)
at org.jboss.reflect.plugins.introspection.ReflectMet hodInfoImpl.invoke(ReflectMethodInfoImpl.java:150)
at org.jboss.joinpoint.plugins.BasicMethodJoinPoint.d ispatch(BasicMethodJoinPoint.java:66)
at org.jboss.kernel.plugins.dependency.KernelControll erContextAction$JoinpointDispatchWrapper.execute(K ernelControllerContextAction.java:241)
at org.jboss.kernel.plugins.dependency.ExecutionWrapp er.execute(ExecutionWrapper.java:47)
at org.jboss.kernel.plugins.dependency.KernelControll erContextAction.dispatchExecutionWrapper(KernelCon trollerContextAction.java:109)
at org.jboss.kernel.plugins.dependency.KernelControll erContextAction.dispatchJoinPoint(KernelController ContextAction.java:70)
at org.jboss.kernel.plugins.dependency.LifecycleActio n.installActionInternal(LifecycleAction.java:221)
at org.jboss.kernel.plugins.dependency.InstallsAwareA ction.installAction(InstallsAwareAction.java:54)
at org.jboss.kernel.plugins.dependency.InstallsAwareA ction.installAction(InstallsAwareAction.java:42)

Caused by: org.hibernate.HibernateException: Could not instantiate dialect class
at org.hibernate.dialect.DialectFactory.buildDialect( DialectFactory.java:107)
at org.hibernate.dialect.DialectFactory.buildDialect( DialectFactory.java:65)
at org.hibernate.cfg.SettingsFactory.determineDialect (SettingsFactory.java:460)
at org.hibernate.cfg.SettingsFactory.buildSettings(Se ttingsFactory.java:155)
at org.hibernate.cfg.Configuration.buildSettings(Conf iguration.java:2101)
at org.hibernate.cfg.Configuration.buildSessionFactor y(Configuration.java:1325)
at org.hibernate.cfg.AnnotationConfiguration.buildSes sionFactory(AnnotationConfiguration.java:867)
at org.hibernate.ejb.Ejb3Configuration.buildEntityMan agerFactory(Ejb3Configuration.java:669)
... 61 more
Caused by: java.lang.ClassCastException: org.hibernate.dialect.MySQLDialect cannot be cast to org.hibernate.dialect.Dialect
at org.hibernate.dialect.DialectFactory.buildDialect( DialectFactory.java:101)
... 68 more


I dont why this error is coming i have tried several forum replies but didnt get any success
Please help me to come out from this