Data Cache Crossover
I am database developer know very little about java, we have an application which connects to Oracle database and uses Oracle IAS as the app server, the application is very data centric, mostly updating/deleting/uploading quite a bit data to the database, the user population is about 600 mostly offsite. The users are only allowed to work with their own set of data and not allowed to view/update data of any other users.
The application seems to be caching data on the app server may be designed that way to improve performance but what we are experiencing quite often that a user inadvertently stumbles upon data of other users, in other words the application is not pulling the correct data. We for sure know this is not due to a problem with SQL and we very much suspect that the app is not pulling the correct data from the cache and is confused about what cache belong to what user.
My questions are
1. What could be the causes for this issue ?
2. Are there any know fool proof methods available to manage the cache ?
If this is not the right forum for this type of question please let me know what forum this belong to.
Any information/help is appreciated
I very, very much doubt it's the app server.
How are you connecting to Oracle in your system?
Is it JDBC?
Yes we are using jdbc for the database connectivity and a connection pool
JDBC does not cache, so it's not that.
It is, basically, an access layer.
Have you some example code around where you are getting odd results returned?