Re: Why use Java Stored Procedures....

From: John Koller <johnckoller_at_yahoo.com>
Date: Mon, 06 Mar 2006 00:38:51 -0600
Message-Id: <pan.2006.03.06.06.38.50.817701@yahoo.com>

On Mon, 06 Mar 2006 02:34:50 +0000, HansF wrote:

> On Mon, 06 Mar 2006 01:54:21 +0000, Bob Jones wrote:
>

>> 
>> "HansF" <News.Hans_at_telus.net> wrote in message 
>> news:pan.2006.03.06.01.46.41.306283_at_telus.net...
>>> On Mon, 06 Mar 2006 00:34:01 +0000, Bob Jones wrote:

[snip]

>>> Please verify PostgreSQL - the docco I have seen, including version 8,
>>> does NOT support that statement. I'd appreciate a link to some
>>> verification.
>>>
>> 
>> Go to PostgreSQL web site, click on About tab. Look under "Highly 
>> Customizable" session.

>
> Thanks for that info.
>
> Not a whole lot to go on - almost looks like marketing ... I guess I'll
> have to dig. So far, it almost appears that the API may be there to
> support generic stored procedures, but the capability for Java may not
> have been set up yet.
>
> It certainly will be interesting to see the differences in how SPs will be
> used in the various environments. I smell opportunity <g>

One of the projects is called PL/Java.
http://gborg.postgresql.org/project/pljava

It is a third party module but I have seen discussions about moving it into the core database.

The windows installer includes it along other 3rd party modules. http://pginstaller.projects.postgresql.org/

-- 
John Koller

Received on Mon Mar 06 2006 - 00:38:51 CST