Unable to setup MySQL data source in JBoss 7.1.1

[joachim.a]

I have been trying to setup MySQL database datasource in JBoss 7.1.1 as well and - as well as others - I am not able to do it successfully. Here the error I am getting:

JBAS014775:    New missing/unsatisfied dependencies:

      service jboss.jdbc-driver.mysql (missing) dependents: [service jboss.data-source.java:jboss/datasources/MySqlDS]

and the driver was not deployed.

Here my modules.xml file located in $JBOSS_HOME/modules/com/mysql/main :

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

<module xmlns="urn:jboss:module:1.1“ name="com.mysql">

    <resources>

        <resource-root path="mysql-connector-java-5.1.29-bin.jar"/>

    </resources>

    <dependencies>

        <module name="javax.api"/>

  <module name="javax.transaction.api"/>

        <module name="javax.servlet.api" optional="true"/>

    </dependencies>

</module>

and the database source configuration of standalone.xml:

            <datasources>

                <datasource jta="true" jndi-name="java:jboss/datasources/MySqlDS" pool-name="MySqlDS" enabled="true" use-java-context="true" use-ccm="true">

                    <connection-url>jdbc:mysql://localhost:3306/MySqlDS</connection-url>

                    <driver>mysql</driver>

                    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>

                    <pool>

                        <min-pool-size>10</min-pool-size>

                        <max-pool-size>100</max-pool-size>

                        <prefill>true</prefill>

                    </pool>

                    <security>

                        <user-name>ABC</user-name>

                        <password>ABC</password>

                    </security>

                    <statement>

                        <prepared-statement-cache-size>32</prepared-statement-cache-size>

                        <share-prepared-statements>true</share-prepared-statements>

                    </statement>

                </datasource>

                <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">

                    <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url>

                    <driver>h2</driver>

                    <security>

                        <user-name>sa</user-name>

                        <password>sa</password>

                    </security>

                </datasource>

                <drivers>

                    <driver name="mysql" module="com.mysql">

                        <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>

                    </driver>

                    <driver name="h2" module="com.h2database.h2">

                        <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>

                    </driver>

                </drivers>

            </datasources>

I appreciate any help.

[sergiu_pienar]

Your driver's name is declared as "com.mysql" and you are using it as "mysql" .

Declaration: <module xmlns="urn:jboss:module:1.1“ name="com.mysql">

Usage: <driver>mysql</driver>

Try putting <driver>com.mysql</driver>

[wdfink]

That should be no problem as the direver is declared with the modue com.mysql.

joachimaltmeyer could you show the logfile during start?

[joachim.a]

Here is the the logfile sever.log

[wdfink]

I see the initialization message of the H2 DB driver

   JBAS010403: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3)

But there is no similar message for the mySQL driver.

Could you start with a clean logfile? And also attach the module + standalone configuration?

[joachim.a]

Thank you for your support.

Yes, I'm also missing the message for the mySQL driver (therefore I've written "...driver was not deployed").

Here are the files (thought that the information was already given - except of the "clean" log file).

[wdfink]

Your module.xml is wrong, there are some confusing characters, might be Word.

Try the attached one.

Unfortunately there is no error message with a hint that the XML is not correct.

Later JBoss versions are showing a message that the module can not be loaded.

[joachim.a]

Thank You, you are right. Coming from PC, it was not clear to me that TextEdit on the Mac is no pure text editor (depending on the settings). It came not in my mind that the error was caused by this.

Thank You!

[wdfink]

Yeah, depend on the editor you might have issues.

Checking the module.xml with a simple editor on the system will be the first step.

But it looks like that the cause messages are swallowed and there should be an improvement for the error message