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

incubator-sqoop-user | bejoy ks | 6 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

    Re: Fw: Fw: [sqoop-user] sqoop import shows ORA-00933: SQL command notproperlyended error

    incubator-sqoop-user | 6 years ago | bejoy ks
    java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  2. 0

    Oracle Import Error Using --direct Option

    sqoop-user | 1 year ago | Ted Dong
    java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  3. 0

    Oracle Import Error Using --direct Option

    sqoop-user | 1 year ago | Ted Dong
    java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hibernate says invalid identifier even if column is available in db

    Stack Overflow | 2 years ago | sr.praneeth
    java.sql.SQLSyntaxErrorException: ORA-00904: "TABLETYPE0_"."TTPNAME": invalid identifier
  6. 0

    AbstractSQLQuery listResults with offset and limit causes SQLSyntaxErrorException in Oracle11g

    GitHub | 5 years ago | dileeph
    com.mysema.query.QueryException: Caught SQLSyntaxErrorException for select * from ( select a.*, rownum rn from ( select bk.TITLE, bk.YAXIS, bk.BMK_TYPE, bk.XAXIS, bk.ZOOM, bk.USERID, bk.BOOKMARK_ID, bk.CLIPPING_STATUS, bk.DEFAULT_MAP, bk.MAP_TYPE, bk.ACCESS_TYPE, bk.TITLE, bk.YAXIS, bk.BMK_TYPE, bk.XAXIS, bk.ZOOM, bk.USERID, bk.BOOKMARK_ID, bk.CLIPPING_STATUS, bk.DEFAULT_MAP, bk.MAP_TYPE, bk.ACCESS_TYPE from BOOKMARK bk order by bk.BOOKMARK_ID asc ) a) where rn > 2 and rn <= 12
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.executeQuery
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
    13 frames
  3. com.quest.oraoop
    OraOopConnManager.getColTypesQuery
    1. com.quest.oraoop.OraOopOracleQueries.getTableColumns(OraOopOracleQueries.java:432)
    2. com.quest.oraoop.OraOopOracleQueries.getTableColumns(OraOopOracleQueries.java:538)
    3. com.quest.oraoop.OraOopOracleQueries.getTableColumnNames(OraOopOracleQueries.java:389)
    4. com.quest.oraoop.OraOopConnManager.getColumnNamesInOracleTable(OraOopConnManager.java:109)
    5. com.quest.oraoop.OraOopConnManager.getSelectedColumnNamesInOracleTable(OraOopConnManager.java:130)
    6. com.quest.oraoop.OraOopConnManager.getColTypesQuery(OraOopConnManager.java:193)
    6 frames
  4. com.cloudera.sqoop
    SqlManager.getColumnTypes
    1. com.cloudera.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:160)
    1 frame
  5. com.quest.oraoop
    OraOopConnManager.getColumnTypes
    1. com.quest.oraoop.OraOopConnManager.getColumnTypes(OraOopConnManager.java:455)
    1 frame
  6. com.cloudera.sqoop
    Sqoop.run
    1. com.cloudera.sqoop.orm.ClassWriter.generate(ClassWriter.java:908)
    2. com.cloudera.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
    3. com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:337)
    4. com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:423)
    5. com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
    5 frames
  7. Hadoop
    ToolRunner.run
    1. org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
    2. org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:79)
    2 frames
  8. com.cloudera.sqoop
    Sqoop.main
    1. com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
    2. com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:218)
    3. com.cloudera.sqoop.Sqoop.main(Sqoop.java:228)
    3 frames