[Pljava-dev] Notify/Listen

Hi John,

On Wed, 2006-08-09 at 12:08 -0400, Burtenshaw, John J. wrote:
>
> Has anyone ever used the Notify/Listen mechanism in pljava? How would
> you implement a client program that would do an sql Listen?
> Apparently according to the Postgresql docs there are functions that
> need to be called periodically to see if an event has occured or not
> (i.e. PQnotifies in libpq)
I do use notify/listen extensively thought not in pljava but in JBoss
using a MBean as a listener, which is polling in a separate thread. The
notify is done in a psql trigger. If you want I can send you the MBean
with the code, although it is very similar to the jdbc example here:
http://jdbc.postgresql.org/documentation/81/listennotify.html#listen-notify-example

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl