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

Java.net JIRA | Dies Koper | 7 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded 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