Not sure if this a good place to ask this question.
I am working on a J2EE application in production environment. In my j2ee websphere applicaiton server i have deployed a ear file.
I have a clustered environemnt where i have three websphere application
servers set up in cluster.The three applcation servers are named server1, server2, and server3. All three application servers have their own jvm and all three application servers use a common database. now say there is a common record in database which is accessed by three users user1, user2 and user3 and the three users are served by server1 , server2 and server3 respectively. After user1, user2 and user3 have accessed the record, if user1 updates the record, i want user2 and user3 to be able to see the updated record (as updated by user1).
Can anyone tell me what could be a solution to this problem.
I think it doesn't really matter that these are web applications, does it? Your question is mainly about how, after one user updates a record, other users can find out about that and see the updated version, right? So let's move it over to the JDBC forum.