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

Oracle Community | 785434 | 5 years 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 Installing CS delivery - Table or view does not exist?

    Oracle Community | 5 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 | 7 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 | 12 months ago | Aaaaaparz1
    java.sql.SQLSyntaxErrorException: ORA-00904: "AUTH_TOKEN": invalid identifier
  6. 0

    Calling StoredProcedure from TopLink

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