java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Oracle Community | 785434 | 4 years ago
  1. 0

    Error Installing CS delivery - Table or view does not exist?

    Oracle Community | 4 years ago | 785434
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  2. 0

    soa server throws exceptions while starting up

    Oracle Community | 6 years ago | 787651
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist Error Code: 942 Call: update MEDIATOR_CASE_INSTANCE set STATUS ='locked', LOCK_TIME =?, CONTAINER_ID =? where STATUS = 'ready' and rownum < ? bind => [2010-07-26 18:11:21.953, 7B8FCFE198B111DFBFEE53AED0E9F621, 10] Query: DataModifyQuery()
  3. 0

    JBatch- how change derby database to Oracle in jbatch config

    Stack Overflow | 2 years ago
    javax.batch.operations.JobStartException: com.ibm.jbatch.container.exception.PersistenceException: java.sql.SQLSyntaxErrorException: ORA-00922: missing or invalid option at com.ibm.jbatch.container.api.impl.JobOperatorImpl.start(JobOperatorImpl.java:90) ~[jsr352-SE-RI-runtime.jar:na]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Getting error while doing full deployment in BCC

    Oracle Community | 9 months ago | Aaaaaparz1
    java.sql.SQLSyntaxErrorException: ORA-00904: "AUTH_TOKEN": invalid identifier
  6. 0

    Calling StoredProcedure from TopLink

    Oracle Community | 8 years ago | 649006
    java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement Error Code: 900 Call: EXECUTE PROCEDURE Insert_Row(?, ?) bind => [0, test@test.com] Query: DataModifyQuery()
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.SQLSyntaxErrorException

    ORA-00942: table or view does not exist

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeUpdate
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3674)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1354)
    12 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.executeUpdate
    1. weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
    1 frame
  4. COM.FutureTense.Servlet
    JDBCTable.AddRow
    1. COM.FutureTense.Servlet.JDBCTable.executeUpdate_trans_logic(JDBCTable.java:1367)
    2. COM.FutureTense.Servlet.JDBCTable.executeUpdate_trans(JDBCTable.java:1337)
    3. COM.FutureTense.Servlet.JDBCTable.executeUpdate(JDBCTable.java:1211)
    4. COM.FutureTense.Servlet.JDBCTable.AddRow(JDBCTable.java:943)
    4 frames
  5. COM.FutureTense.Common
    ftDBTable.insertRow
    1. COM.FutureTense.Common.ftDBTable.insertRow(ftDBTable.java:1271)
    1 frame
  6. COM.FutureTense.CatalogManager
    CatalogEngine.addToTable
    1. COM.FutureTense.CatalogManager.CatalogEngine.addToTable_trans(CatalogEngine.java:820)
    2. COM.FutureTense.CatalogManager.CatalogEngine.addToTable(CatalogEngine.java:705)
    2 frames
  7. COM.FutureTense.Common
    CS.CatalogManager
    1. COM.FutureTense.Common.CatalogManager.execute(CatalogManager.java:752)
    2. COM.FutureTense.Common.ContentServer.runManager(ContentServer.java:3338)
    3. COM.FutureTense.Common.CS.CatalogManager(CS.java:1501)
    4. COM.FutureTense.Common.CS.CatalogManager(CS.java:1456)
    4 frames
  8. com.openmarket.visitor
    VisitorDataManager.worker
    1. com.openmarket.visitor.data.AbstractPersistentObject.callCatalogManager(AbstractPersistentObject.java:156)
    2. com.openmarket.visitor.data.AbstractPersistentObject.executeWrite(AbstractPersistentObject.java:1343)
    3. com.openmarket.visitor.data.AbstractPersistentObject.writeObject(AbstractPersistentObject.java:856)
    4. com.openmarket.visitor.data.PersistentVisitorDataConnection.createAccessMethod(PersistentVisitorDataConnection.java:315)
    5. com.openmarket.visitor.seed.VisitorDataManager.worker(VisitorDataManager.java:334)
    5 frames
  9. com.openmarket.basic
    BaseSeed.endTag
    1. com.openmarket.basic.seed.BaseSeed.endTag(BaseSeed.java:263)
    1 frame
  10. COM.FutureTense.XML
    XMLEval.run
    1. COM.FutureTense.XML.Template.DynTag.execute(DynTag.java:218)
    2. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
    3. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
    4. COM.FutureTense.XML.Template.Root.execute(BlockTag.java:365)
    5. COM.FutureTense.XML.Template.XMLEval.run(XMLEval.java:331)
    5 frames
  11. COM.FutureTense.Common
    ContentServer.processElement
    1. COM.FutureTense.Common.ContentServer.evalTheXML(ContentServer.java:3186)
    2. COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:2447)
    3. COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:1895)
    3 frames
  12. COM.FutureTense.XML
    XMLEval.run
    1. COM.FutureTense.XML.Template.CallElement.execute(CallTag.java:253)
    2. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
    3. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
    4. COM.FutureTense.XML.Template.IfChild.execute(BlockTag.java:397)
    5. COM.FutureTense.XML.Template.IFTag.execute(BlockTag.java:496)
    6. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
    7. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
    8. COM.FutureTense.XML.Template.IfChild.execute(BlockTag.java:397)
    9. COM.FutureTense.XML.Template.IFTag.execute(BlockTag.java:496)
    10. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
    11. COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
    12. COM.FutureTense.XML.Template.Root.execute(BlockTag.java:365)
    13. COM.FutureTense.XML.Template.XMLEval.run(XMLEval.java:331)
    13 frames
  13. COM.FutureTense.Common
    CS.CallElement
    1. COM.FutureTense.Common.ContentServer.evalTheXML(ContentServer.java:3186)
    2. COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:2447)
    3. COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:1895)
    4. COM.FutureTense.Common.CS.CallElement(CS.java:1599)
    4 frames
  14. COM.FutureTense.Apps
    InstallServer.evalPage
    1. COM.FutureTense.Apps.Install.command.ReadURL.exec(ReadURL.java:169)
    2. COM.FutureTense.Apps.Install.command.Command.execute(Command.java:130)
    3. COM.FutureTense.Apps.Install.server.InstallManager.invokeCommand(InstallManager.java:479)
    4. COM.FutureTense.Apps.Install.server.InstallManager.execute(InstallManager.java:104)
    5. COM.FutureTense.Apps.Install.server.InstallServer.evalPage(InstallServer.java:123)
    5 frames
  15. COM.FutureTense.Common
    ContentServer.execute
    1. COM.FutureTense.Common.ContentServer.execute(ContentServer.java:453)
    1 frame
  16. COM.FutureTense.Servlet
    FTServlet.doGet
    1. COM.FutureTense.Servlet.FTServlet.execute(FTServlet.java:129)
    2. COM.FutureTense.Servlet.FTServlet.doGet(FTServlet.java:53)
    2 frames
  17. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    2 frames
  18. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
    2. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
    3. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
    4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
    5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    5 frames
  19. com.fatwire.wem
    SSOFilter.doFilter
    1. com.fatwire.wem.sso.cas.filter.CASFilter.doFilter(CASFilter.java:557)
    2. com.fatwire.wem.sso.SSOFilter.doFilter(SSOFilter.java:51)
    2 frames
  20. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
    3. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
    3 frames
  21. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  22. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    1 frame
  23. Atmosphere weblogic
    ServletRequestImpl.run
    1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
    2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
    3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
    3 frames
  24. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
    2 frames