In-Reply-To: <1150975519.6071.30.camel@localhost>
References: <1150973953.6071.20.camel@localhost>
	<8CB321E6-8402-4AB7-A99B-33254F3251FF@fastcrypt.com>
	<1150975519.6071.30.camel@localhost>
Mime-Version: 1.0 (Apple Message framework v750)
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <6A368D4D-4555-4476-AC17-3BEA7400C7F8@fastcrypt.com>
Cc: pgsql-jdbc@postgresql.org,
 pgsql-interfaces@postgresql.org
Content-Transfer-Encoding: 7bit
From: Dave Cramer <pg@fastcrypt.com>
Subject: Re: [JDBC] How to notify JBoss J2EE application in a trigger or
	rule???
Date: Thu, 22 Jun 2006 07:41:26 -0400
To: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>


On 22-Jun-06, at 7:25 AM, Joost Kraaijeveld wrote:

> On Thu, 2006-06-22 at 07:17 -0400, Dave Cramer wrote:
>> Did you try the pl/java list ?
> Yes, I did. Hence  the "yet unknow to me." I am also looking at the
> source, but I am fairly convinced that I am bitten by the "zlib" bug,
> which results in a lot of work to get it working. Besides the work, it
> will also lead to "non apt-get installable" software which I do do not
> fancy in terms of support....
>
>> Also there is pl/j which is much better designed for this.
> OK, I will look into that. Could you hint as to why it is much better
> designed?
>
pl/java uses JNI, and a JVM per connection, which also means that the  
JVM must run on the same machine as the server, both of these are  
showstoppers for me. On the other hand it is simple.

pl-j uses an RPC mechanism to call the function remotely. This means  
that the JVM can be anywhere, and you don't need a 1-1  mapping of  
connections to JVM's

I will warn you that it may be broken at the moment, but I'm fairly  
sure that Laszlo could be coerced into fixing it.

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