J2EE application in production environment

[jay roy]

hi guys

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.

thanks
J

[Paul Clapham]

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.

[Paul Sturrock]

Pushing updated from a database to another application is not a simple thing. Will all your clients be likely to update the record? Could you get away with optimistic locking?