How to get the table rows refreshed by outside operations?

Question

0.00/5 (No votes)

See more:

Hi.

My project is a web project based on Struts2 + Spring + Hibernate.
And I'm using MySQL.
I'm defining beans and applying DI( Dependency Injection ).
All beans have 'request' scope, but only org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean instance is 'singleton'.

HTML

<bean id="sessionFactory" scope="singleton"
		class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
		<property name="configLocation" value="classpath:hibernate.cfg.xml" />
	</bean>

Problems are as following.

1. I run my project.

2. I connected to my project on the web browser.

http://localhost:8080/myproj

3. Here display the table rows in my database.

4. Then, I changed a row in the database on PHPMyAdmin.

5. I refresh my page, but the page is showing the unchanged data.

What's the problem?
Please help me.

Posted 12-Mar-13 22:15pm

liangwu2777

Updated 12-Mar-13 22:18pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prasad Khandekar · Accepted Answer · 2013-03-24T08:08:00

Hello,

Hibernate has two possible places where data can get cached, in the first level cache (the Session) or the second level cache (some third party cache implementation).
The first level cache is always used when you open a Session and load an object into it. You can update this object's properties all you like, its only when the session is flushed or closed (by calling those methods on the session) that the object's properties are persisted to the database.

The second level cache is only used if you explicitly add caching declarations to your mapping files. Otherwise it is not used.

Given this I suspect that you are not properly closing the session and that's why you are able to see the changes. If you have second level cache (EHCache) then use following xml to disable it. Disabling first level cache is not recommended and there is not suitable way to di this. You can use session.evict(YOUR OBJECT) to remove your object from this cache though.

XML

<!-- Enable the second-level cache  -->
<property name="hibernate.cache.provider_class">
    net.sf.ehcache.hibernate.EhCacheProvider
</property>
<property name="hibernate.cache.region.factory_class">
    net.sf.ehcache.hibernate.EhCacheRegionFactory
</property>
<property name="hibernate.cache.use_query_cache">true</property>
<property name="hibernate.cache.use_second_level_cache">true</property>
<property name="hibernate.cache.use_structured_entries">true</property>     
<property name="hibernate.cache.generate_statistics">true</property>

Regards,