Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp



i am trying to perform some delete operation as follows.Actually it worked when i tried first .But now "Could not synchronize database state with session" ..this exception raising .I will give the code and exceptions below






private void deleteContact(CustomerContactDeleteForm customerContactDeleteForm,GDMSUserDTO roleUser)
{


Timestamp CurrentTS = new Timestamp(System.currentTimeMillis());
SessionFactory sf = null;
Session hibSession = null;
StringBuffer cusQuery=new StringBuffer();
StringBuffer cusQueryCmnt=new StringBuffer();
StringBuffer cusQueryChgLog=new StringBuffer();
StringBuffer cusQueryContDoc=new StringBuffer();
Long custContSkey=customerContactDeleteForm.getCustContSkey();
hibSession = HibernateUtil.getSessionFactory().openSession();
Transaction tx = hibSession.beginTransaction();

try {


List custContCmntList = new ArrayList();
System.out.println("here custContact2");
cusQueryCmnt.append("from fit.gdms.schemadao.CustContCmnt cmnt ");
cusQueryCmnt.append("where cmnt.customerContact.custContSkey ="+custContSkey);
custContCmntList = hibSession.createQuery(new String(cusQueryCmnt)).list();
System.out.println("here custContCmnt000"+custContCmntList);
if (custContCmntList.size()> 0)
{
CustContCmnt custContCmnt = (CustContCmnt)custContCmntList.get(0);
hibSession.delete(custContCmnt);
System.out.println("here custContCmnt");
}

List custCntChgLogList = new ArrayList();
cusQueryChgLog.append("from fit.gdms.schemadao.CustCntChgLog cccl ");
cusQueryChgLog.append("where cccl.customerContact.custContSkey ="+custContSkey);//:custContSkey");
custCntChgLogList = hibSession.createQuery(new String(cusQueryChgLog)).list();
System.out.println("here custCntChgLog0");
if (custCntChgLogList.size()> 0)
{
CustCntChgLog custCntChgLog = (CustCntChgLog)custCntChgLogList.get(0);
hibSession.delete(custCntChgLog);
System.out.println("here custCntChgLog");
}
List custContDocList = new ArrayList();
cusQueryContDoc.append("from fit.gdms.schemadao.CustContDoc ccd ");
cusQueryContDoc.append("where ccd.customerContact.custContSkey ="+custContSkey);//:custContSkey");
custContDocList = hibSession.createQuery(new String(cusQueryContDoc)).list();
if (custContDocList.size()> 0)
{

for(int i=0;i<custContDocList.size();i++)
{
CustContDoc custContDoc = (CustContDoc)custContDocList.get(i);
hibSession.delete(custContDoc);
hibSession.flush();
}

}

List custCont = new ArrayList();
cusQuery.append("from fit.gdms.schemadao.CustomerContact con ");
cusQuery.append("where con.custContSkey ="+custContSkey); //:custContSkey
custCont = hibSession.createQuery(new String(cusQuery)).list();

if (custCont.size()> 0)
{
CustomerContact custContact = (CustomerContact)custCont.get(0);
//hibSession.flush();
hibSession.delete(custContact);

}


CustomerComment custCmnt =new CustomerComment();
Customer customer=new Customer();
customer.setCustSkey(customerContactDeleteForm.getCustSkey());
custCmnt.setCustomer(customer);
custCmnt.setCmtLogText(customerContactDeleteForm.getCmtLogText());
custCmnt.setLastUpdId(roleUser.getUserCNUM());
custCmnt.setLastUpdTs(CurrentTS);
//hibSession.flush();
hibSession.save(custCmnt);
ChangeLogInsertion.log("CUSTOMER",customerContactDeleteForm.getCustSkey(),"Contact Deleted",customerContactDeleteForm.getCustContName(),"",roleUser.getUserCNUM(),hibSession);





tx.commit();
//hibSession.close();
}catch (HibernateException e) {

tx.rollback();
e.getStackTrace();
}catch (Exception e) {
e.printStackTrace();

} finally {

hibSession.close();
}
return;

}




Exceptions


36:12:515 IST] 0000002f SystemOut O Hibernate: select custcontdo0_.CUSTCDOC_SKEY as CUSTCDOC1_15_, custcontdo0_.CONT_DOC_CD as CONT2_15_, custcontdo0_.CUST_CONT_SKEY as CUST3_15_, custcontdo0_.LANGUAGE_CD as LANGUAGE4_15_, custcontdo0_.CONT_DOC_DESC as CONT5_15_, custcontdo0_.LAST_UPD_ID as LAST6_15_, custcontdo0_.LAST_UPD_TS as LAST7_15_ from GDMW.CUST_CONT_DOC custcontdo0_ where custcontdo0_.CUST_CONT_SKEY=3801
[12/18/06 18:36:12:546 IST] 0000002f SystemOut O Hibernate: delete from GDMW.CUST_CONT_CMNT where CUSTCCMNT_SKEY=?
[12/18/06 18:36:12:546 IST] 0000002f SystemOut O Hibernate: delete from GDMW.CUST_CNT_CHG_LOG where CUSTCCLOG_SKEY=?
[12/18/06 18:36:12:562 IST] 0000002f SystemOut O Hibernate: delete from GDMW.CUST_CONT_DOC where CUSTCDOC_SKEY=?
[12/18/06 18:36:12:578 IST] 0000002f SystemOut O Hibernate: select customerco0_.CUST_CONT_SKEY as CUST1_20_, customerco0_.CUST_SKEY as CUST2_20_, customerco0_.CONT_POS_CD as CONT3_20_, customerco0_.LANGUAGE_CD as LANGUAGE4_20_, customerco0_.CUST_CONT_NAME as CUST5_20_, customerco0_.IS_PRIM_CONT_CD as IS6_20_, customerco0_.CUST_CON_ADDR1 as CUST7_20_, customerco0_.CUST_CON_ADDR2 as CUST8_20_, customerco0_.CUST_CON_ADDR3 as CUST9_20_, customerco0_.CUST_CON_ADDR4 as CUST10_20_, customerco0_.CUST_CON_ADDR5 as CUST11_20_, customerco0_.CUST_CON_ADDR6 as CUST12_20_, customerco0_.CUST_CON_ADDR7 as CUST13_20_, customerco0_.CONT_PHONE_1 as CONT14_20_, customerco0_.CONT_PHONE_2 as CONT15_20_, customerco0_.CONT_FAX_1 as CONT16_20_, customerco0_.CONT_FAX_2 as CONT17_20_, customerco0_.CONT_DEPT as CONT18_20_, customerco0_.CONT_POS_DESC as CONT19_20_, customerco0_.CONT_EMAIL as CONT20_20_, customerco0_.LAST_UPD_ID as LAST21_20_, customerco0_.LAST_UPD_TS as LAST22_20_ from GDMW.CUSTOMER_CONTACT customerco0_ where customerco0_.CUST_CONT_SKEY=3801
[12/18/06 18:36:12:671 IST] 0000002f SystemOut O Hibernate: values nextval for GDMW.CUSTCMNTSEQ
[12/18/06 18:36:12:703 IST] 0000002f SystemOut O Hibernate: select customer_.CUST_SKEY, customer_.COUNTRY_CD as COUNTRY2_17_, customer_.ISU_CD as ISU3_17_, customer_.CURR_CD_PREF as CURR7_17_, customer_.SALES_REP as SALES8_17_, customer_.CUSTENT_SKEY as CUSTENT9_17_, customer_.LANGUAGE_CD as LANGUAGE10_17_, customer_.CUSTOMER_CD as CUSTOMER11_17_, customer_.INST_BRANCH_OFF as INST12_17_, customer_.SALES_TEAM as SALES13_17_, customer_.CUST_PHONE as CUST14_17_, customer_.CREDIT_CD as CREDIT15_17_, customer_.CURR_CD_PREF_CAE as CURR16_17_, customer_.COLL_UNIT_CAE_CD as COLL17_17_, customer_.FIRST_CONTACT as FIRST18_17_, customer_.PYMT_DAYS as PYMT19_17_, customer_.DEFER_PYMT_DAYS as DEFER20_17_, customer_.CUST_NAME as CUST21_17_, customer_.CUST_NAME_ENG as CUST22_17_, customer_.CUST_ADDR1 as CUST23_17_, customer_.CUST_ADDR2 as CUST24_17_, customer_.CUST_ADDR3 as CUST25_17_, customer_.CUST_ADDR4 as CUST26_17_, customer_.CUST_ADDR5 as CUST27_17_, customer_.CUST_ADDR6 as CUST28_17_, customer_.IS_PRIORITIZED as IS29_17_, customer_.CONT_MGR_CASE_ID as CONT30_17_, customer_.IS_DELETED as IS31_17_, customer_.LAST_UPD_ID as LAST32_17_, customer_.LAST_UPD_TS as LAST33_17_ from GDMW.CUSTOMER customer_ where customer_.CUST_SKEY=?
[12/18/06 18:36:12:734 IST] 0000002f SystemOut O Hibernate: values nextval for GDMW.CUSTCLOGSEQ
[12/18/06 18:36:12:765 IST] 0000002f SystemOut O Hibernate: insert into GDMW.CUSTOMER_COMMENT (CUST_SKEY, CMT_LOG_TEXT, LAST_UPD_ID, LAST_UPD_TS, CUSTCMNT_SKEY) values (?, ?, ?, ?, ?)
[12/18/06 18:36:12:781 IST] 0000002f SystemOut O Hibernate: insert into GDMW.CUSTOMER_CHG_LOG (CUST_SKEY, CHG_ITEM, OLD_CHG_VALUE, NEW_CHG_VALUE, LAST_UPD_ID, LAST_UPD_TS, CUSTCLOG_SKEY) values (?, ?, ?, ?, ?, ?, ?)
[12/18/06 18:36:12:781 IST] 0000002f SystemOut O Hibernate: delete from GDMW.CUSTOMER_CONTACT where CUST_CONT_SKEY=?
[12/18/06 18:36:12:812 IST] 0000002f JDBCException W SQL Error: -532, SQLState: 23001
[12/18/06 18:36:12:812 IST] 0000002f JDBCException E DB2 SQL error: SQLCODE: -532, SQLSTATE: 23001, SQLERRMC: GDMW.CUST_CONT_CMNT.FK_CCNTCMT_CCNT
[12/18/06 18:36:12:828 IST] 0000002f AbstractFlush E Could not synchronize database state with session
[12/18/06 18:36:12:906 IST] 0000002f AbstractFlush E TRAS0014I: The following exception was logged org.hibernate.exception.ConstraintViolationException: could not delete: [fit.gdms.schemadao.CustomerContact#3801]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2308)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2440)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:73)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:144)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:333)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at fit.gdms.process.DeleteCustomerContactProcess.deleteContact(DeleteCustomerContactProcess.java:229)
at fit.gdms.process.DeleteCustomerContactProcess.validate(DeleteCustomerContactProcess.java:129)
at fit.gdms.controller.CustomerContactDeleteAction.execute(CustomerContactDeleteAction.java:49)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.dolphin.webengine.lifecycle.plugins.ServletManagerPlugin.handleRequest(ServletManagerPlugin.java:112)
at com.ibm.dolphin.webengine.lifecycle.LifecycleManager.processLifecycleRequest(LifecycleManager.java:215)
at com.ibm.dolphin.webengine.servlet.DRLProxyServlet.service(DRLProxyServlet.java:91)
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.webapp.WebApp.handleRequest(WebApp.java:2837)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:220)
at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:204)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1681)
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.HttpICLReadCallback.complete(HttpICLReadCallback.java:94)
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: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -532, SQLSTATE: 23001, SQLERRMC: GDMW.CUST_CONT_CMNT.FK_CCNTCMT_CCNT
at com.ibm.db2.jcc.b.zc.d(zc.java:1351)
at com.ibm.db2.jcc.a.db.l(db.java:366)
at com.ibm.db2.jcc.a.db.a(db.java:64)
at com.ibm.db2.jcc.a.r.a(r.java:48)
at com.ibm.db2.jcc.a.tb.c(tb.java:266)
at com.ibm.db2.jcc.b.ad.Z(ad.java:1666)
at com.ibm.db2.jcc.b.ad.d(ad.java:2224)
at com.ibm.db2.jcc.b.ad.V(ad.java:521)
at com.ibm.db2.jcc.b.ad.executeUpdate(ad.java:504)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2291)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2440)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:73)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:144)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:333)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at fit.gdms.process.DeleteCustomerContactProcess.deleteContact(DeleteCustomerContactProcess.java:229)
at fit.gdms.process.DeleteCustomerContactProcess.validate(DeleteCustomerContactProcess.java:129)
at fit.gdms.controller.CustomerContactDeleteAction.execute(CustomerContactDeleteAction.java:49)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.dolphin.webengine.lifecycle.plugins.ServletManagerPlugin.handleRequest(ServletManagerPlugin.java:112)
at com.ibm.dolphin.webengine.lifecycle.LifecycleManager.processLifecycleRequest(LifecycleManager.java:215)
at com.ibm.dolphin.webengine.servlet.DRLProxyServlet.service(DRLProxyServlet.java:91)
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.webapp.WebApp.handleRequest(WebApp.java:2837)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:220)
at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:204)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1681)
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.HttpICLReadCallback.complete(HttpICLReadCallback.java:94)
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)
.
org.hibernate.exception.ConstraintViolationException: could not delete: [fit.gdms.schemadao.CustomerContact#3801]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2308)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2440)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:73)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:144)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:333)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at fit.gdms.process.DeleteCustomerContactProcess.deleteContact(DeleteCustomerContactProcess.java:229)
at fit.gdms.process.DeleteCustomerContactProcess.validate(DeleteCustomerContactProcess.java:129)
at fit.gdms.controller.CustomerContactDeleteAction.execute(CustomerContactDeleteAction.java:49)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.dolphin.webengine.lifecycle.plugins.ServletManagerPlugin.handleRequest(ServletManagerPlugin.java:112)
at com.ibm.dolphin.webengine.lifecycle.LifecycleManager.processLifecycleRequest(LifecycleManager.java:215)
at com.ibm.dolphin.webengine.servlet.DRLProxyServlet.service(DRLProxyServlet.java:91)
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.webapp.WebApp.handleRequest(WebApp.java:2837)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:220)
at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:204)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1681)
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.HttpICLReadCallback.complete(HttpICLReadCallback.java:94)
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: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -532, SQLSTATE: 23001, SQLERRMC: GDMW.CUST_CONT_CMNT.FK_CCNTCMT_CCNT
at com.ibm.db2.jcc.b.zc.d(zc.java:1351)
at com.ibm.db2.jcc.a.db.l(db.java:366)
at com.ibm.db2.jcc.a.db.a(db.java:64)
at com.ibm.db2.jcc.a.r.a(r.java:48)
at com.ibm.db2.jcc.a.tb.c(tb.java:266)
at com.ibm.db2.jcc.b.ad.Z(ad.java:1666)
at com.ibm.db2.jcc.b.ad.d(ad.java:2224)
at com.ibm.db2.jcc.b.ad.V(ad.java:521)
at com.ibm.db2.jcc.b.ad.executeUpdate(ad.java:504)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2291)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2440)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:73)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:144)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:333)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at fit.gdms.process.DeleteCustomerContactProcess.deleteContact(DeleteCustomerContactProcess.java:229)
at fit.gdms.process.DeleteCustomerContactProcess.validate(DeleteCustomerContactProcess.java:129)
at fit.gdms.controller.CustomerContactDeleteAction.execute(CustomerContactDeleteAction.java:49)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.dolphin.webengine.lifecycle.plugins.ServletManagerPlugin.handleRequest(ServletManagerPlugin.java:112)
at com.ibm.dolphin.webengine.lifecycle.LifecycleManager.processLifecycleRequest(LifecycleManager.java:215)
at com.ibm.dolphin.webengine.servlet.DRLProxyServlet.service(DRLProxyServlet.java:91)
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.webapp.WebApp.handleRequest(WebApp.java:2837)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:220)
at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:204)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1681)
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.HttpICLReadCallback.complete(HttpICLReadCallback.java:94)
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)









First Time it worked correctly.Second time onwards this exception came.I tried with another System then also first time it worked and afterthat it is throwing exceptions..



I am expecting an immediate soln.


Database Used DB2 8.1