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

Oracle Community | 807581 | 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

    ACTION_UPDATE of tables with 32 columns

    Oracle Community | 1 decade ago | 807581
    java.sql.SQLException: ORA-00933: SQL command not properly ended
  2. 0

    index name collision

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: ORA-00955: name is already used by an existing object
  3. 0

    Oracle sequence created twice. ORA-00955: name is already used by an existing object

    Stack Overflow | 2 years ago
    java.sql.SQLException: ORA-00955: name is already used by an existing object
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Oracle 8. Serializable transactions

    Google Groups | 2 decades ago | Vlad Dutov
    java.sql.SQLException: ORA-08177: can't serialize access for this transaction
  6. 0

    Error while starting WebSphere Admin Server while creating the tables

    Google Groups | 1 decade ago | Vinod
    java.sql.SQLException: ORA-00903: invalid table name

  1. rp 1 times, last 4 months ago
26 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.dbaccess.DBError.throwSqlException()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
    1 frame
  3. oracle.jdbc.ttc7
    TTC7Protocol.parseExecuteFetch
    1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
    2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
    3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
    4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
    4 frames
  4. Oracle jdbc
    OracleStatement.executeUpdate
    1. oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
    2. oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
    3. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
    4. oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:693)
    4 frames
  5. com.iplanet.jato
    ApplicationServletBase.doPost
    1. com.iplanet.jato.model.sql.QueryModelBase.executeUpdate(QueryModelBase.java:2111)
    2. com.iplanet.jato.model.sql.QueryModelBase.update(QueryModelBase.java:537)
    3. com.iplanet.jato.view.RequestHandlingViewBase.executeAutoUpdatingModel(RequestHandlingViewBase.java:1370)
    4. com.iplanet.jato.view.RequestHandlingViewBase.executeAutoUpdatingModels(RequestHandlingViewBase.java:1222)
    5. com.iplanet.jato.view.RequestHandlingViewBase.handleWebAction(RequestHandlingViewBase.java:1064)
    6. com.iplanet.jato.view.command.WebActionCommand.execute(WebActionCommand.java:77)
    7. com.iplanet.jato.view.RequestHandlingViewBase.handleRequest(RequestHandlingViewBase.java:308)
    8. com.iplanet.jato.view.ViewBeanBase.dispatchInvocation(ViewBeanBase.java:802)
    9. com.iplanet.jato.view.ViewBeanBase.invokeRequestHandlerInternal(ViewBeanBase.java:740)
    10. com.iplanet.jato.view.ViewBeanBase.invokeRequestHandler(ViewBeanBase.java:571)
    11. com.iplanet.jato.ApplicationServletBase.dispatchRequest(ApplicationServletBase.java:957)
    12. com.iplanet.jato.ApplicationServletBase.processRequest(ApplicationServletBase.java:615)
    13. com.iplanet.jato.ApplicationServletBase.doPost(ApplicationServletBase.java:473)
    13 frames
  6. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    2 frames
  7. Glassfish Core
    StandardWrapperValve$1.run
    1. org.apache.catalina.core.StandardWrapperValve.invokeServletService(StandardWrapperValve.java:720)
    2. org.apache.catalina.core.StandardWrapperValve.access$000(StandardWrapperValve.java:118)
    3. org.apache.catalina.core.StandardWrapperValve$1.run(StandardWrapperValve.java:278)
    3 frames
  8. Java RT
    AccessController.doPrivileged
    1. java.security.AccessController.doPrivileged(Native Method)
    1 frame
  9. Glassfish Core
    StandardPipeline.invoke
    1. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:274)
    2. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505)
    3. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:212)
    4. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505)
    5. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:203)
    6. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505)
    6 frames
  10. com.iplanet.ias
    WebContainer.service
    1. com.iplanet.ias.web.connector.nsapi.NSAPIProcessor.process(NSAPIProcessor.java:157)
    2. com.iplanet.ias.web.WebContainer.service(WebContainer.java:598)
    2 frames