I have just started using Hibernate (with Netbeans 6.1). Almost everything seems to be working properly.. I'm writing a small web application which uses a MySQL database.

I have a class 'User' which I am attempting to update. I make the changes to the User object, call session.save(u) and tx.commit() and I can see the changes in the database. So far, so good.

Now I log out of the web app and log back in as the user I just modified. And the field that got changed (an access control field named 'Role') shows the original value, not the changed value. If I kill Tomcat and restart it, then when I log in the new user Role value shows up.

Somehow, the original user information is being cached, and I don't see where that happens. Can someone point me in the right direction? When I logged in the second time, I reloaded the user from the database (I think) but that didn't seem to help.

Thanks very much,

nbc

if you use Hibernate to update your user and login and update happens in the same webapplication with the same sessionfactory and you haven't changed anything of the cache behaviour than it is probably you caching the user somewhere.

I have not changed the cache behavior. I use the following routine to read my user info from the database:

public void updateDpUser() {
List<User> listUser = null;
try {
Session session = HibernateUtil.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
Query q = session.createQuery("from User");
listUser = (List<User>) q.list();
} catch (Exception e) {
Logger.error("Failed to load users: Exception " + e);
}
dpUser = new User[listUser.size()];
int i = 0;
Logger.info("UPDATE DPUSER: There are " + dpUser.length + " users");
for (User u : listUser) {
dpUser[i++] = u;
u.dump();
}
}

This loads the user data and I can display it in a table. When I edit a user, I do the following to update it:

if (sb1.getBCreateUser() == true) {
editUser.setUserId((String) txt_UserId.getText());
hibernateSession.save(editUser);
} else {
hibernateSession.saveOrUpdate(editUser);
}
hibernateTx.commit();
sb1.updateDpUser(); // **** RELOAD THE DATA ARRAY FOR THE TABLE

The 'dump' call shows the ORIGINAL (unmodified) data. But a 'select * from users' in a mysql xterm window shows that the table has been modified. So when I call the updateDpUser it is picking up a cached version somewhere - and it isn't mine since I create a new array in updateDpUser... So can you tell me what I'm doing wrong?

Note that the failure is intermittent - sometimes the table will come back with the correct (updated) information and sometimes it won't. The fact that the 'dump' fails to reflect the change indicates to me that Hibernate has cached something...

Can you tell me how to clear the cache?? I tried adding a line that says

hibernateSession.setCacheMode(CacheMode.IGNORE) but that did not work.

thanks

nbc

I tend to agree that the application must be caching the object somewhere. Do a refresh call in your code, and set a breakpoint in it and inspect the value of the object coming back from Hibernate. Perhaps you are shadowing a variable somewhere?