From noreply at atlassian.com Mon Feb 27 03:06:49 2012
Content-Type: multipart/mixed; boundary="===============0782832395393756507=="
MIME-Version: 1.0
From: Strong Liu (JIRA) <noreply at atlassian.com>
To: hibernate-issues at lists.jboss.org
Subject: [hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1512) Problem to
 lock a row in a DB2 database with LockMode UPGRADE
Date: Mon, 27 Feb 2012 02:06:49 -0600
Message-ID: <28110930.930.1330330009443.JavaMail.j2ee-onjira@hibernate.onjira.com>

--===============0782832395393756507==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


    [ https://hibernate.onjira.com/browse/HHH-1512?page=3Dcom.atlassian.jir=
a.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D45698#co=
mment-45698 ] =


Strong Liu commented on HHH-1512:
---------------------------------

confirm 1,2,5,6,7 all work with _org.hibernate.test.locking.LockModeTest_

> Problem to lock a row in a DB2 database with LockMode UPGRADE
> -------------------------------------------------------------
>
>                 Key: HHH-1512
>                 URL: https://hibernate.onjira.com/browse/HHH-1512
>             Project: Hibernate ORM
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.1
>         Environment: DB2 v8.2, Hibernate 3.1 and higher
>            Reporter: Peter Potthoff
>            Assignee: Steve Ebersole
>         Attachments: locks.txt
>
>   Original Estimate: 1h
>  Remaining Estimate: 1h
>
> Using the LockMode UPGRADE to lock a row in the database, this will resul=
t in
> a sql-statement: select ID from <schema>.<table> where ID =3D? and versio=
n =3D? for read only with rs
> This statement produces a shared lock and cannot be used for pessimistic =
locking because
> this kind of lock won't stop a concurrent thread from accessing the data.
> The source of the class DB2Dialect.java was changed from release 1.34 to =
1.35:
> http://cvs.sourceforge.net/viewcvs.py/hibernate/Hibernate3/src/org/hibern=
ate/dialect/DB2Dialect.java?r1=3D1.34&r2=3D1.35
> and from 1.33 to 1.34
> http://cvs.sourceforge.net/viewcvs.py/hibernate/Hibernate3/src/org/hibern=
ate/dialect/DB2Dialect.java?r1=3D1.33&r2=3D1.34
> Please take a look at: HHH-378 and http://forum.hibernate.org/viewtopic.p=
hp?t=3D954639&highlight=3Ddb2+lock+upgrade

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

       =20

--===============0782832395393756507==--