spring+hibernate+atmokios+mysql 分布式事务

研究了一周的时间终于把分布式事务配好了，中间走了很多弯路，在这里把它记下来 具体的配置我就不多说了，google一下有很多，下面我主要介召一下注意事项和常见的错误

1、Tomcat必须得配事务的JNDI。 在context.xml文件中<WatchedResource>WEB-INF/web.xml</WatchedResource> 的后面加上 <Transaction factory="com.atomikos.icatch.jta.UserTransactionFactory" /> 我这用的是tomcat6.0 刚开始我一直不想修改tomcat的配置，想找到atmokis或jotm中的解决方案，结果失败了。因为tomcat不支持分布式事务，用开源的atmokios实现jta也要把 UserTransaction 配在tomcat中。如果不配事务资源会抛错。

Caused by: org.hibernate.TransactionException: Could not find UserTransaction in JNDI: 
	at org.hibernate.transaction.JTATransaction.<init>(JTATransaction.java:64)
	at org.hibernate.transaction.JTATransactionFactory.createTransaction(JTATransactionFactory.java:57)
	at org.hibernate.jdbc.JDBCContext.registerSynchronizationIfPossible(JDBCContext.java:172)
	at org.hibernate.impl.SessionImpl.checkTransactionSynchStatus(SessionImpl.java:1867)
	at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:875)
	at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
	at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.orm.hibernate3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1289)
	at $Proxy15.get(Unknown Source)
	at com.cmcc.eri.dao.hibernate.GenericDAO$1.doInHibernate(GenericDAO.java:59)
	at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
	... 65 more

 

 

2、 spring 用版本2.5.3

刚开始我用的是2.5.6，在同一个事务中执行两次查询就会出错，报错如下

com.atomikos.datasource.ResourceException: XA resource 'XA-CORE-TESTPROJECT-DATASOURCE': resume for XID '3139322E3136382E302E322E746D30303332383030303331:3139322E3136382E302E322E746D333233' raised -5: invalid arguments were given for the XA operation
    at com.atomikos.datasource.xa.XAResourceTransaction.resume(XAResourceTransaction.java:653)
    at com.atomikos.datasource.xa.session.BranchEnlistedStateHandler.<init>(BranchEnlistedStateHandler.java:32)
    at com.atomikos.datasource.xa.session.NotInBranchStateHandler.checkEnlistBeforeUse(NotInBranchStateHandler.java:41)
    at com.atomikos.datasource.xa.session.TransactionContext.checkEnlistBeforeUse(TransactionContext.java:60)
    at com.atomikos.datasource.xa.session.SessionHandleState.notifyBeforeUse(SessionHandleState.java:151)
    at com.atomikos.jdbc.AtomikosConnectionProxy.enlist(AtomikosConnectionProxy.java:165)
    at com.atomikos.jdbc.AtomikosConnectionProxy.invoke(AtomikosConnectionProxy.java:105)
    at $Proxy1.prepareStatement(Unknown Source)
    at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
    at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
    at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1573)
    at org.hibernate.loader.Loader.doQuery(Loader.java:696)

 

  3、mysql的驱动需要5.1.10版本，低版本会出现错误：

 

Caused by: java.lang.IllegalArgumentException: null source
	at java.util.EventObject.<init>(EventObject.java:38)
	at javax.sql.StatementEvent.<init>(StatementEvent.java:39)
	at com.mysql.jdbc.jdbc2.optional.JDBC4PreparedStatementWrapper.close(JDBC4PreparedStatementWrapper.java:70)
	at org.hibernate.jdbc.AbstractBatcher.closePreparedStatement(AbstractBatcher.java:534)
	at org.hibernate.jdbc.AbstractBatcher.closeStatement(AbstractBatcher.java:269)
	at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:285)
	at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:212)
	at org.hibernate.loader.Loader.doQuery(Loader.java:726)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
	at org.hibernate.loader.Loader.doList(Loader.java:2213)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
	at org.hibernate.loader.Loader.list(Loader.java:2099)
	at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
	at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
	at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
	at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152)