I have a testcase which use the JPA Transaction Manager, transaction annotation to open a transaction.

once the transaction is open, that is the flow is inside the method , I put a breakpoint.
Now I modify the first name of teh record that is going to be fetched from the method from DB visualizer.(It is on auto commit).

no I release the break point , and let it read the value from the database. I see the hibernate select query in then console, but when i see the first name, then it has the old value.

I am using this test case to replicate my issue.

I have tried different isolation level, like read_commited, read_uncommited.

I am not able to understand why is it not fetching the updated value when the value was updated after the transaction was open, but not closed.

Please advice.

I am using SPring , JPA, Hibernate as the JPA implementer . The database is DB2