agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] IN/INOUT/OUT support in PL/JAVA
Date: Tue, 26 Apr 2005 13:25:11 +0200
Message-ID: <426E2517.3080106@mailblocks.com> (raw)
In-Reply-To: <20050426111804.9865.qmail@web30207.mail.mud.yahoo.com>
References: <20050426111804.9865.qmail@web30207.mail.mud.yahoo.com>

Altaf Malik wrote:

> Hello,
>  PL/JAVA 1.1 claims to support IN/INOUT and OUT parameters. Also it 
> recommends to use PostgreSQL 8.0.2 as a backend database. However i 
> could not find and support in the PostgreSQL8.0.2. Also there is no 
> support in the 8.0.2 protocol parse message to indecate if the 
> parameter is IN/OUT or INOUT.  Am i missing something?

The PL/Java announcement claims "The source of this version will compile 
with the CVS HEAD of the PostgreSQL source (at the time of release date 
that is) and IN/INOUT/OUT parameters are fully functional.". Perhaps not 
crystal clear, but what I meant to say with this was that the 
IN/INOUT/OUT parameters that are functional in CVS HEAD of PostgreSQL 
are also supported in PL/Java. There's no way you can get it to work 
using PosgreSQL 8.0.x.

> Also if this is supported, how can i declare a function on the server 
> side to accept OUT or IN/OUT parameters. and how i can call them from 
> JDBC client.

You need to keep up with the bleeding edge development of PostgreSQL. 
When you do, you can read all about this in the documentation for the 
coming 8.1 version.

Regards,
Thomas Hallgren

view thread (3+ messages)  latest in thread

Message-ID: <426E2517.3080106@mailblocks.com>
Permalink:  ../426E2517.3080106@mailblocks.com/
Also on:    postgresql.org/message-id/426E2517.3080106@mailblocks.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] IN/INOUT/OUT support in PL/JAVA
  In-Reply-To: <426E2517.3080106@mailblocks.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox