I'm working on a web based application which will access a database that will be replicated between 2 masters, and possibly some slaves. In addition to the updates from replication, there are other applications that will read and update the data. For these reasons, I want to make sure the query and second level caches are disabled. How can I make sure of that?

I'm not finding anything clear in the documentation as to how to do that, and it looks like the defaults may have changed over time, so I'm a little suspicious of forum postings.

Thanks for any assistance!

Hibernate component versions:
hibernate-core: 3.3.0.sp1
hibernate-annotations: 3.4.0.GA
hibernate-commons-annotations: 3.1.0.ga
ejb3-persistence: 1.0.2.GA
hibernate-entitymanager: 3.3.2.GA

Wouldn't this work:

hibernate.cache.use_query_cache=false
hibernate.cache.use_second_level_cache=false

Yes, that seems like it will do it. I had a hard time finding the documentation for this for some reason. Thanks!

Now to figure out how to get Spring to pass this along for me, and prove that it is working.

Something like this

<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">

--- MAPPING RESOURCES HERE ----

<property name="dataSource" ref="dataSource" />

<property name="hibernateProperties">
<props>

<prop key="hibernate.cache.use_query_cache">false</prop>
<prop key="hibernate.cache.use_second_level_cache">true</prop>


--- OTHER PROPERTIES ---

</props>
</property>
</bean>

Thanks again. Since I'm using JPA, it's looking more like this:



Seems to work in that if I put in invalid values things break.