0 Replies Latest reply: Jul 31, 2012 7:33 AM by 953010 RSS

    executeUpdat methode never returns

    953010
      I m using OCI Driver with Connection Poolig..Weblogic 11g,Oracle 11g . I found that the executeUpdate method never returns, every 1 out of 100 times, approximately.
      I m calling a procedur from Java,which only inser the insert data,in procedure for tracking I m inserting in one table and that procedure is "PRAGMA AUTONOMOUS_TRANSACTION".Please help me.


      And the thead stack is below


      "[STUCK] ExecuteThread: '81' for queue: 'weblogic.kernel.Default (self-tuning)'" RUNNABLE native

           oracle.jdbc.driver.T2CStatement.t2cParseExecuteDescribe(Native Method)

           oracle.jdbc.driver.T2CCallableStatement.executeForDescribe(T2CCallableStatement.java:482)

           oracle.jdbc.driver.T2CCallableStatement.executeForRows(T2CCallableStatement.java:727)

           oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)

           oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)

           oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657)

           oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4739)

           oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)

           weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)

           com.infotech.kastle.lending.interfaces.core.databaseUtils.InterfaceDAO.saveForLogging(InterfaceDAO.java:460)

           com.infotech.kastle.lending.interfaces.handlers.externalSystems.Simah_CommonResponseHandler.processCommonResponse(Simah_CommonResponseHandler.java:93)

           com.infotech.kastle.lending.interfaces.handlers.externalSystems.Simah_CreditReportHandler.mainProcessing(Simah_CreditReportHandler.java:1188)

           com.infotech.kastle.lending.interfaces.handlers.externalSystems.Simah_CreditReportHandler.processRequest(Simah_CreditReportHandler.java:92)

           com.infotech.kastle.lending.interfaces.handlers.externalSystems.Simah_CreditReportHandler.startHandler(Simah_CreditReportHandler.java:74)

           com.infotech.kastle.lending.interfaces.core.InterfaceManager.executeServices(InterfaceManager.java:314)

           com.infotech.kastle.lending.interfaces.core.InterfaceManager.executeServices(InterfaceManager.java:288)

           com.infotech.kastle.lending.interfaces.core.databaseUtils.DBUtils.callingSimahCreditReport(DBUtils.java:1367)

           com.infotech.kastle.lending.interfaces.core.databaseUtils.DBUtils.InterfaceTrigger(DBUtils.java:2004)

           com.infotech.kastle.lending.interfaces.core.databaseUtils.DBUtils.checkInterfaceFiringForCust(DBUtils.java:1823)

           com.infotech.kastle.lending.action.corporate.BasicInfoISAction.execute(BasicInfoISAction.java:581)

           org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)

           org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)

           org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)

           org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)

           javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

           javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

           weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

           weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

           weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)

           weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)

           weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

           com.infotech.kastle.lending.filter.UTF8EncodingFilter.doFilter(UTF8EncodingFilter.java:70)

           weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

           weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)

           weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)

           weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

           weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

           weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)

           weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)

           weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)

           weblogic.work.ExecuteThread.execute(ExecuteThread.java:207)

           weblogic.work.ExecuteThread.run(ExecuteThread.java:176)