Subject Re: [firebird-support] Asynchronous Signaling
Author Helen Borrie
At 09:33 PM 28/01/2005 +0000, you wrote:

>I am trying to use FireBird asynchronous signaling/asynchronous
>listening service. I will write a trigger or stored procedure that
>posts an event whenever any application inserts data in a table.

This is simple: use POST_EVENT 'Your_Own_Signal' to post an event to the
queue. Any applications that are listening for this event will receive it
when the transaction is successfully committed.

>Then I will write a Java client application listening for this event
>and execute some AST callback function. I do not know how to start
>yet. If you have any kind of samples or instructions, please
>respond. Appreciate your help very much.

How applications listen for events depends on the client interface. If
Jaybird supports events, there will be a function in Jaybird for it. Ask
about it on the Firebird-Java list.

Note that, if you are using events and your server has a firewall, you will
need to open at least one unassigned port for the event traffic. The Event
Manager by default just uses any open port, at random. If you want to
specify a particular port (Fb 1.5 and higher) then open that port in the
firewall and configure the RemoteAuxPort in firebird.conf.