Hi all, I have a stateless session bean (name: Registrar) that is responsible for creating a CM entity bean A which in turn will create CM entity beans B, C & D if they don't exist, update them if they do (all this is done in the A's ejbStore() method). I think I must not be seeing something obvious... the transaction attribute for all entity bean methods is set to required. Included below are the relevant stack traces from the server.log file. Does anyone know what is going on? Thanks in advance for your time. Buzz [JAWS] java.sql.SQLException: ORA-02049: timeout: distributed transaction waiting for lock [JAWS] [JAWS] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) [JAWS] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) [JAWS] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) [JAWS] at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405) [JAWS] at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822) [JAWS] at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446 ) [JAWS] at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371) [JAWS] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java :1900) [JAWS] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState ment.java:363) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCUpdateCommand.executeStatementAndHandleR esult(JDBCUpdateCommand.java:54) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:158 ) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEn tityCommand.java:135) [JAWS] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPersisten ceManager.java:122) [JAWS] at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManag er.java:156) [JAWS] at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:441) [JAWS] at java.lang.reflect.Method.invoke(Native Method) [JAWS] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContaine r.java:639) [JAWS] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySync hronizationInterceptor.java:160) [JAWS] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInt erceptor.java:86) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT. java:263) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86) [JAWS] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.jav a:126) [JAWS] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106) [JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316) [JAWS] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContai nerInvoker.java:200) [JAWS] at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:198) [JAWS] at $Proxy10.create(Unknown Source) [JAWS] at jbuzz.jbuzzFoundation.ejb.elements.PersonBean.ejbStore(PersonBean.java:127) [JAWS] at java.lang.reflect.Method.invoke(Native Method) [JAWS] at org.jboss.ejb.plugins.CMPPersistenceManager.storeEntity(CMPPersistenceManage r.java:313) [JAWS] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor$InstanceSynchronizati on.beforeCompletion(EntitySynchronizationInterceptor.java:343) [JAWS] at org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1104) [JAWS] at org.jboss.tm.TxCapsule.commit(TxCapsule.java:278) [JAWS] at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:76) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT. java:318) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99) [JAWS] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:14 4) [JAWS] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192) [JAWS] at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.jav a:271) [JAWS] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerI nvoker.java:163) [JAWS] at java.lang.reflect.Method.invoke(Native Method) [JAWS] at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source) [JAWS] at sun.rmi.transport.Transport$1.run(Unknown Source) [JAWS] at java.security.AccessController.doPrivileged(Native Method) [JAWS] at sun.rmi.transport.Transport.serviceCall(Unknown Source) [JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source) [JAWS] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source) [JAWS] at java.lang.Thread.run(Unknown Source) [JAWS] java.sql.SQLException: ORA-02049: timeout: distributed transaction waiting for lock [JAWS] [JAWS] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) [JAWS] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) [JAWS] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) [JAWS] at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405) [JAWS] at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822) [JAWS] at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446 ) [JAWS] at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371) [JAWS] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java :1900) [JAWS] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState ment.java:363) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCUpdateCommand.executeStatementAndHandleR esult(JDBCUpdateCommand.java:54) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:158 ) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEn tityCommand.java:135) [JAWS] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPersisten ceManager.java:122) [JAWS] at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManag er.java:156) [JAWS] at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:441) [JAWS] at java.lang.reflect.Method.invoke(Native Method) [JAWS] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContaine r.java:639) [JAWS] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySync hronizationInterceptor.java:160) [JAWS] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInt erceptor.java:86) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT. java:263) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86) [JAWS] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.jav a:126) [JAWS] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106) [JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316) [JAWS] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContai nerInvoker.java:200) [JAWS] at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:198) [JAWS] at $Proxy10.create(Unknown Source) [JAWS] at jbuzz.jbuzzFoundation.ejb.elements.PersonBean.ejbStore(PersonBean.java:127) [JAWS] at java.lang.reflect.Method.invoke(Native Method) [JAWS] at org.jboss.ejb.plugins.CMPPersistenceManager.storeEntity(CMPPersistenceManage r.java:313) [JAWS] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor$InstanceSynchronizati on.beforeCompletion(EntitySynchronizationInterceptor.java:343) [JAWS] at org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1104) [JAWS] at org.jboss.tm.TxCapsule.commit(TxCapsule.java:278) [JAWS] at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:76) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT. java:318) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99) [JAWS] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:14 4) [JAWS] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192) [JAWS] at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.jav a:271) [JAWS] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerI nvoker.java:163) [JAWS] at java.lang.reflect.Method.invoke(Native Method) [JAWS] at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source) [JAWS] at sun.rmi.transport.Transport$1.run(Unknown Source) [JAWS] at java.security.AccessController.doPrivileged(Native Method) [JAWS] at sun.rmi.transport.Transport.serviceCall(Unknown Source) [JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source) [JAWS] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source) [JAWS] at java.lang.Thread.run(Unknown Source) [Registrar] javax.ejb.CreateException: Could not create entity:java.sql.SQLException: ORA-02049: timeout: distributed transaction waiting for lock [Registrar] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEn tityCommand.java:139) [Registrar] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPersisten ceManager.java:122) [Registrar] at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManag er.java:156) [Registrar] at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:441) [Registrar] at java.lang.reflect.Method.invoke(Native Method) [Registrar] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContaine r.java:639) [Registrar] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySync hronizationInterceptor.java:160) [Registrar] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInt erceptor.java:86) [Registrar] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135) [Registrar] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT. java:263) [Registrar] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86) [Registrar] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.jav a:126) [Registrar] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106) [Registrar] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316) [Registrar] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContai nerInvoker.java:200) [Registrar] at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:198) [Registrar] at $Proxy10.create(Unknown Source) [Registrar] at jbuzz.jbuzzFoundation.ejb.elements.PersonBean.ejbStore(PersonBean.java:127) [Registrar] at java.lang.reflect.Method.invoke(Native Method) [Registrar] at org.jboss.ejb.plugins.CMPPersistenceManager.storeEntity(CMPPersistenceManage r.java:313) [Registrar] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor$InstanceSynchronizati on.beforeCompletion(EntitySynchronizationInterceptor.java:343) [Registrar] at org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1104) [Registrar] at org.jboss.tm.TxCapsule.commit(TxCapsule.java:278) [Registrar] at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:76) [Registrar] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT. java:318) [Registrar] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99) [Registrar] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:14 4) [Registrar] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192) [Registrar] at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.jav a:271) [Registrar] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerI nvoker.java:163) [Registrar] at java.lang.reflect.Method.invoke(Native Method) [Registrar] at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source) [Registrar] at sun.rmi.transport.Transport$1.run(Unknown Source) [Registrar] at java.security.AccessController.doPrivileged(Native Method) [Registrar] at sun.rmi.transport.Transport.serviceCall(Unknown Source) [Registrar] at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source) [Registrar] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source) [Registrar] at java.lang.Thread.run(Unknown Source) -- -------------------------------------------------------------- To subscribe: [EMAIL PROTECTED] To unsubscribe: [EMAIL PROTECTED] Problems?: [EMAIL PROTECTED]
