Re: How to notify JBoss J2EE application in a trigger or rule???

Hi, Hoost,

Joost Kraaijeveld wrote:

> I want a PostgreSQL trigger or rule that notifies a JBoss deployed J2EE
> application of a certain event.
>
> I was hoping that pljava would work, but for some -yet unknown to me-
> reason, it does not work on my Debian AMD64 with Sun 1.5.0-7 JVM.
>
> Does anyone have an (working???) example or a pointer to an example of
> how to do this?

Hmm, did you try the GCJ-based pljava variant?

And, as an workaround, have an extra bean sitting in the JBoss that
LISTENs, and the trigger in SQL simply NOTIFYing it?

HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org