Has anyone looked into better options other than the polling built into the JDBC Adapter Notifications?
We are interested in setting up triggers within the database that would monitor for activity, populate a buffer table and notify webMethods to perform a select and delete on the buffer table.
The solution seems a little clunky but still better than the network overhead associated with regular polling for infrequently updated databases–especially when the infrequent activity requires rapid turnaround.
Are there considerations we haven’t taken into account? Has anyone else tried this approach successfully or otherwise?