[hibernate-issues] [Hibernate-JIRA] Created: (HHH-7315) EntityManager will not PESSIMISTIC lock a parent class of JOINED inheritance

[Bryan Varner (JIRA)]

EntityManager will not PESSIMISTIC lock a parent class of JOINED inheritance
----------------------------------------------------------------------------

                 Key: HHH-7315
                 URL: https://hibernate.onjira.com/browse/HHH-7315
             Project: Hibernate ORM
          Issue Type: Bug
          Components: entity-manager
    Affects Versions: 4.1.3, 4.1.2
         Environment: Hibernate 4.1.2, 4.1.3, PostgreSQL 9.1
            Reporter: Bryan Varner


Given a JPA class Hierarchy like:

{code}
@Entity(name = "BaseThing")
@Table(name = "BaseThing")
@Inheritance(strategy = InheritanceType.JOINED)
public abstract class BaseThing implements Serializable {
    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "BaseThing_id_seq")
    @SequenceGenerator(name = "BaseThing_id_seq", sequenceName = "BaseThing_id_seq", allocationSize = 50)
    @Column(name = "id", nullable = false)
    private Long id;

    @Basic(optional = false)
    @Column(name = "name", nullable = false, length = 48)
    private String name;

    @Version
    @Column(name = "version")
    private int version;
    
    ...
}


@Entity(name = "ConcreteThing")
@Table(name = "ConcreteThing")
@PrimaryKeyJoinColumn(name = "id", referencedColumnName = "id")
public class ConcreteThing extends BaseThing {
    private static final long serialVersionUID = 1L;

    @Basic(optional = false)
    @Column(name = "aprop", nullable = false, length = 12)
    private String aProp;

    ...
}


@Entity(name = "AnotherConcreteThing")
@Table(name = "AnotherConcreteThing")
@PrimaryKeyJoinColumn(name = "id", referencedColumnName = "id")
public class AnotherConcreteThing extends BaseThing {
    private static final long serialVersionUID = 1L;

    @Basic(optional = false)
    @Column(name = "anotherprop", nullable = false, length = 12)
    private String anotherProp;

    ...
}
{code}

Invoking the following code fails to generate a query with a FOR UPDATE clause.
{code}
entityManager.find(BaseThing.class, 0, LockModeType.PESSIMISTIC_WRITE);
{code}

Inspecting the LockMode on the returned object results in the following behavior...

{code}
BaseThing obj = entityManager.find(BaseThing.class, 0, LockModeType.PESSIMISTIC_WRITE);

// The PESSIMISTIC_WRITE lock requirement is totally ignored, and the object is returned with OPTIMISTIC.
// If you try to promote the lock to PESSIMISTIC_WRITE...
if (entityManager.getLockMode(obj).equals(LockModeType.OPTIMISTIC)) {
    entityManager.lock(obj, LockModeType.PESSIMISTIC_WRITE);
}

// It looks like it's succesfull
if (entityManager.getLockMode(obj).equals(LockModeType.PESSIMISTIC_WRITE)) {
    System.out.println("Hurray!");
}

// HOWEVER... There's not any SQL generated. AT ALL, by the lock() method, and there is no lock in the database.
{code}

So I suppose this bug it two-fold.

1.) You can't get a PESSIMISTIC lock on anything that results in a left outer join to get the polymorphic query results.
2.) You can't promote the optimistic locks for those polymorphic objects into a PESSIMISTIC lock.





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