Actian Community Forum

dejan · 2012-07-19

I need a way to get a notification message whenever table in database gets a new record, a record gets deleted, or when a record is updated, so I can update my JTable model(s). I am quite sure someone have already solved this problem somehow. Any clues?

daryl.monge · 2012-07-19

One idea: Write a rule/procedure that fires a database event. Unfortunately I have never used dbevents in Java so I'm not entirely sure how to receive those other than a JNI interface.

dejan · 2012-07-19

I have already thought about it, but it won't work because JDBC driver can't handle DBEVENTs...

The only sane approach I came up with is to write an OME function, say SENDMSG, which will communicate with another JAVA application, or HornetQ server directly, to send database events around...

rhann · 2012-07-19

I imagine it would be pretty easy to write a DBEvent listener in C that would relay messages to any port at any address using any protocol you can name.

Or, if you don't need synchronous/real-time notification, you can select from iiaudit in iidbdb.

nick.bolton · 2012-07-27

Rather than rules, you should use "security alarms" to raise the events.

You'd then need something registered to receive the events (e.g. a bit of C) and pass them onto your Java app. The problem with events is that if nothing is there to receive them; then the situation did not happen, so you won't just catch-up at some point. At least with a security alarm, you can find anything you missed from the audit logs.

dejan · 2012-07-30

This is actually a pretty good solution. It would be really, really great if iijdbc driver was capable of listening to Ingres DBevents... Btw. any plans of having this functionality in the Ingres JDBC driver?

thogo01 · 2012-07-30

The JDBC interface is an external spec. Can you a suggest a way to pass dbevent info between the driver and the application?

dejan · 2012-09-17

Well, I do not mind Ingres JDBC doing the same what Oracle does: Database Change Notification

3magku · 2012-09-19

With ORACLE you can use dbms_alert.register and dbms_alert.waitone as java.sql.CallableStatement. I would expect to use register dbevent and get dbevent in the same way with Ingres.

Users have been requesting this feature for such a long time - many years and Ingres releases later and still no solution ... very poor.