What is the best way to implement a SQL(database) Listener?

Question

What is the best way to implement a generic database which monitor a table and trigger an event(ws-event) when the table get updated. Is there any standard way to do this?

A standard way to do this would be to use some kind of message queue mechanism. Most databases have somekind of message queue built in. — Nick.Mc, Nov 22 '13 at 03:07

score 2 · Accepted Answer · answered Nov 22 '13 at 03:02

2

I think you are looking for a database table trigger:

http://www.sqlteam.com/article/an-introduction-to-triggers-part-i

answered Nov 22 '13 at 03:02

collusionbdbh

701
1
6
18

Thank you soo much for your reference.. Do you have a sample where it send messages to a JMS Que (ie mysql event trigger) when an insertion happen – poohdedoo Nov 22 '13 at 04:00
Sorry, I have never used JMS myself. – collusionbdbh Nov 23 '13 at 03:39

What is the best way to implement a SQL(database) Listener?

1 Answers1