Re: implemention of calls to stored procs.
Barry Lind <barry@xythos.com>
From: Barry Lind <barry@xythos.com>
To: Nic Ferrier <nferrier@tapsellferrier.co.uk>
Cc: Doug McNaught <doug@wireboard.com>, pgsql-general@postgresql.org
Date: 2002-01-23T01:54:16Z
Lists: pgsql-general
Nic, Check out http://www.rootshell.be/~hornyakl/download This has the latest code for pl/pgj. The Java procedure language support that Laszlo Hornyak (hornyakl@users.sourceforge.net) has been working on for the last month or so. thanks, --Barry Nic Ferrier wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > >