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

Hibernate JIRA | Grzegorz Glowaty | 1 decade ago
  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 native SQL error

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

    JasperReports: How to put more than 1000 values in a list into $X() statement

    Stack Overflow | 3 years ago | rocks_90
    net.sf.jasperreports.engine.JRException: Error executing SQL statement for : report name

    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