Change Notification or Polling Techniques

[kosurusekhar <ko...@gmail.com>]

Hi Folks,

Is there any in built feature in derby like Database Change Notification in
oracle. Basically I am looking for as soon as table is getting
updated/inserted/deleted I have to update to the UI. This requirement I am
dividing into two parts. 1) Know the updates happening in database, in
processing server.
2) Push this updates to clients. This second part I have to implement
separately. But the first part, how can I get notifications as soon as some
data got modified in tables. 

One way is polling database with fixed time intervals, but we won't get real
time updates.
Second way is having trigger, I have basically around 6 tables to watch
continuously.

Is there any side effects after introducing trigger(s)? 

Please suggest me how to proceed with my requirement.

Thanks in Advance.

Regards
Sekhar.



--
View this message in context: http://apache-database.10148.n7.nabble.com/Change-Notification-or-Polling-Techniques-tp143741.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.