How can we know the Data Table fields changed for every 5mints
posted 8 years ago
I have Strange requirement, I have to work on recordLocking functionality,
When User1 is lock the request and editing the request, Administrator can unlock the request and edit the same request, whenever admin unlocak the request user1 has to get a promt saying that Admin has locked your request , You can't further proceed the same request.
Could any one please come up with one trigger in java to find out whenever the table "REQUEST" fields "lockby" and "lockedtime" changes to null we have to get promt ..? Is there any provision in Struts or JDBC