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 | 7 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

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

    ibm.com | 7 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