java.sql.SQLException: ORA-00933: SQL command not properly ended

hibernate.org | 5 months ago
  1. 0

    Error executing SQL statement for report when print jasper file

    Stack Overflow | 11 months ago | Sandun Chathuranga
    java.sql.SQLException: ORA-00933: SQL command not properly ended
  2. 0

    Confluence 2.0.1, Oracle 8.1.7, when trying to delete space from Space Admin, getting error report: Cause: org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: ORA-00933: SQL command not properly ended Stack Trace: [hide] org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: ORA-00933: SQL command not properly ended java.sql.SQLException: ORA-00933: SQL command not properly ended at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:182) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:500) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:942) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:532) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1037) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2905) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2946) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:875) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133) at net.sf.hibernate.loader.Loader.doList(Loader.java:1033) at net.sf.hibernate.loader.Loader.list(Loader.java:1024)

    Atlassian JIRA | 1 decade ago | Daniel Ostermeier
    java.sql.SQLException: ORA-00933: SQL command not properly ended
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    ODI Desginer don't open

    Oracle Community | 7 years ago | 699138
    java.sql.SQLException: ORA-00933: SQL command not properly ended
  5. 0

    Confluence 2.0.1, Oracle 8.1.7, when trying to delete space from Space Admin, getting error report: Cause: org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: ORA-00933: SQL command not properly ended Stack Trace: [hide] org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: ORA-00933: SQL command not properly ended java.sql.SQLException: ORA-00933: SQL command not properly ended at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:182) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:500) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:942) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:532) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1037) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2905) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2946) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:875) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133) at net.sf.hibernate.loader.Loader.doList(Loader.java:1033) at net.sf.hibernate.loader.Loader.list(Loader.java:1024)

    Atlassian JIRA | 1 decade ago | Daniel Ostermeier
    java.sql.SQLException: ORA-00933: SQL command not properly ended

    12 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

      ORA-00933: SQL command not properly ended

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OraclePreparedStatement.executeQuery
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
      5. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
      6. oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:420)
      7. oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896)
      8. oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:452)
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986)
      10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
      11. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2929)
      11 frames
    3. Hibernate
      QueryLoader.list
      1. org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:118)
      2. org.hibernate.loader.Loader.getResultSet(Loader.java:1197)
      3. org.hibernate.loader.Loader.doQuery(Loader.java:366)
      4. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:206)
      5. org.hibernate.loader.Loader.doList(Loader.java:1515)
      6. org.hibernate.loader.Loader.list(Loader.java:1498)
      7. org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
      7 frames
    4. Hibernate HQL/JP-QL Parser
      QueryTranslatorImpl.list
      1. org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:268)
      1 frame
    5. Hibernate
      QueryImpl.list
      1. org.hibernate.impl.SessionImpl.list(SessionImpl.java:788)
      2. org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
      2 frames
    6. org.hibernate.console
      HQLQueryPage.getList
      1. org.hibernate.console.HQLQueryPage.getList(HQLQueryPage.java:30)
      1 frame
    7. org.hibernate.eclipse
      QueryPageViewer$ContentProviderImpl.getElements
      1. org.hibernate.eclipse.console.views.QueryPageViewer$ContentProviderImpl.getElements(QueryPageViewer.java:80)
      1 frame
    8. JFace
      StructuredViewer.setInput
      1. org.eclipse.jface.viewers.StructuredViewer.getRawChildren(StructuredViewer.java:765)
      2. org.eclipse.jface.viewers.TableViewer.getRawChildren(TableViewer.java:1046)
      3. org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:707)
      4. org.eclipse.jface.viewers.StructuredViewer.getSortedChildren(StructuredViewer.java:822)
      5. org.eclipse.jface.viewers.TableViewer.internalRefreshAll(TableViewer.java:762)
      6. org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:712)
      7. org.eclipse.jface.viewers.TableViewer.internalRefresh(TableViewer.java:701)
      8. org.eclipse.jface.viewers.StructuredViewer$7.run(StructuredViewer.java:1171)
      9. org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1108)
      10. org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1169)
      11. org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1128)
      12. org.eclipse.jface.viewers.TableViewer.inputChanged(TableViewer.java:662)
      13. org.eclipse.jface.viewers.ContentViewer.setInput(ContentViewer.java:248)
      14. org.eclipse.jface.viewers.StructuredViewer.setInput(StructuredViewer.java:1324)
      14 frames
    9. org.hibernate.eclipse
      QueryPageTabView$1.intervalAdded
      1. org.hibernate.eclipse.console.views.QueryPageViewer.createTable(QueryPageViewer.java:174)
      2. org.hibernate.eclipse.console.views.QueryPageViewer.createControl(QueryPageViewer.java:153)
      3. org.hibernate.eclipse.console.views.QueryPageViewer.<init>(QueryPageViewer.java:111)
      4. org.hibernate.eclipse.console.views.QueryPageTabView.rebuild(QueryPageTabView.java:83)
      5. org.hibernate.eclipse.console.views.QueryPageTabView$1.contentsChanged(QueryPageTabView.java:52)
      6. org.hibernate.eclipse.console.views.QueryPageTabView$1.intervalAdded(QueryPageTabView.java:57)
      6 frames
    10. Java RT
      AbstractListModel.fireIntervalAdded
      1. javax.swing.AbstractListModel.fireIntervalAdded(Unknown Source)
      1 frame
    11. org.hibernate.console
      ConsoleConfiguration.executeHQLQuery
      1. org.hibernate.console.QueryPageModel.add(QueryPageModel.java:50)
      2. org.hibernate.console.KnownConfigurations$3.queryPageCreated(KnownConfigurations.java:167)
      3. org.hibernate.console.ConsoleConfiguration.fireQueryPageCreated(ConsoleConfiguration.java:266)
      4. org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:247)
      4 frames
    12. org.hibernate.eclipse
      KnownConfigurationsView$3.doubleClick
      1. org.hibernate.eclipse.console.views.KnownConfigurationsView$5.run(KnownConfigurationsView.java:143)
      2. org.hibernate.eclipse.console.views.KnownConfigurationsView$3.doubleClick(KnownConfigurationsView.java:91)
      2 frames
    13. JFace
      StructuredViewer$1.run
      1. org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:637)
      1 frame
    14. Eclipse Core
      Platform.run
      1. org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:1021)
      2. org.eclipse.core.runtime.Platform.run(Platform.java:757)
      2 frames
    15. Eclipse UI
      JFaceUtil$1.run
      1. org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:40)
      1 frame
    16. JFace
      OpenStrategy$1.handleEvent
      1. org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:148)
      2. org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:635)
      3. org.eclipse.jface.viewers.StructuredViewer.handleDoubleSelect(StructuredViewer.java:857)
      4. org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:964)
      5. org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:219)
      6. org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:216)
      7. org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:275)
      7 frames
    17. RWT
      Display.readAndDispatch
      1. org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:82)
      2. org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:842)
      3. org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2894)
      4. org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2527)
      4 frames
    18. Eclipse UI
      Workbench.createAndRunWorkbench
      1. org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1570)
      2. org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1534)
      3. org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:306)
      3 frames
    19. Eclipse UI
      IDEApplication.run
      1. org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)
      2. org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103)
      2 frames
    20. Eclipse Core
      PlatformActivator$1.run
      1. org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:228)
      1 frame
    21. Eclipse OSGi
      EclipseStarter.run
      1. org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)
      2. org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:156)
      2 frames
    22. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    23. Equinox
      Main.main
      1. org.eclipse.core.launcher.Main.invokeFramework(Main.java:315)
      2. org.eclipse.core.launcher.Main.basicRun(Main.java:268)
      3. org.eclipse.core.launcher.Main.run(Main.java:942)
      4. org.eclipse.core.launcher.Main.main(Main.java:926)
      4 frames