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

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
    java.sql.SQLException: [SQL0104] Token <END-OF-STATEMENT> was not valid. Valid tokens: ( NEW FINAL TABLE LATERAL.
  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

    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 | 1 year 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