Hello,
I am using the query cache feature to avoid hitting the database for data that does not change frequently. Everything goes fine with retrieval and updates, since Hibernate knows when the object's state changed. However, what can I do regarding inserts? When I insert a new object the cache is not notified (so it seems) and I have to wait until the specified period for a query refresh.
This is new ground for me and there is nothing on the docs regarding this issue, so any help will be highly appreciated.
BTW, I'm using 2.1.1 w/ the default EHCache.
Below are samples of my mappings:
On the app configuration for Spring:
<bean id="sessionFactory" class="org.springframework.orm.hibernate.LocalSessionFactoryBean">
<property name="dataSource"><ref local="dataSource"/></property>
<property name="mappingResources">
<list>
<value>net/picture.hbm.xml</value>
<value>net/audit.hbm.xml</value>
<value>net/stats.hbm.xml</value>
<value>net/customer.hbm.xml</value>
<value>net/news.hbm.xml</value>
<value>net/office.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">net.sf.hibernate.dialect.MySQLDialect</prop>
<prop key="hibernate.query.substitutions">true=1 false=0</prop>
<prop key="hibernate.connection.pool_size">2</prop>
<prop key="hibernate.statement_cache.size">25</prop>
<prop key="hibernate.cache.use_query_cache">true</prop>
<prop key="hibernate.show_sql">true</prop>
</props>
</property>
</bean>
The class in question is mapped as follows:
<class name="net.News" table="news">
<cache usage="read-write"/>
<id name="id" column="id" type="long">
<generator class="native"/>
</id>
<property name="author"/>
<property name="title"/>
<property name="content"/>
<property name="visible" type="boolean"/>
<property name="creationDate" column="creation_date"/>
<property name="lastModifiedDate" column="last_modified_date"/>
</class>
And finally, a snippet of the DAO code:
public List getNews() throws DataAccessException{
return ( List )getHibernateTemplate().execute( new HibernateCallback(){
public Object doInHibernate( Session session ) throws HibernateException{
List result = session.createQuery(
"from News n order by n.creationDate desc" ).setCacheable( true ).
list();
return result;
}
}
);
}
As I said, all works fine for this method and updates. It fails to update the cache on inserts because I think the cache is not notified since there was no change of state.
Cheers
jorge
Login
FAQ
Search
