I have a situation today where the following method is returning a stale version of an object. When I look at the database, it is current! I have set a break point in my IDE and drilled into the PersistentContext. I see the object in the entityByKey Map, and it is stale. Any ideas?

public Object getObject(Class clazz, Long id) {
try {
begin();
Object o = sess.get(clazz, id);
commit();
log.debug("getObject(Class clazz, long id) returning:" + o);
return o;
} catch (HibernateException e) {
log.error(e);
commit();
return null;
}
}

Thanks,
Scott

Is session.close() required in 3.1? Also, what are the implications of

<property name="transaction.auto_close_session">true</property>

I have been chasing the strangest problems between the data in the database and the object representation as per sess.get(id). I happened on to this hibernate property, and it seems to have fixed everything! I have read the docs and also own the new JPA book. If this discussion is in either place, can you please refer me to the reading. I realize this ties into TX, but either it is not well explained or is in the wrong location.

On page 388 in JPA, the first line on the page discusses a UOW ending and closing the persistence context. Wow! Where is the UOW formally defined and what is meant by closing the persistence context? Is this closing the session, and now we are back to the original question!

Scott