oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT FIELD1, FIELD2 FROM

Oracle Community | 941130 | 4 years ago
  1. 0

    JBO-27122: SQL error during statement preparation

    Oracle Community | 4 years ago | 941130
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT FIELD1, FIELD2 FROM
  2. 0

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

    Stack Overflow | 3 years ago | sadiqmrd
    java.sql.SQLException: The connection does not exist.
  3. 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.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Toolbox for Java/JTOpen / Bugs / #313 java.lang.ArrayIndexOutOfBoundsException

    sourceforge.net | 11 months ago
    java.sql.SQLException: Internal driver error. (class java.lang.ArrayIndexOutOfBoundsException)
  6. 0

    Hibernate Query DB2 with Case and listParameter

    Stack Overflow | 1 year ago | Cristian Arboleda
    java.sql.SQLException: [SQL0104] S?mbolo ? no v?lido. S?mbolos v?lidos: (.

    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

      [SQL0104] Token <END-OF-STATEMENT> was not valid. Valid tokens: ( NEW FINAL TABLE LATERAL.

      at com.ibm.as400.access.JDError.throwSQLException()
    2. JT400
      AS400JDBCConnection.prepareStatement
      1. com.ibm.as400.access.JDError.throwSQLException(JDError.java:703)
      2. com.ibm.as400.access.JDError.throwSQLException(JDError.java:669)
      3. com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1777)
      4. com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JDBCPreparedStatement.java:316)
      5. com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:2166)
      6. com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:1965)
      6 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