Received: from retep.org.uk ([216.126.85.184]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f32DI4K81960 for ; Mon, 2 Apr 2001 09:18:04 -0400 (EDT) (envelope-from peter@retep.org.uk) Received: (from nobody@localhost) by retep.org.uk (8.11.3/8.11.1) id f32DHlX81946; Mon, 2 Apr 2001 09:17:47 -0400 (EDT) (envelope-from peter@retep.org.uk) X-Authentication-Warning: retep.org.uk: nobody set sender to peter@retep.org.uk using -f To: A James Lewis Subject: Re: Calling Java from psql (was Re: requesting help) Message-ID: <986217467.3ac87bfbd0250@webmail.retep.org.uk> Date: Mon, 02 Apr 2001 09:17:47 -0400 (EDT) From: Peter T Mount Cc: Peter Mount , Mathijs Brands , Peter Eisentraut , pgsql-sql@postgresql.org References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: IMP/PHP IMAP webmail program 2.2.3 X-Archive-Number: 200104/10 X-Sequence-Number: 2349 Quoting A James Lewis : > > Before I go investigating this, is it possible to trigger an arbitrary > program from the SQL, say a shell script? In theory yes, but I'd suspect not a good idea. Even more so with java, as the JVM's startup time is pretty big. Having it talk to an already running JVM is the best option. > Also, why am I getting "not subscribed messages", I am subscribed since > I'm replying to a message that was sent to me!! I'm getting that with the patches list as well. Peter > On Thu, 29 Mar 2001, Peter Mount wrote: > > > At 21:37 26/03/01 +0200, Mathijs Brands wrote: > > >On Mon, Mar 26, 2001 at 07:00:43PM +0200, Peter Eisentraut allegedly > wrote: > > > > Mathijs Brands writes: > > > > > > > > > Has anybody ever tried calling Java code from a pgsql trigger > written > > > > > in C? Shouldn't this be possible using JNI? > > > > > > > > I have, and given the current Java implementations it's a > desaster. > > > > > >That bad eh? Well, I must admit I couldn't get the PHP-Java coupling > to > > >work stable either :( > > > > Not having looked at the PHP-Java link, are they working as one > process or > > is it some IPC type link? > > > > PeterM > > > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 3: 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 > > > > A. James Lewis (james@fsck.co.uk) > If your OS needs a virus detector... RUN!!! > ...Out and get Linux! > > -- Peter Mount peter@retep.org.uk PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/