Adapter notification

, ,
1

Adapter Notification not running
I been using JDBC for the past integration in WM6.1 and able to use most of the features with no problem of JDBC Adapter. I just started to use Adapter Notification for the first time as If some thing is inserted, modified or deleted I need to get notification ,
To start with I created the modification Notification to monitor the given table in
SQL data base . as Webmethod will create a Publishable Document along with that service ,
I also created the one trigger and handling service( service just to debug to log) to Subscribe to that Publishable document. Now as every thing is in place ,I manually modified using SQL Analyzer (Enterprise Manager ) to modify that particular table ,
And the when I see nothing in error log ,means that document is not getting fired when there is any modification on that target table .

Is there thing I am doing wrong Or its webMethods Problem or its Permission Issue while accessing the database .

I will appreciate your responses
Thanks every one .

2

Kitt,

This behaviour could be due to privileges/triggering DB/synonyms issue while acessing adapter notification connecting to that SQL db.so please make sure that webMethods have with necessary privileges using notification.Also make sure that trigger service input signature having with fully qualified publishable documenttype name.

HTH,
RMG.

3

Hi Kitt,
I hope you very well know this but you missed this point in your Post. YOu have to enable the notification using the IS Administrator. And also make sure your service has in input the fully qualified name of the publishable doc.
Regards,
Pradeep.

4

thank a TON Pradeep and RMG ,
I really missed that point for enabling that trigger.
I really appreciate webMethods Folks who is keeping this thing going …

Thanks.

Kit.

5

glad to know…it is working…

goodluck,

6

You are welcome kittt

Regards,
Pradeep.