eggB

如果你的应用设计到以下方面(Distributed Transaction 分布式事务), 则应该使用XADatasource, 而不是使用Datasource

1. Uses the Java Transaction API (JTA) 有用到JTA

2. Includes multiple database updates within a single
transaction 单个事务中涉及多次数据库更新操作

3. Accesses multiple resources, such as a database and the
Java Messaging Service (JMS), during a transaction 同一事物中, 访问多个资源, 比如数据库和JMS

4. Use the same connection pool on multiple servers 多个服务器(集群环境)使用同一连接池

对应的Oracle JDBC Drive:  oracle.jdbc.xa.client.OracleXADataSource

付JDBC连接池配置做个参考, 注意黑体的两阶段提交协议

<jdbc-connection-pool-params>
<initial-capacity>0</initial-capacity>
<max-capacity>100</max-capacity>
<capacity-increment>1</capacity-increment>
<shrink-frequency-seconds>900</shrink-frequency-seconds>
<highest-num-waiters>2147483647</highest-num-waiters>
<connection-creation-retry-frequency-seconds>10</connection-creation-retry-frequency-seconds>
<connection-reserve-timeout-seconds>0</connection-reserve-timeout-seconds>
<test-frequency-seconds>10</test-frequency-seconds>
<test-connections-on-reserve>true</test-connections-on-reserve>
<ignore-in-use-connections-enabled>true</ignore-in-use-connections-enabled>
<inactive-connection-timeout-seconds>0</inactive-connection-timeout-seconds>
<test-table-name>SQL SELECT 1 FROM DUAL</test-table-name>
<login-delay-seconds>0</login-delay-seconds>
<statement-cache-size>50</statement-cache-size>
<statement-cache-type>LRU</statement-cache-type>
<remove-infected-connections>false</remove-infected-connections>
<seconds-to-trust-an-idle-pool-connection>10</seconds-to-trust-an-idle-pool-connection>
<statement-timeout>-1</statement-timeout>
<pinned-to-thread>false</pinned-to-thread>
</jdbc-connection-pool-params>
<jdbc-data-source-params>
<jndi-name>xa_failover.ds</jndi-name>
<row-prefetch>true</row-prefetch>
<row-prefetch-size>50</row-prefetch-size>
<stream-chunk-size>8192</stream-chunk-size>
<global-transactions-protocol>TwoPhaseCommit</global-transactions-protocol>
</jdbc-data-source-params>
</jdbc-data-source>