I am having the same problem
| 2004.07.16 08:58:30.609 EDT INFO [STDOUT] org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=DBOON1//197, BranchQual=] status=STATUS_NO_TRANSACTION; - nested throwable: (javax.ejb.EJBException: Update failed. Expected one affected row: [EMAIL PROTECTED],childProductId=9388,startDate=2004-07-16 12:58:30.546) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:413) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at org.jboss.tm.TxManager.commit(TxManager.java:141) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:126) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at com.isopia.ilms.ui.common.UserTX.commitTX(UserTX.java:76) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at com.isopia.ilms.ui.msi.PackageJB.processForm(PackageJB.java:945) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at org.apache.jsp.msi.pp.package_005fcreate_jsp._jspService(package_005fcreate_jsp.java:198) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at com.elementk.util.RequestTimingFilter.doFilter(RequestTimingFilter.java:49) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at com.elementk.security.servlet.LmnkSecurityFilter.doFilter(LmnkSecurityFilter.java:110) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) | 2004.07.16 08:58:30.609 EDT INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245) | 2004.07.16 08:58:30.625 EDT INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199) | 2004.07.16 08:58:30.625 EDT INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) | 2004.07.16 08:58:30.625 EDT INFO [STDOUT] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:509) | 2004.07.16 08:58:30.625 EDT INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) | 2004.07.16 08:58:30.625 EDT INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) | 2004.07.16 08:58:30.703 EDT INFO [STDOUT] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:195) | 2004.07.16 08:58:30.703 EDT INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) | 2004.07.16 08:58:30.703 EDT INFO [STDOUT] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164) | 2004.07.16 08:58:30.703 EDT INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) | 2004.07.16 08:58:30.703 EDT INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) | 2004.07.16 08:58:30.703 EDT INFO [STDOUT] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156) | 2004.07.16 08:58:30.703 EDT INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) | 2004.07.16 08:58:30.703 EDT INFO [STDOUT] at com.elementk.util.valve.RequestCollectorValve.invoke(RequestCollectorValve.java:96) | 2004.07.16 08:58:30.796 EDT INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) | 2004.07.16 08:58:30.796 EDT INFO [STDOUT] at com.elementk.util.valve.RequestEncodingValve.invoke(RequestEncodingValve.java:73) | 2004.07.16 08:58:30.796 EDT INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) | 2004.07.16 08:58:30.796 EDT INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564) | 2004.07.16 08:58:30.796 EDT INFO [STDOUT] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972) | 2004.07.16 08:58:30.796 EDT INFO [STDOUT] at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:211) | 2004.07.16 08:58:30.796 EDT INFO [STDOUT] at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:309) | 2004.07.16 08:58:30.796 EDT INFO [STDOUT] at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:387) | 2004.07.16 08:58:30.921 EDT INFO [STDOUT] at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:673) | 2004.07.16 08:58:30.921 EDT INFO [STDOUT] at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:615) | 2004.07.16 08:58:30.921 EDT INFO [STDOUT] at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:786) | 2004.07.16 08:58:30.921 EDT INFO [STDOUT] at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677) | 2004.07.16 08:58:30.921 EDT INFO [STDOUT] at java.lang.Thread.run(Thread.java:534) | 2004.07.16 08:58:30.921 EDT INFO [STDOUT] Caused by: javax.ejb.EJBException: Update failed. Expected one affected row: [EMAIL PROTECTED],childProductId=9388,startDate=2004-07-16 12:58:30.546 | 2004.07.16 08:58:30.921 EDT INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.execute(JDBCStoreEntityCommand.java:155) | 2004.07.16 08:58:31.156 EDT INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.storeEntity(JDBCStoreManager.java:627) | 2004.07.16 08:58:31.156 EDT INFO [STDOUT] at org.jboss.ejb.plugins.CMPPersistenceManager.storeEntity(CMPPersistenceManager.java:421) | 2004.07.16 08:58:31.156 EDT INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.storeEntity(CachedConnectionInterceptor.java:387) | 2004.07.16 08:58:31.156 EDT INFO [STDOUT] at org.jboss.ejb.EntityContainer.storeEntity(EntityContainer.java:714) | 2004.07.16 08:58:31.156 EDT INFO [STDOUT] at org.jboss.ejb.GlobalTxEntityMap.synchronizeEntities(GlobalTxEntityMap.java:149) | 2004.07.16 08:58:31.156 EDT INFO [STDOUT] at org.jboss.ejb.GlobalTxEntityMap$GlobalTxEntityMapSynchronize.beforeCompletion(GlobalTxEntityMap.java:215) | 2004.07.16 08:58:31.156 EDT INFO [STDOUT] at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1308) | 2004.07.16 08:58:31.156 EDT INFO [STDOUT] at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:347) | 2004.07.16 08:58:31.343 EDT INFO [STDOUT] ... 49 more | | I have made the change you suggested, with using NoLock and <optimistic-locking/> in our jbosscmp-jdbc.xml. However we are still getting the same error. This situation seems unique in that the transaction iis a UserTransaction. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3842387#3842387 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3842387 ------------------------------------------------------- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user