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

incubator-sqoop-user | bejoy ks | 5 years ago
  1. 0

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

    incubator-sqoop-user | 5 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