closed.oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Groups.GROU_ID FROM GROUPS Groups WHERE (GROU_ID=1) at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java(Compiled Code)) at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java(Compiled Code)) at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java(Compiled Code)) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java(Compiled Code)) at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java(Inlined Compiled Code)) at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java(Inlined Compiled Code)) at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java(Compiled Code))

ibm.com | 5 months ago
  1. 0

    WebSphere:WebSphere Application Server:DSRA9110E: Statement is closed JDBC and datasources - WebSphere Application Server Forum

    ibm.com | 5 months ago
    closed.oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Groups.GROU_ID FROM GROUPS Groups WHERE (GROU_ID=1) at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java(Compiled Code)) at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java(Compiled Code)) at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java(Compiled Code)) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java(Compiled Code)) at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java(Inlined Compiled Code)) at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java(Inlined Compiled Code)) at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java(Compiled Code))

    Root Cause Analysis

    1. closed.oracle.jbo.SQLStmtException

      JBO-27122: SQL error during statement preparation. Statement: SELECT Groups.GROU_ID FROM GROUPS Groups WHERE (GROU_ID=1) at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java(Compiled Code)) at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java(Compiled Code)) at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java(Compiled Code)) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java(Compiled Code)) at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java(Inlined Compiled Code)) at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java(Inlined Compiled Code)) at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java(Compiled Code))

      at framework.util.PageFields.setFormQuery()
    2. framework.util
      PageFields.setFormQuery
      1. framework.util.PageFields.setFormQuery(Unknown Source)
      2. framework.util.PageFields.setFormQuery(Unknown Source)
      2 frames
    3. com.ibm._jsp
      _SA001_5F_U._jspService
      1. com.ibm._jsp._SA001_5F_U._jspService(_SA001_5F_U.java:157)
      1 frame
    4. com.ibm.ws
      HttpJspBase.service
      1. com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:91)
      1 frame
    5. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    6. WebSphere
      ServletWrapper.handleRequest
      1. com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1572)
      2. com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:762)
      2 frames
    7. com.ibm.wsspi
      GenericServletWrapper.handleRequest
      1. com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:121)
      1 frame
    8. com.ibm.ws
      JSPExtensionServletWrapper.handleRequest
      1. com.ibm.ws.jsp.webcontainerext.JSPExtensionServletWrapper.handleRequest(JSPExtensionServletWrapper.java:204)
      1 frame
    9. WebSphere
      WebContainer.handleRequest
      1. com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:89)
      2. com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1924)
      2 frames
    10. com.ibm.ws
      WCChannelLink.ready
      1. com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:98)
      1 frame
    11. WebSphere
      WorkQueueManager.requestComplete
      1. com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472)
      2. com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411)
      3. com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:101)
      4. com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:566)
      4 frames