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 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
