用atomikos + tomcat + spring + hibernate 配置分布式事务

ct38

1.tomcat + spring + hibernate + atomikos 配置分布式事务,数据库分别为mysql5.5.11 和 oracle10.2.0.1.
2.在atomikos 官网上下载AtomikosTransactionsEssentials-3.7.0
3.将atomikos/disc下的jar包拷到工程的web-inf/lib下.
4.下面是spring配置文件内容：
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
    <property name="dataSource" ref="myDataSource"/>
    <property name="packagesToScan" value="com.kevin.statistic.entity"/>
    <property name="hibernateProperties">
        <props>
       <prop key="hibernate.dialect">
    org.hibernate.dialect.MySQLDialect
    </prop>
    </props>
    </property>
</bean>

<bean id="myDataSource" class="com.atomikos.jdbc.AtomikosDataSourceBean">
<property name="uniqueResourceName"><value>MYSQL</value></property>
<property name="xaDataSourceClassName"><value>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</value></property>
<property name="xaProperties">
<props>
<prop key="databaseName">STATISTIC</prop>
<prop key="createDatabase">create</prop>
<prop key="user">root</prop>
<prop key="password">root</prop>
<prop key="url">jdbc:mysql://192.168.1.101:3306/statistic</prop>
</props>
</property>
<property name="poolSize"><value>4</value></property>
<property name="borrowConnectionTimeout"><value>60</value></property>
</bean>

<!--以下内容用于测试-->
<bean id="oracleSessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
    <property name="dataSource" ref="oracleDataSource"/>
    <property name="packagesToScan" value="com.kevin.statistic.oracleentity"/>
    <property name="hibernateProperties">
        <props>
       <prop key="hibernate.dialect">
    org.hibernate.dialect.OracleDialect
    </prop>
    </props>
    </property>
</bean>

<bean id="oracleDataSource" class="com.atomikos.jdbc.AtomikosDataSourceBean">
<property name="uniqueResourceName"><value>oracle</value></property>
<property name="xaDataSourceClassName"><value>oracle.jdbc.xa.client.OracleXADataSource</value></property>
<property name="xaProperties">
<props>
<prop key="user">kevin</prop>
<prop key="password">asdfff</prop>
<prop key="URL">jdbc:oracle:thin:@192.168.1.101:1521:XE</prop>
</props>
</property>
<property name="poolSize"><value>1</value></property>
<property name="borrowConnectionTimeout"><value>60</value></property>
</bean>
<!--以上内容用于测试-->

<bean id="atomikosTransactionManager" class="com.atomikos.icatch.jta.UserTransactionManager" init-method="init" destroy-method="close">
<property name="forceShutdown"><value>true</value></property>
</bean>
<bean id="atomikosUserTransaction" class="com.atomikos.icatch.jta.UserTransactionImp">
    <property name="transactionTimeout"><value>300</value></property>
</bean>
<bean id="springTransactionManager" class="org.springframework.transaction.jta.JtaTransactionManager">
<property name="transactionManager"><ref bean="atomikosTransactionManager"  /></property>
<property name="userTransaction"><ref bean="atomikosUserTransaction"  /></property>
<property name="allowCustomIsolationLevels" value="true"/>
</bean>


<tx:advice id="transactionManagerAdivice" transaction-manager="springTransactionManager">
<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.kevin.statistic.system.service.SystemService.*(..))" id="tsServicePc" />
<aop:advisor advice-ref="transactionManagerAdivice" pointcut-ref="tsServicePc" />
</aop:config>

5.确保oracle能用XA：
用sys或dba用户登录，执行以下语句：
grant select on sys.dba_pending_transactions to <user name>;
grant select on sys.pending_trans$ to <user name>;
grant select on sys.dba_2pc_pending to <user name>;
grant execute on sys.dbms_system to <user name>;

6.特别要注意的是<prop key="URL">jdbc:oracle:thin:@192.168.1.101:1521:XE</prop>节点中url为大写。就因为这个大小写问题，折腾了我很长时间。


附：
如果要用spring的annotation,可将：
<tx:advice id="transactionManagerAdivice" transaction-manager="springTransactionManager">
<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.kevin.statistic.system.service.SystemService.*(..))" id="tsServicePc" />
<aop:advisor advice-ref="transactionManagerAdivice" pointcut-ref="tsServicePc" />
</aop:config>
改成：
<bean id="atomikosTransactionManager" class="com.atomikos.icatch.jta.UserTransactionManager" init-method="init" destroy-method="close">
<property name="forceShutdown"><value>true</value></property>
</bean>
<bean id="atomikosUserTransaction" class="com.atomikos.icatch.jta.UserTransactionImp">
    <property name="transactionTimeout"><value>300</value></property>
</bean>
<bean id="springTransactionManager" class="org.springframework.transaction.jta.JtaTransactionManager">
<property name="transactionManager"><ref bean="atomikosTransactionManager"  /></property>
<property name="userTransaction"><ref bean="atomikosUserTransaction"  /></property>
<property name="allowCustomIsolationLevels" value="true"/>
</bean>

<tx:annotation-driven transaction-manager="springTransactionManager"/>

之后在要用事务的方法前面加@Transactional即可
例如：
@Transactional
public void execute(){}