1 Reply Latest reply on Sep 27, 2011 12:06 AM by jaikiran

    Unable to deploy and initialize datasource for MySQL

    developer251

      Hi all,

      I'm trying to create a datasource for mysql (5.1) using JBoss 7.0.2. I've gone through the following issues:

      1. If I deploy the mysql-connector-java-5.1.16-bin.jar into the deployments folder the console logs:

       

      21:16:13,820 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1 -1) Deploying non-JDBC-compliant driver class com.mysql.jdbc.Driver (version 5.1)

       

      But the JDBC driver actually contains into the META-INF/services a file named java.sql.Driver with the JDBC driver name.

       

      2. The second issue is that if I try to add the datasource using CLI, I have a generic error which says the datasource is already registered (?!?)

       

      [standalone@localhost:9999 /] /subsystem=datasources/data-source=MySqlDB:add(jndi-name="MySqlDB",pool-name="MySql_Pool",connection-url=jdbc:mysql://localhost:3306/database1,username=max ,password=korn,driver-class=com.mysql.jdbc.Driver,driver-name="mysql")

      {

          "outcome" => "failed",

          "failure-description" => "Operation handler failed: org.jboss.msc.service.DuplicateServiceException: Service jboss.data-source-config.MySqlDB is already registered",

          "rolled-back" => true

      }

      Maybe the CLI syntax I'm using is incorrect so the CLI tries to add the resource twice ......

      Any help to solve these issues ????

      Thanks a lot

      Max