I am performing a DML Update statement to affect multiple rows in the database. Directly after the update statement but before the transaction has been committed I eagerly fetch the data via a select statement. I set the session cache mode to IGNORE so that the select statement bypasses the second-level cache. The entity in question does not reflect the updated values. Does anyone know why I cannot refresh the in-memory entity state? I can see that the values have been updated in the db.

Is the entity cached in the first-level/session cache? If so you may have to call session.clear() or session.evict() before the select statement.