[jboss-user] [JBoss Seam] - Seam and MySQL - Apparently wrong driver class specified?

[strickla]

Hi everyone,

I'm trying to create a new Seam project and use MySQL instead of HSQL.  
When I attempt to start up the JBoss AS I get the following exception during initialization:

10:45:03,312 INFO  [DatasourceConnectionProvider] Using datasource: java:/mmogwi
  | dgetsDatasource
  | 10:45:03,328 WARN  [JBossManagedConnectionPool] Throwable while attempting to ge
  | t a new connection: null
  | org.jboss.resource.JBossResourceException: Could not create connection; - nested
  |  throwable: (org.jboss.resource.JBossResourceException: Apparently wrong driver
  | class specified for URL: class: com.mysql.jdbc.Driver, url: jdbc:mysql://localho
  | st:3306/mmogwidgets)
  |         at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.c
  | reateManagedConnection(LocalManagedConnectionFactory.java:179)
  |         at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.cr
  | eateConnectionEventListener(InternalManagedConnectionPool.java:577)
  |         at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.ge
  | tConnection(InternalManagedConnectionPool.java:262)
  |         at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BaseP
  | ool.getConnection(JBossManagedConnectionPool.java:500)
  |         at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManage
  | dConnection(BaseConnectionManager2.java:341)
  |         at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedCo
  | nnection(TxConnectionManager.java:315)
  |         at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateC
  | onnection(BaseConnectionManager2.java:396)
  |         at org.jboss.resource.connectionmanager.BaseConnectionManager2$Connectio


I used mysql Connector/J driver as the library to provide my driver class during seam setup script.  It's name is "mysql-connector-java-5.0.6-bin.jar".  I modified the build.xml to include that lib in the war when it is deployed.  I also changed the dialect in the -ds.xml file so that it uses MySQLDialect.

Here is my data source xml file:

<local-tx-datasource>
  |       <jndi-name>mmogwidgetsDatasource</jndi-name>
  |       <connection-url>jdbc:mysql://localhost:3306/mmogwidgets</connection-url>
  |       <driver-class>com.mysql.jdbc.Driver</driver-class>
  |       <user-name>xxx</user-name>
  |       <password>xxx</password>
  | <!-- 
  |       <exception-sorter-class-name>
  |          org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter
  |       </exception-sorter-class-name>
  |       <metadata>
  |          <type-mapping>mySQL</type-mapping>
  |       </metadata>
  | -->
  |    </local-tx-datasource>

and here is my persistence xml file:

<persistence-unit name="mmogwidgets" transaction-type="JTA">
  |       <provider>org.hibernate.ejb.HibernatePersistence</provider>
  |       <jta-data-source>java:/mmogwidgetsDatasource</jta-data-source>
  |       <properties>
  |          <property name="hibernate.hbm2ddl.auto" value="create-drop"/>
  |          <property name="hibernate.show_sql" value="true"/>
  |          <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
  |          <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup"/>
  |       </properties>
  |    </persistence-unit>

Anyone know what's going wrong?

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4060874#4060874

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4060874