Re: implemention of calls to stored procs.

Поиск
Список
Период
Сортировка
От Holger Krug
Тема Re: implemention of calls to stored procs.
Дата
Msg-id 20020123083137.A653@dev12.rationalizer.com
обсуждение исходный текст
Ответ на 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
On Wed, Jan 23, 2002 at 12:11:09AM +0000, Nic Ferrier wrote:
> 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).

As you probably know, you are not the first attempting to allow java
classes as stored procs. I'm interested in why you people are
attempting this. I can imagine 2 goals, the one of which is a hot
issue also for me and should has a relative simple solution, the other
seems to be not very imported and heavy to achieve:

1. goal) Give PostgreSQL after triggers the ability to notify Java
         apps about events in the database. In almost all cases this
         would be done using a JMS (Java Message Service) implementation
         in an application server which has to be called by the after
         trigger.
2. goal) To have Java as a YAPL4P (yet another procedural language for
         PostgresSQL).

I think all the big problems regularly reported on this list when a
new attempt is announced to be made to create a java plugin for
PostgreSQL are related to the second point: Java as a full-scale
YAPL4P - which is nice but should not be very important.

But if you have the same goal as I would like to have to time for:
using Java to notify outside Java apps about database events, then - I
think - your approach is promising and I wish you really good luck.

--
Holger Krug
hkrug@rationalizer.com

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

Предыдущее
От: Sean Chittenden
Дата:
Сообщение: Re: Password type ?
Следующее
От: Mark Rae
Дата:
Сообщение: Re: frustration with database size