Re: implemention of calls to stored procs.

Holger Krug <hkrug@rationalizer.com> writes:

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

Actually my initial goal is neither of these things. My initial goal
is to learn about the internals of pg.

I am more of a Java programmer than a C programmer (just because I'm
lazy) and therefore I would like to pursue your second option.

The most difficult part of that is actually defining the java function
interface, but other than that I think I've already cracked it (I
wrote most of the JDBC implementation last night).


As for your 1st objective... I don't think that would be easy, even
with what I'm proposing there would have to be some sort of RMI or
CORBA link to the remote app.


Nic