[ https://issues.apache.org/jira/browse/OPENJPA-941?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12676602#action_12676602 ]
Milosz Tylenda commented on OPENJPA-941: ---------------------------------------- Joachim, Probably the same problem has been recently reported and resolved on the OpenJPA Users mailing list [1]. Quote from there: "When using a managed DataSource, you should also configure a second unmanaged DataSource that OpenJPA can use to perform tasks that are independent of the global transaction. The most common of these tasks is updating the sequence table OpenJPA uses to generate unique primary key values for your datastore identity objects." [1] http://n2.nabble.com/%40Id%2C-%40TableGenerator---Id-creation-fails-when-using-a-connection-pool-(inside-Geronimo-2.1.3)-tc2373340.html > Unable to write data into table > ------------------------------- > > Key: OPENJPA-941 > URL: https://issues.apache.org/jira/browse/OPENJPA-941 > Project: OpenJPA > Issue Type: Bug > Environment: z/OS > Reporter: Joachim Stein > > My Application is running on WAS 6.1.0.18 which runs on a z/OS system. I'm > working with EJB 3.0. I can read data from database but everytime i call > persist() to insert a row into the table i get the following error message: > ExtendedMessage: BBOO0220E: WTRN0074E: Exception caught from > before_completion synchronization operation: <openjpa-1.0.1-r420667:592145 > nonfatal general error> org.apache.openjpa.persistence.PersistenceException: > null > at > org.apache.openjpa.jdbc.kernel.AbstractJDBCSeq.getConnection(AbstractJDBCSeq.java:162) > > at > org.apache.openjpa.jdbc.kernel.TableJDBCSeq.allocateSequence(TableJDBCSeq.java:366) > > at > org.apache.openjpa.jdbc.kernel.TableJDBCSeq.nextInternal(TableJDBCSeq.java:266) > > at > org.apache.openjpa.jdbc.kernel.AbstractJDBCSeq.next(AbstractJDBCSeq.java:60) > > at org.apache.openjpa.util.ImplHelper.generateValue(ImplHelper.java:160) > > at > org.apache.openjpa.util.ImplHelper.generateFieldValue(ImplHelper.java:144) > > at > org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignField(JDBCStoreManager.java:557) > > at org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:450) > > at org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:426) > > at > org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignObjectId(JDBCStoreManager.java:541) > > at > org.apache.openjpa.kernel.DelegatingStoreManager.assignObjectId(DelegatingStoreManager.java:134) > > at > org.apache.openjpa.kernel.StateManagerImpl.assignObjectId(StateManagerImpl.java:501) > > at > org.apache.openjpa.kernel.StateManagerImpl.preFlush(StateManagerImpl.java:2770) > > at org.apache.openjpa.kernel.PNewState.beforeFlush(PNewState.java:39) > > at > org.apache.openjpa.kernel.StateManagerImpl.beforeFlush(StateManagerImpl.java:940) > > at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1892) > > at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1852) > > at > org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1770) > > at > com.ibm.ws.uow.ComponentContextSynchronizationWrapper.beforeCompletion(ComponentContextSynchronizationWrapper.java:66) > at > com.ibm.ws.Transaction.JTA.RegisteredSyncs.distributeBefore(RegisteredSyncs.java:242) > > at > com.ibm.ws.Transaction.JTA.TransactionImpl.prePrepare(TransactionImpl.java:2404) > > at > com.ibm.ws.Transaction.JTA.TransactionImpl.stage1CommitProcessing(TransactionImpl.java:1637) > > at > com.ibm.ws.Transaction.JTA.TransactionImpl.processCommit(TransactionImpl.java:1608) > > at > com.ibm.ws.Transaction.JTA.TransactionImpl.commit(TransactionImpl.java:1543) > > at > com.ibm.ws.Transaction.JTA.TranManagerImpl.commit(TranManagerImpl.java:240) > > at com.ibm.ws.Transaction.JTA.TranManagerSet.commit(TranManagerSet.java:164) > > at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:782) > > at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java:206) > > at com.ibm.ejs.csi.RequiresNew.postInvoke(RequiresNew.java:93) > > at > com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:581) > > at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:4311) > > at > interfaces.EJSLocal0SLOmegamonMasterManagerImpl_22398363.createOmegamonMaster(EJSLocal0SLOmegamonMasterManagerImpl_22398363.java > ) > > at management.SstDbManagerImpl.createServer(SstDbManagerImpl.java:109) > > at > interfaces.EJSRemote0SLSstDbManagerImpl_9a8f969a.createServer(EJSRemote0SLSstDbManagerImpl_9a8f969a.java) > > at interfaces._SstDbManager_Stub.createServer(_SstDbManager_Stub.java) > > at com.ibm.db2pm.sst.SstController.doGet(SstController.java:435) > > at com.ibm.db2pm.sst.SstController.doPost(SstController.java:653) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:763) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) > > at > com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1076) > > at > com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:550) > > at > com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:486) > > at > com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90) > at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:744) > > at > com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1455) > > at > com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:115) > > at > com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458) > > at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInf > > furthermore: > Message: BBOO0220E: SRVE0068E: Uncaught exception thrown in one of the > service methods of the servlet: SstController. Exception thrown : > javax.ejb.EJBTransactionRolledbackException: > > at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:795) > at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java:206) > > at > com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:581) > > at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:4311) > > at > interfaces.EJSRemote0SLSstDbManagerImpl_9a8f969a.createServer(EJSRemote0SLSstDbManagerImpl_9a8f969a.java) > at interfaces._SstDbManager_Stub.createServer(_SstDbManager_Stub.java) > > at com.ibm.db2pm.sst.SstController.doGet(SstController.java:436) > > at com.ibm.db2pm.sst.SstController.doPost(SstController.java:654) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:763) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) > > at > com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1076) > > at > com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:550) > > at > com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:486) > > at > com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90) > > at > com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:744) > > at > com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1455) > > at > com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:115) > > at > com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458) > > at > com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387) > > at > com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:267) > > at com.ibm.ws390.channel.xmem.XMemConnLink.ready(XMemConnLink.java:762) > > at > com.ibm.ws390.xmem.XMemSRBridgeImpl.httpinvoke(XMemSRBridgeImpl.java:230) > > at > com.ibm.ws390.xmem.XMemSRCppUtilities.httpinvoke(XMemSRCppUtilities.java:74) > > at com.ibm.ws390.orb.ServerRegionBridge.httpinvoke(Unknown Source) > > at com.ibm.ws390.orb.ORBEJSBridge.httpinvoke(Unknown Source) > > at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source) > > > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:618) > > at > com.ibm.ws390.orb.parameters.HTTPInvoke.HTTPInvokeParmSetter(HTTPInvoke.java:105) > > at com.ibm.ws390.orb.CommonBridge.nativeRunApplicationThread(Native Method) > > at com.ibm.ws390.orb.CommonBridge.runApplicationThread(Unknown Source) > > at com.ibm.ws.util.ThreadPool$ZOSWorker.run(ThreadPool.java:1670) > > com.ibm.ws.webcontainer.servlet.ServletWrapper > com.ibm.ws.webcontainer.servlet.ServletWrapper > What do you think does this exactly means? I've tried to fix the problem > after looking similarly problems in the internet but nothing helps. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.