<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
EJB3 and Hibernate Second Level Cache InvalidationEJB3 and Hibernate Second Level Cache Invalidation
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/ab_99">Anurag Bhatia</a> in <i>EJB 3.0</i> - <a href="http://community.jboss.org/message/564483#564483">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>I am using the hibernate second level cache for  my ejb3 entity beans for entity caching as well as query caching. Does  anyone have any idea on how to invalidate the hibernate second level  cache? <br/> I tried to use the evictXXXX() methods in the sessionfactory but had no success. There is nothing there in the EntityPersisters or the CollecitonPersisters.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>My entities are marked with the@Cache (usage=CacheConcurrencyStrategy.TRANSACTIONAL) annotation</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>The queries are used as follows -</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>      Query query = entityManager.createQuery(query String.........);<br/>      query.setParameter(DATEPARAM, date);<br/>      query.setHint("org.hibernate.cacheable", true);<br/>      return query.getResultList();</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>persitence.xml -</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><?xml version="1.0" encoding="UTF-8"?><br/><span><persistence xmlns="</span><a class="jive-link-external-small" href="http://java.sun.com/xml/ns/persistence" target="_blank">http://java.sun.com/xml/ns/persistence</a><span>"</span><br/><span>   xmlns:xsi="</span><a class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema-instance" target="_blank">http://www.w3.org/2001/XMLSchema-instance</a><span>"</span><br/><span>   xsi:schemaLocation="</span><a class="jive-link-external-small" href="http://java.sun.com/xml/ns/persistence" target="_blank">http://java.sun.com/xml/ns/persistence</a><span> </span><a class="jive-link-external-small" href="http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" target="_blank">http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd</a><span>"</span><br/>   version="1.0"><br/>       <persistence-unit name="test"><br/>          <jta-data-source>java:com/test/datasources/DataSource</jta-data-source><br/>          <properties><br/>            <property name="hibernate.cache.use_second_level_cache" value="true"/><br/>            <property name="hibernate.cache.use_query_cache" value="true"/><br/>            <property name="hibernate.cache.provider_class" value="org.hibernate.cache.HashtableCacheProvider"/><br/>            <property name="hibernate.cache.region.factory_class" value="org.hibernate.cache.jbc2.JndiMultiplexedJBossCacheRegionFactory"/><br/>            <property name="hibernate.cache.region.jbc2.cachefactory" value="java:CacheManager"/><br/>            <property name="hibernate.cache.region.jbc2.cfg.entity" value="mvcc-entity"/><br/>            <property name="hibernate.cache.region.jbc2.cfg.collection" value="mvcc-entity"/><br/>            <property name="hibernate.cache.region.jbc2.cfg.query" value="local-query"/><br/>            <property name="hibernate.cache.region_prefix" value="tempdb"/> <br/>            <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup"/><br/>            <property name="hibernate.generate_statistics" value="true"/><br/>            <property name="hibernate.show_sql" value="true"/><br/>          </properties><br/>       </persistence-unit><br/></persistence></p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/564483#564483">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in EJB 3.0 at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2029">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>