[Seasar-user:11501] Re: requiresNewTxにてcommit時に例外が発生した場合にRollbackされない

[鈴木 順]

小林さん

お世話になっております。鈴木です。

ついにうまく行くと思ったのですが、ダメでした。
意味不明な例外が出ました。
とりあえず今日はこれであきらめようと思います。
もし何か分かりましたら、お教えください。

Caused by: org.seasar.framework.exception.SSQLException: [ESSR0072]SQLで
例外(SQL=[select urllink0_.LINK_ID as LINK1_133_0_, urllink0_.LINK_NM as
LINK2_133_0_, urllink0_.LINK_URL as LINK3_133_0_, urllink0_.PRC_DATE as
PRC4_133_0_ from UT_URL_LINK urllink0_ where urllink0_.LINK_ID=?],
Message=[enlist: caught Exception], ErrorCode=0, SQLState=null)が発生し
ました
	at org.seasar.extension.dbcp.impl.ConnectionWrapperImpl.wrapException(ConnectionWrapperImpl.java:551)
	at org.seasar.extension.dbcp.impl.ConnectionWrapperImpl.prepareStatement(ConnectionWrapperImpl.java:172)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423)
	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
	at org.hibernate.loader.Loader.doQuery(Loader.java:673)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
	at org.hibernate.loader.Loader.loadEntity(Loader.java:1860)
	... 85 more
Caused by: java.sql.SQLException: enlist: caught Exception
	at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java:1160)
	at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:609)
	at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1889)
	at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1844)
	at org.seasar.extension.dbcp.impl.ConnectionWrapperImpl.prepareStatement(ConnectionWrapperImpl.java:168)
	... 92 more
Caused by: javax.resource.ResourceException: enlist: caught Exception
	at com.ibm.ejs.j2c.LocalTransactionWrapper.enlist(LocalTransactionWrapper.java:619)
	at com.ibm.ejs.j2c.ConnectionManager.lazyEnlist(ConnectionManager.java:1895)
	at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.lazyEnlist(WSRdbManagedConnectionImpl.java:2062)
	at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:555)
	... 95 more
Caused by: com.ibm.ws.Transaction.IllegalResourceIn2PCTransactionException: Illegal attempt to enlist multiple 1PC XAResources
	at com.ibm.ws.Transaction.JTA.RegisteredResources.enlistResource(RegisteredResources.java:409)
	at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:3077)
	at com.ibm.ws.Transaction.JTA.TranManagerSet.enlistOnePhase(TranManagerSet.java:418)
	at com.ibm.ejs.j2c.LocalTransactionWrapper.enlist(LocalTransactionWrapper.java:516)
	... 98 more