X-Original-To: pgsql-interfaces-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E73ED9FA606 for ; Thu, 22 Jun 2006 08:17:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 61708-02 for ; Thu, 22 Jun 2006 08:17:49 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by postgresql.org (Postfix) with SMTP id 01FA19F9FE3 for ; Thu, 22 Jun 2006 08:17:49 -0300 (ADT) Received: (qmail 6345 invoked from network); 22 Jun 2006 11:17:47 -0000 Received: from dcdsl.ebox.com (HELO ?192.168.1.2?) (davec@64.7.143.116) by net2.micro-automation.com with SMTP; 22 Jun 2006 11:17:47 -0000 In-Reply-To: <1150973953.6071.20.camel@localhost> References: <1150973953.6071.20.camel@localhost> Mime-Version: 1.0 (Apple Message framework v750) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <8CB321E6-8402-4AB7-A99B-33254F3251FF@fastcrypt.com> Cc: pgsql-jdbc@postgresql.org, pgsql-interfaces@postgresql.org Content-Transfer-Encoding: 7bit From: Dave Cramer Subject: Re: [JDBC] How to notify JBoss J2EE application in a trigger or rule??? Date: Thu, 22 Jun 2006 07:17:46 -0400 To: Joost Kraaijeveld X-Mailer: Apple Mail (2.750) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/26 X-Sequence-Number: 6167 Did you try the pl/java list ? Also there is pl/j which is much better designed for this. Dave On 22-Jun-06, at 6:59 AM, Joost Kraaijeveld wrote: > Hi, > > 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? > > TIA > > -- > Groeten, > > Joost Kraaijeveld > Askesis B.V. > Molukkenstraat 14 > 6524NB Nijmegen > tel: 024-3888063 / 06-51855277 > fax: 024-3608416 > web: www.askesis.nl > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that > your > message can get through to the mailing list cleanly >