[jboss-dev-forums] [JBoss AS 7 Development] - Data Source Configuration in AS 7

[jarkko rantavuori]

jarkko rantavuori [https://community.jboss.org/people/jrantav] commented on the document

"Data Source Configuration in AS 7"

To view all comments on this document, visit: https://community.jboss.org/docs/DOC-16657#comment-11262

--------------------------------------------------
Note that the steps in the article only allow creation of non-xa datasources with mysql.

If you need xa-datasources, you need to have something like this in your module.xml (note the dependency to transaction api):

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

As explained in this irc log:  http://echelog.com/logs/browse/jboss-as7/1327618800 http://echelog.com/logs/browse/jboss-as7/1327618800

Note also that at the time of this writing (14.12.2012) current mysql connector (5.1.22) already contains the file mentioned for type 4 drivers, java.sql.Driver.

Here's a working configuration that defines a non-xa and an xa datasource for mysql:

<datasource jndi-name="java:jboss/datasources/MySqlDS" pool-name="MySqlDS" enabled="true">
    <connection-url>jdbc:mysql://localhost:3306/test</connection-url>
    <driver>com.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>root</user-name>
        <password>mysqlpass</password>
    </security>
    <statement>
        <prepared-statement-cache-size>32</prepared-statement-cache-size>
        <share-prepared-statements>true</share-prepared-statements>
    </statement>
</datasource>
<xa-datasource jndi-name="java:jboss/datasources/MySqlXADS" pool-name="MySqlXADS" enabled="true" use-ccm="false">
    <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
        <xa-datasource-property name="ServerName">
            localhost
        </xa-datasource-property>
        <xa-datasource-property name="DatabaseName">
            test
        </xa-datasource-property>
        <xa-datasource-property name="User">
            root
        </xa-datasource-property>
        <xa-datasource-property name="Password">
            mysqlpass
        </xa-datasource-property>
    <driver>com.mysql</driver>
    <xa-pool>
        <is-same-rm-override>false</is-same-rm-override>
        <interleaving>false</interleaving>
        <pad-xid>false</pad-xid>
        <wrap-xa-resource>false</wrap-xa-resource>
    </xa-pool>
    <security>
        <user-name>root</user-name>
        <password>mysqlpass</password>
    </security>
    <validation>
        <validate-on-match>false</validate-on-match>
        <background-validation>false</background-validation>
    </validation>
    <statement>
        <share-prepared-statements>false</share-prepared-statements>
    </statement>
</xa-datasource>
<drivers>
    <driver name="com.mysql" module="com.mysql">
        <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
    </driver>
</drivers>
--------------------------------------------------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-dev-forums/attachments/20121214/2bac6275/attachment-0001.html