I am working with JDBC adapter notifications. I have created an insertNotification. In the JDBC adapter user’s guide they have told that a buffer table and a trigger are also created. What is the location of the buffer table? Can I view the contents of it?
This is what I am trying to do:
1)Insert a row in table A (insert adapter).
2)Insert Notification for the table A.
3)Trigger which subscribes to the insertNotificationPublishDoc.
4)The trigger in turns calls a flow service which has a single step debugLog.
Whenever I am inserting any row in table A….None of the other steps are getting executed. Note that I have enabled the polling notification for the insertNotification.
Tell me, if I am missing out anything.