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
– Nick.Mc, Commented Nov 22, 2013 at 3:07

collusionbdbh · Accepted Answer · 2013-11-22 03:02:20Z

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, 2013 at 3:02

collusionbdbh

7001 gold badge6 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

poohdedoo Over a year ago

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

collusionbdbh Over a year ago

Sorry, I have never used JMS myself.

Collectives™ on Stack Overflow

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

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related