spring+jotm 多数据源事务管理(二)hibernate

JOTM (Java Open Transaction Manager)是由ObjectWeb协会开发的功能完整的且资源开放的独立的事务管理器。

它提供了 JAVA 应用程序的事务支持，而且与 JTA（ JAVA 事务 API）兼容。您可以在JOTM home page 了解到更多的详细信息。

 

下载地址：http://forge.ow2.org/projects/jotm/

 

本文介绍如何在spring配置文件中加入jotm来实现多数据源事务控制。

使用hibernate关联jotm也很方便，先看一个没有使用jotm的例子：

 

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" xmlns:p="http://www.springframework.org/schema/p"  
4.     xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context"  
5.     xmlns:tx="http://www.springframework.org/schema/tx" xmlns:util="http://www.springframework.org/schema/util"  
6.     xmlns:jee="http://www.springframework.org/schema/jee"  
7.     xsi:schemaLocation="  
8.             http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd  
9.             http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd  
10.             http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd  
11.             http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd  
12.             http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-2.5.xsd  
13.             http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-2.5.xsd">  
14.   
15.   
16.     <bean id="dataSource1"    
17.         class="org.apache.commons.dbcp.BasicDataSource">    
18.         <property name="driverClassName">    
19.             <value>${datasource1.driver}</value>    
20.         </property>    
21.         <property name="url">    
22.             <value>${datasource1.url}</value>    
23.         </property>    
24.         <property name="username">    
25.             <value>${datasource1.username}</value>    
26.         </property>    
27.         <property name="password">    
28.             <value>${datasource1.password}</value>    
29.         </property>    
30.         <property name="initialSize">    
31.             <value>5</value>    
32.         </property>    
33.         <property name="maxActive">    
34.             <value>10</value>    
35.         </property>    
36.     </bean>    
37.         
38.     <bean id="dataSource2"    
39.         class="org.apache.commons.dbcp.BasicDataSource">    
40.         <property name="driverClassName">    
41.             <value>${datasource2.driver}</value>    
42.         </property>    
43.         <property name="url">    
44.             <value>${datasource2.url}</value>    
45.         </property>    
46.         <property name="username">    
47.             <value>${datasource2.username}</value>    
48.         </property>    
49.         <property name="password">    
50.             <value>${datasource2.password}</value>    
51.         </property>    
52.         <property name="initialSize">    
53.             <value>5</value>    
54.         </property>    
55.         <property name="maxActive">    
56.             <value>10</value>    
57.         </property>    
58.     </bean>    
59.   
60.     <bean id="sessionFactory1"  
61.         class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">  
62.         <property name="dataSource" ref="dataSource1" />  
63.         <property name="mappingLocations" value="${das.mapping.locations}" />  
64.         <property name="hibernateProperties">  
65.             <props>  
66.                 <prop key="hibernate.dialect">  
67.                     ${hibernate.dialect}  
68.                 </prop>  
69.                 <prop key="hibernate.show_sql">  
70.                     ${hibernate.show_sql}  
71.                 </prop>  
72.                 <prop key="hibernate.use_sql_comments">  
73.                     ${hibernate.use_sql_comments}  
74.                 </prop>  
75.             </props>  
76.         </property>  
77.     </bean>  
78.   
79.   
80.     <bean id="sessionFactory2"  
81.         class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">  
82.         <property name="dataSource" ref="dataSource2" />  
83.         <property name="mappingLocations" value="${history.mapping.locations}" />  
84.         <property name="hibernateProperties">  
85.             <props>  
86.                 <prop key="hibernate.dialect">  
87.                     ${hibernate.dialect}  
88.                 </prop>  
89.                 <prop key="hibernate.show_sql">  
90.                     ${hibernate.show_sql}  
91.                 </prop>  
92.                 <prop key="hibernate.use_sql_comments">  
93.                     ${hibernate.use_sql_comments}  
94.                 </prop>  
95.             </props>  
96.         </property>  
97.     </bean>  
98.   
99.   
100.       
101.   
102.     <bean id="transactionManager1"  
103.         class="org.springframework.orm.hibernate3.HibernateTransactionManager">  
104.         <property name="sessionFactory" ref="sessionFactory1" />  
105.     </bean>  
106.     <bean id="transactionManager2"  
107.         class="org.springframework.orm.hibernate3.HibernateTransactionManager">  
108.         <property name="sessionFactory" ref="sessionFactory2" />  
109.     </bean>  
110.   
111.     <aop:config proxy-target-class="true">  
112.         <aop:pointcut id="servicePoint1"  
113.             expression="execution (* com.xxx.function..service.*.*Service*.*(..))" />  
114.         <aop:advisor pointcut-ref="servicePoint1" id="txAdvisor1"  
115.             advice-ref="txAdvice1" />  
116.     </aop:config>  
117.   
118.     <aop:config proxy-target-class="true">  
119.         <aop:pointcut id="servicePoint2"  
120.             expression="execution (* com.xxx.function..service.*.*Service*.*(..))" />  
121.         <aop:advisor pointcut-ref="servicePoint2" id="txAdvisor2"  
122.             advice-ref="txAdvice2" />  
123.     </aop:config>  
124.   
125.   
126.     <tx:advice id="txAdvice1" transaction-manager="transactionManager1">  
127.         <tx:attributes>  
128.             <tx:method name="find*" read-only="true" />  
129.             <tx:method name="get*" read-only="true" />  
130.             <tx:method name="query*" read-only="true" />  
131.             <tx:method name="load*" read-only="true" />  
132.             <tx:method name="add*" propagation="REQUIRED" rollback-for="java.lang.Exception" />  
133.             <tx:method name="create*" propagation="REQUIRED"  
134.                 rollback-for="java.lang.Exception" />  
135.             <tx:method name="save*" propagation="REQUIRED"  
136.                 rollback-for="java.lang.Exception" />  
137.             <tx:method name="update*" propagation="REQUIRED"  
138.                 rollback-for="java.lang.Exception" />  
139.             <tx:method name="modify*" propagation="REQUIRED"  
140.                 rollback-for="java.lang.Exception" />  
141.             <tx:method name="delete*" propagation="REQUIRED"  
142.                 rollback-for="java.lang.Exception" />  
143.             <tx:method name="remove*" propagation="REQUIRED"  
144.                 rollback-for="java.lang.Exception" />  
145.             <tx:method name="apply*" propagation="REQUIRED"  
146.                 rollback-for="java.lang.Exception" />  
147.             <tx:method name="handle*" propagation="REQUIRED"  
148.                 rollback-for="java.lang.Exception" />  
149.         </tx:attributes>  
150.     </tx:advice>  
151.     <tx:advice id="txAdvice2" transaction-manager="transactionManager2">  
152.         <tx:attributes>  
153.             <tx:method name="find*" read-only="true" />  
154.             <tx:method name="get*" read-only="true" />  
155.             <tx:method name="query*" read-only="true" />  
156.             <tx:method name="load*" read-only="true" />  
157.             <tx:method name="add*" propagation="REQUIRED" rollback-for="java.lang.Exception" />  
158.             <tx:method name="create*" propagation="REQUIRED"  
159.                 rollback-for="java.lang.Exception" />  
160.             <tx:method name="save*" propagation="REQUIRED"  
161.                 rollback-for="java.lang.Exception" />  
162.             <tx:method name="update*" propagation="REQUIRED"  
163.                 rollback-for="java.lang.Exception" />  
164.             <tx:method name="modify*" propagation="REQUIRED"  
165.                 rollback-for="java.lang.Exception" />  
166.             <tx:method name="delete*" propagation="REQUIRED"  
167.                 rollback-for="java.lang.Exception" />  
168.             <tx:method name="remove*" propagation="REQUIRED"  
169.                 rollback-for="java.lang.Exception" />  
170.             <tx:method name="apply*" propagation="REQUIRED"  
171.                 rollback-for="java.lang.Exception" />  
172.             <tx:method name="handle*" propagation="REQUIRED"  
173.                 rollback-for="java.lang.Exception" />  
174.                 <tx:method name="do*" propagation="REQUIRED"  
175.                 rollback-for="java.lang.Exception" />  
176.         </tx:attributes>  
177.     </tx:advice>  
178.   
179.   
180. </beans>  

 

    下面看加入jotm的例子：

 

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" xmlns:p="http://www.springframework.org/schema/p"  
4.     xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context"  
5.     xmlns:tx="http://www.springframework.org/schema/tx" xmlns:util="http://www.springframework.org/schema/util"  
6.     xmlns:jee="http://www.springframework.org/schema/jee" xmlns:security="http://www.springframework.org/schema/security"  
7.     xsi:schemaLocation="  
8.             http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd  
9.             http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd  
10.             http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd  
11.             http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd  
12.             http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-2.5.xsd  
13.             http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-2.5.xsd  
14.             http://www.springframework.org/schema/security http://www.springframework.org/schema/security/spring-security-2.0.xsd"  
15.     default-lazy-init="true">  
16.   
17.   
18.     <bean id="jotm" class="org.springframework.transaction.jta.JotmFactoryBean" />  
19.   
20.     <bean id="transactionManager"  
21.         class="org.springframework.transaction.jta.JtaTransactionManager">  
22.         <property name="userTransaction" ref="jotm" />  
23.     </bean>  
24.   
25.     <bean id="dataSource1" class="org.enhydra.jdbc.pool.StandardXAPoolDataSource"  
26.         destroy-method="shutdown">  
27.         <property name="dataSource">  
28.             <bean class="org.enhydra.jdbc.standard.StandardXADataSource"  
29.                 destroy-method="shutdown">  
30.                 <property name="transactionManager" ref="jotm" />  
31.                 <property name="driverName" value="${datasource1.driver}" />  
32.                 <property name="url" value="${datasource1.url}" />  
33.             </bean>  
34.         </property>  
35.         <property name="user" value="${datasource1.username}" />  
36.         <property name="password" value="${datasource1.password}" />  
37.     </bean>  
38.   
39.     <bean id="dataSource2" class="org.enhydra.jdbc.pool.StandardXAPoolDataSource"  
40.         destroy-method="shutdown">  
41.         <property name="dataSource">  
42.             <bean class="org.enhydra.jdbc.standard.StandardXADataSource"  
43.                 destroy-method="shutdown">  
44.                 <property name="transactionManager" ref="jotm" />  
45.                 <property name="driverName" value="${datasource2.driver}" />  
46.                 <property name="url" value="${datasource2.url}" />  
47.             </bean>  
48.         </property>  
49.         <property name="user" value="${datasource2.username}" />  
50.         <property name="password" value="${datasource2.password}" />  
51.     </bean>  
52.   
53.   
54.       
55.   
56.     <bean id="sessionFactory1"  
57.         class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">  
58.         <property name="dataSource" ref="dataSource1" />  
59.         <property name="mappingLocations" value="${hibernate.mapping.locations}" />  
60.         <property name="hibernateProperties">  
61.             <props>  
62.                 <prop key="hibernate.dialect">  
63.                     ${hibernate.dialect}  
64.                 </prop>  
65.                 <prop key="hibernate.show_sql">  
66.                     ${hibernate.show_sql}  
67.                 </prop>  
68.                 <prop key="hibernate.use_sql_comments">  
69.                     ${hibernate.use_sql_comments}  
70.                 </prop>  
71.             </props>  
72.         </property>  
73.     </bean>  
74.   
75.       
76.     <bean id="sessionFactory2"  
77.         class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">  
78.         <property name="dataSource" ref="dataSource2" />  
79.         <property name="mappingLocations" value="${hibernate.mapping.special}" />  
80.         <property name="hibernateProperties">  
81.             <props>  
82.                 <prop key="hibernate.dialect">  
83.                     ${hibernate.dialect}  
84.                 </prop>  
85.                 <prop key="hibernate.show_sql">  
86.                     ${hibernate.show_sql}  
87.                 </prop>  
88.                 <prop key="hibernate.use_sql_comments">  
89.                     ${hibernate.use_sql_comments}  
90.                 </prop>  
91.             </props>  
92.         </property>  
93.     </bean>  
94.   
95.     <aop:config proxy-target-class="true">  
96.         <aop:pointcut id="servicePoint"  
97.             expression="execution (* com.xxx.function.*.service.*.*Service*.*(..))" />  
98.         <aop:advisor pointcut-ref="servicePoint" id="txAdvisor"  
99.             advice-ref="defaultTxAdvice" />  
100.     </aop:config>  
101.   
102.     <tx:advice id="defaultTxAdvice" transaction-manager="transactionManager">  
103.         <tx:attributes>  
104.             <tx:method name="find*" read-only="true" />  
105.             <tx:method name="get*" read-only="true" />  
106.             <tx:method name="query*" read-only="true" />  
107.             <tx:method name="load*" read-only="true" />  
108.             <tx:method name="add*" propagation="REQUIRED" rollback-for="java.lang.Exception" />  
109.             <tx:method name="create*" propagation="REQUIRED"  
110.                 rollback-for="java.lang.Exception" />  
111.             <tx:method name="save*" propagation="REQUIRED"  
112.                 rollback-for="java.lang.Exception" />  
113.             <tx:method name="update*" propagation="REQUIRED"  
114.                 rollback-for="java.lang.Exception" />  
115.             <tx:method name="modify*" propagation="REQUIRED"  
116.                 rollback-for="java.lang.Exception" />  
117.             <tx:method name="delete*" propagation="REQUIRED"  
118.                 rollback-for="java.lang.Exception" />  
119.             <tx:method name="remove*" propagation="REQUIRED"  
120.                 rollback-for="java.lang.Exception" />  
121.             <tx:method name="apply*" propagation="REQUIRED"  
122.                 rollback-for="java.lang.Exception" />  
123.             <tx:method name="handle*" propagation="REQUIRED"  
124.                 rollback-for="java.lang.Exception" />  
125.         </tx:attributes>  
126.     </tx:advice>  
127.   
128.       
129.   
130. </beans>    

  

 另外，在使用jotm时，可能会抛如下异常：

Java代码  

1. java.lang.NoSuchMethodError at:sun.rmi.transport.ObjectTable.getStub(Ljava/rmi/Remote;)Ljava/rmi/server/RemoteStub;  

 

此时，在项目编译路径下新建一个属性文件，名称：carol.properties，即可解决问题。

Java代码  

1. # JNDI (Protocol Invocation)  
2. carol.protocols=jrmp  
3. # Local RMI Invocation  
4. carol.jvm.rmi.local.call=true  
5. # do not use CAROL JNDI wrapper  
6. carol.start.jndi=false  
7. # do not start a name server  
8. carol.start.ns=false  
9. carol.start.rmi=false  
10. # Naming Factory  
11. carol.jndi.java.naming.factory.url.pkgs=org.apache.naming  

ok。