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

hibernate.org | 10 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

    Error executing SQL statement for report when print jasper file

    Stack Overflow | 1 year 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 | 8 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