From: Dave Cramer <pg@fastcrypt.com>
To: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
Cc: pgsql-jdbc@postgresql.org
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [JDBC] How to notify JBoss J2EE application in a trigger or rule???
Date: Thu, 22 Jun 2006 07:41:26 -0400
Message-ID: <6A368D4D-4555-4476-AC17-3BEA7400C7F8@fastcrypt.com> (raw)
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>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: pg@fastcrypt.com, J.Kraaijeveld@Askesis.nl, pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] How to notify JBoss J2EE application in a trigger or rule???
In-Reply-To: <6A368D4D-4555-4476-AC17-3BEA7400C7F8@fastcrypt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox