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