Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How can we know the Data Table fields changed for every 5mints

 
saivenu madhav
Greenhorn
Posts: 29
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi folks


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




ThanksInadavance
Madhav
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic