I have an application that is using Hibernate. It appears that I have to close the SessionFactory, then re-establish the SessionFactory and a new session to see updates done to the database by another application.

I this correct? I have this feeling that I am not doing something correct. Can anyone shed some light on this for me?

Thanks.

doh!

Must have a transaction around a read only query.
Must have a transaction around a read only query.
Must have a transaction around a read only query.
Must have a transaction around a read only query.
Must have a transaction around a read only query.
Must have a transaction around a read only query.
Must have a transaction around a read only query.
Must have a transaction around a read only query.

:)

You only want one SessionFactory, but you'll be creating many Session objects.

The Hibernate Session will cache changes and the entities you are using. If someone else updates the database underneath an active Session that is caching data, the Hibernate Session will get out of sync.

try to flush your data

and verify your results either querying from the same session or directly from the database

Thanks for the replies, but as I implied in my second post, I forgot to have my query in a transaction. Committing the transaction must do some cache updates or something that allow the query to be up to date.