I have few server running same version of web application.
These application run from One of the server always show "funny" results,which likely due to cache/memory/session problem.
1)delete/change certain data then save to database,database update data successfully.However come to screen still showing old result.
2)I search result of certain document from Internet Explorer,then I log out and login to previous search document.Those search criteria and result still REMAIN there.
Fine,I login with different browser,such as mozila firefox,those search criteria and result showing on screen.
If I leave this issue few hours,then come back to previous screen or document,it was show uptodate info.
I have tried delete server cache,browser cache,db cache.problem still persisted.
P/S:Other 3 server runnig same version of web application no such issue.
As you are saying that even after updating the database, search results being shown are old. The only reason for it could be that search results are being cached on persistence layer of the application. Just like there are default caching feature available in hibernate which caches the same query.
You can validate by tracing the logs. Run the search for the first time see the logs for query fired and then re-run the same search, I am sure that it will not fire the query second time. Somehow caching is on in the layer which is interacting with database.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com