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

Database record change identification

 
Veshnu Ramakrishnan
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
Is there any way of intimating a program automatically when a record in a database is changed by the database administrator without the program's knowledge.
And is there any way to check whether a record is changed since previous visit and to load that data only if that record has been changed.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34084
337
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Veshnu,
Welcome to JavaRanch!


Is there any way of intimating a program automatically when a record in a database is changed by the database administrator without the program's knowledge.

Who changed it? You could have a trigger based on user id. But you would have to be able to determine whether it was the program or the user making the change.


And is there any way to check whether a record is changed since previous visit and to load that data only if that record has been changed.

You still have to do a query, but you can add a last updated column to your table.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic