Re: implemention of calls to stored procs. - Mailing list pgsql-general

From Nic Ferrier
Subject Re: implemention of calls to stored procs.
Date
Msg-id 87n0z5yjer.fsf@tf1.tapsellferrier.co.uk
Whole thread Raw
In response to Re: implemention of calls to stored procs.  (Doug McNaught <doug@wireboard.com>)
List pgsql-general
Firstly, thanks for your responses... good to know I was thinking the
right thing (and, yes, I was taking the process thing into account,
tho' I didn't realise threads weren't used at all).


Doug McNaught <doug@wireboard.com> writes:

> Nic Ferrier <nferrier@tapsellferrier.co.uk> writes:
>
> > I've been looking at the implementation of the procedural language
> > support code with a view to writing a java plugin (ie: something to
> > allow java classes to be used as stored procs).
>
> Someone else has been talking about this--check the archives from the
> last six months.

I couldn't find any reference but the archive searcher is broken right
now and a manual search is not very reliable.

It's not terribly difficult to crack this actually... I was going to
use GCJ as a platform for a base java class that could be used like a
quick C stored proc.

I envisage having a natively implemented JDBC Connection passed to an
init method in such a class.


GCJ is perfect for this task because it has a native call interface,
CNI, which is a seamless part of the class heirarchy.

Once I've got something working I'll drop a line here.



Nic

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: detecting deadlocks
Next
From: Justin Clift
Date:
Subject: Re: [HACKERS] PostgreSQL Licence: GNU/GPL