aspose file tools*
The moose likes JDBC and the fly likes Best solution to prevent unwanted database updates Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Best solution to prevent unwanted database updates" Watch "Best solution to prevent unwanted database updates" New topic
Author

Best solution to prevent unwanted database updates

srikanth bukkapatnam
Greenhorn

Joined: Jul 31, 2001
Posts: 7
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

Joined: Jul 18, 2001
Posts: 49
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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Best solution to prevent unwanted database updates