Re: "out" parameters in CallableStatements - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: "out" parameters in CallableStatements
Date
Msg-id Pine.BSO.4.56.0409231355460.5455@leary.csoft.net
Whole thread Raw
In response to "out" parameters in CallableStatements  ("David Parker" <dparker@tazznetworks.com>)
List pgsql-jdbc

On Thu, 23 Sep 2004, David Parker wrote:

> Is the JDBC driver doing something special to support the
> registerOutParameter call? Assuming that it is using this to map the
> return value of the stored procedure, does it check that only one OUT
> parameter is registered, or limit it to parameter 1?
>

It is currently limited to the first parameter.  Dave Cramer has produced
a patch to allow full in/out parameter support, but this requires some
complicated modifications to the stored procedure code.  Since no one
has really requested this functionality and people are discussing adding
real in/out backend support for 8.1 we are currently waiting to see how
the real backend support works out before introducing this temporary hack
that will undoubtedly cause some backward compatibility problems.

http://archives.postgresql.org/pgsql-jdbc/2004-09/msg00004.php

Kris Jurka

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: JDBC DRIVER FOR HANDHELDS
Next
From: "Qi, Xlaoyan"
Date:
Subject: telnet to port 5432 failed