pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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/



view thread (12+ messages)

Message-ID: <986217467.3ac87bfbd0250@webmail.retep.org.uk>
Permalink:  ../986217467.3ac87bfbd0250@webmail.retep.org.uk/
Also on:    postgresql.org/message-id/986217467.3ac87bfbd0250@webmail.retep.org.uk

 · 

reply

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