Hello. My company currently has a
J2EE web app serving about 300 internal employees. Now that the app is being heavily used, we are noticing data corruption by the users. For example...
Step #:
1) User A is served a
jsp which contains a form filled with data ready to be updated.
2) User B is served a jsp which contains a form filled with data ready to be updated. This is the same data as User A.
3) User A changes the data, and clicks "Update". The commit is done in Oracle.
4) User B, never seeing User A's change because the jsp was not refreshed, submits their changes (which are different from User A's). This overwrites User A's data with User B's and the first set of changes are lost.
Is there any Oracle/JDBC/Java best practices to resolve this? There must be something since web apps are so popular now....
TIA