Skip site navigation (1) Skip section navigation (2)

PL/(pg)J

From: Laszlo Hornyak <hornyakl(at)freemail(dot)hu>
To: pgsql-hackers(at)postgresql(dot)org, ssutjiono(at)wc-group(dot)com
Subject: PL/(pg)J
Date: 2002-01-01 13:03:51
Message-ID: 3C31B3B7.6030703@freemail.hu (view raw or flat)
Thread:
Lists: pgsql-hackers
Happy new year for all!

I would like to tell you about the results of my work on pl/j.
memo: Java and postgres must run in a separate address space. First I 
wanted to use the sys v ipc, which was a bad idea becouse of some 
problems with java VM-s. Many hackers told me about its bad sides, and 
the good sides of the sockets, so I droped the whole code and started a 
new one.

I started to write the java side first, which is maybe almost 10% ready :))
-we have is a communication protocol between the two process. I know 
noone will like it, so there is an API for protocols, so it is plugable. 
The current implementation is receiveing calls,sends exceptions, but 
sending the results is not implemented yet.

-the Postgres side is not yet done. It sends function calls without 
arguments, it doesn`t receive sql queries, exceptions or results at all, 
and there is no API for it, it is an uggly hardcoded thing.

-there is no JDBC implementation, and I have never written JDBC driver, 
so it may take for a while...

But it says "hello world" :))

Todo for me:

-learn more about postgres, jdbc drivers, etc, etc
-develop api for the postgres side of the communication.

This will take for a good while becouse of other todos but I hope next 
time I can tell you good news.

thx,
Laszlo Hornyak


pgsql-hackers by date

Next:From: Jean-Michel POUREDate: 2002-01-01 13:59:54
Subject: Happy new year
Previous:From: Thomas LockhartDate: 2002-01-01 03:06:15
Subject: Re: Latest datetime changes produce gcc complaints

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group