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

Atlassian JIRA | Dominic Auclair | 1 decade 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

    Referer URL: http://srv45451w02:9080/confluence/spaces/removespace.action?key=test2 Build Information: Confluence Home: D:\confluence\test2 Uptime: 1 month, 4 days, 3 minutes, 50 seconds Version: 2.0.2 Build Number: 322 Server Information: Application Server: IBM WebSphere Application Server/5.1 Servlet Version: 2.3 Database Dialect: net.sf.hibernate.dialect.OracleDialect Memory Information: Total Memory: 768 MB Free Memory: 64 MB Used Memory: 704 MB System Information: System Date: Wednesday, 11 Jan 2006 System Time: 15:23:30 System Favourite Colour: Chartreuse Java Version: 1.4.2 Java Vendor: IBM Corporation JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.2 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Classic VM User Name: wasuser User Timezone: America/New_York Operating System: Windows 2003 5.2 OS Architecture: x86 Request Information: URL: http://srv45451w02:9080/confluence/500page.jsp - Scheme: http - Server: srv45451w02 - Port: 9080 - URI: /confluence/500page.jsp - - Context Path: /confluence - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: null Attributes: - javax.servlet.error.message : Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: ORA-00933: SQL command not properly ended - javax.servlet.error.exception : org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: ORA-00933: SQL command not properly ended - ErrorReport : com.ibm.ws.webcontainer.webapp.WebAppErrorReport: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: ORA-00933: SQL command not properly ended - os_securityfilter_already_filtered : true - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - com.ibm.servlet.engine.webapp.dispatch_nested : true - javax.servlet.error.request_uri : /confluence/spaces/doremovespace.action - javax.servlet.error.status_code : 500 - os_authstatus : null - __sitemesh__filterapplied : true - javax.servlet.error.servlet_name : action - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@2cf2582 - loginfilter.already.filtered : true - atlassian.core.seraph.original.url : /spaces/doremovespace.action?key=test2 - javax.servlet.jsp.jspException : com.ibm.ws.webcontainer.webapp.WebAppErrorReport: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: ORA-00933: SQL command not properly ended - com.ibm.servlet.engine.webapp.dispatch_type : forward - sessioninview.FILTERED : true - com.atlassian.core.filters.gzip.GzipFilter_already_filtered : true Parameters: - confirm = OK - key = test2 Logging: 1 log statements generated by this request: --- [ERROR] Wed Jan 11 15:23:30 EST 2006 [com.atlassian.confluence.util.XWorkTransactionInterceptor] Invoking rollback for transaction on action '/spaces/doremovespace.action (RemoveSpaceAction.doRemove())' due to throwable: org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: ORA-00933: SQL command not properly ended Throwable: 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:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java(Compiled Code)) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java(Inlined Compiled Code)) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java(Compiled Code)) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java(Compiled Code)) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java(Compiled Code)) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java(Compiled Code)) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java(Compiled Code)) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java(Compiled Code)) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java(Compiled Code)) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java(Compiled Code)) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java(Compiled Code)) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java(Compiled Code)) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java(Compiled Code)) at net.sf.hibernate.loader.Loader.doQuery(Loader.java(Compiled Code)) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java(Compiled Code)) at net.sf.hibernate.loader.Loader.doList(Loader.java(Inlined Compiled Code)) at net.sf.hibernate.loader.Loader.list(Loader.java(Compiled Code))

    Atlassian JIRA | 1 decade ago | Dominic Auclair
    java.sql.SQLException: ORA-00933: SQL command not properly ended
  2. 0

    Referer URL: http://srv45451w02:9080/confluence/spaces/removespace.action?key=test2 Build Information: Confluence Home: D:\confluence\test2 Uptime: 1 month, 4 days, 3 minutes, 50 seconds Version: 2.0.2 Build Number: 322 Server Information: Application Server: IBM WebSphere Application Server/5.1 Servlet Version: 2.3 Database Dialect: net.sf.hibernate.dialect.OracleDialect Memory Information: Total Memory: 768 MB Free Memory: 64 MB Used Memory: 704 MB System Information: System Date: Wednesday, 11 Jan 2006 System Time: 15:23:30 System Favourite Colour: Chartreuse Java Version: 1.4.2 Java Vendor: IBM Corporation JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.2 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Classic VM User Name: wasuser User Timezone: America/New_York Operating System: Windows 2003 5.2 OS Architecture: x86 Request Information: URL: http://srv45451w02:9080/confluence/500page.jsp - Scheme: http - Server: srv45451w02 - Port: 9080 - URI: /confluence/500page.jsp - - Context Path: /confluence - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: null Attributes: - javax.servlet.error.message : Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: ORA-00933: SQL command not properly ended - javax.servlet.error.exception : org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: ORA-00933: SQL command not properly ended - ErrorReport : com.ibm.ws.webcontainer.webapp.WebAppErrorReport: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: ORA-00933: SQL command not properly ended - os_securityfilter_already_filtered : true - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - com.ibm.servlet.engine.webapp.dispatch_nested : true - javax.servlet.error.request_uri : /confluence/spaces/doremovespace.action - javax.servlet.error.status_code : 500 - os_authstatus : null - __sitemesh__filterapplied : true - javax.servlet.error.servlet_name : action - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@2cf2582 - loginfilter.already.filtered : true - atlassian.core.seraph.original.url : /spaces/doremovespace.action?key=test2 - javax.servlet.jsp.jspException : com.ibm.ws.webcontainer.webapp.WebAppErrorReport: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: ORA-00933: SQL command not properly ended - com.ibm.servlet.engine.webapp.dispatch_type : forward - sessioninview.FILTERED : true - com.atlassian.core.filters.gzip.GzipFilter_already_filtered : true Parameters: - confirm = OK - key = test2 Logging: 1 log statements generated by this request: --- [ERROR] Wed Jan 11 15:23:30 EST 2006 [com.atlassian.confluence.util.XWorkTransactionInterceptor] Invoking rollback for transaction on action '/spaces/doremovespace.action (RemoveSpaceAction.doRemove())' due to throwable: org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: ORA-00933: SQL command not properly ended Throwable: 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:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java(Compiled Code)) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java(Inlined Compiled Code)) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java(Compiled Code)) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java(Compiled Code)) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java(Compiled Code)) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java(Compiled Code)) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java(Compiled Code)) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java(Compiled Code)) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java(Compiled Code)) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java(Compiled Code)) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java(Compiled Code)) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java(Compiled Code)) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java(Compiled Code)) at net.sf.hibernate.loader.Loader.doQuery(Loader.java(Compiled Code)) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java(Compiled Code)) at net.sf.hibernate.loader.Loader.doList(Loader.java(Inlined Compiled Code)) at net.sf.hibernate.loader.Loader.list(Loader.java(Compiled Code))

    Atlassian JIRA | 1 decade ago | Dominic Auclair
    java.sql.SQLException: ORA-00933: SQL command not properly ended
  3. 0

    JPA + Hibernate, bulk delete with IS NULL, SQL command not properly ended

    Stack Overflow | 4 months ago | Nina
    java.sql.SQLException: ORA-00933: SQL command not properly ended
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Cross Schema NetworkManager Problem when reading NetWork with MBR

    Oracle Community | 7 years ago | 407022
    java.sql.SQLException: ORA-29902: error in executing ODCIIndexStart() routine ORA-13208: internal error while evaluating [window SRID does not match layer SRID] operator ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 333
  6. 0

    Unable to call Stored procedure from hibernate

    Stack Overflow | 2 years ago | jayendra bhatt
    java.sql.SQLException: Invalid column name

    4 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
      DatabaseError.throwSqlException
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      1 frame