Hi Friends!
My problem as follows.,
In my project, we had the form used to display and edit user profile information. When users edit the form the values are updated to the database then i have to display the updated info on the form.
when i retrieve the updated value from DB through HQL, it retrieves only old data. But the DB has updated values..

we are using hibernate3.1 and mysql5.
i don't enable hibernate caching in hibernate.cfg.xml file.

i already tried session.evict and sessionFactory.evict methods. but no use, till now it retrieve only old values...

If you're updating using hibernate, then you should already have the updated record.

For example, calling recordObject.saveOrUpdate() will result in recordOjbect having the data of the updated record. You won't need to make a trip to the db to get the latest recordObject data.

Also, you may need to invalidate the user cache.