You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Milosz Tylenda (JIRA)" <ji...@apache.org> on 2009/02/25 11:32:02 UTC

[jira] Commented: (OPENJPA-941) Unable to write data into table

    [ 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.