Hi Armin, In addition to this, (Base on the testing in attach) if in 2 tiers testing for PB api, if the transaction is rollback because of error in LogPondBlock object, the LogPond object will not be persist but in 3 tiers(Jboss) it will. Is there any particular setting in should take care of in 3 tiers?
>-----Original Message----- >From: Stephen Ting [mailto:[EMAIL PROTECTED] >Sent: 16 July 2003 18:28 >To: 'OJB Users List'; 'Armin Waibel' >Subject: RE: Transaction in PB api > > >Hi Armin, > >Thanks for replying. > >I am using container-managed transaction in the session bean. >I didn't used OJB sequence manager to generate the sequence >number, I manually set the sequence number. So, I think >shouldn't be the problems of sequence manager. > >I have same SQL exception in 2-tiers..if using ODMG api. If >using PB api, I have no problems. > >My test code for 2 tiers usage. > > public void testODMG() throws Exception{ > Implementation odmg = OJB.getInstance(); > Database db = odmg.newDatabase(); > try{ > >db.open(TestHelper.createSite().getDbConnectionAlias(), > Database.OPEN_READ_WRITE); > Transaction tx = odmg.newTransaction(); > tx.begin(); > LogPond lp = createLogPond(); > //tx.lock(document, Database.OPEN_READ_WRITE); > db.makePersistent(lp); > tx.commit(); > > System.out.println(lp.toString()); > > }catch(ODMGException e){ > throw new BDException(e.getMessage()); > > } > > > > } > public void testPB() throws Exception{ > PersistenceBroker broker = null; > > try{ > broker = >PersistenceBrokerFactory.createPersistenceBroker( > new >PBKey(TestHelper.createSite().getDbConnectionAlias())); > broker.beginTransaction(); > LogPond lp = createLogPond(); > broker.store(lp); > broker.commitTransaction(); > }catch(Exception e){ > broker.abortTransaction(); > e.printStackTrace(); > > } > > > public LogPond createLogPond(){ > > LogPond doc = new LogPond(); > doc.setId("logPond1"); > doc.setName("sypmyylogpond"); > doc.setRemark("anythign here"); > > for(int i=1; i<=1; i++){ > LogPondBlock item = new LogPondBlock(); > item.setId(Integer.toString(i)); > > item.setName("zedteeblock1"); > item.setRemark("anything here"); > item.setLogPond(doc); > doc.addLogPondBlock(item); > } > return doc; > } > <class-descriptor > class="my.com.shinyang.eply.model.LogPondBlock" > table="LOG_POND_BLOCK"> > > <field-descriptor > name="id" > column="ID" > jdbc-type="VARCHAR" > primarykey="true" > /> > <field-descriptor > name="logPondId" > column="LOG_POND_ID" > jdbc-type="VARCHAR" > /> > <field-descriptor > name="name" > column="NAME" > jdbc-type="VARCHAR" > /> > <field-descriptor > name="volume" > column="VOLUME" > jdbc-type="DECIMAL" > /> > <field-descriptor > name="pieces" > column="PIECES" > jdbc-type="INTEGER" > /> > <field-descriptor > name="remark" > column="REMARK" > jdbc-type="VARCHAR" > /> > <collection-descriptor > name="logList" > element-class-ref="my.com.shinyang.eply.model.Log" > auto-retrieve="false" > auto-update="false" > auto-delete="false"> > <inverse-foreignkey field-ref="id"/> > </collection-descriptor> > </class-descriptor> > > <class-descriptor > class="my.com.shinyang.eply.model.LogPond" > table="LOG_POND"> > > <field-descriptor > name="id" > column="ID" > jdbc-type="VARCHAR" > primarykey="true" > /> > <field-descriptor > name="name" > column="NAME" > jdbc-type="VARCHAR" > /> > <field-descriptor > name="volume" > column="VOLUME" > jdbc-type="DECIMAL" > /> > <field-descriptor > name="pieces" > column="PIECES" > jdbc-type="INTEGER" > /> > <field-descriptor > name="remark" > column="REMARK" > jdbc-type="VARCHAR" > /> > <collection-descriptor > name="logPondBlockList" > >element-class-ref="my.com.shinyang.eply.model.LogPondBlock" > auto-retrieve="true" > auto-update="true" > auto-delete="true"> > <inverse-foreignkey field-ref="logPondId"/> > </collection-descriptor> > </class-descriptor> > >Thanks > >Regards, >Stephen > >>-----Original Message----- >>From: Armin Waibel [mailto:[EMAIL PROTECTED] >>Sent: 16 July 2003 15:58 >>To: OJB Users List; Stephen Ting Tiew Ung >>Subject: Re: Transaction in PB api >> >> >>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(PreparedStatemen >>t.java:17 >>> 00) >>> at >>> >>com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatemen >>t.java:15 >>> 69) >>> at >>> >>org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.execut >>eUpdate(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(TxInterce >>ptorCMT.j >>> ava:365) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIn >>terceptor >>> CMT.java:247) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT >.java:98) >>> at >>> >>org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterc >>eptor.jav >>> a:130) >>> at >>> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) >>> at >>> >>org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSession >>Container >>> .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(NativeMethodAccesso >>rImpl.jav >>> a:39) >>> at >>> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho >>dAccessor >>> 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(TCPTra >>nsport.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(PreparedStatemen >>t.java:17 >>> 00) >>> at >>> >>com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatemen >>t.java:15 >>> 69) >>> at >>> >>org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.execut >>eUpdate(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(TxInterce >>ptorCMT.j >>> ava:365) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIn >>terceptor >>> CMT.java:247) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT >.java:98) >>> at >>> >>org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterc >>eptor.jav >>> a:130) >>> at >>> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) >>> at >>> >>org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSession >>Container >>> .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(NativeMethodAccesso >>rImpl.jav >>> a:39) >>> at >>> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho >>dAccessor >>> 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(TCPTra >>nsport.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(TxInterce >>ptorCMT.j >>> ava:365) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIn >>terceptor >>> CMT.java:247) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT >.java:98) >>> at >>> >>org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterc >>eptor.jav >>> a:130) >>> at >>> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) >>> at >>> >>org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSession >>Container >>> .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(NativeMethodAccesso >>rImpl.jav >>> a:39) >>> at >>> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho >>dAccessor >>> 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(TCPTra >>nsport.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(PreparedStatemen >>t.java:17 >>> 00) >>> at >>> >>com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatemen >>t.java:15 >>> 69) >>> at >>> >>org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.execut >>eUpdate(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$L >>ocalConne >>> ctionEventListener.enlist(LocalTxConnectionManager.java:320) >>> at >>> >>org.jboss.resource.connectionmanager.LocalTxConnectionManager.m >>anagedCon >>> nectionReconnected(LocalTxConnectionManager.java:255) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2.all >>ocateConn >>> ection(BaseConnectionManager2.java:534) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2$Con >>nectionMa >>> 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.getConn >>ection(Un >>> known Source) >>> at >>> >>org.apache.ojb.broker.accesslayer.StatementManager.getPreparedS >>tatement( >>> 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.createRsIterat >>or(Unknow >>> n Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorF >>romQuery( >>> Unknown Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFro >>mQuery(Un >>> known Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQ >>uery(Unkn >>> own Source) >>> at >>> >>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getItera >>torByQuer >>> y(Unknown Source) >>> at >>> >>org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOu >>tLocks(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.releaseLoc >k(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(TxInterce >>ptorCMT.j >>> ava:365) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIn >>terceptor >>> CMT.java:247) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT >.java:98) >>> at >>> >>org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterc >>eptor.jav >>> a:130) >>> at >>> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) >>> at >>> >>org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSession >>Container >>> .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(NativeMethodAccesso >>rImpl.jav >>> a:39) >>> at >>> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho >>dAccessor >>> 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(TCPTra >>nsport.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$L >>ocalConne >>> ctionEventListener.enlist(LocalTxConnectionManager.java:329) >>> at >>> >>org.jboss.resource.connectionmanager.LocalTxConnectionManager.m >>anagedCon >>> nectionReconnected(LocalTxConnectionManager.java:255) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2.all >>ocateConn >>> ection(BaseConnectionManager2.java:534) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2$Con >>nectionMa >>> 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.getConn >>ection(Un >>> known Source) >>> at >>> >>org.apache.ojb.broker.accesslayer.StatementManager.getPreparedS >>tatement( >>> 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.createRsIterat >>or(Unknow >>> n Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorF >>romQuery( >>> Unknown Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFro >>mQuery(Un >>> known Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQ >>uery(Unkn >>> own Source) >>> at >>> >>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getItera >>torByQuer >>> y(Unknown Source) >>> at >>> >>org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOu >>tLocks(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.releaseLoc >k(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(TxInterce >>ptorCMT.j >>> ava:365) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIn >>terceptor >>> CMT.java:247) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT >.java:98) >>> at >>> >>org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterc >>eptor.jav >>> a:130) >>> at >>> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) >>> at >>> >>org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSession >>Container >>> .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(NativeMethodAccesso >>rImpl.jav >>> a:39) >>> at >>> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho >>dAccessor >>> 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(TCPTra >>nsport.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.getConn >>ection(Un >>> known Source) >>> at >>> >>org.apache.ojb.broker.accesslayer.StatementManager.getPreparedS >>tatement( >>> 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.createRsIterat >>or(Unknow >>> n Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorF >>romQuery( >>> Unknown Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFro >>mQuery(Un >>> known Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQ >>uery(Unkn >>> own Source) >>> at >>> >>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getItera >>torByQuer >>> y(Unknown Source) >>> at >>> >>org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOu >>tLocks(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.releaseLoc >k(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(TxInterce >>ptorCMT.j >>> ava:365) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIn >>terceptor >>> CMT.java:247) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT >.java:98) >>> at >>> >>org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterc >>eptor.jav >>> a:130) >>> at >>> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) >>> at >>> >>org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSession >>Container >>> .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(NativeMethodAccesso >>rImpl.jav >>> a:39) >>> at >>> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho >>dAccessor >>> 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(TCPTra >>nsport.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.m >>anagedCon >>> nectionReconnected(LocalTxConnectionManager.java:260) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2.all >>ocateConn >>> ection(BaseConnectionManager2.java:534) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2$Con >>nectionMa >>> 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.getConn >>ection(Un >>> known Source) >>> at >>> >>org.apache.ojb.broker.accesslayer.StatementManager.getPreparedS >>tatement( >>> 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.createRsIterat >>or(Unknow >>> n Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorF >>romQuery( >>> Unknown Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFro >>mQuery(Un >>> known Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQ >>uery(Unkn >>> own Source) >>> at >>> >>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getItera >>torByQuer >>> y(Unknown Source) >>> at >>> >>org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOu >>tLocks(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.releaseLoc >k(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(TxInterce >>ptorCMT.j >>> ava:365) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIn >>terceptor >>> CMT.java:247) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT >.java:98) >>> at >>> >>org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterc >>eptor.jav >>> a:130) >>> at >>> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) >>> at >>> >>org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSession >>Container >>> .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(NativeMethodAccesso >>rImpl.jav >>> a:39) >>> at >>> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho >>dAccessor >>> 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(TCPTra >>nsport.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.m >>anagedCon >>> nectionReconnected(LocalTxConnectionManager.java:260) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2.all >>ocateConn >>> ection(BaseConnectionManager2.java:534) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2$Con >>nectionMa >>> 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.getConn >>ection(Un >>> known Source) >>> at >>> >>org.apache.ojb.broker.accesslayer.StatementManager.getPreparedS >>tatement( >>> 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.createRsIterat >>or(Unknow >>> n Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorF >>romQuery( >>> Unknown Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFro >>mQuery(Un >>> known Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQ >>uery(Unkn >>> own Source) >>> at >>> >>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getItera >>torByQuer >>> y(Unknown Source) >>> at >>> >>org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOu >>tLocks(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.releaseLoc >k(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(TxInterce >>ptorCMT.j >>> ava:365) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIn >>terceptor >>> CMT.java:247) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT >.java:98) >>> at >>> >>org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterc >>eptor.jav >>> a:130) >>> at >>> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) >>> at >>> >>org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSession >>Container >>> .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(NativeMethodAccesso >>rImpl.jav >>> a:39) >>> at >>> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho >>dAccessor >>> 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(TCPTra >>nsport.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.m >>anagedCon >>> nectionReconnected(LocalTxConnectionManager.java:260) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2.all >>ocateConn >>> ection(BaseConnectionManager2.java:534) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2$Con >>nectionMa >>> 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.getPreparedS >>tatement( >>> 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.createRsIterat >>or(Unknow >>> n Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorF >>romQuery( >>> Unknown Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFro >>mQuery(Un >>> known Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQ >>uery(Unkn >>> own Source) >>> at >>> >>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getItera >>torByQuer >>> y(Unknown Source) >>> at >>> >>org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOu >>tLocks(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.releaseLoc >k(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(TxInterce >>ptorCMT.j >>> ava:365) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIn >>terceptor >>> CMT.java:247) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT >.java:98) >>> at >>> >>org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterc >>eptor.jav >>> a:130) >>> at >>> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) >>> at >>> >>org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSession >>Container >>> .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(NativeMethodAccesso >>rImpl.jav >>> a:39) >>> at >>> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho >>dAccessor >>> 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(TCPTra >>nsport.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.getConn >>ection(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.m >>anagedCon >>> nectionReconnected(LocalTxConnectionManager.java:260) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2.all >>ocateConn >>> ection(BaseConnectionManager2.java:534) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2$Con >>nectionMa >>> 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.getConn >>ection(Un >>> known Source) >>> at >>> >>org.apache.ojb.broker.accesslayer.StatementManager.getPreparedS >>tatement( >>> 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.createRsIterat >>or(Unknow >>> n Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorF >>romQuery( >>> Unknown Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFro >>mQuery(Un >>> known Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQ >>uery(Unkn >>> own Source) >>> at >>> >>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getItera >>torByQuer >>> y(Unknown Source) >>> at >>> >>org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOu >>tLocks(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.releaseLoc >k(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(TxInterce >>ptorCMT.j >>> ava:365) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIn >>terceptor >>> CMT.java:247) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT >.java:98) >>> at >>> >>org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterc >>eptor.jav >>> a:130) >>> at >>> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) >>> at >>> >>org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSession >>Container >>> .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(NativeMethodAccesso >>rImpl.jav >>> a:39) >>> at >>> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho >>dAccessor >>> 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(TCPTra >>nsport.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.m >>anagedCon >>> nectionReconnected(LocalTxConnectionManager.java:260) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2.all >>ocateConn >>> ection(BaseConnectionManager2.java:534) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2$Con >>nectionMa >>> 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.getConn >>ection(Un >>> known Source) >>> at >>> >>org.apache.ojb.broker.accesslayer.StatementManager.getPreparedS >>tatement( >>> 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.createRsIterat >>or(Unknow >>> n Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorF >>romQuery( >>> Unknown Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFro >>mQuery(Un >>> known Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQ >>uery(Unkn >>> own Source) >>> at >>> >>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getItera >>torByQuer >>> y(Unknown Source) >>> at >>> >>org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOu >>tLocks(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.releaseLoc >k(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(TxInterce >>ptorCMT.j >>> ava:365) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIn >>terceptor >>> CMT.java:247) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT >.java:98) >>> at >>> >>org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterc >>eptor.jav >>> a:130) >>> at >>> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) >>> at >>> >>org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSession >>Container >>> .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(DelegatingMetho >>dAccessor >>> 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(TCPTra >>nsport.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.m >>anagedCon >>> nectionReconnected(LocalTxConnectionManager.java:260) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2.all >>ocateConn >>> ection(BaseConnectionManager2.java:534) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2$Con >>nectionMa >>> 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.getPreparedS >>tatement( >>> 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.createRsIterat >>or(Unknow >>> n Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorF >>romQuery( >>> Unknown Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFro >>mQuery(Un >>> known Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQ >>uery(Unkn >>> own Source) >>> at >>> >>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getItera >>torByQuer >>> y(Unknown Source) >>> at >>> >>org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOu >>tLocks(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.releaseLoc >k(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(TxInterce >>ptorCMT.j >>> ava:365) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIn >>terceptor >>> CMT.java:247) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT >.java:98) >>> at >>> >>org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterc >>eptor.jav >>> a:130) >>> at >>> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) >>> at >>> >>org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSession >>Container >>> .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(NativeMethodAccesso >>rImpl.jav >>> a:39) >>> at >>> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho >>dAccessor >>> 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(TCPTra >>nsport.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.getConn >>ection(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.m >>anagedCon >>> nectionReconnected(LocalTxConnectionManager.java:260) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2.all >>ocateConn >>> ection(BaseConnectionManager2.java:534) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2$Con >>nectionMa >>> 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.getConn >>ection(Un >>> known Source) >>> at >>> >>org.apache.ojb.broker.accesslayer.StatementManager.getPreparedS >>tatement( >>> 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.createRsIterat >>or(Unknow >>> n Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorF >>romQuery( >>> Unknown Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFro >>mQuery(Un >>> known Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQ >>uery(Unkn >>> own Source) >>> at >>> >>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getItera >>torByQuer >>> y(Unknown Source) >>> at >>> >>org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOu >>tLocks(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.releaseLoc >k(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(TxInterce >>ptorCMT.j >>> ava:365) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIn >>terceptor >>> CMT.java:247) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT >.java:98) >>> at >>> >>org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterc >>eptor.jav >>> a:130) >>> at >>> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) >>> at >>> >>org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSession >>Container >>> .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(NativeMethodAccesso >>rImpl.jav >>> a:39) >>> at >>> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho >>dAccessor >>> 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(TCPTra >>nsport.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.m >>anagedCon >>> nectionReconnected(LocalTxConnectionManager.java:260) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2.all >>ocateConn >>> ection(BaseConnectionManager2.java:534) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2$Con >>nectionMa >>> 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.getConn >>ection(Un >>> known Source) >>> at >>> >>org.apache.ojb.broker.accesslayer.StatementManager.getPreparedS >>tatement( >>> 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.createRsIterat >>or(Unknow >>> n Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorF >>romQuery( >>> Unknown Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFro >>mQuery(Un >>> known Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQ >>uery(Unkn >>> own Source) >>> at >>> >>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getItera >>torByQuer >>> y(Unknown Source) >>> at >>> >>org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOu >>tLocks(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.releaseLoc >k(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(TxInterce >>ptorCMT.j >>> ava:365) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIn >>terceptor >>> CMT.java:247) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT >.java:98) >>> at >>> >>org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterc >>eptor.jav >>> a:130) >>> at >>> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) >>> at >>> >>org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSession >>Container >>> .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(NativeMethodAccesso >>rImpl.jav >>> a:39) >>> at >>> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho >>dAccessor >>> 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(TCPTra >>nsport.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.m >>anagedCon >>> nectionReconnected(LocalTxConnectionManager.java:260) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2.all >>ocateConn >>> ection(BaseConnectionManager2.java:534) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2$Con >>nectionMa >>> 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.getPreparedS >>tatement( >>> 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.createRsIterat >>or(Unknow >>> n Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorF >>romQuery( >>> Unknown Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFro >>mQuery(Un >>> known Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQ >>uery(Unkn >>> own Source) >>> at >>> >>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getItera >>torByQuer >>> y(Unknown Source) >>> at >>> >>org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOu >>tLocks(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.releaseLoc >k(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(TxInterce >>ptorCMT.j >>> ava:365) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIn >>terceptor >>> CMT.java:247) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT >.java:98) >>> at >>> >>org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterc >>eptor.jav >>> a:130) >>> at >>> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) >>> at >>> >>org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSession >>Container >>> .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(NativeMethodAccesso >>rImpl.jav >>> a:39) >>> at >>> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho >>dAccessor >>> 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(TCPTra >>nsport.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.getConn >>ection(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.m >>anagedCon >>> nectionReconnected(LocalTxConnectionManager.java:260) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2.all >>ocateConn >>> ection(BaseConnectionManager2.java:534) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2$Con >>nectionMa >>> 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(TxInterce >>ptorCMT.j >>> ava:365) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIn >>terceptor >>> CMT.java:247) >>> at >>> >>org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT >.java:98) >>> at >>> >>org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterc >>eptor.jav >>> a:130) >>> at >>> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) >>> at >>> >>org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSession >>Container >>> .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(NativeMethodAccesso >>rImpl.jav >>> a:39) >>> at >>> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho >>dAccessor >>> 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(TCPTra >>nsport.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.getPreparedS >>tatement( >>> 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.createRsIterat >>or(Unknow >>> n Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorF >>romQuery( >>> Unknown Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFro >>mQuery(Un >>> known Source) >>> at >>> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQ >>uery(Unkn >>> own Source) >>> at >>> >>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getItera >>torByQuer >>> y(Unknown Source) >>> at >>> >>org.apache.ojb.odmg.locking.PersistentLockMapImpl.removeTimedOu >>tLocks(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.releaseLoc >k(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.getConn >>ection(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.m >>anagedCon >>> nectionReconnected(LocalTxConnectionManager.java:260) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2.all >>ocateConn >>> ection(BaseConnectionManager2.java:534) >>> at >>> >>org.jboss.resource.connectionmanager.BaseConnectionManager2$Con >>nectionMa >>> 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] >> >> > > >--------------------------------------------------------------------- >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]
