Consider the following transactions with isolation level = READ_COMMITTED.

Tx-1
T1: Get object with id = 1. Returned object has name = "X"
T2: Sleep for 10 sec
T3: Get object with id = 1, Returned object has name = "X"

Tx-2
T2: Update name of object id = 1 to "Y"

Why is Hibernate not updating the name to "Y"? It does follow the isolation level if we delete object id = 1. In this case, it returns a NULL record.

What's the actual code you are using to test?

Not sure how useful the code will be. I want to know if the observed behavior is expected or not. When an object is already loaded in Hibenate session cache, any updates to this object outside the transaction does not seem to be reflected in this transaction.

Get object:
Criteria criteria = session.createCriteria(MyObject.class)
.add(Restrictions.eq("id", 123));
criteria.uniqueResult();

The update is done externally (outside of Java) using PostgreSQL client.