We have a requirement of having an Insert adapter notification from a table which is of Type: Synonym. After adding the notification and while enabling the polling notification we noticed below error.
[ART.116.3038] Adapter Runtime (Notification): Error in Notification Callback:enableCallback notification test1:segment_test. [ADA.1.349] Execution of DDL query of Notification failed during enable/disable. Please check the datatypes of columns selected in notification. [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-25001: cannot create this trigger type on this type of view.
Latest fix: JDBC_9.10_Fix13 is applied
We added the connection properties as well and tried enabling but the issue still persists. Is our adapter supports Insert notification on Synonym table type? Do i have to modify any other parameter to make it working or do i have to request clients for the direct DB table access instead of a Synonym?