Received: from marketingchallenge.com (marketingchallenge.com [64.40.111.205] (may be forged)) by postgresql.org (8.11.3/8.11.1) with SMTP id f2TFqEK38588 for ; Thu, 29 Mar 2001 10:52:14 -0500 (EST) (envelope-from drfrog@smartt.com) Received: (qmail 20958 invoked from network); 29 Mar 2001 15:52:12 -0000 Received: from clayton-cottingham.imc (HELO smartt.com) (drfrog@10.1.4.1) by marketingchallenge.com with SMTP; 29 Mar 2001 15:52:12 -0000 Message-ID: <3AC35AB1.E50CDF34@smartt.com> Date: Thu, 29 Mar 2001 07:54:25 -0800 From: clayton cottingham X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.17-21mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: Peter Mount CC: Mathijs Brands , pgsql-sql@postgresql.org Subject: Re: Calling Java from psql (was Re: requesting help) References: <5.0.2.1.0.20010329100409.02122480@mail.retep.org.uk> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200103/609 X-Sequence-Number: 2280 Peter Mount wrote: > > At 10:33 26/03/01 +0200, Mathijs Brands wrote: > > >Has anybody ever tried calling Java code from a pgsql trigger written > >in C? Shouldn't this be possible using JNI? > > This was discussed recently. > > >I'm not exactly a Java expert myself, but this is the way PHP allows > >you to call Java code from your PHP scripts. > > It may be something to look at when things quieten down a bit. I'm rushed > of my feet at the moment (busy at work, long hours etc) but once 7.1 is > finally out of the door, I may get the chance to start looking at JNI (& my > employers don't mind me spending some time working on postgres when I'm not > on other projects either which is nice ;-) ) > > PS: the JDBC list is the best place for java based emails - I rarely read > sql ;-) > > Peter > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster another possible angle is to use perl and its new inline module {not sure if java is fully supported yet...} or its other perl->java binding it should be avail a t cpan