I’m interested in best practices for managing JDBC Adapter Polling Notifications.
As far as I know, there’s no other way to change the notification interval. In my experience, it makes more sense to use basic notification in most cases. You have to write the trigger code, of course, but that can be done by creating an automatic notification operation on a development copy of the database and then copying the table/trigger/sequence created by the adapter. This allows you to give the database objects to a DBA for management (a necessity in most organizations), plus the adapter will no longer drop the database objects when the integration is disabled.