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
  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]
  3. 0

    Query under Transaction Exception....

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: DB2 SQL error: SQLCODE: -511, SQLSTATE: 42829, SQLERRMC: null {prepstmnt 107840951 SELECT t0.GROUPSETTINGID, t0.ALLOWDRAW, t0.ALLOWSTRIKE, t0.ALLOWTRANSFER, t0.ASCENDONLY, t0.AUTOAPPROVE, t0.BARVISIBLE, t0.DEFAULTLEVELNAME, t0.LASTMODIFY, t0.MAXDRAW, t0.MAXRECHARGE, t0.MAXROWS, t0.MAXSTRIKE, t0.MAXTRANSFER, t0.MINDRAW, t0.MINRECHARGE, t0.MINSTRIKE, t0.MINTRANSFER, t0.GROUPID, t0.RECHARGEABLE, t0.USERTYPEMODIFICATION FROM OLTP.GROUPSETTING t0 INNER JOIN OLTP.ORGANGROUP t1 ON t0.GROUPID = t1.GROUPID WHERE (t1.GROUPID = ?) FOR UPDATE [reused=0]} [code=-511, state=42829]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Kodo v4.0.0EA2 Bugs List

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: ERROR: relation "kodo_sequence_table" does not exist {prepstmnt 31538514 SELECT SEQUENCE_VALUE FROM KODO_SEQUENCE_TABLE WHERE ID = ? FOR UPDATE [reused=0]} [code=0, state=42P01]
  6. 0

    Webstart Issue

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The cursor was not declared.

    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. 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