com.solarmetric.jdbc.ReportingSQLException: ORA-00942: table or view does not exist {prepstmnt 7569347 SELECT SEQUENCEX FROM MARY.JDO_SEQUENCEX WHERE PKX = ? FOR UPDATE [reused=0]} [code=942, state=42000]

Oracle Community | 3004 | 1 decade 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

    Multiple Kodo Datasources in WebLogic 8.1 using JCA - How?

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: ORA-00942: table or view does not exist {prepstmnt 7569347 SELECT SEQUENCEX FROM MARY.JDO_SEQUENCEX WHERE PKX = ? FOR UPDATE [reused=0]} [code=942, state=42000]
  2. 0

    SQL Server error

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: [Microsoft][SQLServer 2000 Driver fo r JDBC]Can't start a cloned connection while in manual transaction mode. {SELECT SEQUENCE_VALUE FROM JDO_SEQUENCE WHERE ID = ?} [code=0, state=08007]

    Root Cause Analysis

    1. com.solarmetric.jdbc.ReportingSQLException

      ORA-00942: table or view does not exist {prepstmnt 7569347 SELECT SEQUENCEX FROM MARY.JDO_SEQUENCEX WHERE PKX = ? FOR UPDATE [reused=0]} [code=942, state=42000]

      at kodo.jdbc.schema.DBSequenceFactory.getNext()
    2. kodo.jdbc.schema
      DBSequenceFactory.getNext
      1. kodo.jdbc.schema.DBSequenceFactory.getNext(DBSequenceFactory.java:227)
      1 frame