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.

Call session.flush() when you persist the object to the DB.

i.e)
session.save(obj)
session.flush()

session.saveOrupdate(obj)
session.flush()
session.update(obj)
session.flush()

session.delete(obj)
session.flush()

So that you can see the inserted record in the list when you retrieve from the table.