使用Atomikos Transactions Essentials实现多数据源JTA分布式事务

 

1. <!-- 第一个数据库 -->   
2. < bean   id = "dataSource"   class = "com.atomikos.jdbc.SimpleDataSourceBean"   init-method = "init"   destroy-method = "close" >   
3.     < property   name = "uniqueResourceName" >   
4.         < value > mysql/main </ value >   
5.     </ property >   
6.     < property   name = "xaDataSourceClassName" >   
7.         <!-- 使用Mysql XADataSource(mysql>=5.0, Connector/J>=5.0才可以支持XADatasource)-->   
8.         < value > com.mysql.jdbc.jdbc2.optional.MysqlXADataSource </ value >   
9.     </ property >   
10.     < property   name = "xaDataSourceProperties" >   
11.         < value > URL =${jdbc.url}; user =${jdbc.username}; password =${jdbc.password} </ value >   
12.     </ property >   
13.     < property   name = "exclusiveConnectionMode" >   
14.         < value > true </ value >   
15.     </ property >   
16.     < property   name = "connectionPoolSize" >   
17.         < value > 3 </ value >   
18.     </ property >   
19.     < property   name = "validatingQuery" >   
20.         < value > SELECT 1 </ value >   
21.     </ property >   
22. </ bean >   
23. <!-- 第二个数据库 -->   
24. < bean   id = "dataSourceB"   class = "com.atomikos.jdbc.SimpleDataSourceBean"   init-method = "init"   destroy-method = "close" >   
25.     < property   name = "uniqueResourceName" >   
26.         < value > mysql/news </ value >   
27.     </ property >   
28.     < property   name = "xaDataSourceClassName" >   
29.         <!-- 使用Mysql XADataSource(mysql>=5.0, Connector/J>=5.0才可以支持XADatasource)-->   
30.         < value > com.mysql.jdbc.jdbc2.optional.MysqlXADataSource </ value >   
31.     </ property >   
32.     < property   name = "xaDataSourceProperties" >   
33.         < value > URL =${jdbc.url.b}; user =${jdbc.username.b}; password =${jdbc.password.b} </ value >   
34.     </ property >   
35.     < property   name = "exclusiveConnectionMode" >   
36.         < value > true </ value >   
37.     </ property >   
38.     < property   name = "connectionPoolSize" >   
39.         < value > 3 </ value >   
40.     </ property >   
41.     < property   name = "validatingQuery" >   
42.         < value > SELECT 1 </ value >   
43.     </ property >   
44. </ bean >   
45.   
46.   
47. < bean   id = "lobHandler"   class = "org.springframework.jdbc.support.lob.DefaultLobHandler"   />   
48.   
49. <!-- 第一个数据库的sqlMapClient -->   
50. < bean   id = "sqlMapClient"   class = "org.springframework.orm.ibatis.SqlMapClientFactoryBean" >   
51.     < property   name = "configLocation" >   
52.         <!-- 包含第一个数据库表的map -->   
53.         < value > classpath:/sqlmap-config.xml </ value >   
54.     </ property >   
55.     < property   name = "dataSource"   ref = "dataSource"   />   
56.     < property   name = "lobHandler"   ref = "lobHandler"   />   
57. </ bean >   
58. <!-- 第二个数据库的sqlMapClient -->   
59. < bean   id = "sqlMapClientB"   class = "org.springframework.orm.ibatis.SqlMapClientFactoryBean" >   
60.     < property   name = "configLocation" >   
61.         <!-- 包含第一个数据库表的map -->   
62.         < value > classpath:/sqlmap-configb.xml </ value >   
63.     </ property >   
64.     < property   name = "dataSource"   ref = "dataSourceB"   />   
65.     < property   name = "lobHandler"   ref = "lobHandler"   />   
66. </ bean >   
67.   
68. <!-- Construct Atomikos UserTransactionManager, needed to configure Spring -->   
69. < bean   id = "atomikosTransactionManager"   class = "com.atomikos.icatch.jta.UserTransactionManager"   init-method = "init"   
70.     destroy-method = "close" >   
71.     <!--  when close is called, should we force transactions to terminate or not? -->   
72.     < property   name = "forceShutdown" >   
73.         < value > true </ value >   
74.     </ property >   
75. </ bean >   
76.   
77. <!-- Also use Atomikos UserTransactionImp, needed to configure Spring  -->   
78. < bean   id = "atomikosUserTransaction"   class = "com.atomikos.icatch.jta.UserTransactionImp" >   
79.     < property   name = "transactionTimeout"   value = "240"   />   
80. </ bean >   
81.   
82. <!-- Configure the Spring framework to use JTA transactions from Atomikos -->   
83. < bean   id = "transactionManager"   class = "org.springframework.transaction.jta.JtaTransactionManager" >   
84.     < property   name = "transactionManager" >   
85.         < ref   bean = "atomikosTransactionManager"   />   
86.     </ property >   
87.     < property   name = "userTransaction" >   
88.         < ref   bean = "atomikosUserTransaction"   />   
89.     </ property >   
90. </ bean >   

事务的配置, 使用了spring2.0的语法，所以将namesapce也帖出来了.

xml 代码

 

1. <? xml   version = "1.0"   encoding = "UTF-8" ?>   
2. < beans   xmlns = "http://www.springframework.org/schema/beans"   
3.        xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance"   
4.        xmlns:aop = "http://www.springframework.org/schema/aop"   
5.        xmlns:tx = "http://www.springframework.org/schema/tx"   
6.        xsi:schemaLocation ="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd  
7.            http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd  
8.            http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd"  
9.        default-autowire = "byName"   default-lazy-init = "true" >   
10.     <!-- 支持 @AspectJ 标记-->   
11.     < aop:aspectj-autoproxy />   
12.   
13.     < aop:config   proxy-target-class = "true" >   
14.         < aop:advisor   pointcut = "execution(* *Facade.*(..))"   advice-ref = "txAdvice" />   
15.         < aop:advisor   pointcut = "execution(* *Manager.*(..))"   advice-ref = "txAdvice" />   
16.     </ aop:config >   
17.   
18.     < tx:advice   id = "txAdvice" >   
19.         < tx:attributes >   
20.             < tx:method   name = "get*"   read-only = "true" />   
21.             < tx:method   name = "find*"   read-only = "true" />   
22.             < tx:method   name = "has*"   read-only = "true" />   
23.             < tx:method   name = "locate*"   read-only = "true" />   
24.             < tx:method   name = "*" />   
25.         </ tx:attributes >   
26.     </ tx:advice >   
27. </ beans >