Configured JDBC update and insert notification on a Oracle table. I see buffer tables and triggers created on the database but when I insert a record in to table, the record is not picked by the IS. I did clean all the stuff manually and also disable/enable the notification.
Anyone has idea how to overcome this issue.
Thanks in advance
Yes, please make sure the IS trigger is configured correctly.
Make sure you have configured and enabled the adapter notification (in the JDBC Adapter config screen, goto Polling Notifications, edit the schedule of your Adapter Notification and then click Enable).
Regards
Andy Withers
Solutions Architect
Glue:
I had the same problem, I delete the trigger and recreate it,
It worked fine, no problem till now.