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

Hibernate version:2.1

Hello

i have very interesting problem.

my web application is running and client is using the aplication and everything goes fine. client can edit any data on the page and view the modifed data and so on. so no problem.
but
when i modify some data from console of mysql(REMEMBER: DIRECTLY USING MYSQL), then when the client refresh the page he is seeing old data!

but when i restart tomcat then my application works successfully.

pls tell me the reason behind that.

Thank You

Chinmoy

Cache ?????

sorry i cant understadnd what u said.
pls write in details.

Thank You

Chinmoy

If you make some changes using direct SQL, you need to use session.refresh() on the objects you have loaded. Hibernate uses an object cache and you are making changes without notifying it to Hibernate.

Bye.

Hi,

The value will not be there in 1st level cache. So what you need to do is to refresh the session which will refresh the Cache too.

session.refresh(obj);

Is that Clear now?

hello

thanks for ur reply. and things now clear to me.
so it is not possible to see changed data without restarting the tomcat.
am i write?

Thank you

Chinmoy

go learn about proper usage of sessions.

You should not just use a single one forever.

i am using eclipse plugin for hibernate(hibernate syncronizer) that autometiically generates
DAO classes and others. it can give u session with getSession() method and can close seesion using closeSession() method.

so when i used this method i always uses session for any busness operation and closes it when it finishes.

just like the following code:

###############################
session = getSession();



Company company=(Company)session.load(Company.class,companyOid);





divisions=company.getDivisions();



tempDivisions=new ArrayList();





for (Iterator i = divisions.iterator(); i.hasNext();) {

Division division = (Division) i.next();



tempDivisions.add(division);





}



closeSession();
#########################################
what more i can do?

chinmoy

If you also properly begin and commit your transaction you should not read old data.

No need to restart Tomcat. Tomcat has it's own caches for web processing, but people in this thread are talking about Hibernate's data cache.

Hibernate keeps the data for the objects in an array-based format (or something like that), and then rebuilds objects from this in-memory data cache. If the database changes, this in-memory representation of the data will not be updated unless you configure Hibernate to refresh the cache. You can programmatically configure this and no need to restart Hibernate.

Look for articles on using Hibernate with a shared database -- by writing directly to the DB you are simulating a situation where other processes are using the same DB as Hibernate.

that is only relevant when using 2nd level cache.

How can i programmatically configure to refresh the cache?
is there any ariticle or any example?

Chinmoy