Re: Calling Java from psql (was Re: requesting help)

Quoting A James Lewis <james(at)fsck(dot)co(dot)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(at)postgresql(dot)org so that your
> > message can get through to the mailing list cleanly
> >
>
> A. James Lewis (james(at)fsck(dot)co(dot)uk)
> If your OS needs a virus detector... RUN!!!
> ...Out and get Linux!
>
>

--
Peter Mount peter(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/