From: Peter Mount <peter@retep.org.uk>
To: Jeff MacDonald <jeff@hub.org>
To: Jeff MacDonald <jeff@hub.org>
To: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] Java
Date: Tue, 7 Sep 1999 22:07:30 +0100
Message-ID: <9909072216510M.00229@tabatha> (raw)
References: <Pine.LNX.4.10.9909071435240.1772-100000@penguin.hub.org>
On Tue, 07 Sep 1999, Jeff MacDonald wrote:
> This question was sent to me, and i'm wondering if it's viable
> or if anyone else has any interest in it ?
>
> ++++++++++++++++
>
> Have you any plans to make possible writing simple functions/stored
> procedures in Java to extend PostgreSQL ?
>
> ++++++++++++++++
>
> Now my question related to this, if i understand correctly
> this would mean we would need the java runtime thingy in Postgres
> and would seriously wreck our speed . Right ?
I remember writing something some months ago (check the archives) of a possible
way around this.
IIRC, I seem to remember thinking along the lines of a single JVM thats run by
the Postmaster, and when a backend calls a stored procedure thats in Java, the
first call creates a new Thread/ThreadGroup in the JVM, and any call from that
backend goes to that thread using a simple set of Interface's.
When the backend closes, the ThreadGroup is killed off.
I think that's what I originally posted, but it would take someone with a lot
of time and JNI experience to pull it off.
Peter
--
Peter T Mount peter@retep.org.uk Tel +44 (0) 7990 898443
Homepage http://www.retep.org.uk Fax UK +44 (0) 870 0568837
PostgreSQL JDBC http://www.retep.org.uk/postgres/ US +1 734 661 0110
Java PDF Generator http://www.retep.org.uk/pdf/ More details on the website
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 using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: peter@retep.org.uk, jeff@hub.org
Subject: Re: [INTERFACES] Java
In-Reply-To: <9909072216510M.00229@tabatha>
* 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