Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes Struts and the fly likes How can we know the Data Table fields changed for every 5mints Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "How can we know the Data Table fields changed for every 5mints" Watch "How can we know the Data Table fields changed for every 5mints" New topic
Author

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

saivenu madhav
Greenhorn

Joined: Nov 15, 2007
Posts: 29
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How can we know the Data Table fields changed for every 5mints