From: Peter T Mount <peter@retep.org.uk>
To: A James Lewis <james@fsck.co.uk>
Cc: Peter Mount <peter@retep.org.uk>
Cc: Mathijs Brands <mathijs@ilse.nl>
Cc: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Calling Java from psql (was Re: requesting help)
Date: Mon, 02 Apr 2001 09:17:47 -0400 (EDT)
Message-ID: <986217467.3ac87bfbd0250@webmail.retep.org.uk> (raw)
In-Reply-To: <Pine.LNX.4.33.0103291444390.15105-100000@vortex1.vrtx.net>
References: <Pine.LNX.4.33.0103291444390.15105-100000@vortex1.vrtx.net>
Quoting A James Lewis <james@fsck.co.uk>:
>
> 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/
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: peter@retep.org.uk, james@fsck.co.uk, mathijs@ilse.nl, peter_e@gmx.net
Subject: Re: Calling Java from psql (was Re: requesting help)
In-Reply-To: <986217467.3ac87bfbd0250@webmail.retep.org.uk>
References: <Pine.LNX.4.33.0103291444390.15105-100000@vortex1.vrtx.net> <986217467.3ac87bfbd0250@webmail.retep.org.uk>
* 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