[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5870?page=c... ] Gail Badner commented on HHH-5870: ---------------------------------- Please provide a runnable test case that reproduces this issue. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5870?page=c... ] nodje edited comment on HHH-5870 at 1/27/11 5:08 AM: ----------------------------------------------------- I can't quickly post a test case. It is rather difficult to build one. Webapp boiler plate code + database + mapping + test case ... I hope just listing the code that is processed in the scenario can make sense for someone familiar with it: Imagine the following code: SQLQuery query = session.createSQLQuery("sqlQueryString").setCacheable(true); Session:730 SessionImpl:1776 AbstractSessionImpl:146 new SQLQueryImpl SQLQueryImpl:138 <--- this is were the problem originate from: querySpaces = null (SQLQueryImpl:141). They'll never be any space added. The only way to add some seems to be SQLQueryImpl:366 addSynchronizedQuerySpace(...) - undocumented Then call a query.list(); SQLQueryImpl:149 SessionImplementor:221 AbstractSessionImpl:165 SessionImplementor:204 SessionImpl:1835 CustomLoader loader is instanciated with quesySpaces from the customQuery: null SessionImpl:1842 loader.list CustomLoader:316 querySpace is still null here Loader:2268 since it's cacheable Loader:2309 getResultFromQueryCache since the query result is already in cache - the bug is that it won't invalide the cached result Loader:2561 queryCache.get QueryCache:48 StandardQueryCache:135 <-- if ( !isNaturalKeyLookup && !isUpToDate( spaces, timestamp ) ) lead to isUpToDate with spaces being empty StandardQueryCache:185 <-- updateTimestampsCache.isUpToDate( spaces, timestamp ); UpdateTimestampsCache:89 : public synchronized boolean isUpToDate(Set spaces, Long timestamp) throws HibernateException Set spaces is empty, isUpToDate returns true the queryCache.get returns the cached result. HTH was (Author: nodje): I can't quickly post a test case. It is rather difficult to build one. Webapp boiler plate code + database + mapping + test case ... I hope just listing the code that is processed in the scenario can make sense someone familiar with that part: Imagine the following code: SQLQuery query = session.createSQLQuery("sqlQueryString").setCacheable(true); Session:730 SessionImpl:1776 AbstractSessionImpl:146 new SQLQueryImpl SQLQueryImpl:138 <--- this is were the problem originate from: querySpaces = null (SQLQueryImpl:141). They'll never be any space added. The only way to add some seems to be SQLQueryImpl:366 addSynchronizedQuerySpace(...) - undocumented Then call a query.list(); SQLQueryImpl:149 SessionImplementor:221 AbstractSessionImpl:165 SessionImplementor:204 SessionImpl:1835 CustomLoader loader is instanciated with quesySpaces from the customQuery: null SessionImpl:1842 loader.list CustomLoader:316 querySpace is still null here Loader:2268 since it's cacheable Loader:2309 getResultFromQueryCache since the query result is already in cache - the bug is that it won't invalide the cached result Loader:2561 queryCache.get QueryCache:48 StandardQueryCache:135 <-- if ( !isNaturalKeyLookup && !isUpToDate( spaces, timestamp ) ) lead to isUpToDate with spaces being empty StandardQueryCache:185 <-- updateTimestampsCache.isUpToDate( spaces, timestamp ); UpdateTimestampsCache:89 : public synchronized boolean isUpToDate(Set spaces, Long timestamp) throws HibernateException Set spaces is empty, isUpToDate returns true the queryCache.get returns the cached result. HTH -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5870?page=c... ] nodje edited comment on HHH-5870 at 1/27/11 5:11 AM: ----------------------------------------------------- I can't quickly post a test case. It is rather difficult to build one. Webapp boiler plate code + database + mapping + test case ... I hope just listing the code that is processed in the scenario can make sense for someone familiar with it: Imagine the following code: SQLQuery query = session.createSQLQuery("sqlQueryString").setCacheable(true); Session:730 SessionImpl:1776 AbstractSessionImpl:146 new SQLQueryImpl SQLQueryImpl:138 <--- this is were the problem originate from: querySpaces = null (SQLQueryImpl:141). They'll never be any space added. The only way to add some seems to be SQLQueryImpl:366 addSynchronizedQuerySpace(...) - undocumented Then call a query.list(); SQLQueryImpl:149 SessionImplementor:221 AbstractSessionImpl:165 SessionImplementor:204 SessionImpl:1835 CustomLoader loader is instanciated with quesySpaces from the customQuery: null SessionImpl:1842 loader.list CustomLoader:316 querySpace is still null here Loader:2268 since it's cacheable Loader:2309 getResultFromQueryCache since the query result is already in cache - the bug is that it won't invalidate the cached result Loader:2561 queryCache.get QueryCache:48 StandardQueryCache:135 <-- if ( !isNaturalKeyLookup && !isUpToDate( spaces, timestamp ) ) lead to isUpToDate with spaces being empty StandardQueryCache:185 <-- updateTimestampsCache.isUpToDate( spaces, timestamp ); UpdateTimestampsCache:89 : public synchronized boolean isUpToDate(Set spaces, Long timestamp) throws HibernateException Since 'Set spaces' is empty, isUpToDate will always return true. the queryCache.get returns the cached result. HTH was (Author: nodje): I can't quickly post a test case. It is rather difficult to build one. Webapp boiler plate code + database + mapping + test case ... I hope just listing the code that is processed in the scenario can make sense for someone familiar with it: Imagine the following code: SQLQuery query = session.createSQLQuery("sqlQueryString").setCacheable(true); Session:730 SessionImpl:1776 AbstractSessionImpl:146 new SQLQueryImpl SQLQueryImpl:138 <--- this is were the problem originate from: querySpaces = null (SQLQueryImpl:141). They'll never be any space added. The only way to add some seems to be SQLQueryImpl:366 addSynchronizedQuerySpace(...) - undocumented Then call a query.list(); SQLQueryImpl:149 SessionImplementor:221 AbstractSessionImpl:165 SessionImplementor:204 SessionImpl:1835 CustomLoader loader is instanciated with quesySpaces from the customQuery: null SessionImpl:1842 loader.list CustomLoader:316 querySpace is still null here Loader:2268 since it's cacheable Loader:2309 getResultFromQueryCache since the query result is already in cache - the bug is that it won't invalidate the cached result Loader:2561 queryCache.get QueryCache:48 StandardQueryCache:135 <-- if ( !isNaturalKeyLookup && !isUpToDate( spaces, timestamp ) ) lead to isUpToDate with spaces being empty StandardQueryCache:185 <-- updateTimestampsCache.isUpToDate( spaces, timestamp ); UpdateTimestampsCache:89 : public synchronized boolean isUpToDate(Set spaces, Long timestamp) throws HibernateException Set spaces is empty, isUpToDate returns true the queryCache.get returns the cached result. HTH -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5870?page=c... ] nodje commented on HHH-5870: ---------------------------- Gail, this is quite a heavy mapping here, our biggest entity indeed. SQL stmt is very simple, just a basic select with a where condition, it's using createCacheableSQLQuery(columns + query).addScalar("id", Hibernate.STRING).setResultTransformer(Transformers.aliasToBean(SearchBean.class)).list(); I'd rather try to add a test case to the existing test suite. But I need a hand with GitHub. I'm not familiar with it unfortunately. I have been able to clone the master branch, but want to work on 3.6 branch. git checkout 3.6 doesn't work, and that's what I understand I have to do from the doc. Can't find any forum/chat/communication way on GitHub. Can you just explain me how to switch on 3.6 please? ------------ And hum, can't believe you removed a working Maven configuration to keep only gradle... my 2c opinion... -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira