java.sql.SQLException

If you like a tip written by other Samebug users, mark is as helpful! Marks help our algorithm provide you better solutions and also help other users.
tip

This is a bug in version 4.1.9 and it's fixed from version 4.3.0beta and beyond.

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • Rundeck 2.0.1 Integrating with Oracle Database
    via by Sunil Tantry,
  • 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)
    via by Chen Wen,
  • JDBC driver problem
    via by 843804,
  • ORA-01654: unable to extend index
    via Stack Overflow by Karl
    ,
  • OpenUDDI / Mailing Lists
    via by Unknown author,
    • java.sql.SQLException: ORA-00942: table or view does not exist| at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) 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)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    tomthomas
    1 times, last one,
    tzrlk
    10 times, last one,
    treefolk
    6 times, last one,
    46 more bugmates