hello
i want to create update notification on a table…i created a update notification, trigger and a flow service…plz tell me the steps to make a flow service to run the the update notificaton…
Thnks
After creating update notification have u pushed any data onto the corresponding tables ?
Since you had LOCAL_TRANSACTION for the jdbc connection it will implicitly auto-commit.
What db you had the update notification and also make sure your subscribing service input (flow) has the fully qualified doctype name and once there is update on the table you should see the data in the pipeline of the subscribed service.
Did you test the update notification having with sub service in place?
HTH,
RMG