<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Data Source Configuration in AS 7
</h3>
<span style="margin-bottom: 10px;">
new comment by <a href="http://community.jboss.org/people/kwutzke">Karsten Wutzke</a> <a href="http://community.jboss.org/docs/DOC-16657#comment-7163">View all comments on this document</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>In any case, whatever I tried, I only got the MySQL driver to work as a module. Here's my final <datasources> element from standalone.xml using the MySQL driver installed as a module:</p><pre><code><br/></code><p><datasources></p><p>    ...</p><p>    <datasource jndi-name="java:jboss/datasources/YourDS" pool-name="MySqlDS" enabled="true" jta="true" use-java-context="true" use-ccm="true"></p><p>        <connection-url></p><p>            jdbc:mysql://localhost:3306/yourdb</p><p>        </connection-url></p><p>        <driver></p><p>            mysql</p><p>        </driver></p><p>        <transaction-isolation></p><p>            TRANSACTION_READ_COMMITTED</p><p>        </transaction-isolation></p><p>        <pool></p><p>            <min-pool-size></p><p>                10</p><p>            </min-pool-size></p><p>            <max-pool-size></p><p>                100</p><p>            </max-pool-size></p><p>            <prefill></p><p>                true</p><p>            </prefill></p><p>            <use-strict-min></p><p>                false</p><p>            </use-strict-min></p><p>            <flush-strategy></p><p>                FailingConnectionOnly</p><p>            </flush-strategy></p><p>        </pool></p><p>        <security></p><p>            <user-name></p><p>                user</p><p>            </user-name></p><p>            <password></p><p>                pass</p><p>            </password></p><p>        </security></p><p>        <statement></p><p>            <prepared-statement-cache-size></p><p>                32</p><p>            </prepared-statement-cache-size></p><p>        </statement></p><p>    </datasource></p><p>    <drivers></p><p>        ...</p><p>        <driver name="mysql" module="com.mysql"></p><p>            <xa-datasource-class></p><p>                com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</p><p>            </xa-datasource-class></p><p>        </driver></p><p>    </drivers></p><p></datasources></p></pre><p><span>Note that the way you install the driver (deployment vs. module) is independent from the server operating mode (standalone vs. domain), even though you drop the driver JAR into the standalone/deployments directory, see </span><a class="jive-link-external-small" href="https://docs.jboss.org/author/display/AS7/How+do+I+migrate+my+application+from+AS5+or+AS6+to+AS7" target="_blank">https://docs.jboss.org/author/display/AS7/How+do+I+migrate+my+application+from+AS5+or+AS6+to+AS7</a><span>. So you effectively get a matrix of four driver installation - operating mode possibilities, aside from the JDBC 4 compliance (which simply defines whether you need to specify the driver name somewhere) and the choice of XA or plain datasource (adjust tag and class names as appropriate). Note, for whatever reason, there's no such thing as a <datasource-class> tag, hence the use of <xa-datasource-class>.</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span>I have also just gotten through all this and I definitely need to re-read documentation like </span><a class="jive-link-external-small" href="https://docs.jboss.org/author/display/AS7/Operating+modes" target="_blank">https://docs.jboss.org/author/display/AS7/Operating+modes</a><span> myself. Hopefully this will help someone else.</span></p></div>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>