Hi All,


I want to retrieve updated values from table using select query.
I used session.flush but it didnt worked.
my criteria is as below:

List lst = session.createCriteria(Entity.class).list();

when i navigate back ,even though changes in the DB , it does not reflect in the result set.

Please let me know what i should go for.

Thanks in advance.

--Sidh

Who is updating the values, if not your Hibernate Session?

If you close the Session and reopen it again, do you get the latest values?

Hibernate maintains a cache of data so round trips to the database aren't required. If someone undermines Hibernate with direct database updates, you're in trouble.

Close the Session and open a new Hibernate Session and you should get the updated, uncached values. You could also rerun the query or try to do a refresh. Otherwise, you may want to lock your table when Hibernate has selected values.

Hi Cameron,

Thanks for the reply. Some owner is responsible for updating the values in the table. Im using hibernate pagination , and closing and opening session for every page , still not getting the updated values.

as im using session criteria for selection of values , not able to refresh the session , is there is any way for doing this?

Please let me know your views on same.

Its required for me to fetch the updated records . even the record has updated in between the page navigation .

Thanks,
--Sidh