JBoss 7 MySQL数据源问题 [英] JBoss 7 MySQL datasource issue

问题描述

我正在尝试在JBOSS 7中创建数据源.

I'm trying to create a datasource in JBOSS 7.

我的standalone.xml摘录:

My standalone.xml excerpts:

<subsystem xmlns="urn:jboss:domain:datasources:1.0">
<datasources>
    <datasource jndi-name="MySqlDS" pool-name="MySqlDS" enabled="true" jta="true" use-java-context="true" use-ccm="true">
         <connection-url>jdbc:mysql://localhost:3306/sampledb</connection-url>
          <driver>mysql</driver>
          <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
          <pool>
            <prefill>true</prefill>
            <use-strict-min>false</use-strict-min>
            <flush-strategy>FailingConnectionOnly</flush-strategy>
          </pool>
          <security>
            <user-name>root</user-name>
            <password>matrix</password>
          </security>
    </datasource>
    <drivers>
        <driver name="mysql" module="com.mysql">
         <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
        </driver>
    </drivers>
</datasources>

我已经创建了module/com/mysql/main目录，并将mysql jar和module.xml放在其中，如下所示:

and I have created module/com/mysql/main directory and have put mysql jar there along with module.xml which is as below:

<module xmlns="urn:jboss:module:1.0" name="com.mysql">
    <resources>
        <resource-root path="mysql-connector-java-3.0.17-ga-bin.jar"/>
            <!-- Insert resources here -->
    </resources>
    <dependencies>
      <module name="javax.api"/>
      <module name="javax.transaction.api"/>
    </dependencies>
</module>

并且我的persistence.xml使用此数据源

and my persistence.xml uses this datasource

 <jta-data-source>java:/MySqlDS</jta-data-source>

但是服务器启动时会引发如下错误消息.

But the server start throws the error message as below.

New missing/unsatisfied dependencies:
      service jboss.jdbc-driver.mysql (missing)

能请你帮忙吗?

谢谢.

推荐答案

这将帮助您解决问题.

Jboss和mysql连接器

这篇关于JBoss 7 MySQL数据源问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！