Request a Demo
Home   >   mailing lists

Re: Make procedure OUT parameters work with JDBC - Mailing list pgsql-hackers

From Craig Ringer
Subject Re: Make procedure OUT parameters work with JDBC
Date
Msg-id CAGRY4nwcryGTthVf+wkF2oOt1jktH-gdf-7s8M-OCVzOP+vcFw@mail.gmail.com
Whole thread Raw
In response to Re: Make procedure OUT parameters work with JDBC  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: Make procedure OUT parameters work with JDBC
List pgsql-hackers
Tree view


On Mon, 19 Oct 2020, 19:16 Andrew Dunstan, <andrew@dunslane.net> wrote:

On 10/19/20 5:19 AM, Peter Eisentraut wrote:
> A follow-up to the recently added support for OUT parameters for
> procedures.  The JDBC driver sends OUT parameters with type void. 
> This makes sense when calling a function, so that the parameters are
> ignored in ParseFuncOrColumn().  For a procedure call we want to treat
> them as unknown.  This is of course a bit of a hack on top of another
> hack, but it's small and contained and gets the job done.
>

The JDBC spec defines CallableStatement.registerOutPararameter(...) variants that take SQLType enumeration value and optionally type name.

It's important that this change not break correct and fully specified use of the CallableStatement interface.

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Hash support for row types
Next
From: Mark Dilger
Date:
Subject: Reduce the dependence on access/xlog_internal.h