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