Hi,
I have a strange hibernate problem.
We are developing a web based application using Tomcat, Struts2 and Hibernate with MySql. The DB is used for several other applications also. and when other application made any data change our applicaton can not notice it. I have to restart the webserver and then it picks up the new data.
It seems that hibernate is cacheing the data. Here is the hibernate.cfg.xml:
<property name="hibernate.bytecode.use_reflection_optimizer">false</property>
property name="hibernate.connection.driver_class">org.gjt.mm.mysql.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://DB</property>
<property name="hibernate.connection.username">USER</property>
<property name="hibernate.connection.password">PASSWD</property>
<!-- property name="hibernate.default_schema">SCHEMA</property -->
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.hbm2ddl.auto">update</property>
<property name="hibernate.show_sql">true</property>

<property name="hibernate.cache.use_second_level_cache">false</property>
<property name="hibernate.cache.use_query_cache">false</property>
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>