Re: implemention of calls to stored procs.

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: implemention of calls to stored procs.
Дата
Msg-id m3g04x6d19.fsf@varsoon.denali.to
обсуждение исходный текст
Ответ на implemention of calls to stored procs.  (Nic Ferrier <nferrier@tapsellferrier.co.uk>)
Ответы Re: implemention of calls to stored procs.  (Nic Ferrier <nferrier@tapsellferrier.co.uk>)
Список pgsql-general
Nic Ferrier <nferrier@tapsellferrier.co.uk> writes:

> 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.

Interesting approach.  The other person that posted recently was going
to run Java as a separate daemon, since the idea of linking postgres
with the JVM was causing loud gagging sounds among the members of this
list (for reasons I agree with).

Are you talking about Java compiled to native code rather than
bytecode?  I know GCJ can do that and it would seem to be a better way
to do this (since you can already link in native compiled C
libraries).

The other thing to be aware of is that, if GCJ requires linking with
thread libraries, you may have some problems, since the PG backend
itself is not threaded--I'm not sure I'd want a threaded library call
running in a non-thread-aware app.

> 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.

Have fun!   Sounds a neat idea.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

В списке pgsql-general по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: timestamp and indexes
Следующее
От: Nic Ferrier
Дата:
Сообщение: Re: implemention of calls to stored procs.