• Post Reply Bookmark Topic Watch Topic
  • New Topic

Database record change identification  RSS feed

 
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.
 
author & internet detective
Marshal
Posts: 37714
579
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
Boost this thread!