I have a database table with a version column, which is used by Hibernate to keep track of versioning. The table also has a trigger to ensure version value will increase whenver a update happens.

After rows in that table were updated by a different process, I ran a select query from Hibernate. The result was not what's in the database but a cached version from the current session.

I understand versioning in Hibernate might be designed to just handle concurrent update. But is there a way to make Hibernate smart enough to pick up the latest version when a outside update has occurred?

Thanks.

-Ken

session.refresh(o) ?

But isn't refreshing on a versioned/optimistic locked row against it's use ? ;)