[jboss-user] Mysql - Wrong driver class for this connection URL

[Oscar Ostlund]

Hi

I am quite new to JBoss and I am struggling to get a MySQL Datasource
working.

I am writing a Seam application but the problem seems to be a JBoss problem
and I have tried for several hours to get it woking... I really don't
understand what is wrong and I don't know if JMX allows to test the database
connection either...


I have copied mysql-connector-java-5.1.7-bin.jar to server/default/lib and
my datasource is defined as followed:
(the driver works when I connect to the database from Eclipse...)

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE datasources
    PUBLIC "-//JBoss//DTD JBOSS JCA Config 1.5//EN"
    "http://www.jboss.org/j2ee/dtd/jboss-ds_1_5.dtd">

<datasources>

   <local-tx-datasource>
      <jndi-name>MyDatabaseDatasource</jndi-name>

<connection-url>jbdc:mysql://localhost:3306/mydatabase</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>

</datasources>


Here is the exception I get...



16:59:10,223 WARN  [JBossManagedConnectionPool] Throwable while attempting
to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; -
nested throwable: (org.jboss.resource.JBossResourceException: Wrong driver
class for this connection URL)
    at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:225)
    at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:195)
    at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:611)
   ....

16:59:10,231 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null
16:59:10,231 ERROR [JDBCExceptionReporter] Could not create connection; -
nested throwable: (org.jboss.resource.JBossResourceException: Wrong driver
class for this connection URL); - nested throwable:
(org.jboss.resource.JBossResourceException: Could not create connection; -
nested throwable: (org.jboss.resource.JBossResourceException: Wrong driver
class for this connection URL))

Many thanks for your help

Oscar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20090418/1165bedb/attachment.html