Capturing events on database server

[Former Member]

Hi Friends,

Using the sender JDBC adapter can we listen to a particular event happening on database.

For example if suppose theres a table called EMPLOYEE.Now if someone goes and update a record or create a new record in this table, then I need to send this data to a file.

Is this possible using JDBC sender adapter .

One way I could think is giving a poll interval to JDBC adapter so that it fires a select query and gets me the data. But then this is not real time processing, its based on polling.

Can anyone please guide me on this.

Regards,

Yomesh

[bhavesh_kantilal]

Hi Yomesh,

Apart from polling the JDBC adapter over your Database, there is no standrad way to capture what you are trying to acheive.

Regards,

Bhavesh