java.sql.SQLException: ORA-00904: "JMSMESSAGEID": invalid identifier ORA-06512: at "SYS.DBMS_AQIN", line 651 ORA-06512: at line 1at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :112)

Oracle Community | 334994 | 9 years ago
  1. 0

    java.sql.SQLException: ORA-00904: "JMSMESSAGEID": invalid identifier

    Oracle Community | 9 years ago | 334994
    java.sql.SQLException: ORA-00904: "JMSMESSAGEID": invalid identifier ORA-06512: at "SYS.DBMS_AQIN", line 651 ORA-06512: at line 1at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :112)
  2. 0

    Gradebook throws deadlock exceptions when updates grades for big classes. We have classes with more than 300 students. When instructors try to update grades, deadlock exceptions are thrown. Below attached error messages. Setting hibernate query locking mode to UPGRADE can help this situation. It uses "select for update" that query will wait indefinitely until the lock is released. Attached please fina a patch I created for this. Thanks, Chen org.sakaiproject.tool.api.ToolException: Exception while invoking expression #{assignmentDetailsBean.processUpdateScores} at org.sakaiproject.portal.charon.CharonPortal.forwardTool(CharonPortal.jav a:1244) caused by: javax.servlet.ServletException: Exception while invoking expression #{assignmentDetailsBean.processUpdateScores} at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:252) caused by: javax.faces.el.EvaluationException: Exception while invoking expression #{assignmentDetailsBean.processUpdateScores} at javax.faces.component.UICommand.broadcast(UICommand.java:86) caused by: org.springframework.dao.DeadlockLoserDataAccessException: Hibernate operation: could not update: [org.sakaiproject.tool.gradebook.CourseGradeRecord#1511523]; SQL [update GB_GRADE_RECORD_T set VERSION=?, GRADABLE_OBJECT_ID=?, STUDENT_ID=?, GRADER_ID=?, DATE_RECORDED=?, POINTS_EARNED=?, ENTERED_GRADE=?, SORT_GRADE=? where ID=? and VERSION=?]; ORA-00060: deadlock detected while waiting for resource ; nested exception is java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessEx ception(HibernateAccessor.java:424) caused by: java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11 2) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.jav a:216) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem ent.java:955) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement. java:1168) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare dStatement.java:3285) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS tatement.java:3368)

    Sakai JIRA | 1 decade ago | Chen Wen
    java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11 2)
  3. 0

    Rundeck 2.0.1 Integrating with Oracle Database

    Google Groups | 3 years ago | Sunil Tantry
    java.sql.SQLException: ORA-00942: table or view does not exist| at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JDBC driver problem

    Oracle Community | 9 years ago | 843804
    java.sql.SQLException: ORA-01745: invalid host/bind variable name at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
  6. 0

    data inserted but still giving java.sql.SQLException: ORA-00942: table or view does not exist

    Stack Overflow | 5 years ago | ct_anas
    java.sql.SQLException: ORA-00942: table or view does not exist

    1 unregistered visitors
    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.SQLException

      ORA-00904: "JMSMESSAGEID": invalid identifier ORA-06512: at "SYS.DBMS_AQIN", line 651 ORA-06512: at line 1at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :112)

      at oracle.jdbc.driver.T4CTTIoer.processError()
    2. Oracle jdbc
      T4C8Oall.receive
      1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
      3. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
      3 frames