One solution is to define a separate table "changes" in which you insert the changes, updates, deletes (possible field names: id, change_date, change_type, affected_table, affected_id). That means, if you updates/inserts/deletes record in a table, you make an additional entry in the new table "change". Later, your Java application can look periodical in this table for changes (after looking, you delete the read record).
Anton -----Ursprungliche Nachricht----- Von: Sashi Ramaswamy [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 6. Januar 2004 17:20 An: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Betreff: Database Update Notification Hi, I am trying to build an application in Java (1.4.2) which will have a notification mechanism to notify various components within the system when database changes occur. Since MySQL does not support triggers I am trying to figure out an efficient way of implementing this. How can I know when changes(updates/inserts/deletes) occur in the database? Any thoughts or ideas are welcome. Thanks for you help, Sashi -- MySQL Java Mailing List For list archives: http://lists.mysql.com/java To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
