Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate3.0.1

Oracle9i

Hi Guys,

We have problem with session.flush() usage.We are using the session-per-request pattern.We call session.flush() even when we are fetching objects from DB and also when are persisting them to DB.My question is should we explicitly call session.flush() when we are listing the objects using query.list() , session.get() ,criteria.list() calls ?What is the ideal scenario where it has to be called ?How should we keep our session in sync with DB always ?

Thanks ,
Neil.
OSI Technologies.

Usually you dont need to call session.flush(). Especially in the cases you mentioned.

session.flush() is useful in cases you need the primary key for further processing (before the commit).

If you're using the session-per-request pattern with Hibernates contextual sessions and you're using the default FlushMode of AUTO, Hibernate will automatically flush the session when one of the following happens:

The Transaction is commited
A Query is executed
You explicitly call session.flush()

With the defaults, Hibernate will make sure you're not making dirty reads and this is how Hibernate automagically keeps your session in sync.

Ryan-