hi,

Below is my observation:

1. Table A has 2 rows
2. Start a hibernate session
3. Remove one of the rows from table A using external operation (for example, manually remove it from some query browser)
4. Call findAll on the table A. It loads 2 entries, but I am expecting 1 as the db table A should only have 1 entry left after step 3

Is there any way to make step 4 loads from the DB of its current/latest status? I tried to call flush() on the hibernate session but it still shows 2 entries.

Or is it by definition that the hibernate session will ignore all the external changes to the DB once the session is started?

Many thanks in advance!

It is most likely a configuration issue for the "transaction isolation level" setting. Check your Hibernate configuration file for a setting named hibernate.connection.isolation. If it is not present, you should add it. The value is a number with 1=read uncommitted, 2=read committed, 4=repeatable read, 8=serializable

My guess is that you currently have 4 or 8, but what you really want is 2.

Thanks!!!

This totally solved my problem. We are using inno_db which is using REPEATABLE_READ.

I tried to set Isolation level earlier but Spring will not let me. However it works perfectly when I put it in the hibernate configuration file as suggested!

Again zillion thanks :) !