OpenJPA
  1. OpenJPA
  2. OPENJPA-991

Implement LockTimeout using db specific server-side lock timeout feature

    Details

    • Type: Improvement Improvement
    • Status: Reopened
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 1.0.4, 1.1.1, 1.2.2, 1.3.0, 2.0.0, 2.2.0, 2.3.0
    • Fix Version/s: None
    • Component/s: kernel
    • Labels:
      None

      Description

      This issue is originally reported by Donald Woods in OPENJPA-957.

      "Looks like the existing implementation (not defined in JPA 1.0 Spec and OpenJPA specific) is using setQueryTimeout() in PessimisticLockManager, which is a client side JDBC timeout function, while lock timeouts are implemented in the DB server. See -
      DB2 - http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0011874.htm
      MS SQL - http://msdn.microsoft.com/en-us/library/aa213032(SQL.80).aspx
      Derby - config property - http://db.apache.org/derby/docs/dev/devguide/cdevconcepts16400.html
      Oracle - LOCKWAIT on the connection or on the DB
      Also, the following discussion gives a good overview of the two and why apps should use both to handle unreliable network conditions -
      http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/95755534-bbef-4c2c-afa4-b80ca2a2c333/"

      This issue caused TestException.testThrowsOptimisticException to hang when run against DB2 because the default lock timeout is -1 on DB2, which means to wait forever. This test case will be disabled until the issue is resolved and re-enabled.

      Albert Lee.

        Issue Links

          Activity

          Albert Lee created issue -
          Donald Woods made changes -
          Field Original Value New Value
          Link This issue is related to OPENJPA-957 [ OPENJPA-957 ]
          Donald Woods made changes -
          Affects Version/s 2.0.0 [ 12314019 ]
          Affects Version/s 2.0.0-M2 [ 12313483 ]
          Michael Dick made changes -
          Fix Version/s 1.2.2 [ 12313681 ]
          Fix Version/s 2.0.0 [ 12314019 ]
          Michael Dick made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Donald Woods made changes -
          Fix Version/s 2.0.0-beta [ 12314149 ]
          Fix Version/s 2.0.0 [ 12314019 ]
          Donald Woods made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Pinaki Poddar made changes -
          Link This issue relates to OPENJPA-1565 [ OPENJPA-1565 ]
          Donald Woods made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Donald Woods made changes -
          Fix Version/s 2.1.0 [ 12314542 ]
          Fix Version/s 1.2.2 [ 12313681 ]
          Fix Version/s 2.0.0-beta [ 12314149 ]
          Donald Woods made changes -
          Link This issue relates to OPENJPA-1594 [ OPENJPA-1594 ]
          Michael Dick made changes -
          Fix Version/s 2.2.0 [ 12315910 ]
          Fix Version/s 2.1.0 [ 12314542 ]
          Albert Lee made changes -
          Fix Version/s 2.3.0 [ 12319463 ]
          Fix Version/s 2.2.0 [ 12315910 ]
          Affects Version/s 2.2.0 [ 12315910 ]
          Albert Lee made changes -
          Fix Version/s 2.3.0 [ 12319463 ]
          Affects Version/s 2.3.0 [ 12319463 ]

            People

            • Assignee:
              Unassigned
              Reporter:
              Albert Lee
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:

                Development