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

Stack Overflow | Nina | 2 months ago
  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 | 2 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

    Unable to call Stored procedure from hibernate

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

    [OPENJPA-964] Finish updating sql-error-state- codes.xml for query timeout support on other DBs - ASF JIRA

    apache.org | 12 months ago
    java.sql.SQLException: ORA-01013: user requested cancel of current operation

    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)[DatabaseError.class:Oracle JDBC Driver version - "10.2.0.2.0"]
      1 frame