Caching of dynamic content

Hi,

I'm moving a J2EE app from Orion to SJSAS v8.2PE and am confused by a caching issue.

I'm using struts, with jsp's calling action classes - and then an EJB layer doing the selection of data using iBatis and a MySQL dB. It all works fine in both app servers, except in SJSAS it's not showing changes to the underlying data in the database - but appears to be caching the old values.

In fact on further investigation, if i log out and login again (removing my session) the new values are shown. But if i keep refreshing the page the old value appears occationally (about every 5 refreshes). I can see from the logs that a dB call is made every time - so i don't know why it's not displaying the uptodate value, unless the old value is being cached somewhere...

Any ideas?

Thanks Ed.

[826 byte] By [mrEdmundo] at [2007-11-26 6:57:44]
# 1
UPDATE:Managed to fix this problem by changing the dB transaction isolation on the connection pools to 'read-committed' - this is because the default for the MySQL connector JDBC driver is 'repeatable-read' which causes the caching.Ed.
mrEdmundo at 2007-7-6 15:33:14 > top of Java-index,Application & Integration Servers,Application Servers...