Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: [JDBC] 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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group