Hi,

I have two applications. But both are using the same database.
when i update a table from application 1, i am not able to see the latest(updated one) from my application 2.

I have done commit() after every transaction and also i am doing flush().

Can someone help me how to get the latest values from database as soon if i access that table from my another application.

rgd,
kalai.

Are you using Spring or any other AOP? If so then I find that if I wait untill I've gone ousdie of the scope of a Service method and then query for a table again in another method it will force Hibernate to do a commit. (Which would let you get the current data from you DB in your other app.)

Thanks for ur reply.

I am using Struts and Hibernate for both of my applications.

In application 1 i am using session.saveOrUpdate(saveData) to save the values.

In application 2 i am using find() method to get the values. In find method i am creating a criteria and afetr that i am calling criteria.list() to get the values.

I hope now my proplem will be clear for u.

This may sound silly, did you actually queried the database to check if your saved or updated data is getting reflected in your table?

ofcourse...

I have checked in my database.Whatever i updated or saved from my application 1 is there in that table.

But still i am not able to see the updated values from application 2 .

pls note this also..

If i restart my tomcat i am getting my latest values..But before that i am not able to get that..

Are you using any kind of cache, there may be a possibility that the second app is fetching data from the cache, which is why when you restart your server you get the updated values. I am still trying to figure out the exact cause :-)

No. i am not using any kind of cache.

set you log level to see hibernate genrated logs, and check the place where new session is created and query is fired

hi all,

i solved the problem..there was a problem with handling the transaction.

thanks for all ur help..

Glad to hear you have your issue solved now.
Please give credit to the people that helped you. >_>