<!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/MrEasy">Rico Neubauer</a> <a href="http://community.jboss.org/docs/DOC-16657#comment-6572">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>Example for an Oracle XA-datasource:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><em><xa-datasource jndi-name="java:/MyDB" pool-name="MyDB" enabled="true" use-java-context="true"></em></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><em>    <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class></em></p><p><em>    <xa-datasource-property name="URL">jdbc:oracle:thin:@server:1521:dbname</xa-datasource-property></em></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><em>    <!-- HA: Oracle Specific methods to deal with connection problems --></em></p><p><em>    <new-connection-sql>call DBMS_APPLICATION_INFO.SET_MODULE('MyApp ${bisas.pid}','MyDB')</new-connection-sql></em></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><em>    <security></em></p><p><em>        <user-name>MyUser</user-name></em></p><p><em>        <password>MyPassword</password></em></p><p><em>    </security></em></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><em>    <!-- pooling parameters --></em></p><p><em>    <xa-pool></em></p><p><em>        <min-pool-size>5</min-pool-size></em></p><p><em>        <max-pool-size>200</max-pool-size></em></p><p><em>        <!-- uncomment to enable interleaving <interleaving/> --></em></p><p><em>        <is-same-rm-override>false</is-same-rm-override></em></p><p><em>        <!-- Oracles XA datasource cannot reuse a connection outside a transaction once enlisted in a global transaction and vice-versa --></em></p><p><em>        <no-tx-separate-pools/></em></p><p><em>    </xa-pool></em></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><em>    <!-- timeout and expiry parameters --></em></p><p><em>    <validation></em></p><p><em>        <validate-on-match>false</validate-on-match></em></p><p><em>        <background-validation-minutes>5</background-validation-minutes></em></p><p><em>        <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool --></em></p><p><em>        <!--valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name--></em></p><p><em>        <!-- Checks the Oracle error codes and messages for fatal errors --></em></p><p><em>        <exception-sorter class-name="org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter"></exception-sorter></em></p><p><em>    </validation></em></p><p><em>    <!-- TODO why is this not working? It should comply with the schema</em></p><p><em>    <time-out></em></p><p><em>        <blocking-timeout-millis>60000</blocking-timeout-millis></em></p><p><em>        <idle-timeout-minutes>15</idle-timeout-minutes></em></p><p><em>    </time-out></em></p><p><em>    --></em></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><em>    <statement></em></p><p><em>        <prepared-statement-cache-size>20</prepared-statement-cache-size></em></p><p><em>        <!-- Whether to monitor for unclosed Statements and ResultSets and issue warnings when the user forgets to close them (default nowarn).</em></p><p><em>         Use nowarn for production and true for testing --></em></p><p><em>        <track-statements>nowarn</track-statements></em></p><p><em>    </statement></em></p><p><em></xa-datasource></em></p></div>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>