Atomikos分兩個(gè)：一個(gè)是開源的TransactionEssentials，一個(gè)是商業(yè)的ExtremeTransactions。
TransactionEssentials的主要特征：JTA/XA 事務(wù)管理 —— 提供事務(wù)管理和連接池不需要應(yīng)用服務(wù)器 —— TransactionEssentials可以在任何Java EE應(yīng)用服務(wù)器中運(yùn)行，也就是不依賴于任何應(yīng)用服務(wù)器開源 —— TransactionEssentials是遵守Apache版本2許可的開源軟件專注于JDBC/JMS —— 支持所有XA資源，但是資源池和消息監(jiān)聽是專供JDBC和JMS的與Spring 和 Hibernate 集成 —— 提供了描述如何與Spring和Hibernate集成的文檔
一、環(huán)境
spring 2
ibatis2
AtomikosTransactionsEssentials-3.7.0?下載地址：http://www.atomikos.com/Main/InstallingTransactionsEssentials
MySQL-5.1 ： 數(shù)據(jù)庫(kù)引擎為InnoDB，只有這樣才能支持事務(wù)?
JDK1.6
Oracle10
二 jar包
? Atomikos jar必須包?transactions-jdbc.jar
transactions-jta.jar
transactions.jar
atomikos-util.jar??
transactions-api.jar?
ibatis,spring
只要符合二者集成jar組合即可，無額外jar
三、配置
Oracle用戶授權(quán)：（視情況而定，如果程序出現(xiàn)如下異常則需要加上1672 [main] WARN atomikos - ERROR IN RECOVERY com.atomikos.datasource.ResourceException: Error in recovery）
grant select on sys.dba_pending_transactions to orcl;
grant select on sys.pending_trans$ to orcl;
grant select on sys.dba_2pc_pending to orcl;
grant execute on sys.dbms_system to orcl;
jta.properties 配置文件，即src/ jta.properties內(nèi)容如下：
?
1
|
com.atomikos.icatch.service=com.atomikos.icatch.standalone.UserTransactionServiceFactory
|
2
|
?
com.atomikos.icatch.console_file_name = tm.out?
|
3
|
com.atomikos.icatch.log_base_name = tmlog?
|
4
|
com.atomikos.icatch.tm_unique_name = com.atomikos.spring.jdbc.tm?
|
5
|
com.atomikos.icatch.console_log_level = INFO
|
?
?
spring配置文件
代碼
<!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
-->
<?
xml version="1.0" encoding="UTF-8"
?>
<
beans
xmlns
="http://www.springframework.org/schema/beans"
xmlns:xsi
="http://www.w3.org/2001/XMLSchema-instance"
xmlns:aop
="http://www.springframework.org/schema/aop"
xmlns:tx
="http://www.springframework.org/schema/tx"
xsi:schemaLocation
="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd "
>
<!--
事物管理器
-->
<
bean
id
="atomikosUserTransaction"
class
="com.atomikos.icatch.jta.UserTransactionImp"
>
<
description
>
UserTransactionImp
</
description
>
<
property
name
="transactionTimeout"
value
="300"
/>
</
bean
>
<
bean
id
="atomikosTransactionManager"
class
="com.atomikos.icatch.jta.UserTransactionManager"
init-method
="init"
destroy-method
="close"
>
<
description
>
UserTransactionManager
</
description
>
<
property
name
="forceShutdown"
>
<
value
>
true
</
value
>
</
property
>
</
bean
>
<
bean
id
="transactionManager"
class
="org.springframework.transaction.jta.JtaTransactionManager"
>
<
description
>
JtaTransactionManager
</
description
>
<
property
name
="transactionManager"
>
<
ref
bean
="atomikosTransactionManager"
/>
</
property
>
<
property
name
="userTransaction"
>
<
ref
bean
="atomikosUserTransaction"
/>
</
property
>
<
property
name
="allowCustomIsolationLevels"
value
="true"
/>
<!
—必須設(shè)置，否則程序出現(xiàn)異常 JtaTransactionManager does not support custom isolation levels by default --
>
<!
—oracle數(shù)據(jù)源定義 --
>
</
bean
>
<
bean
id
="oracleDS"
class
="com.atomikos.jdbc.AtomikosDataSourceBean"
init-method
="init"
destroy-method
="close"
>
<
description
>
oracle xa datasource
</
description
>
<
property
name
="uniqueResourceName"
>
<
value
>
oracle_ds
</
value
>
</
property
>
<
property
name
="xaDataSourceClassName"
>
<
value
>
oracle.jdbc.xa.client.OracleXADataSource
</
value
>
</
property
>
<
property
name
="xaProperties"
>
<
props
>
<
prop
key
="user"
>
orcl
</
prop
>
<
prop
key
="password"
>
123
</
prop
>
<
prop
key
="URL"
>
jdbc:oracle:thin:@ localhost:1521:orcl
</
prop
>
</
props
>
</
property
>
<
property
name
="testQuery"
>
<
value
>
select 1 from dual
</
value
>
<!
—盡力加上，不然會(huì)出現(xiàn)告警 --
>
</
property
>
</
bean
>
<!
— mysql數(shù)據(jù)源定義 --
>
<
bean
id
="dataSourceoracle2"
class
="com.atomikos.jdbc.AtomikosDataSourceBean"
init-method
="init"
destroy-method
="close"
>
<
description
>
mysql xa datasource
</
description
>
<
property
name
="uniqueResourceName"
>
<
value
>
mysql_ds
</
value
>
</
property
>
<
property
name
="xaDataSourceClassName"
>
<
value
>
com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
</
value
>
</
property
>
<
property
name
="xaProperties"
>
<
props
>
<
prop
key
="user"
>
root
</
prop
>
<
prop
key
="password"
>
123
</
prop
>
<
prop
key
="URL"
>
jdbc:mysql://localhost:3306/test?useUnicode=true
&
characterEncoding=utf-8
</
prop
>
</
props
>
</
property
>
<
property
name
="testQuery"
>
<
value
>
select 1
</
value
>
<!
—盡力加上，不然會(huì)出現(xiàn)告警 --
>
</
property
>
</
bean
>
<!--
ibatis配置源
-->
<
bean
id
="sqlMapClient"
class
="org.springframework.orm.ibatis.SqlMapClientFactoryBean"
>
<
property
name
="configLocation"
value
="classpath:sql-moredata-config.xml"
/>
<
property
name
="dataSource"
ref
="oracleDS"
/>
</
bean
>
<!--
ibatis配置源2
-->
<
bean
id
="sqlMapClient2"
class
="org.springframework.orm.ibatis.SqlMapClientFactoryBean"
>
<
property
name
="configLocation"
value
="classpath:sql-moredata2-config.xml"
/>
<
property
name
="dataSource"
ref
="dataSourceoracle2"
/>
</
bean
>
<
bean
id
="testDaoR"
class
="com.test.moredata.TestDAOImpR"
>
<
property
name
="sqlMapClient"
ref
="sqlMapClient"
></
property
>
</
bean
>
<
bean
id
="testDao"
class
="com.test.moredata.TestDAOImp"
>
<
property
name
="sqlMapClient"
ref
="sqlMapClient2"
></
property
>
</
bean
>
<
bean
id
="testService"
class
="com.test.moredata.TestService"
>
<
property
name
="testDao"
ref
="testDao"
></
property
>
<
property
name
="testDaoR"
ref
="testDaoR"
></
property
>
</
bean
>
<!
— aop配置 --
>
<
tx:advice
id
="transactionManagerAdivice"
transaction-manager
="transactionManager"
>
<
tx:attributes
>
<
tx:method
name
="*"
isolation
="READ_COMMITTED"
propagation
="REQUIRED"
rollback-for
="java.lang.RuntionException"
/>
</
tx:attributes
>
</
tx:advice
>
<
aop:config
>
<
aop:pointcut
expression
="execution(* com.test.moredata.TestService.*(..))"
id
="tsServicePc"
/>
<
aop:advisor
advice-ref
="transactionManagerAdivice"
pointcut-ref
="tsServicePc"
/>
</
aop:config
>
更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號(hào)聯(lián)系： 360901061
您的支持是博主寫作最大的動(dòng)力，如果您喜歡我的文章，感覺我的文章對(duì)您有幫助，請(qǐng)用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點(diǎn)擊下面給點(diǎn)支持吧，站長(zhǎng)非常感激您！手機(jī)微信長(zhǎng)按不能支付解決辦法：請(qǐng)將微信支付二維碼保存到相冊(cè)，切換到微信，然后點(diǎn)擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對(duì)您有幫助就好】元
