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.releaseLock(Unknown
>> Source)
>> at
>>
>org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown
>Source)
>> at
>> org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416)
>> at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368)
>> at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73)
>> at
>>
>org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(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.releaseLock(Unknown
>> Source)
>> at
>>
>org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown
>Source)
>> at
>> org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416)
>> at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368)
>> at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73)
>> at
>>
>org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(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.releaseLock(Unknown
>> Source)
>> at
>>
>org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown
>Source)
>> at
>> org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416)
>> at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368)
>> at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73)
>> at
>>
>org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(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.releaseLock(Unknown
>> Source)
>> at
>>
>org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown
>Source)
>> at
>> org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416)
>> at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368)
>> at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73)
>> at
>>
>org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(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.releaseLock(Unknown
>> Source)
>> at
>>
>org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown
>Source)
>> at
>> org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416)
>> at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368)
>> at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73)
>> at
>>
>org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(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.releaseLock(Unknown
>> Source)
>> at
>>
>org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown
>Source)
>> at
>> org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416)
>> at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368)
>> at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73)
>> at
>>
>org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(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.releaseLock(Unknown
>> Source)
>> at
>>
>org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown
>Source)
>> at
>> org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416)
>> at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368)
>> at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73)
>> at
>>
>org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(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.releaseLock(Unknown
>> Source)
>> at
>>
>org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown
>Source)
>> at
>> org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416)
>> at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368)
>> at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73)
>> at
>>
>org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(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.releaseLock(Unknown
>> Source)
>> at
>>
>org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown
>Source)
>> at
>> org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416)
>> at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368)
>> at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73)
>> at
>>
>org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(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.releaseLock(Unknown
>> Source)
>> at
>>
>org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown
>Source)
>> at
>> org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416)
>> at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368)
>> at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73)
>> at
>>
>org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(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.releaseLock(Unknown
>> Source)
>> at
>>
>org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown
>Source)
>> at
>> org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416)
>> at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368)
>> at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73)
>> at
>>
>org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(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.releaseLock(Unknown
>> Source)
>> at
>>
>org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.abort(Unknown Source) at
>> org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown
>Source)
>> at
>> org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416)
>> at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368)
>> at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:73)
>> at
>>
>org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(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.releaseLock(Unknown
>> Source)
>> at
>>
>org.apache.ojb.odmg.locking.LockManagerDefaultImpl.releaseLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.removeLock(Unknown
>> Source)
>> at org.apache.ojb.odmg.TransactionImpl.doClose(Unknown
>Source) ... 25
>> more Caused by: org.apache.ojb.broker.accesslayer.LookupException:
>> SQLException thrown while trying to get Connection from Datasource
>> (java:MySqlDSSYWEB): Could not enlist in transaction on entering
>> meta-aware object!javax.transaction.SystemException: Could not enlist
>> XAResource!javax.transaction.RollbackException: Already marked for
>> rollback; - nested throwable:
>(javax.resource.ResourceException: Could
>> not enlist in transaction on entering meta-aware
>> object!javax.transaction.SystemException: Could not enlist
>> XAResource!javax.transaction.RollbackException: Already marked for
>> rollback)
>> at
>>
>org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl
>.newConne
>> ctionFromDataSource(Unknown Source)
>> at
>>
>org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl
>.lookupCo
>> nnection(Unknown Source)
>> at
>>
>org.apache.ojb.broker.accesslayer.ConnectionFactoryManagedImpl.
>lookupCon
>> nection(Unknown Source)
>> at
>>
>org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.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]