You'd be better off asking on a Hibernate forum for exact details of what Hibernate can determine from your query. But in general, if the stored procedure causes a change to happen in the database that isn't expressed in the SQL statement that you ask Hibernate to execute, Hibernate can't figure it out. It's great software but it's not magic. ;) BTW, this issue is not specific to a distributed 2nd level cache. The same problem exists with a non-distributed 2nd level cache. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4121104#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...