[jboss-user] [JCA/JBoss] - Hibernate+JBossTS+SybaseXA=XAException
mskonda
do-not-reply at jboss.com
Thu Mar 15 10:02:37 EDT 2007
Have a look at the initial discussion about the ssue: http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4028316#4028316
Weston, here's the stack trace:
| 2007-03-15 13:47:12,563 INFO [test.com.cmi2.hib.HibernateMDB] ---> setMDBContext
| 2007-03-15 13:47:12,568 INFO [test.com.cmi2.hib.HibernateMDB] ---> ejbCreate
| 2007-03-15 13:47:12,573 INFO [test.com.cmi2.hib.HibernateMDB] ---> Message ' MK - 0 ' Received
| 2007-03-15 13:47:12,574 INFO [test.com.cmi2.hib.HibernateMDB] --> publishing the message to testTopic2
| 2007-03-15 13:47:12,574 INFO [test.com.cmi2.hib.HibernateMDB] Only one message
| 2007-03-15 13:47:12,574 INFO [test.com.cmi2.hib.HibernateMDB] -->got xa conn factorg.jboss.resource.adapter.jms.JmsConnectionFactoryImpl at 708a605c
| 2007-03-15 13:47:12,581 INFO [test.com.cmi2.hib.HibernateMDB] -->created conns
| 2007-03-15 13:47:12,587 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] internalRegisterPool: registering pool with interval 900000 old interval: 450000
| 2007-03-15 13:47:12,601 DEBUG [org.jboss.jms.ConnectionFactoryHelper] using connection factory: JBossConnectionFactory->ConnectionFactoryDelegate[1, SID=0]
| 2007-03-15 13:47:12,601 DEBUG [org.jboss.jms.ConnectionFactoryHelper] using username/password: guest/-- not shown --
| 2007-03-15 13:47:12,601 DEBUG [org.jboss.jms.client.remoting.JMSRemotingConnection] JMSRemotingConnection[bisocket://10.110.221.94:4457/?NumberOfCallRetries=2&clientMaxPoolSize=50&clientSocketClass=org.jboss.jms.client.remoting.ClientSocketWrapper&dataType=jms&marshaller=org.jboss.jms.server.remoting.JMSWireFormat&numberOfRetries=1&serializationtype=jms&socket.check_connection=false&unmarshaller=org.jboss.jms.server.remoting.JMSWireFormat] created
| 2007-03-15 13:47:12,606 DEBUG [org.jboss.remoting.MicroRemoteClientInvoker] SocketClientInvoker[b4bbd50, bisocket://10.110.221.94:4457] added client with session ID a32652m-6usjoy-ezb9a390-1-ezb9awrd-v to the lease pinger
| 2007-03-15 13:47:12,606 DEBUG [org.jboss.jms.client.remoting.JMSRemotingConnection] JMSRemotingConnection[bisocket://10.110.221.94:4457/?NumberOfCallRetries=2&clientMaxPoolSize=50&clientSocketClass=org.jboss.jms.client.remoting.ClientSocketWrapper&dataType=jms&marshaller=org.jboss.jms.server.remoting.JMSWireFormat&numberOfRetries=1&serializationtype=jms&socket.check_connection=false&unmarshaller=org.jboss.jms.server.remoting.JMSWireFormat] is doing push callbacks
| 2007-03-15 13:47:12,606 DEBUG [org.jboss.remoting.Client] starting callback Connector: InvokerLocator [bisocket://10.110.221.94:304231203/callback?serverSocketClass=org.jboss.jms.server.remoting.ServerSocketWrapper&isCallbackServer=true&callbackServerProtocol=bisocket&datatype=jms&guid=a32652m-6usjoy-ezb9a390-1-ezb9awri-w&callbackServerHost=10.110.221.94&callbackServerPort=304231203&onewayThreadPool=org.jboss.jms.server.remoting.DirectThreadPool&serializationtype=jms&clientSocketClass=org.jboss.jms.client.remoting.ClientSocketWrapper]
| 2007-03-15 13:47:12,619 DEBUG [org.jboss.remoting.ServerInvoker] SocketServerInvoker[UNINITIALIZED] did not find server socket factory configuration as mbean service or classname. Creating default server socket factory.
| 2007-03-15 13:47:12,619 DEBUG [org.jboss.remoting.ServerInvoker] SocketServerInvoker[UNINITIALIZED] created server socket factory javax.net.DefaultServerSocketFactory at 6d289e48
| 2007-03-15 13:47:12,619 DEBUG [org.jboss.remoting.transport.Connector] org.jboss.remoting.transport.Connector at 1312656b started
| 2007-03-15 13:47:12,620 DEBUG [org.jboss.remoting.ServerInvoker] ServerInvoker (SocketServerInvoker[UNINITIALIZED]) added client callback handler CallbackManager[2c320256] with session id of a32652m-6usjoy-ezb9a390-1-ezb9awrd-v+a32652m-6usjoy-ezb9a390-1-ezb9awrv-x and callback handle object of null.
| 2007-03-15 13:47:12,620 DEBUG [org.jboss.remoting.InvokerRegistry] removed org.jboss.remoting.transport.local.LocalClientInvoker at 1cc05d95 from registry
| 2007-03-15 13:47:12,620 DEBUG [org.jboss.remoting.transport.bisocket.BisocketServerInvoker] creating control connection: InvokerLocator [null://10.110.221.94:2971/null]
| 2007-03-15 13:47:12,621 DEBUG [org.jboss.remoting.transport.bisocket.BisocketServerInvoker] created control connection: Socket[addr=/10.110.221.94,port=2971,localport=50474]
| 2007-03-15 13:47:12,627 DEBUG [org.jboss.jms.client.remoting.JMSRemotingConnection] JMSRemotingConnection[bisocket://10.110.221.94:4457/?NumberOfCallRetries=2&clientMaxPoolSize=50&clientSocketClass=org.jboss.jms.client.remoting.ClientSocketWrapper&dataType=jms&marshaller=org.jboss.jms.server.remoting.JMSWireFormat&numberOfRetries=1&serializationtype=jms&socket.check_connection=false&unmarshaller=org.jboss.jms.server.remoting.JMSWireFormat] started
| 2007-03-15 13:47:12,632 DEBUG [org.jboss.remoting.ConnectionValidator] ConnectionValidator[null, pingPeriod=2000 ms] created
| 2007-03-15 13:47:12,632 DEBUG [org.jboss.remoting.ConnectionValidator] ConnectionValidator[SocketClientInvoker[558ad183, bisocket://10.110.221.94:4457], pingPeriod=2000 ms] started
| 2007-03-15 13:47:12,632 DEBUG [org.jboss.jms.message.MessageIdGeneratorFactory] checked out MessageIdGenerator for 0, reference count is 3
| 2007-03-15 13:47:12,632 DEBUG [org.jboss.jms.ConnectionFactoryHelper] created XAConnection: JBossConnection->ConnectionDelegate[1053896183, ID=424, SID=0]
| 2007-03-15 13:47:12,632 DEBUG [org.jboss.jms.client.remoting.ConsolidatedRemotingConnectionListener] ConnectionState[424].ConsolidatedListener adding JMS exception listener org.jboss.resource.adapter.jms.JmsManagedConnection at 1720d359
| 2007-03-15 13:47:12,634 TRACE [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] supplying new ManagedConnection: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener at 7539f0bb[state=NORMAL mc=org.jboss.resource.adapter.jms.JmsManagedConnection at 1720d359 handles=0 lastUse=1173966432634 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$PoolBySubjectAndCri at 2eebc11d context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool at 77d36efb xaResource=MessagingXAResource[425] txSync=null]
| 2007-03-15 13:47:12,634 TRACE [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Got connection from pool org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener at 7539f0bb[state=NORMAL mc=org.jboss.resource.adapter.jms.JmsManagedConnection at 1720d359 handles=0 lastUse=1173966432634 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$PoolBySubjectAndCri at 2eebc11d context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool at 77d36efb xaResource=MessagingXAResource[425] txSync=null] [InUse/Available/Max]: [1/19/20]
| 2007-03-15 13:47:12,644 INFO [test.com.cmi2.hib.HibernateMDB] -->created sessions
| 2007-03-15 13:47:12,648 INFO [test.com.cmi2.hib.HibernateMDB] Topic /topic/testTopic3 exists
| 2007-03-15 13:47:12,903 INFO [test.com.cmi2.hib.HibernateMDB] -->created pubishers
| 2007-03-15 13:47:12,905 INFO [test.com.cmi2.hib.HibernateMDB] -->created txtmsgs
| 2007-03-15 13:47:12,918 DEBUG [org.jboss.jms.client.container.ClosedInterceptor] ClosedInterceptor.ClientProducerDelegate[-1] closed
| 2007-03-15 13:47:12,919 TRACE [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] putting ManagedConnection back into pool kill=false cl=org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener at 7539f0bb[state=NORMAL mc=org.jboss.resource.adapter.jms.JmsManagedConnection at 1720d359 handles=0 lastUse=1173966432634 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$PoolBySubjectAndCri at 2eebc11d context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool at 77d36efb xaResource=MessagingXAResource[425] txSync=null]
| 2007-03-15 13:47:12,919 TRACE [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Returning connection to pool org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener at 7539f0bb[state=NORMAL mc=org.jboss.resource.adapter.jms.JmsManagedConnection at 1720d359 handles=0 lastUse=1173966432919 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$PoolBySubjectAndCri at 2eebc11d context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool at 77d36efb xaResource=MessagingXAResource[425] txSync=null] [InUse/Available/Max]: [0/20/20]
| 2007-03-15 13:47:12,920 DEBUG [org.hibernate.impl.SessionFactoryObjectFactory] JNDI lookup: cmi2/testHibernate/hibernate/sessionFactory
| 2007-03-15 13:47:12,920 DEBUG [org.hibernate.impl.SessionFactoryObjectFactory] lookup: uid=8aee5dde1155d9d3011155d9d6400000
| 2007-03-15 13:47:12,920 INFO [test.com.cmi2.hib.HibernateMDB] SessionFactory found: org.hibernate.impl.SessionFactoryImpl at 39223bf0
| 2007-03-15 13:47:13,002 DEBUG [org.hibernate.jdbc.JDBCContext] successfully registered Synchronization
| 2007-03-15 13:47:13,002 DEBUG [org.hibernate.impl.SessionImpl] opened session at timestamp: 4808566509436928
| 2007-03-15 13:47:13,004 INFO [test.com.cmi2.hib.HibernateMDB] Session created: SessionImpl(PersistenceContext[entityKeys=[],collectionKeys=[]];ActionQueue[insertions=[] updates=[] deletions=[] collectionCreations=[] collectionRemovals=[] collectionUpdates=[]])
| 2007-03-15 13:47:13,004 INFO [test.com.cmi2.hib.HibernateMDB] Logging HibernateCat
| 2007-03-15 13:47:13,011 DEBUG [org.hibernate.event.def.DefaultSaveOrUpdateEventListener] saving transient instance
| 2007-03-15 13:47:13,012 DEBUG [org.hibernate.event.def.AbstractSaveEventListener] generated identifier: 1173966433004, using strategy: org.hibernate.id.Assigned
| 2007-03-15 13:47:13,016 DEBUG [org.hibernate.event.def.AbstractSaveEventListener] saving [test.com.cmi2.hib.HibernateCat#1173966433004]
| 2007-03-15 13:47:13,047 INFO [test.com.cmi2.hib.HibernateMDB] HibernateCat saved!!
| 2007-03-15 13:47:13,048 INFO [test.com.cmi2.hib.HibernateMDB] Message Delivered Successfully in publish 3!
| 2007-03-15 13:47:13,050 DEBUG [org.hibernate.transaction.CacheSynchronization] transaction before completion callback
| 2007-03-15 13:47:13,050 DEBUG [org.hibernate.transaction.CacheSynchronization] automatically flushing session
| 2007-03-15 13:47:13,050 DEBUG [org.hibernate.impl.SessionImpl] automatically flushing session
| 2007-03-15 13:47:13,051 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] flushing session
| 2007-03-15 13:47:13,052 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] processing flush-time cascades
| 2007-03-15 13:47:13,054 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] dirty checking collections
| 2007-03-15 13:47:13,054 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushing entities and processing referenced collections
| 2007-03-15 13:47:13,062 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Processing unreferenced collections
| 2007-03-15 13:47:13,062 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Scheduling collection removes/(re)creates/updates
| 2007-03-15 13:47:13,062 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 1 insertions, 0 updates, 0 deletions to 1 objects
| 2007-03-15 13:47:13,062 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
| 2007-03-15 13:47:13,065 DEBUG [org.hibernate.pretty.Printer] listing entities:
| 2007-03-15 13:47:13,065 DEBUG [org.hibernate.pretty.Printer] test.com.cmi2.hib.HibernateCat{lname=Barry, fname=Larry, id=1173966433004}
| 2007-03-15 13:47:13,066 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] executing flush
| 2007-03-15 13:47:13,066 DEBUG [org.hibernate.jdbc.ConnectionManager] registering flush begin
| 2007-03-15 13:47:13,066 DEBUG [org.hibernate.persister.entity.AbstractEntityPersister] Inserting entity: [test.com.cmi2.hib.HibernateCat#1173966433004]
| 2007-03-15 13:47:13,078 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
| 2007-03-15 13:47:13,078 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection
| 2007-03-15 13:47:13,079 TRACE [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] supplying ManagedConnection from pool: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener at 6ac6b7ee[state=NORMAL mc=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection at 1c55a106 handles=0 lastUse=1173966410400 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool at 39be9f72 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool at 11d612fc xaResource=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection at 1c55a106 txSync=null]
| 2007-03-15 13:47:13,080 TRACE [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Got connection from pool org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener at 6ac6b7ee[state=NORMAL mc=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection at 1c55a106 handles=0 lastUse=1173966410400 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool at 39be9f72 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool at 11d612fc xaResource=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection at 1c55a106 txSync=null] [InUse/Available/Max]: [1/19/20]
| 2007-03-15 13:47:13,088 DEBUG [org.hibernate.SQL] insert into HibernateCat (FirstName, LastName, Id) values (?, ?, ?)
| 2007-03-15 13:47:13,088 INFO [STDOUT] Hibernate: insert into HibernateCat (FirstName, LastName, Id) values (?, ?, ?)
| 2007-03-15 13:47:13,088 DEBUG [org.hibernate.jdbc.AbstractBatcher] preparing statement
| 2007-03-15 13:47:13,089 DEBUG [org.hibernate.persister.entity.AbstractEntityPersister] Dehydrating entity: [test.com.cmi2.hib.HibernateCat#1173966433004]
| 2007-03-15 13:47:13,089 DEBUG [org.hibernate.type.StringType] binding 'Larry' to parameter: 1
| 2007-03-15 13:47:13,089 DEBUG [org.hibernate.type.StringType] binding 'Barry' to parameter: 2
| 2007-03-15 13:47:13,089 DEBUG [org.hibernate.type.LongType] binding '1173966433004' to parameter: 3
| 2007-03-15 13:47:13,093 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
| 2007-03-15 13:47:13,093 DEBUG [org.hibernate.jdbc.AbstractBatcher] closing statement
| 2007-03-15 13:47:13,093 DEBUG [org.hibernate.jdbc.ConnectionManager] skipping aggressive-release due to flush cycle
| 2007-03-15 13:47:13,093 DEBUG [org.hibernate.jdbc.ConnectionManager] registering flush end
| 2007-03-15 13:47:13,094 DEBUG [org.hibernate.jdbc.ConnectionManager] aggressively releasing JDBC connection
| 2007-03-15 13:47:13,094 DEBUG [org.hibernate.jdbc.ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
| 2007-03-15 13:47:13,097 TRACE [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] putting ManagedConnection back into pool kill=false cl=org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener at 6ac6b7ee[state=NORMAL mc=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection at 1c55a106 handles=0 lastUse=1173966410400 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool at 39be9f72 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool at 11d612fc xaResource=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection at 1c55a106 txSync=null]
| 2007-03-15 13:47:13,098 TRACE [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Returning connection to pool org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener at 6ac6b7ee[state=NORMAL mc=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection at 1c55a106 handles=0 lastUse=1173966433098 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool at 39be9f72 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool at 11d612fc xaResource=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection at 1c55a106 txSync=null] [InUse/Available/Max]: [0/20/20]
| 2007-03-15 13:47:13,098 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] post flush
| 2007-03-15 13:47:13,098 DEBUG [org.hibernate.jdbc.JDBCContext] before transaction completion
| 2007-03-15 13:47:13,098 DEBUG [org.hibernate.impl.SessionImpl] before transaction completion
| 2007-03-15 13:47:13,108 ERROR [org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory] End transaction failed for XAResource
| javax.transaction.xa.XAException
| at com.sybase.jdbc3.jdbc.SybXAResource.verifyReturnCode(SybXAResource.java:850)
| at com.sybase.jdbc3.jdbc.SybXAResource.sendRPC(SybXAResource.java:763)
| at com.sybase.jdbc3.jdbc.SybXAResource.sendRPC(SybXAResource.java:635)
| at com.sybase.jdbc3.jdbc.SybXAResource.end(SybXAResource.java:369)
| at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.end(XAManagedConnection.java:147)
| at com.arjuna.ats.internal.jta.resources.arjunacore.XAResourceRecord.topLevelPrepare(XAResourceRecord.java:259)
| at com.arjuna.ats.arjuna.coordinator.BasicAction.doPrepare(BasicAction.java:2872)
| at com.arjuna.ats.arjuna.coordinator.BasicAction.doPrepare(BasicAction.java:2829)
| at com.arjuna.ats.arjuna.coordinator.BasicAction.prepare(BasicAction.java:2383)
| at com.arjuna.ats.arjuna.coordinator.BasicAction.End(BasicAction.java:1784)
| at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:87)
| at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)
| at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1181)
| at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:134)
| at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:87)
| at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:351)
| at org.jboss.jms.client.remoting.MessageCallbackHandler.callOnMessage(MessageCallbackHandler.java:153)
| at org.jboss.jms.client.container.SessionAspect.handleRun(SessionAspect.java:791)
| at org.jboss.aop.advice.org.jboss.jms.client.container.SessionAspect14.invoke(SessionAspect14.java)
| at org.jboss.jms.client.delegate.ClientSessionDelegate$run_N8003352271541955702.invokeNext(ClientSessionDelegate$run_N8003352271541955702.java)
| at org.jboss.jms.client.container.ClosedInterceptor.invoke(ClosedInterceptor.java:171)
| at org.jboss.aop.advice.PerInstanceInterceptor.invoke(PerInstanceInterceptor.java:117)
| at org.jboss.jms.client.delegate.ClientSessionDelegate$run_N8003352271541955702.invokeNext(ClientSessionDelegate$run_N8003352271541955702.java)
| at org.jboss.jms.client.container.ExceptionInterceptor.invoke(ExceptionInterceptor.java:71)
| at org.jboss.jms.client.delegate.ClientSessionDelegate$run_N8003352271541955702.invokeNext(ClientSessionDelegate$run_N8003352271541955702.java)
| at org.jboss.jms.client.container.ClientLogInterceptor.invoke(ClientLogInterceptor.java:107)
| at org.jboss.jms.client.delegate.ClientSessionDelegate$run_N8003352271541955702.invokeNext(ClientSessionDelegate$run_N8003352271541955702.java)
| at org.jboss.jms.client.delegate.ClientSessionDelegate.run(ClientSessionDelegate.java)
| at org.jboss.jms.client.JBossSession.run(JBossSession.java:211)
| at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:194)
| at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:743)
| at java.lang.Thread.run(Thread.java:595)
| 2007-03-15 13:47:13,109 WARN [org.jboss.resource.connectionmanager.TxConnectionManager] Connection error occured: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener at 6ac6b7ee[state=NORMAL mc=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection at 1c55a106 handles=0 lastUse=1173966433098 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool at 39be9f72 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool at 11d612fc xaResource=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection at 1c55a106 txSync=null]
| javax.transaction.xa.XAException
| at com.sybase.jdbc3.jdbc.SybXAResource.verifyReturnCode(SybXAResource.java:850)
| at com.sybase.jdbc3.jdbc.SybXAResource.sendRPC(SybXAResource.java:763)
| at com.sybase.jdbc3.jdbc.SybXAResource.sendRPC(SybXAResource.java:635)
| at com.sybase.jdbc3.jdbc.SybXAResource.end(SybXAResource.java:369)
| at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.end(XAManagedConnection.java:147)
| at com.arjuna.ats.internal.jta.resources.arjunacore.XAResourceRecord.topLevelPrepare(XAResourceRecord.java:259)
| at com.arjuna.ats.arjuna.coordinator.BasicAction.doPrepare(BasicAction.java:2872)
| at com.arjuna.ats.arjuna.coordinator.BasicAction.doPrepare(BasicAction.java:2829)
| at com.arjuna.ats.arjuna.coordinator.BasicAction.prepare(BasicAction.java:2383)
| at com.arjuna.ats.arjuna.coordinator.BasicAction.End(BasicAction.java:1784)
| at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:87)
| at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)
| at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1181)
| at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:134)
| at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:87)
| at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:351)
| at org.jboss.jms.client.remoting.MessageCallbackHandler.callOnMessage(MessageCallbackHandler.java:153)
| at org.jboss.jms.client.container.SessionAspect.handleRun(SessionAspect.java:791)
| at org.jboss.aop.advice.org.jboss.jms.client.container.SessionAspect14.invoke(SessionAspect14.java)
| at org.jboss.jms.client.delegate.ClientSessionDelegate$run_N8003352271541955702.invokeNext(ClientSessionDelegate$run_N8003352271541955702.java)
| at org.jboss.jms.client.container.ClosedInterceptor.invoke(ClosedInterceptor.java:171)
| at org.jboss.aop.advice.PerInstanceInterceptor.invoke(PerInstanceInterceptor.java:117)
| at org.jboss.jms.client.delegate.ClientSessionDelegate$run_N8003352271541955702.invokeNext(ClientSessionDelegate$run_N8003352271541955702.java)
| at org.jboss.jms.client.container.ExceptionInterceptor.invoke(ExceptionInterceptor.java:71)
| at org.jboss.jms.client.delegate.ClientSessionDelegate$run_N8003352271541955702.invokeNext(ClientSessionDelegate$run_N8003352271541955702.java)
| at org.jboss.jms.client.container.ClientLogInterceptor.invoke(ClientLogInterceptor.java:107)
| at org.jboss.jms.client.delegate.ClientSessionDelegate$run_N8003352271541955702.invokeNext(ClientSessionDelegate$run_N8003352271541955702.java)
| at org.jboss.jms.client.delegate.ClientSessionDelegate.run(ClientSessionDelegate.java)
| at org.jboss.jms.client.JBossSession.run(JBossSession.java:211)
| at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:194)
| at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:743)
| at java.lang.Thread.run(Thread.java:595)
| 2007-03-15 13:47:13,110 TRACE [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] putting ManagedConnection back into pool kill=true cl=org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener at 6ac6b7ee[state=NORMAL mc=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection at 1c55a106 handles=0 lastUse=1173966433098 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool at 39be9f72 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool at 11d612fc xaResource=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection at 1c55a106 txSync=null]
| 2007-03-15 13:47:13,110 TRACE [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Destroying returned connection org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener at 6ac6b7ee[state=NORMAL mc=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection at 1c55a106 handles=0 lastUse=1173966433098 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool at 39be9f72 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool at 11d612fc xaResource=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection at 1c55a106 txSync=null]
| 2007-03-15 13:47:13,114 TRACE [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Returning connection to pool org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener at 6ac6b7ee[state=DESTROYED mc=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection at 1c55a106 handles=0 lastUse=1173966433098 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool at 39be9f72 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool at 11d612fc xaResource=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection at 1c55a106 txSync=null] [InUse/Available/Max]: [0/20/20]
| 2007-03-15 13:47:13,116 WARN [com.arjuna.ats.jta.logging.loggerI18N] [com.arjuna.ats.internal.jta.resources.arjunacore.preparefailed] [com.arjuna.ats.internal.jta.resources.arjunacore.preparefailed] XAResourceRecord.prepare - prepare failed with exception XAException.XAER_PROTO
| 2007-03-15 13:47:13,116 WARN [com.arjuna.ats.arjuna.logging.arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.BasicAction_36] - BasicAction.End() - prepare phase of action-id a6edd5e:c37c:45f94e39:96 failed.
| 2007-03-15 13:47:13,117 WARN [com.arjuna.ats.arjuna.logging.arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.BasicAction_38] - Action Aborting
| 2007-03-15 13:47:13,127 ERROR [org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory] End transaction failed for XAResource
| javax.transaction.xa.XAException
| at com.sybase.jdbc3.jdbc.SybXAResource.sendRPC(SybXAResource.java:756)
| at com.sybase.jdbc3.jdbc.SybXAResource.sendRPC(SybXAResource.java:635)
| at com.sybase.jdbc3.jdbc.SybXAResource.end(SybXAResource.java:369)
| at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.end(XAManagedConnection.java:147)
| at com.arjuna.ats.internal.jta.resources.arjunacore.XAResourceRecord.topLevelAbort(XAResourceRecord.java:369)
| at com.arjuna.ats.arjuna.coordinator.BasicAction.doAbort(BasicAction.java:3223)
| at com.arjuna.ats.arjuna.coordinator.BasicAction.doAbort(BasicAction.java:3201)
| at com.arjuna.ats.arjuna.coordinator.BasicAction.phase2Abort(BasicAction.java:2212)
| at com.arjuna.ats.arjuna.coordinator.BasicAction.End(BasicAction.java:1810)
| at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:87)
| at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)
| at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1181)
| at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:134)
| at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:87)
| at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:351)
| at org.jboss.jms.client.remoting.MessageCallbackHandler.callOnMessage(MessageCallbackHandler.java:153)
| at org.jboss.jms.client.container.SessionAspect.handleRun(SessionAspect.java:791)
| at org.jboss.aop.advice.org.jboss.jms.client.container.SessionAspect14.invoke(SessionAspect14.java)
| at org.jboss.jms.client.delegate.ClientSessionDelegate$run_N8003352271541955702.invokeNext(ClientSessionDelegate$run_N8003352271541955702.java)
| at org.jboss.jms.client.container.ClosedInterceptor.invoke(ClosedInterceptor.java:171)
| at org.jboss.aop.advice.PerInstanceInterceptor.invoke(PerInstanceInterceptor.java:117)
| at org.jboss.jms.client.delegate.ClientSessionDelegate$run_N8003352271541955702.invokeNext(ClientSessionDelegate$run_N8003352271541955702.java)
| at org.jboss.jms.client.container.ExceptionInterceptor.invoke(ExceptionInterceptor.java:71)
| at org.jboss.jms.client.delegate.ClientSessionDelegate$run_N8003352271541955702.invokeNext(ClientSessionDelegate$run_N8003352271541955702.java)
| at org.jboss.jms.client.container.ClientLogInterceptor.invoke(ClientLogInterceptor.java:107)
| at org.jboss.jms.client.delegate.ClientSessionDelegate$run_N8003352271541955702.invokeNext(ClientSessionDelegate$run_N8003352271541955702.java)
| at org.jboss.jms.client.delegate.ClientSessionDelegate.run(ClientSessionDelegate.java)
| at org.jboss.jms.client.JBossSession.run(JBossSession.java:211)
| at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:194)
| at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:743)
| at java.lang.Thread.run(Thread.java:595)
| 2007-03-15 13:47:13,133 WARN [com.arjuna.ats.jta.logging.loggerI18N] [com.arjuna.ats.internal.jta.resources.arjunacore.rollbackxaerror] [com.arjuna.ats.internal.jta.resources.arjunacore.rollbackxaerror] XAResourceRecord.rollback - xa error XAException.XAER_RMERR
| 2007-03-15 13:47:13,133 DEBUG [org.hibernate.transaction.CacheSynchronization] transaction after completion callback, status: 4
| 2007-03-15 13:47:13,133 DEBUG [org.hibernate.jdbc.JDBCContext] after transaction completion
| 2007-03-15 13:47:13,133 DEBUG [org.hibernate.impl.SessionImpl] after transaction completion
| 2007-03-15 13:47:13,133 DEBUG [org.hibernate.transaction.CacheSynchronization] automatically closing session
| 2007-03-15 13:47:13,133 DEBUG [org.hibernate.impl.SessionImpl] automatically closing session
| 2007-03-15 13:47:13,133 DEBUG [org.hibernate.impl.SessionImpl] closing session
| 2007-03-15 13:47:13,133 DEBUG [org.hibernate.jdbc.ConnectionManager] connection already null in cleanup : no action
| 2007-03-15 13:47:13,134 ERROR [org.jboss.jms.asf.StdServerSession] failed to commit/rollback
| javax.transaction.RollbackException
| at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1192)
| at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:134)
| at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:87)
| at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:351)
| at org.jboss.jms.client.remoting.MessageCallbackHandler.callOnMessage(MessageCallbackHandler.java:153)
| at org.jboss.jms.client.container.SessionAspect.handleRun(SessionAspect.java:791)
| at org.jboss.aop.advice.org.jboss.jms.client.container.SessionAspect14.invoke(SessionAspect14.java)
| at org.jboss.jms.client.delegate.ClientSessionDelegate$run_N8003352271541955702.invokeNext(ClientSessionDelegate$run_N8003352271541955702.java)
| at org.jboss.jms.client.container.ClosedInterceptor.invoke(ClosedInterceptor.java:171)
| at org.jboss.aop.advice.PerInstanceInterceptor.invoke(PerInstanceInterceptor.java:117)
| at org.jboss.jms.client.delegate.ClientSessionDelegate$run_N8003352271541955702.invokeNext(ClientSessionDelegate$run_N8003352271541955702.java)
| at org.jboss.jms.client.container.ExceptionInterceptor.invoke(ExceptionInterceptor.java:71)
| at org.jboss.jms.client.delegate.ClientSessionDelegate$run_N8003352271541955702.invokeNext(ClientSessionDelegate$run_N8003352271541955702.java)
| at org.jboss.jms.client.container.ClientLogInterceptor.invoke(ClientLogInterceptor.java:107)
| at org.jboss.jms.client.delegate.ClientSessionDelegate$run_N8003352271541955702.invokeNext(ClientSessionDelegate$run_N8003352271541955702.java)
| at org.jboss.jms.client.delegate.ClientSessionDelegate.run(ClientSessionDelegate.java)
| at org.jboss.jms.client.JBossSession.run(JBossSession.java:211)
| at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:194)
| at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:743)
| at java.lang.Thread.run(Thread.java:595)
| 2007-03-15 13:47:13,134 INFO [test.com.cmi2.hib.HibernateMDB] ---> Message ' MK - 0 ' Received
| 2007-03-15 13:47:13,161 INFO [test.com.cmi2.hib.HibernateMDB] --> publishing the message to testTopic2
Here' the respective *ds.xml (whihc creates datasources)
| <datasources>
|
| <!-- ============================ -->
| <!-- local transaction datasource -->
| <!-- ============================ -->
|
| <local-tx-datasource>
| <jndi-name>CMITrade01EAIDS</jndi-name>
| <connection-url>jdbc:sybase:Tds:svc-trade01DBd:4100/MK_CMITrade01EAI</connection-url>
| <driver-class>com.sybase.jdbc3.jdbc.SybDataSource</driver-class>
| <use-java-context>true</use-java-context>
| <user-name>xxxxx</user-name>
| <password>xxxxx</password>
| <check-valid-connection-sql>SELECT @@VERSION</check-valid-connection-sql>
| <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.SybaseExceptionSorter</exception-sorter-class-name>
| <metadata>
| <type-mapping>Sybase</type-mapping>
| </metadata>
| </local-tx-datasource>
|
| <!-- ============================ -->
| <!-- xa transaction datasource -->
| <!-- ============================ -->
|
| <xa-datasource>
| <jndi-name>CMITrade01EAIXADS</jndi-name>
| <use-java-context>true</use-java-context>
| <user-name>xxxx</user-name>
| <password>xxxxxx</password>
| <xa-datasource-class>com.sybase.jdbc3.jdbc.SybXADataSource</xa-datasource-class>
| <xa-datasource-property name="DatabaseName">MK_CMITrade01EAI</xa-datasource-property>
| <xa-datasource-property name="ServerName">svc-trade01DBd</xa-datasource-property>
| <xa-datasource-property name="PortNumber">4100</xa-datasource-property>
| <check-valid-connection-sql>SELECT @@VERSION</check-valid-connection-sql>
| <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.SybaseExceptionSorter</exception-sorter-class-name>
| <metadata>
| <type-mapping>Sybase</type-mapping>
| </metadata>
| </xa-datasource>
|
| </datasources>
|
Here's the tx conn factory:
| <tx-connection-factory>
| <jndi-name>JmsXA</jndi-name>
| <xa-transaction/>
| <rar-name>jms-ra.rar</rar-name>
| <connection-definition>org.jboss.resource.adapter.jms.JmsConnectionFactory</connection-definition>
| <config-property name="SessionDefaultType" type="java.lang.String">javax.jms.Topic</config-property>
| <config-property name="JmsProviderAdapterJNDI" type="java.lang.String">java:/DefaultJMSProvider</config-property>
| <max-pool-size>20</max-pool-size>
| <security-domain-and-application>JmsXARealm</security-domain-and-application>
| <depends>jboss.messaging:service=ServerPeer</depends>
| </tx-connection-factory>
|
My Sybase verion: Sybase SE 12.5.3
Please let me know if you need furter info
Thanks
Madhu
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4028377#4028377
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4028377
More information about the jboss-user
mailing list