-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 4 posts ] 
Author Message
 Post subject: Hibernate-Websphere - Every Second transaction fails. Clues?
PostPosted: Thu Dec 08, 2005 5:22 pm 
Beginner
Beginner

Joined: Thu Dec 01, 2005 7:07 pm
Posts: 21
Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.0

Mapping documents:<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration SYSTEM "hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="connection.datasource">PensionConnection</property>
<property name="show_sql">true</property>
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="hibernate.query.factory_class">org.hibernate.hql.ast.ASTQueryTranslatorFactory</property>
<property name="transaction.factory_class">org.hibernate.transaction.CMTTransactionFactory</property>
<property name="transaction.manager_lookup_class">org.hibernate.transaction.WebSphereExtendedJTATransactionLookup</property>
<property name="hibernate.transaction.flush_before_completion">true</property>
<property name="hibernate.transaction.auto_close_session">true</property>
<property name="hibernate.generate_statistics">true</property>
<mapping resource="./com/co/pensions/common/properties/table2.hbm.xml"/>
<mapping resource="./com/co/coreafp/pensions/common/properties/table1.hbm.xml"/>
</session-factory>
</hibernate-configuration> <br> <br> Table2.hbm.xml:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping SYSTEM "hibernate-mapping-3.0.dtd" >
<hibernate-mapping>
<class name="com.co.coreafp.pensions.common.beans.NormalRetirementPensionRequests" table="t_pension_requests">
<id name="pensionRequestsHid" column="pension_requests_hid" type="int">
<generator class="sequence">
<param name="sequence">s_pension_requests</param>
</generator>
</id>
<property name="affiliateRUT" column="AFFILIATE_RUT" type="java.lang.String" />
<property name="pensionReqId" column="PENSION_REQUEST_ID" type="java.lang.String" />
</class>
</hibernate-mapping>

Code between sessionFactory.openSession() and session.close():
session.save(aObjNormalPensionRequests);
Full stack trace of any exception that occurs:
[12/8/05 18:00:07:147 VET] 0000003b RegisteredSyn E WTRN0074E: Exception caught from before_completion synchronization operation: java.lang.NullPointerException
at oracle.jdbc.dbaccess.DBData.clearItem(DBData.java:431)
at oracle.jdbc.dbaccess.DBDataSetImpl.clearItem(DBDataSetImpl.java:3528)
at oracle.jdbc.driver.OraclePreparedStatement.clearParameters(OraclePreparedStatement.java:3401)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.resetStatement(WSJdbcConnection.java:2179)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1830)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1782)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:396)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:76)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:69)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:150)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1839)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:324)
at org.hibernate.transaction.CacheSynchronization.beforeCompletion(CacheSynchronization.java:58)
at org.hibernate.transaction.WebSphereExtendedJTATransactionLookup$1.invoke(WebSphereExtendedJTATransactionLookup.java:134)
at $Proxy0.beforeCompletion(Unknown Source)
at com.ibm.ws.jtaextensions.SynchronizationCallbackWrapper.beforeCompletion(SynchronizationCallbackWrapper.java:65)
at com.ibm.ws.Transaction.JTA.RegisteredSyncs.distributeBefore(RegisteredSyncs.java:171)
at com.ibm.ws.Transaction.JTA.TransactionImpl.prePrepare(TransactionImpl.java:2109)
at com.ibm.ws.Transaction.JTA.TransactionImpl.stage1CommitProcessing(TransactionImpl.java:1538)
at com.ibm.ws.Transaction.JTA.TransactionImpl.commit(TransactionImpl.java:1372)
at com.ibm.ws.Transaction.JTA.TranManagerImpl.commit(TranManagerImpl.java:231)
at com.ibm.ws.Transaction.JTA.TranManagerSet.commit(TranManagerSet.java:156)
at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:716)
at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java:167)
at com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:564)
at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:3798)
at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:3620)
at com.co.coreafp.pensions.requests.ejb.EJSRemoteStatelessNormalRetirementPensionRequest_c1aead01.addUpdateNormalPensionRequestDetails(EJSRemoteStatelessNormalRetirementPensionRequest_c1aead01.java:94)
at com.co.coreafp.pensions.requests.ejb._NormalRetirementPensionRequest_Stub.addUpdateNormalPensionRequestDetails(_NormalRetirementPensionRequest_Stub.java:264)
at com.co.pensionrequestnewweb.actions.PensionRequestAction.savePensionRequestDetails(PensionRequestAction.java:50)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
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:1212)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:629)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:80)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1657)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:201)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:103)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:548)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:601)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:934)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1021)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1332)

[12/8/05 18:00:07:569 VET] 0000003b ServletWrappe E SRVE0068E: Could not invoke the service() method on servlet action. Exception thrown : java.lang.NullPointerException
at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:441)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
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:1212)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:629)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:80)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1657)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:201)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:103)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:548)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:601)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:934)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1021)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1332)

[12/8/05 18:00:07:694 VET] 0000003b LocalTranCoor E WLTC0017E: Resources rolled back due to setRollbackOnly() being called.
[12/8/05 18:00:07:710 VET] 0000003b WebApp E SRVE0026E: [Servlet Error]-[action]: java.lang.NullPointerException
at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:441)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
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:1212)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:629)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:80)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1657)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:201)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:103)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:548)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:601)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:934)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1021)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1332)

[12/8/05 18:00:07:538 VET] 0000003b SystemErr R javax.transaction.TransactionRolledbackException: CORBA TRANSACTION_ROLLEDBACK 0x0 No; nested exception is:
org.omg.CORBA.TRANSACTION_ROLLEDBACK: javax.transaction.TransactionRolledbackException: ; nested exception is:
com.ibm.websphere.csi.CSITransactionRolledbackException: vmcid: 0x0 minor code: 0 completed: No
at com.ibm.CORBA.iiop.UtilDelegateImpl.mapSystemException(UtilDelegateImpl.java:214)
at com.ibm.CORBA.iiop.UtilDelegateImpl.wrapException(UtilDelegateImpl.java:684)
at javax.rmi.CORBA.Util.wrapException(Util.java:296)
at com.co.coreafp.pensions.requests.ejb._NormalRetirementPensionRequest_Stub.addUpdateNormalPensionRequestDetails(_NormalRetirementPensionRequest_Stub.java:271)
at com.co.pensionrequestnewweb.actions.PensionRequestAction.savePensionRequestDetails(PensionRequestAction.java:50)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
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:1212)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:629)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:80)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1657)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:201)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:103)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:548)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:601)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:934)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1021)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1332)
Caused by: org.omg.CORBA.TRANSACTION_ROLLEDBACK: javax.transaction.TransactionRolledbackException: ; nested exception is:
com.ibm.websphere.csi.CSITransactionRolledbackException: vmcid: 0x0 minor code: 0 completed: No
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:80)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java(Compiled Code))
at java.lang.reflect.Constructor.newInstance(Constructor.java(Compiled Code))
at com.ibm.rmi.util.ProxyUtil.copyObject(ProxyUtil.java:341)
at com.ibm.CORBA.iiop.UtilDelegateImpl.copyObject(UtilDelegateImpl.java:789)
at javax.rmi.CORBA.Util.copyObject(Util.java:333)
at com.co.coreafp.pensions.requests.ejb._NormalRetirementPensionRequest_Stub.addUpdateNormalPensionRequestDetails(_NormalRetirementPensionRequest_Stub.java:267)
... 29 more

[12/8/05 18:00:07:538 VET] 0000003b SystemErr R at com.ibm.CORBA.iiop.UtilDelegateImpl.mapSystemException(UtilDelegateImpl.java:214)
[12/8/05 18:00:07:538 VET] 0000003b SystemErr R at com.ibm.CORBA.iiop.UtilDelegateImpl.wrapException(UtilDelegateImpl.java:684)
[12/8/05 18:00:07:538 VET] 0000003b SystemErr R at javax.rmi.CORBA.Util.wrapException(Util.java:296)
[12/8/05 18:00:07:538 VET] 0000003b SystemErr R at com.co.coreafp.pensions.requests.ejb._NormalRetirementPensionRequest_Stub.addUpdateNormalPensionRequestDetails(_NormalRetirementPensionRequest_Stub.java:271)
[12/8/05 18:00:07:538 VET] 0000003b SystemErr R at com.co.pensionrequestnewweb.actions.PensionRequestAction.savePensionRequestDetails(PensionRequestAction.java:50)
[12/8/05 18:00:07:538 VET] 0000003b SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[12/8/05 18:00:07:538 VET] 0000003b SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
[12/8/05 18:00:07:538 VET] 0000003b SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:629)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:80)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1657)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters(NewConnectionInitialReadCallback.java:201)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:103)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:548)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:601)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:934)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1021)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1332)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R Caused by: org.omg.CORBA.TRANSACTION_ROLLEDBACK: javax.transaction.TransactionRolledbackException: ; nested exception is:
com.ibm.websphere.csi.CSITransactionRolledbackException: vmcid: 0x0 minor code: 0 completed: No
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:80)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java(Compiled Code))
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at java.lang.reflect.Constructor.newInstance(Constructor.java(Compiled Code))
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at com.ibm.rmi.util.ProxyUtil.copyObject(ProxyUtil.java:341)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at com.ibm.CORBA.iiop.UtilDelegateImpl.copyObject(UtilDelegateImpl.java:789)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at javax.rmi.CORBA.Util.copyObject(Util.java:333)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R at com.co.coreafp.pensions.requests.ejb._NormalRetirementPensionRequest_Stub.addUpdateNormalPensionRequestDetails(_NormalRetirementPensionRequest_Stub.java:267)
[12/8/05 18:00:07:554 VET] 0000003b SystemErr R ... 29 more

Name and version of the database you are using:
Oracle 9i
The generated SQL (show_sql=true):
insert into t_pension_requests (AFFILIATE_RUT, AFFILIATE_CIVIL_STATUS, AFFILIATE_COUNTRY, AFFILIATE_HLTH_INST, AFFILIATE_SEX, AFFILIATE_NAME, AFFILIATE_DOB, AFF_WRK_PBLC_CO_IND, AGENCY, AMT_FRM_VOL_CNTR_TO_MNDTRY_IND, AMT_FRM_VOL_SVNG_TO_MNDTRY_IND, AMT_FRM_VOL_SVNG_ACC, AMT_FRM_VOL_CNTRB_ACC, DT_REQ_ACCEPTED, DT_REQ_RECD, AMT_ADJ_MIN_PENS_IND, CNTRB_OTHR_CNTRIES_IND, DEPST_OTHR_AFP_IND, PENS_CALC_LGL_RETR_AGE_IND, PENS_CALC_FRM_REQ_ACC_DT_IND, PRLM_PYMNT_REQ_IND, ELD_REQ_IND, RETRO_PYMNT_REQ_IND, VOL_SVNGS_OTHR_AFP_IND, PENS_CALC_INC_VOL_SVNG_IND, VOL_MNDTRY_REQ_IND, REQ_RCVD_MODE, REQ_ACCPT_DT, REQ_DT, REQ_STATUS, PENSION_REQUEST_ID, pension_requests_hid) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Debug level Hibernate log excerpt:

Using CMT transaction of Websphere. While inserting the record, i am getting the above error. table2.hbm.xml has been condensed. so, dont worry about the mismatch between the sql and the hbm. The curious part is that the INSERT works fine every second time. Any help??


Top
 Profile  
 
 Post subject: Same expirience
PostPosted: Fri Dec 16, 2005 5:14 am 
Newbie

Joined: Fri Dec 16, 2005 5:07 am
Posts: 6
i have same expirience. Websphere 5.1, hibernate 3.1
have you solved it ?!

<session-factory>

<!-- Data Source -->
<property name="connection.datasource">java:comp/env/jdbc/dzos</property>

<!-- Database Settings -->
<property name="default_schema">authadmin</property>
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="show_sql">true</property>

<!-- JDBC Settings -->
<property name="jdbc.use_streams_for_binary">true</property>
<property name="max_fetch_depth">1</property>

<!-- Cache settings -->
<property name="cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
<!-- Transaction API -->
<property name="transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property>
<property name="transaction.manager_lookup_class">org.hibernate.transaction.WebSphereTransactionManagerLookup</property>

<!-- Mapping files -->
<mapping resource="org/nazdar/dzos/sql/Apcdval.hbm.xml"/>

</session-factory>


Top
 Profile  
 
 Post subject:
PostPosted: Fri Dec 16, 2005 9:22 pm 
Beginner
Beginner

Joined: Thu Dec 01, 2005 7:07 pm
Posts: 21
All of a sudden this error vanished. Weird. Among few changes done, I remember this: setting the cachestatement size of websphere to 0. I guess it was in one of the suggestions on Gavin. However, currently I am facing that problem in a different machine and setting this to 0 does not help. Other things which were done include dropping and recreating the synonyms thru which the tables were accessed. I am not sure if that has any correlation


Top
 Profile  
 
 Post subject: solution
PostPosted: Tue Dec 20, 2005 10:00 am 
Newbie

Joined: Fri Dec 16, 2005 5:07 am
Posts: 6
check
http://forum.hibernate.org/viewtopic.php?t=938805

driver update solve the problem...:-)


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 4 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.