Re: implemention of calls to stored procs.

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(at)wireboard(dot)com> writes:

> Nic Ferrier <nferrier(at)tapsellferrier(dot)co(dot)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