Hi Stephen, ----- Original Message ----- From: "Stephen Ting" <[EMAIL PROTECTED]> To: "'OJB Users List'" <[EMAIL PROTECTED]> Sent: Wednesday, July 16, 2003 9:42 AM Subject: RE: Transaction in PB api
> I am answering myself, most properly my questions is not very clear. > My configuration is OJB 1 rc3, Jboss 3.0.7 and Mysql db. I used PB api > in session bean. > What tx-demarcation do you use - bm-tx, cm-tx? If you set transaction 'required' in your deployment descriptor, then don't use OJB tx-demarcation, shown in your example > > broker = getBroker(new PBKey(site.getDbConnectionAlias())); > > broker.beginTransaction(); > > broker.store(document); > > broker.commitTransaction(); if you using bm-tx demarcation, only use JTA-UserTransaction (not the PB/ODMG tx-demarcation). > java.sql.SQLException: Invalid argument value, message from server: > "Duplicate entry '1' for key 1" Which sequence manager implementation do you use? Do you have tried to use SequenceManagerInMemoryImpl as an alternative? Did your code work in 2-tier environment? You can add a simple test to OJB test suite handle A,B objects. regards, Armin > My problem is in one transaction, say if i insert object A into table > TABLE_A and object B into TABLE_B and Object A has 1:M relationship with > Object B, if there are any errors in inserting object B into TABLE_B in > the transaction it will rollback the inserted object A. But in my > testing, it doesn't. Can someone show me the way to do it in PB api? Or > I have to use ODMG api. (Both tables are Innodb type). > > When trying to use ODMG, if errors occurred, it will rollback and there > are no changes to the database. But when It suppose to successfully > insert the record (as tried in PB api)... The following exception > thrown.. > > The error message "Duplicate entry '1' for key 1". But actually the > database is empty, no records. > > Thanks.. > > Regards, > Stephen > > 2003-07-16 15:23:27,738 ERROR > [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] SQLException during > the execution of the insert (for a > my.com.shinyang.eply.model.LogPondBlock): Invalid argument value, > message from server: "Duplicate entry '1' for key 1" > java.sql.SQLException: Invalid argument value, message from server: > "Duplicate entry '1' for key 1" > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1651) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:889) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:956) > at com.mysql.jdbc.Connection.execSQL(Connection.java:1874) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:17 > 00) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:15 > 69) > at > org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(W > rappedPreparedStatement.java:308) > at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown > Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown > Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown > Source) > at org.apache.ojb.odmg.states.StateNewDirty.commit(Unknown > Source) > at > org.apache.ojb.odmg.ObjectEnvelopeTable.commitAllEnvelopes(Unknown > Source) > at org.apache.ojb.odmg.ObjectEnvelopeTable.commit(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.doCommitOnObjects(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.prepare(Unknown Source) > at > org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown Source) > at > org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416) > at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368) > at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73) > at > org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.j > ava:365) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor > CMT.java:247) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:98) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav > a:130) > at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) > at > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer > .java:313) > at org.jboss.ejb.Container.invoke(Container.java:738) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:383 > ) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav > a:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) > at sun.rmi.transport.Transport$1.run(Transport.java:148) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:144) > at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja > va:701) > at java.lang.Thread.run(Thread.java:534) > 2003-07-16 15:23:27,753 ERROR [org.apache.ojb.odmg.ObjectEnvelopeTable] > Commit on object level failed for tx > [EMAIL PROTECTED] > java.sql.SQLException: Invalid argument value, message from server: > "Duplicate entry '1' for key 1" > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1651) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:889) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:956) > at com.mysql.jdbc.Connection.execSQL(Connection.java:1874) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:17 > 00) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:15 > 69) > at > org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(W > rappedPreparedStatement.java:308) > at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown > Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown > Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown > Source) > at org.apache.ojb.odmg.states.StateNewDirty.commit(Unknown > Source) > at > org.apache.ojb.odmg.ObjectEnvelopeTable.commitAllEnvelopes(Unknown > Source) > at org.apache.ojb.odmg.ObjectEnvelopeTable.commit(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.doCommitOnObjects(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.prepare(Unknown Source) > at > org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown Source) > at > org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416) > at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368) > at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73) > at > org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.j > ava:365) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor > CMT.java:247) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:98) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav > a:130) > at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) > at > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer > .java:313) > at org.jboss.ejb.Container.invoke(Container.java:738) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:383 > ) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav > a:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) > at sun.rmi.transport.Transport$1.run(Transport.java:148) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:144) > at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja > va:701) > at java.lang.Thread.run(Thread.java:534) > rethrown as > org.apache.ojb.broker.PersistenceBrokerSQLException: Invalid argument > value, message from server: "Duplicate entry '1' for key 1" > at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown > Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown > Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown > Source) > at org.apache.ojb.odmg.states.StateNewDirty.commit(Unknown > Source) > at > org.apache.ojb.odmg.ObjectEnvelopeTable.commitAllEnvelopes(Unknown > Source) > at org.apache.ojb.odmg.ObjectEnvelopeTable.commit(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.doCommitOnObjects(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.prepare(Unknown Source) > at > org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown Source) > at > org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416) > at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368) > at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73) > at > org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.j > ava:365) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor > CMT.java:247) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:98) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav > a:130) > at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) > at > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer > .java:313) > at org.jboss.ejb.Container.invoke(Container.java:738) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:383 > ) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav > a:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) > at sun.rmi.transport.Transport$1.run(Transport.java:148) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:144) > at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja > va:701) > at java.lang.Thread.run(Thread.java:534) > Caused by: java.sql.SQLException: Invalid argument value, message from > server: "Duplicate entry '1' for key 1" > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1651) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:889) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:956) > at com.mysql.jdbc.Connection.execSQL(Connection.java:1874) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:17 > 00) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:15 > 69) > at > org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(W > rappedPreparedStatement.java:308) > ... 34 more > 2003-07-16 15:23:27,769 ERROR [org.apache.ojb.odmg.TransactionImpl] > Could not prepare for commit: null > 2003-07-16 15:23:27,769 ERROR [org.apache.ojb.odmg.J2EETransactionImpl] > org.apache.ojb.broker.OJBRuntimeException: beforeCompletion: commit > failed > 2003-07-16 15:23:27,769 INFO [org.apache.ojb.odmg.JTATxManager] Set > extern transaction to rollback > 2003-07-16 15:23:27,785 INFO > [org.jboss.resource.connectionmanager.LocalTxConnectionManager$LocalConn > ectionEventListener] Could not enlist XAResource! > javax.transaction.RollbackException: Already marked for rollback > at org.jboss.tm.TxCapsule.enlistResource(TxCapsule.java:681) > at > org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:102) > at > org.jboss.resource.connectionmanager.LocalTxConnectionManager$LocalConne > ctionEventListener.enlist(LocalTxConnectionManager.java:320) > at > org.jboss.resource.connectionmanager.LocalTxConnectionManager.managedCon > nectionReconnected(LocalTxConnectionManager.java:255) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConn > ection(BaseConnectionManager2.java:534) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionMa > nagerProxy.allocateConnection(BaseConnectionManager2.java:828) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:122) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConne > ctionFromDataSource(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupCo > nnection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryManagedImpl.lookupCon > nection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Un > known Source) > at > org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement( > Unknown Source) > at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown > Source) > at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown > Source) > at > org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknow > n Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery( > Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Un > known Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQuery(Unkn > own Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getIteratorByQuer > y(Unknown Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOutLocks(Un > known Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.AbstractLockStrategy.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.ReadUncommittedStrategy.releaseLock(Unknown > Source) > at > org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) > at org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) > at > org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown Source) > at > org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416) > at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368) > at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73) > at > org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.j > ava:365) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor > CMT.java:247) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:98) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav > a:130) > at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) > at > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer > .java:313) > at org.jboss.ejb.Container.invoke(Container.java:738) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:383 > ) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav > a:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) > at sun.rmi.transport.Transport$1.run(Transport.java:148) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:144) > at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja > va:701) > at java.lang.Thread.run(Thread.java:534) > 2003-07-16 15:23:27,785 INFO > [org.jboss.resource.connectionmanager.LocalTxConnectionManager] Could > not enlist in transaction on entering meta-aware object! > javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback > at > org.jboss.resource.connectionmanager.LocalTxConnectionManager$LocalConne > ctionEventListener.enlist(LocalTxConnectionManager.java:329) > at > org.jboss.resource.connectionmanager.LocalTxConnectionManager.managedCon > nectionReconnected(LocalTxConnectionManager.java:255) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConn > ection(BaseConnectionManager2.java:534) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionMa > nagerProxy.allocateConnection(BaseConnectionManager2.java:828) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:122) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConne > ctionFromDataSource(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupCo > nnection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryManagedImpl.lookupCon > nection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Un > known Source) > at > org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement( > Unknown Source) > at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown > Source) > at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown > Source) > at > org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknow > n Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery( > Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Un > known Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQuery(Unkn > own Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getIteratorByQuer > y(Unknown Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOutLocks(Un > known Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.AbstractLockStrategy.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.ReadUncommittedStrategy.releaseLock(Unknown > Source) > at > org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) > at org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) > at > org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown Source) > at > org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416) > at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368) > at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73) > at > org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.j > ava:365) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor > CMT.java:247) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:98) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav > a:130) > at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) > at > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer > .java:313) > at org.jboss.ejb.Container.invoke(Container.java:738) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:383 > ) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav > a:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) > at sun.rmi.transport.Transport$1.run(Transport.java:148) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:144) > at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja > va:701) > at java.lang.Thread.run(Thread.java:534) > 2003-07-16 15:23:27,800 ERROR > [org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl] > SQLException thrown while trying to get Connection from Datasource > (java:MySqlDSSYWEB) > org.jboss.util.NestedSQLException: Could not enlist in transaction on > entering meta-aware object!javax.transaction.SystemException: Could not > enlist XAResource!javax.transaction.RollbackException: Already marked > for rollback; - nested throwable: (javax.resource.ResourceException: > Could not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:126) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConne > ctionFromDataSource(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupCo > nnection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryManagedImpl.lookupCon > nection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Un > known Source) > at > org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement( > Unknown Source) > at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown > Source) > at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown > Source) > at > org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknow > n Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery( > Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Un > known Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQuery(Unkn > own Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getIteratorByQuer > y(Unknown Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOutLocks(Un > known Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.AbstractLockStrategy.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.ReadUncommittedStrategy.releaseLock(Unknown > Source) > at > org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) > at org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) > at > org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown Source) > at > org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416) > at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368) > at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73) > at > org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.j > ava:365) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor > CMT.java:247) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:98) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav > a:130) > at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) > at > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer > .java:313) > at org.jboss.ejb.Container.invoke(Container.java:738) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:383 > ) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav > a:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) > at sun.rmi.transport.Transport$1.run(Transport.java:148) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:144) > at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja > va:701) > at java.lang.Thread.run(Thread.java:534) > Caused by: javax.resource.ResourceException: Could not enlist in > transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback > at > org.jboss.resource.connectionmanager.LocalTxConnectionManager.managedCon > nectionReconnected(LocalTxConnectionManager.java:260) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConn > ection(BaseConnectionManager2.java:534) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionMa > nagerProxy.allocateConnection(BaseConnectionManager2.java:828) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:122) > ... 44 more > 2003-07-16 15:23:27,816 ERROR > [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] > PersistenceBrokerException during the execution of the query: Used > ConnectionManager instance could not obtain a connection: SQLException > thrown while trying to get Connection from Datasource > (java:MySqlDSSYWEB): Could not enlist in transaction on entering > meta-aware object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback; - nested throwable: (javax.resource.ResourceException: Could > not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > org.jboss.util.NestedSQLException: Could not enlist in transaction on > entering meta-aware object!javax.transaction.SystemException: Could not > enlist XAResource!javax.transaction.RollbackException: Already marked > for rollback; - nested throwable: (javax.resource.ResourceException: > Could not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:126) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConne > ctionFromDataSource(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupCo > nnection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryManagedImpl.lookupCon > nection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Un > known Source) > at > org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement( > Unknown Source) > at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown > Source) > at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown > Source) > at > org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknow > n Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery( > Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Un > known Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQuery(Unkn > own Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getIteratorByQuer > y(Unknown Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOutLocks(Un > known Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.AbstractLockStrategy.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.ReadUncommittedStrategy.releaseLock(Unknown > Source) > at > org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) > at org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) > at > org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown Source) > at > org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416) > at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368) > at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73) > at > org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.j > ava:365) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor > CMT.java:247) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:98) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav > a:130) > at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) > at > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer > .java:313) > at org.jboss.ejb.Container.invoke(Container.java:738) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:383 > ) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav > a:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) > at sun.rmi.transport.Transport$1.run(Transport.java:148) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:144) > at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja > va:701) > at java.lang.Thread.run(Thread.java:534) > Caused by: javax.resource.ResourceException: Could not enlist in > transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback > at > org.jboss.resource.connectionmanager.LocalTxConnectionManager.managedCon > nectionReconnected(LocalTxConnectionManager.java:260) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConn > ection(BaseConnectionManager2.java:534) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionMa > nagerProxy.allocateConnection(BaseConnectionManager2.java:828) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:122) > ... 44 more > rethrown as > org.apache.ojb.broker.accesslayer.LookupException: SQLException thrown > while trying to get Connection from Datasource (java:MySqlDSSYWEB): > Could not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback; - nested throwable: (javax.resource.ResourceException: Could > not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConne > ctionFromDataSource(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupCo > nnection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryManagedImpl.lookupCon > nection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Un > known Source) > at > org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement( > Unknown Source) > at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown > Source) > at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown > Source) > at > org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknow > n Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery( > Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Un > known Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQuery(Unkn > own Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getIteratorByQuer > y(Unknown Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOutLocks(Un > known Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.AbstractLockStrategy.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.ReadUncommittedStrategy.releaseLock(Unknown > Source) > at > org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) > at org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) > at > org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown Source) > at > org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416) > at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368) > at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73) > at > org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.j > ava:365) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor > CMT.java:247) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:98) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav > a:130) > at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) > at > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer > .java:313) > at org.jboss.ejb.Container.invoke(Container.java:738) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:383 > ) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav > a:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) > at sun.rmi.transport.Transport$1.run(Transport.java:148) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:144) > at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja > va:701) > at java.lang.Thread.run(Thread.java:534) > Caused by: org.jboss.util.NestedSQLException: Could not enlist in > transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback; - nested throwable: (javax.resource.ResourceException: Could > not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:126) > ... 44 more > Caused by: javax.resource.ResourceException: Could not enlist in > transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback > at > org.jboss.resource.connectionmanager.LocalTxConnectionManager.managedCon > nectionReconnected(LocalTxConnectionManager.java:260) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConn > ection(BaseConnectionManager2.java:534) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionMa > nagerProxy.allocateConnection(BaseConnectionManager2.java:828) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:122) > ... 44 more > rethrown as > org.apache.ojb.broker.PersistenceBrokerException: Used ConnectionManager > instance could not obtain a connection: SQLException thrown while trying > to get Connection from Datasource (java:MySqlDSSYWEB): Could not enlist > in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback; - nested throwable: (javax.resource.ResourceException: Could > not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at > org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement( > Unknown Source) > at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown > Source) > at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown > Source) > at > org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknow > n Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery( > Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Un > known Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQuery(Unkn > own Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getIteratorByQuer > y(Unknown Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOutLocks(Un > known Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.AbstractLockStrategy.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.ReadUncommittedStrategy.releaseLock(Unknown > Source) > at > org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) > at org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) > at > org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown Source) > at > org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416) > at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368) > at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73) > at > org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.j > ava:365) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor > CMT.java:247) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:98) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav > a:130) > at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) > at > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer > .java:313) > at org.jboss.ejb.Container.invoke(Container.java:738) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:383 > ) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav > a:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) > at sun.rmi.transport.Transport$1.run(Transport.java:148) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:144) > at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja > va:701) > at java.lang.Thread.run(Thread.java:534) > Caused by: org.apache.ojb.broker.accesslayer.LookupException: > SQLException thrown while trying to get Connection from Datasource > (java:MySqlDSSYWEB): Could not enlist in transaction on entering > meta-aware object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback; - nested throwable: (javax.resource.ResourceException: Could > not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConne > ctionFromDataSource(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupCo > nnection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryManagedImpl.lookupCon > nection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Un > known Source) > ... 40 more > Caused by: org.jboss.util.NestedSQLException: Could not enlist in > transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback; - nested throwable: (javax.resource.ResourceException: Could > not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:126) > ... 44 more > Caused by: javax.resource.ResourceException: Could not enlist in > transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback > at > org.jboss.resource.connectionmanager.LocalTxConnectionManager.managedCon > nectionReconnected(LocalTxConnectionManager.java:260) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConn > ection(BaseConnectionManager2.java:534) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionMa > nagerProxy.allocateConnection(BaseConnectionManager2.java:828) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:122) > ... 44 more > 2003-07-16 15:23:27,831 INFO > [org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] Rollback was > called, do rollback on current connection null > 2003-07-16 15:23:27,831 ERROR [STDERR] > org.jboss.util.NestedSQLException: Could not enlist in transaction on > entering meta-aware object!javax.transaction.SystemException: Could not > enlist XAResource!javax.transaction.RollbackException: Already marked > for rollback; - nested throwable: (javax.resource.ResourceException: > Could not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:126) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConne > ctionFromDataSource(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupCo > nnection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryManagedImpl.lookupCon > nection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Un > known Source) > at > org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement( > Unknown Source) > at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown > Source) > at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown > Source) > at > org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknow > n Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery( > Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Un > known Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQuery(Unkn > own Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getIteratorByQuer > y(Unknown Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOutLocks(Un > known Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.AbstractLockStrategy.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.ReadUncommittedStrategy.releaseLock(Unknown > Source) > at > org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) > at org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) > at > org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown Source) > at > org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416) > at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368) > at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73) > at > org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.j > ava:365) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor > CMT.java:247) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:98) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav > a:130) > at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) > at > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer > .java:313) > at org.jboss.ejb.Container.invoke(Container.java:738) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:383 > ) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav > a:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) > at sun.rmi.transport.Transport$1.run(Transport.java:148) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:144) > at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja > va:701) > at java.lang.Thread.run(Thread.java:534) > Caused by: javax.resource.ResourceException: Could not enlist in > transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback > at > org.jboss.resource.connectionmanager.LocalTxConnectionManager.managedCon > nectionReconnected(LocalTxConnectionManager.java:260) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConn > ection(BaseConnectionManager2.java:534) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionMa > nagerProxy.allocateConnection(BaseConnectionManager2.java:828) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:122) > ... 44 more > rethrown as org.apache.ojb.broker.accesslayer.LookupException: > SQLException thrown while trying to get Connection from Datasource > (java:MySqlDSSYWEB): Could not enlist in transaction on entering > meta-aware object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback; - nested throwable: (javax.resource.ResourceException: Could > not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConne > ctionFromDataSource(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupCo > nnection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryManagedImpl.lookupCon > nection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Un > known Source) > at > org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement( > Unknown Source) > at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown > Source) > at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown > Source) > at > org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknow > n Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery( > Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Un > known Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQuery(Unkn > own Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getIteratorByQuer > y(Unknown Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOutLocks(Un > known Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.AbstractLockStrategy.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.ReadUncommittedStrategy.releaseLock(Unknown > Source) > at > org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) > at org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) > at > org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown Source) > at > org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416) > at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368) > at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73) > at > org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.j > ava:365) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor > CMT.java:247) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:98) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav > a:130) > at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) > at > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer > .java:313) > at org.jboss.ejb.Container.invoke(Container.java:738) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:383 > ) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMet > 2003-07-16 15:23:27,847 ERROR [STDERR] hodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) > at sun.rmi.transport.Transport$1.run(Transport.java:148) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:144) > at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja > va:701) > at java.lang.Thread.run(Thread.java:534) > Caused by: org.jboss.util.NestedSQLException: Could not enlist in > transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback; - nested throwable: (javax.resource.ResourceException: Could > not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:126) > ... 44 more > Caused by: javax.resource.ResourceException: Could not enlist in > transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback > at > org.jboss.resource.connectionmanager.LocalTxConnectionManager.managedCon > nectionReconnected(LocalTxConnectionManager.java:260) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConn > ection(BaseConnectionManager2.java:534) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionMa > nagerProxy.allocateConnection(BaseConnectionManager2.java:828) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:122) > ... 44 more > rethrown as org.apache.ojb.broker.PersistenceBrokerException: Used > ConnectionManager instance could not obtain a connection: SQLException > thrown while trying to get Connection from Datasource > (java:MySqlDSSYWEB): Could not enlist in transaction on entering > meta-aware object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback; - nested throwable: (javax.resource.ResourceException: Could > not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at > org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement( > Unknown Source) > at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown > Source) > at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown > Source) > at > org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknow > n Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery( > Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Un > known Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQuery(Unkn > own Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getIteratorByQuer > y(Unknown Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOutLocks(Un > known Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.AbstractLockStrategy.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.ReadUncommittedStrategy.releaseLock(Unknown > Source) > at > org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) > at org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) > at > org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown Source) > at > org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416) > at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368) > at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73) > at > org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.j > ava:365) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor > CMT.java:247) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:98) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav > a:130) > at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) > at > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer > .java:313) > at org.jboss.ejb.Container.invoke(Container.java:738) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:383 > ) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav > a:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) > at sun.rmi.transport.Transport$1.run(Transport.java:148) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:144) > at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja > va:701) > at java.lang.Thread.run(Thread.java:534) > Caused by: org.apache.ojb.broker.accesslayer.LookupException: > SQLException thrown while trying to get Connection from Datasource > (java:MySqlDSSYWEB): Could not enlist in transaction on entering > meta-aware object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback; - nested throwable: (javax.resource.ResourceException: Could > not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConne > ctionFromDataSource(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupCo > nnection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryManagedImpl.lookupCon > nection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Un > known Source) > ... 40 more > Caused by: org.jboss.util.NestedSQLException: Could not enlist in > transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback; - nested throwable: (javax.resource.ResourceException: Could > not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:126) > ... 44 more > Caused by: javax.resource.ResourceException: Could not enlist in > transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback > at > org.jboss.resource.connectionmanager.LocalTxConnectionManager.managedCon > nectionReconnected(LocalTxConnectionManager.java:260) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConn > ection(BaseConnectionManager2.java:534) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionMa > nagerProxy.allocateConnection(BaseConnectionManager2.java:828) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:122) > ... 44 more > 2003-07-16 15:23:27,847 ERROR [STDERR] Query "rollback" > execution time: 0 > 2003-07-16 15:23:27,847 ERROR [STDERR] Query "SET autocommit=1" > execution time: 0 > 2003-07-16 15:23:27,847 ERROR [STDERR] Query "SHOW VARIABLES LIKE > 'tx_isolation'" execution time: 0 result set fetch time: 0 > 2003-07-16 15:23:27,847 ERROR [org.jboss.ejb.plugins.LogInterceptor] > TransactionRolledbackException, causedBy: > org.jboss.util.NestedSQLException: Could not enlist in transaction on > entering meta-aware object!javax.transaction.SystemException: Could not > enlist XAResource!javax.transaction.RollbackException: Already marked > for rollback; - nested throwable: (javax.resource.ResourceException: > Could not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:126) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConne > ctionFromDataSource(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupCo > nnection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryManagedImpl.lookupCon > nection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Un > known Source) > at > org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement( > Unknown Source) > at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown > Source) > at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown > Source) > at > org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknow > n Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery( > Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Un > known Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQuery(Unkn > own Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getIteratorByQuer > y(Unknown Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOutLocks(Un > known Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.AbstractLockStrategy.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.ReadUncommittedStrategy.releaseLock(Unknown > Source) > at > org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) > at org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) > at > org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown Source) > at > org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416) > at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368) > at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73) > at > org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.j > ava:365) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor > CMT.java:247) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:98) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav > a:130) > at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) > at > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer > .java:313) > at org.jboss.ejb.Container.invoke(Container.java:738) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:383 > ) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav > a:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) > at sun.rmi.transport.Transport$1.run(Transport.java:148) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:144) > at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja > va:701) > at java.lang.Thread.run(Thread.java:534) > Caused by: javax.resource.ResourceException: Could not enlist in > transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback > at > org.jboss.resource.connectionmanager.LocalTxConnectionManager.managedCon > nectionReconnected(LocalTxConnectionManager.java:260) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConn > ection(BaseConnectionManager2.java:534) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionMa > nagerProxy.allocateConnection(BaseConnectionManager2.java:828) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:122) > ... 44 more > rethrown as > org.apache.ojb.broker.accesslayer.LookupException: SQLException thrown > while trying to get Connection from Datasource (java:MySqlDSSYWEB): > Could not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback; - nested throwable: (javax.resource.ResourceException: Could > not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConne > ctionFromDataSource(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupCo > nnection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryManagedImpl.lookupCon > nection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Un > known Source) > at > org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement( > Unknown Source) > at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown > Source) > at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown > Source) > at > org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknow > n Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery( > Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Un > known Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQuery(Unkn > own Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getIteratorByQuer > y(Unknown Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOutLocks(Un > known Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.AbstractLockStrategy.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.ReadUncommittedStrategy.releaseLock(Unknown > Source) > at > org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) > at org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) > at > org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown Source) > at > org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416) > at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368) > at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73) > at > org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.j > ava:365) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor > CMT.java:247) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:98) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav > a:130) > at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) > at > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer > .java:313) > at org.jboss.ejb.Container.invoke(Container.java:738) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:383 > ) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav > a:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) > at sun.rmi.transport.Transport$1.run(Transport.java:148) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:144) > at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja > va:701) > at java.lang.Thread.run(Thread.java:534) > Caused by: org.jboss.util.NestedSQLException: Could not enlist in > transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback; - nested throwable: (javax.resource.ResourceException: Could > not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:126) > ... 44 more > Caused by: javax.resource.ResourceException: Could not enlist in > transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback > at > org.jboss.resource.connectionmanager.LocalTxConnectionManager.managedCon > nectionReconnected(LocalTxConnectionManager.java:260) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConn > ection(BaseConnectionManager2.java:534) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionMa > nagerProxy.allocateConnection(BaseConnectionManager2.java:828) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:122) > ... 44 more > rethrown as > org.apache.ojb.broker.PersistenceBrokerException: Used ConnectionManager > instance could not obtain a connection: SQLException thrown while trying > to get Connection from Datasource (java:MySqlDSSYWEB): Could not enlist > in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback; - nested throwable: (javax.resource.ResourceException: Could > not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at > org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement( > Unknown Source) > at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown > Source) > at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown > Source) > at > org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknow > n Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery( > Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Un > known Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQuery(Unkn > own Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getIteratorByQuer > y(Unknown Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOutLocks(Un > known Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.AbstractLockStrategy.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.ReadUncommittedStrategy.releaseLock(Unknown > Source) > at > org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) > at org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) > at > org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown Source) > at > org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416) > at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368) > at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73) > at > org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.j > ava:365) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor > CMT.java:247) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:98) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav > a:130) > at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) > at > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer > .java:313) > at org.jboss.ejb.Container.invoke(Container.java:738) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:383 > ) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav > a:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) > at sun.rmi.transport.Transport$1.run(Transport.java:148) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:144) > at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja > va:701) > at java.lang.Thread.run(Thread.java:534) > Caused by: org.apache.ojb.broker.accesslayer.LookupException: > SQLException thrown while trying to get Connection from Datasource > (java:MySqlDSSYWEB): Could not enlist in transaction on entering > meta-aware object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback; - nested throwable: (javax.resource.ResourceException: Could > not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConne > ctionFromDataSource(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupCo > nnection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryManagedImpl.lookupCon > nection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Un > known Source) > ... 40 more > Caused by: org.jboss.util.NestedSQLException: Could not enlist in > transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback; - nested throwable: (javax.resource.ResourceException: Could > not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:126) > ... 44 more > Caused by: javax.resource.ResourceException: Could not enlist in > transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback > at > org.jboss.resource.connectionmanager.LocalTxConnectionManager.managedCon > nectionReconnected(LocalTxConnectionManager.java:260) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConn > ection(BaseConnectionManager2.java:534) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionMa > nagerProxy.allocateConnection(BaseConnectionManager2.java:828) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:122) > ... 44 more > rethrown as > org.apache.ojb.broker.OJBRuntimeException: Unexpected error occured > while aborting: Used ConnectionManager instance could not obtain a > connection: SQLException thrown while trying to get Connection from > Datasource (java:MySqlDSSYWEB): Could not enlist in transaction on > entering meta-aware object!javax.transaction.SystemException: Could not > enlist XAResource!javax.transaction.RollbackException: Already marked > for rollback; - nested throwable: (javax.resource.ResourceException: > Could not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) > at > org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown Source) > at > org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416) > at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368) > at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73) > at > org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.j > ava:365) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor > CMT.java:247) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:98) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav > a:130) > at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) > at > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer > .java:313) > at org.jboss.ejb.Container.invoke(Container.java:738) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:383 > ) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav > a:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) > at sun.rmi.transport.Transport$1.run(Transport.java:148) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:144) > at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja > va:701) > at java.lang.Thread.run(Thread.java:534) > Caused by: org.apache.ojb.broker.PersistenceBrokerException: Used > ConnectionManager instance could not obtain a connection: SQLException > thrown while trying to get Connection from Datasource > (java:MySqlDSSYWEB): Could not enlist in transaction on entering > meta-aware object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback; - nested throwable: (javax.resource.ResourceException: Could > not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at > org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement( > Unknown Source) > at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown > Source) > at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown > Source) > at > org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknow > n Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery( > Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Un > known Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQuery(Unkn > own Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getIteratorByQuer > y(Unknown Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOutLocks(Un > known Source) > at > org.apache.ojb.odmg.locking.PersistentLockMapImpl.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.AbstractLockStrategy.getWriter(Unknown > Source) > at > org.apache.ojb.odmg.locking.ReadUncommittedStrategy.releaseLock(Unknown > Source) > at > org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown > Source) > at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) > ... 25 more > Caused by: org.apache.ojb.broker.accesslayer.LookupException: > SQLException thrown while trying to get Connection from Datasource > (java:MySqlDSSYWEB): Could not enlist in transaction on entering > meta-aware object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback; - nested throwable: (javax.resource.ResourceException: Could > not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConne > ctionFromDataSource(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupCo > nnection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryManagedImpl.lookupCon > nection(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Un > known Source) > ... 40 more > Caused by: org.jboss.util.NestedSQLException: Could not enlist in > transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback; - nested throwable: (javax.resource.ResourceException: Could > not enlist in transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:126) > ... 44 more > Caused by: javax.resource.ResourceException: Could not enlist in > transaction on entering meta-aware > object!javax.transaction.SystemException: Could not enlist > XAResource!javax.transaction.RollbackException: Already marked for > rollback > at > org.jboss.resource.connectionmanager.LocalTxConnectionManager.managedCon > nectionReconnected(LocalTxConnectionManager.java:260) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConn > ection(BaseConnectionManager2.java:534) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionMa > nagerProxy.allocateConnection(BaseConnectionManager2.java:828) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperD > ataSource.java:122) > ... 44 more > > > > > > > >-----Original Message----- > >From: Stephen Ting [mailto:[EMAIL PROTECTED] > >Sent: 15 July 2003 17:50 > >To: 'Ojb Users List' > >Subject: Transaction in PB api > > > > > >I have the following problem in PB transaction. I have an > >object with 1:M relationship. In testing, I found that when > >there are error in persisting the line item of the header > >object. The header still persisted to database whereas the > >line item didn't. > > > >I am expecting whenver there any errors, it will roll back and > >no saving being done.. Can anyone show me how to do this in PB > >API? What actually PB transaction can do and don't? > > > >I used PB api in session bean. > > > > > y{ > > broker = getBroker(new PBKey(site.getDbConnectionAlias())); > > broker.beginTransaction(); > > broker.store(document); > > broker.commitTransaction(); > >}catch(PersistenceBrokerException ex){ > > broker.abortTransaction(); > > broker.close(); > > throw new ServiceException(ex.getMessage()); > >}finally{ > > if(broker != null){ > > broker.close(); > > } > >} > > > >Regards, > > > >Stephen Ting > > > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
