Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Best solution to prevent unwanted database updates

 
srikanth bukkapatnam
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
When a user clicks submit on a page, when nothing has changed,what would be the best and efficient solution to check for real updates.
- things to consider:
Business objects in question are really large and spans multiple tables, so saving previous object in session is ruled out.
Column to Column check for changes before update is also ruled out.
-cannot use triggers on tables
Any solution that does a check on Html Page level for something that has changed is acceptable.
Thanks in advance,
Srikanth
 
Robert Brunner
Ranch Hand
Posts: 49
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If the user is using GET/POST to update form fields, you have access to all of the data at the server, just check to see if anything was changed in the forms. You can do this simply with beans, but probably other ways as well.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic