How should I use the alerter if my desired event sequence is Source table inserted with data - table trigger - [my stored procedure] - commit_and_notify (or similar) - alerter is notified - agent then publishes?
Welcome to "KB Articles"
How should I use the alerter if my desired event sequence is Source table inserted with data - table trigger - [my stored procedure] - commit_and_notify (or similar) - alerter is notified - agent then publishes?
book
Article ID: KB0084478
calendar_today
Updated On: 01-14-2017
Products
Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database
-
Not Applicable
-
Description
Resolution: The general recommendation is: place commit_and_notify wherever you would place commit in your stored procedure. If your stored procedure does commit itself, then you only need to do “notify” part of commit_and_notify. Here are the steps:
1) Remove "commit work" line from "commit_and_notify" stored procedure. 2) Add "execute commit_and_notify" to your stored procedure.
Issue/Introduction
How should I use the alerter if my desired event sequence is Source table inserted with data - table trigger - [my stored procedure] - commit_and_notify (or similar) - alerter is notified - agent then publishes?
Environment
Product: TIBCO Adapter for ActiveDatabase
Version: ALL
OS: All
--------------------
Attachments
How should I use the alerter if my desired event sequence is Source table inserted with data - table trigger - [my stored procedure] - commit_and_notify (or similar) - alerter is notified - agent then publishes?
get_app