oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT XWBCCD, XWG4TX, XWB2CD, XWB3CD, XWHITX, XWE0NB, XWJUN0, XWDVCD, XWBNCD, PERSON, DSDCDE, XWBTCD, XWGIVA, XWAOCD, XWBBCD, XWG4T0, XWC7ST, XWDAST, XWBPD0, XWBAD0, XWARDT, XWF0VA, XWASDT, XWF0V0, XWBQDT, XWF1VA, XWF1V0, XWF2VA, XWF3VA, XWF4VA, XWF6VA, XWIDV0, XWGAVA, XWGBVA, XWGCVA, XWGDVA, XWGEVA, XWGFVA, XWGGVA, CUSNO FROM

Oracle Community | 941130 | 5 years 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

    JBO-27122: SQL error during statement preparation

    Oracle Community | 5 years ago | 941130
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT XWBCCD, XWG4TX, XWB2CD, XWB3CD, XWHITX, XWE0NB, XWJUN0, XWDVCD, XWBNCD, PERSON, DSDCDE, XWBTCD, XWGIVA, XWAOCD, XWBBCD, XWG4T0, XWC7ST, XWDAST, XWBPD0, XWBAD0, XWARDT, XWF0VA, XWASDT, XWF0V0, XWBQDT, XWF1VA, XWF1V0, XWF2VA, XWF3VA, XWF4VA, XWF6VA, XWIDV0, XWGAVA, XWGBVA, XWGCVA, XWGDVA, XWGEVA, XWGFVA, XWGGVA, CUSNO FROM
  2. 0

    After connection is closed, and opened again, it no longer exists

    Stack Overflow | 4 years ago | sadiqmrd
    java.sql.SQLException: The connection does not exist.
  3. 0

    multiple transactions

    Oracle Community | 1 decade ago | 843830
    java.sql.SQLException: The connection does not exist.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    multiple transactions

    Oracle Community | 1 decade ago | 843836
    java.sql.SQLException: The connection does not exist.
  6. 0

    JDBC & Hiberntate Error in DB2 : Connection authorization failure occurred | SQL Error: -99999, SQLState: 42505

    Stack Overflow | 2 years ago
    java.sql.SQLException: Connection authorization failure occurred.

    3 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      The connection does not exist.

      at com.ibm.as400.access.JDError.throwSQLException()
    2. JT400
      AS400JDBCConnection.prepareStatement
      1. com.ibm.as400.access.JDError.throwSQLException(JDError.java:415)
      2. com.ibm.as400.access.AS400JDBCConnection.checkOpen(AS400JDBCConnection.java:460)
      3. com.ibm.as400.access.AS400JDBCConnection.sendAndReceive(AS400JDBCConnection.java:2941)
      4. com.ibm.as400.access.AS400JDBCStatement.close(AS400JDBCStatement.java:474)
      5. com.ibm.as400.access.AS400JDBCPreparedStatement.close(AS400JDBCPreparedStatement.java:631)
      6. com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JDBCPreparedStatement.java:318)
      7. com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:2166)
      8. com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:1965)
      8 frames
    3. oracle.jbo.server
      ViewObjectImpl.first
      1. oracle.jbo.server.DBTransactionImpl.createPreparedStatement(DBTransactionImpl.java:3671)
      2. oracle.jbo.server.DBTransactionImpl2.createPreparedStatement(DBTransactionImpl2.java:399)
      3. oracle.jbo.server.DBTransactionImpl.createReUsePreparedStatement(DBTransactionImpl.java:4981)
      4. oracle.jbo.server.ViewObjectImpl.getPreparedStatement(ViewObjectImpl.java:13391)
      5. oracle.jbo.server.ViewObjectImpl.getPreparedStatement(ViewObjectImpl.java:13366)
      6. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1123)
      7. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:913)
      8. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:7282)
      9. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1227)
      10. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1078)
      11. oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2800)
      12. oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2777)
      13. oracle.jbo.server.ViewRowSetIteratorImpl.first(ViewRowSetIteratorImpl.java:1606)
      14. oracle.jbo.server.ViewRowSetImpl.first(ViewRowSetImpl.java:3556)
      15. oracle.jbo.server.ViewObjectImpl.first(ViewObjectImpl.java:10288)
      15 frames
    4. oracle.adf.model
      DCIteratorBinding.refreshControl
      1. oracle.adf.model.binding.DCIteratorBinding.setupRSIstate(DCIteratorBinding.java:808)
      2. oracle.adf.model.binding.DCIteratorBinding.refreshControlAndNotifyDCE(DCIteratorBinding.java:707)
      3. oracle.adf.model.binding.DCIteratorBinding.refreshControl(DCIteratorBinding.java:676)
      3 frames
    5. oracle.jbo.uicli
      JUIteratorBinding.refreshControl
      1. oracle.jbo.uicli.binding.JUIteratorBinding.refreshControl(JUIteratorBinding.java:485)
      1 frame
    6. oracle.adf.model
      DCIteratorBinding.getRowSetIterator
      1. oracle.adf.model.binding.DCIteratorBinding.refresh(DCIteratorBinding.java:4555)
      2. oracle.adf.model.binding.DCExecutableBinding.refreshIfNeeded(DCExecutableBinding.java:347)
      3. oracle.adf.model.binding.DCIteratorBinding.getRowSetIterator(DCIteratorBinding.java:1634)
      3 frames
    7. oracle.jbo.jbotester
      AbstractJboAction.actionPerformed
      1. oracle.jbo.jbotester.panel.BindingPanel.setBindingContext(BindingPanel.java:131)
      2. oracle.jbo.jbotester.panel.OverviewPanel.setBindingContext(OverviewPanel.java:176)
      3. oracle.jbo.jbotester.panel.BindingPanel.<init>(BindingPanel.java:101)
      4. oracle.jbo.jbotester.panel.OverviewPanel.<init>(OverviewPanel.java:68)
      5. oracle.jbo.jbotester.form.OverviewForm.createMasterPanel(OverviewForm.java:53)
      6. oracle.jbo.jbotester.form.BindingForm.init(BindingForm.java:126)
      7. oracle.jbo.jbotester.form.JTForm.<init>(JTForm.java:72)
      8. oracle.jbo.jbotester.form.BindingForm.<init>(BindingForm.java:52)
      9. oracle.jbo.jbotester.form.OverviewForm.<init>(OverviewForm.java:46)
      10. oracle.jbo.jbotester.form.FormType$2.createForm(FormType.java:76)
      11. oracle.jbo.jbotester.form.FormType.createForm(FormType.java:199)
      12. oracle.jbo.jbotester.form.FormType.createTab(FormType.java:270)
      13. oracle.jbo.jbotester.form.FormType.showForm(FormType.java:248)
      14. oracle.jbo.jbotester.form.FormType.showForm(FormType.java:207)
      15. oracle.jbo.jbotester.form.FormType.showForm(FormType.java:203)
      16. oracle.jbo.jbotester.tree.ObjTreeNode.showForm(ObjTreeNode.java:135)
      17. oracle.jbo.jbotester.tree.BindingContainerTreeNode$1.doAction(BindingContainerTreeNode.java:114)
      18. oracle.jbo.jbotester.AbstractJboAction.actionPerformed(AbstractJboAction.java:97)
      18 frames
    8. Java RT
      EventDispatchThread.run
      1. javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
      2. javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
      3. javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
      4. javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
      5. javax.swing.AbstractButton.doClick(AbstractButton.java:357)
      6. javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:809)
      7. javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:850)
      8. java.awt.Component.processMouseEvent(Component.java:6289)
      9. javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
      10. java.awt.Component.processEvent(Component.java:6054)
      11. java.awt.Container.processEvent(Container.java:2041)
      12. java.awt.Component.dispatchEventImpl(Component.java:4652)
      13. java.awt.Container.dispatchEventImpl(Container.java:2099)
      14. java.awt.Component.dispatchEvent(Component.java:4482)
      15. java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
      16. java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
      17. java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
      18. java.awt.Container.dispatchEventImpl(Container.java:2085)
      19. java.awt.Window.dispatchEventImpl(Window.java:2478)
      20. java.awt.Component.dispatchEvent(Component.java:4482)
      21. java.awt.EventQueue.dispatchEventImpl(EventQueue.java:644)
      22. java.awt.EventQueue.access$000(EventQueue.java:85)
      23. java.awt.EventQueue$1.run(EventQueue.java:603)
      24. java.awt.EventQueue$1.run(EventQueue.java:601)
      25. java.security.AccessController.doPrivileged(Native Method)
      26. java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
      27. java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
      28. java.awt.EventQueue$2.run(EventQueue.java:617)
      29. java.awt.EventQueue$2.run(EventQueue.java:615)
      30. java.security.AccessController.doPrivileged(Native Method)
      31. java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
      32. java.awt.EventQueue.dispatchEvent(EventQueue.java:614)
      33. java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
      34. java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
      35. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
      36. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
      37. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
      38. java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
      38 frames