common.serviceexecutor.ServiceExecutorException: com.*********.common.exception.SCBBaseException: SQL Exception occured while getting connection from ConnectionPool in SQLMassRetrieveExecutor at com.*********.common.serviceexecutor.Service.executeMethodsInOrder(Unknown Source) at com.*********.common.serviceexecutor.Service.execute(Unknown Source) at com.*********.common.serviceexecutor.ServiceDefinition.executeServices(Unknown Source) at com.*********.common.serviceexecutor.StatelessServiceExecutorImpl.executeServiceDefinition(Unknown Source) at com.*********.common.sessionutil.PageManager.executeServiceExecutor(Unknown Source) at com.*********.common.sessionutil.PageManager.executeMethod(Unknown Source) at com.*********.common.sessionutil.PageManager.getFirstPage(Unknown Source) at com.*********.common.sessionutil.PageManager.getPages(Unknown Source) at com.*********.sci.view.action.VerifyQueueListAction.perform(VerifyQueueListAction.java:124)

Oracle Community | brainstormer | 10 years ago
  1. 0

    Connection pooling unable to close connection on Oracle 9i 64bit

    Oracle Community | 10 years ago | brainstormer
    common.serviceexecutor.ServiceExecutorException: com.*********.common.exception.SCBBaseException: SQL Exception occured while getting connection from ConnectionPool in SQLMassRetrieveExecutor at com.*********.common.serviceexecutor.Service.executeMethodsInOrder(Unknown Source) at com.*********.common.serviceexecutor.Service.execute(Unknown Source) at com.*********.common.serviceexecutor.ServiceDefinition.executeServices(Unknown Source) at com.*********.common.serviceexecutor.StatelessServiceExecutorImpl.executeServiceDefinition(Unknown Source) at com.*********.common.sessionutil.PageManager.executeServiceExecutor(Unknown Source) at com.*********.common.sessionutil.PageManager.executeMethod(Unknown Source) at com.*********.common.sessionutil.PageManager.getFirstPage(Unknown Source) at com.*********.common.sessionutil.PageManager.getPages(Unknown Source) at com.*********.sci.view.action.VerifyQueueListAction.perform(VerifyQueueListAction.java:124)

    Root Cause Analysis

    1. common.serviceexecutor.ServiceExecutorException

      com.*********.common.exception.SCBBaseException: SQL Exception occured while getting connection from ConnectionPool in SQLMassRetrieveExecutor at com.*********.common.serviceexecutor.Service.executeMethodsInOrder(Unknown Source) at com.*********.common.serviceexecutor.Service.execute(Unknown Source) at com.*********.common.serviceexecutor.ServiceDefinition.executeServices(Unknown Source) at com.*********.common.serviceexecutor.StatelessServiceExecutorImpl.executeServiceDefinition(Unknown Source) at com.*********.common.sessionutil.PageManager.executeServiceExecutor(Unknown Source) at com.*********.common.sessionutil.PageManager.executeMethod(Unknown Source) at com.*********.common.sessionutil.PageManager.getFirstPage(Unknown Source) at com.*********.common.sessionutil.PageManager.getPages(Unknown Source) at com.*********.sci.view.action.VerifyQueueListAction.perform(VerifyQueueListAction.java:124)

      at org.apache.struts.action.ActionServlet.processActionPerform()
    2. struts
      ActionServlet.doPost
      1. org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1787)
      2. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1586)
      3. org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
      3 frames
    3. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      2 frames
    4. Glassfish Core
      ApplicationDispatcher.forward
      1. org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
      2. org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:432)
      3. org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:356)
      3 frames
    5. struts
      ActionServlet.doPost
      1. org.apache.struts.action.ActionServlet.processActionForward(ActionServlet.java:1759)
      2. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1596)
      3. org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
      3 frames
    6. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      2 frames
    7. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      2 frames