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

Java.net JIRA | Dies Koper | 7 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

    In-flight transactions recovery fails (vs. server crash that should work correctly accordingly to Marina, I have not tried). On Oracle, using the test application and instructions from issue #11409 to create an in-doubt transaction, followed by 'asadmin recover-transactions server', the following error messages are seen in server.log. The database remains in 'in-doubt' state. [#|2010-02-02T12:53:22.678+1100|INFO|glassfishv3.0|javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors.inbound|_ThreadID=34;_ThreadName=Thread-1;|Recovery of Inbound Transactions started.|#] [#|2010-02-02T12:53:22.694+1100|WARNING|glassfishv3.0|javax.enterprise.resource.resourceadapter.com.sun.enterprise.resource.recovery|_ThreadID=34;_ThreadName=Thread-1;|RAR5005:Error in accessing XA resource with JNDI name [__TimerPool] for recovery|#] [#|2010-02-02T12:53:22.740+1100|WARNING|glassfishv3.0|javax.enterprise.resource.resourceadapter.com.sun.enterprise.resource.recovery|_ThreadID=34;_ThreadName=Thread-1;|RAR5005:Error in accessing XA resource with JNDI name [ora1] for recovery|#] [#|2010-02-02T12:53:22.944+1100|WARNING|glassfishv3.0|javax.enterprise.resource.resourceadapter.com.sun.enterprise.resource.recovery|_ThreadID=34;_ThreadName=Thread-1;|RAR5005:Error in accessing XA resource with JNDI name [ora2] for recovery|#] On Derby, Marina reported seeing another error message: JTS5029: Exception [org.omg.CORBA.INTERNAL: vmcid: 0x0 minor code: 0 completed: Maybe] on [OTSResource rollback] operation during resync. I saw a different error message on Derby too (might have been JTS5029), but unfortunately did not back up the log file.

    Java.net JIRA | 7 years ago | Dies Koper
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  2. 0

    error on an xa_recover operation.

    Oracle Community | 1 decade ago | 484415
    javax.transaction.xa.XAException
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Problems with XATransactions

    Oracle Community | 1 decade ago | 843859
    javax.transaction.xa.XAException

    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 com.sun.enterprise.transaction.jts.recovery.OracleXAResource.recoverList()
    2. Embedded GlassFish Web
      ResourceRecoveryManagerImpl.recoverIncompleteTx
      1. com.sun.enterprise.transaction.jts.recovery.OracleXAResource.recoverList(OracleXAResource.java:116)
      2. com.sun.enterprise.transaction.jts.recovery.OracleXAResource.recover(OracleXAResource.java:85)
      3. com.sun.jts.CosTransactions.RecoveryManager.getInDoubtXids(RecoveryManager.java:883)
      4. com.sun.jts.CosTransactions.RecoveryManager.recoverIncompleteTx(RecoveryManager.java:1464)
      5. com.sun.enterprise.transaction.jts.ResourceRecoveryManagerImpl.recoverIncompleteTx(ResourceRecoveryManagerImpl.java:130)
      5 frames