Is there a gateway that monitors database changes (for example, new table records?)

Forum|Forum|3 years ago
August 23, 2022
3 replies
314 views

Hi everybody,

I look for a gateway that watches changes in a database (e.g., insertions of records into a table, etc.), just like DirectoryWatcher monitors in a directory for files when they are created, modified, or deleted.

Which of the existing CF gateways is most suited for this purpose? or might it work with a few changes???

Is there a bespoke CF gateway that does this?

Thank you in advance.

This topic has been closed for replies.

BKBK

Community Expert

This question was asked here - almost word for word - two months ago: https://community.adobe.com/t5/coldfusion-discussions/is-there-gateway-watching-changes-in-a-database-e-g-new-table-records/m-p/12993117

ColdFusion hasn't changed much since then. 🙂

M

Mike Collins_CF

Inspiring

Sounds like you want an insert trigger. If you have a created timestamp column you could monitor new records with a schedule task that looks for new records at some interval.

Charlie Arehart

Community Expert

No cf gateway will support that. There are ways to audit such things from the db side--which makes sense all the more if you may have such db changes caused by other than the cf code.

/Charlie (troubleshooter, carehart. org)

AXcrystallis

Known Participant

Thank you Charlie for your response. You are right, through db it would much easier.

Charlie Arehart

Community Expert

Great to hear, and glad to help. I notice another user started the thread, how2557215989vj. Is that you as well, perhaps ?

/Charlie (troubleshooter, carehart. org)

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded