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

Oracle Community | 2735416 | 2 years ago
  1. 0

    ODI-1224: Database error while connecting to work repository WORKREP_SIT

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

    Exception in thread "main" org.hibernate.exception.SQLGrammarException: ORA-00926: missing VALUES keyword

    Stack Overflow | 8 months ago | Harish Amarnath
    org.hibernate.exception.SQLGrammarException: ORA-00926: missing VALUES keyword
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Failed to navigate from RegistryWizardState :

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

    Framework Service configuration error 11.1.2.2

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

  1. mellson 1 times, last 4 months ago
  2. Jeremy 12 times, last 4 months ago
13 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.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:462)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)
    12 frames
  3. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor196.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  4. oracle.ucp.jdbc
    PreparedStatementProxyFactory.invoke
    1. oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:230)
    2. oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:124)
    2 frames
  5. Unknown
    $Proxy3.executeUpdate
    1. $Proxy3.executeUpdate(Unknown Source)
    1 frame
  6. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor196.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  7. oracle.odi.core
    RuntimeClassLoaderDataSourceCreator$StatementInvocationHandler.invoke
    1. oracle.odi.core.datasource.support.RuntimeClassLoaderDataSourceCreator$StatementInvocationHandler.invoke(RuntimeClassLoaderDataSourceCreator.java:173)
    1 frame
  8. Unknown
    $Proxy4.executeUpdate
    1. $Proxy4.executeUpdate(Unknown Source)
    1 frame
  9. com.sunopsis.sql
    SnpsQuery.executeUpdate
    1. com.sunopsis.sql.SnpsQuery.executeUpdate(SnpsQuery.java:712)
    1 frame
  10. com.sunopsis.dwg
    SnpSession.treatSession
    1. com.sunopsis.dwg.dbobj.SnpSession.updateSession(SnpSession.java:2928)
    2. com.sunopsis.dwg.dbobj.SnpSession.treatSessionPreTrt(SnpSession.java:2661)
    3. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1962)
    3 frames
  11. oracle.odi.runtime
    StartSessRequestProcessor$2.doAction
    1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
    1 frame
  12. oracle.odi.core
    DwgObjectTemplate.execute
    1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
    1 frame
  13. oracle.odi.runtime
    DefaultAgentTaskExecutor$2.run
    1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
    2. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
    3. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
    4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
    5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
    5 frames
  14. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:662)
    1 frame