hibernate createSQLQuery use CacheQuery?

Question

Query query=getHibernateTemplate().getSessionFactory().getCurrentSession().createSQLQuery(
                "select...

getHibernateTemplate().setCacheQueries(true);
List result= query.list();
getHibernateTemplate().setCacheQueries(false);

return result;

may i know when i do manual "createSQLQuery" how to use cacheQuery? the above doesnt cache the result. show_sql still showing every request get from database

Pascal Thivent · Accepted Answer · 2010-03-15 13:54:59Z

1

AFAIK when using createSQLQuery, you must use an explicit .addScalar or .addEntity if setCacheable is true, or hibernate gets confused on casting. Apart from that, my understanding is that it should work.

answered Mar 15, 2010 at 13:54

Pascal Thivent

572k140 gold badges1.1k silver badges1.1k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Artsiom Anisimau · Accepted Answer · 2010-03-15 09:38:06Z

1

Try to configure ApplicationContext

<prop key="hibernate.cache.provider_class">org.hibernate .cache.EhCacheProvider</prop>
<prop key="hibernate.cache.use_second_level_cache">true</prop>
<prop key="hibernate.cache.use_query_cache">true</prop>

answered Mar 15, 2010 at 9:38

Artsiom Anisimau

1,1873 gold badges12 silver badges27 bronze badges

1 Comment

cometta Over a year ago

already added that. it work only for DetachedCriteria , but for manual sql like above will it work?

Collectives™ on Stack Overflow

hibernate createSQLQuery use CacheQuery?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related