[Info-vax] RDB, trigger, native procedure and ActiveMQ

Arne Vajhøj arne at vajhoej.dk
Mon May 31 15:49:10 EDT 2021


On 5/31/2021 6:36 AM, Jan-Erik Söderholm wrote:
> Den 2021-05-31 kl. 01:47, skrev Arne Vajhøj:
>> Rdb features have been discussed here a few times and
>> some time ago I read a bit in the Rdb manual and found
>> the section on native procedure.
>>
>> And since I like playing around with such stuff I
>> created a little demo.
>>
>> Setup:
>>
>> Rdb table -> insert trigger -> procedure written in C -> STOMP library 
>> -> message queue on ActiveMQ

> Was it the "database clients" that did the table insert?

Yes.

> If so, it would work from any source, it doesn't matter *how* the
> record was inserted into the table, the trigger would fire anyway.

Yes.

That is the whole point. Any program can insert the data and
trigger the send to message queue. And any program can read
from the message queue and take action.

Arne





More information about the Info-vax mailing list