java.sql.SQLException: ORA-00942: table or view doesn't exist

Hibernate JIRA | Grzegorz Glowaty | 1 decade ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    It seems like fix in version 2.1.7c which quotes table name in the query selecting max value from the primary key column broken increment generator on Oracle. Oracle gives error: java.sql.SQLException: ORA-00942: table or view doesn't exist at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:651) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2117) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2331) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:422) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:366) at net.sf.hibernate.id.IncrementGenerator.getNext(IncrementGenerator.java:68) at net.sf.hibernate.id.IncrementGenerator.generate(IncrementGenerator.java:42) at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:774) at net.sf.hibernate.impl.SessionImpl.doCopy(SessionImpl.java:4062) The problem is Oracle doesn't allow quotes around table name in the query. My suggestion is to ask Dialect (is it possible to add new function to the Dialect?) to know if quoting table names is ever possible. As I noticed adding those quotes fixed some other bug :) But produced another ;)

    Hibernate JIRA | 1 decade ago | Grzegorz Glowaty
    java.sql.SQLException: ORA-00942: table or view doesn't exist
  2. 0

    It seems like fix in version 2.1.7c which quotes table name in the query selecting max value from the primary key column broken increment generator on Oracle. Oracle gives error: java.sql.SQLException: ORA-00942: table or view doesn't exist at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:651) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2117) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2331) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:422) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:366) at net.sf.hibernate.id.IncrementGenerator.getNext(IncrementGenerator.java:68) at net.sf.hibernate.id.IncrementGenerator.generate(IncrementGenerator.java:42) at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:774) at net.sf.hibernate.impl.SessionImpl.doCopy(SessionImpl.java:4062) The problem is Oracle doesn't allow quotes around table name in the query. My suggestion is to ask Dialect (is it possible to add new function to the Dialect?) to know if quoting table names is ever possible. As I noticed adding those quotes fixed some other bug :) But produced another ;)

    Hibernate JIRA | 1 decade ago | Grzegorz Glowaty
    java.sql.SQLException: ORA-00942: table or view doesn't exist
  3. 0

    10gLiteR3 publishing ORA-00942: table or view does not exist error

    Oracle Community | 9 years ago | 589502
    java.sql.SQLException: ORA-00942: table or view does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hibernate exception

    Coderanch | 6 years ago | S. M. Sabbir
    java.sql.SQLException: ORA-00942: table or view does not exist
  6. 0

    Hibernate native SQL error

    Stack Overflow | 6 years ago | Neel
    org.hibernate.exception.SQLGrammarException: could not execute query

  1. rp 1 times, last 3 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-00942: table or view doesn't exist

    at oracle.jdbc.dbaccess.DBError.throwSqlException()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
    1 frame
  3. oracle.jdbc.ttc7
    TTC7Protocol.parseExecuteDescribe
    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:1451)
    4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:651)
    4 frames
  4. Oracle jdbc
    OraclePreparedStatement.executeQuery
    1. oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2117)
    2. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2331)
    3. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:422)
    4. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:366)
    4 frames
  5. net.sf.hibernate
    SessionImpl.doCopy
    1. net.sf.hibernate.id.IncrementGenerator.getNext(IncrementGenerator.java:68)
    2. net.sf.hibernate.id.IncrementGenerator.generate(IncrementGenerator.java:42)
    3. net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:774)
    4. net.sf.hibernate.impl.SessionImpl.doCopy(SessionImpl.java:4062)
    4 frames