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

Oracle Community | user12866742 | 1 year ago
  1. 0

    ODI Inserting to C$ filter is failing while running interface using package and load plan

    Oracle Community | 1 year ago | user12866742
    java.sql.BatchUpdateException: ORA-00942: table or view does not exist
  2. 0

    Mapping issue !

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

    Update non-existent table - crash ORA-00942

    Stack Overflow | 6 years ago | Ten_of_a_Kind
    java.sql.BatchUpdateException: ORA-00942: table or view does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hibernate Oracle Create table

    Stack Overflow | 2 years ago | Gercek Ad
    org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update

  1. r1chjames 10 times, last 6 months ago
12 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.BatchUpdateException

    ORA-00942: table or view does not exist

    at oracle.jdbc.driver.OraclePreparedStatement.executeBatch()
  2. Oracle jdbc
    OracleStatementWrapper.executeBatch
    1. oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:15709)
    2. oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:264)
    2 frames
  3. oracle.odi.runtime
    OdiJob.call
    1. oracle.odi.runtime.agent.execution.sql.BatchSQLCommand.executeBatch(BatchSQLCommand.java:110)
    2. oracle.odi.runtime.agent.execution.sql.BatchSQLCommand.execute(BatchSQLCommand.java:68)
    3. oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:141)
    4. oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:28)
    5. oracle.odi.runtime.agent.execution.Executor.performAction(Executor.java:449)
    6. oracle.odi.runtime.agent.execution.Executor.invokeOnThread(Executor.java:127)
    7. oracle.odi.runtime.agent.execution.sql.concurrent.ExecutorController$ThreadedExecutor.call(ExecutorController.java:423)
    8. oracle.odi.runtime.agent.execution.sql.concurrent.ExecutorController$ThreadedExecutor.call(ExecutorController.java:355)
    9. oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
    10. oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
    10 frames
  4. Java RT
    Thread.run
    1. java.util.concurrent.FutureTask.run(FutureTask.java:262)
    2. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    3. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    4. java.lang.Thread.run(Thread.java:744)
    4 frames