Re: Make procedure OUT parameters work with JDBC

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: Make procedure OUT parameters work with JDBC
Дата
Msg-id CAGRY4nwcryGTthVf+wkF2oOt1jktH-gdf-7s8M-OCVzOP+vcFw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Make procedure OUT parameters work with JDBC  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: Make procedure OUT parameters work with JDBC  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers


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 по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Hash support for row types
Следующее
От: Mark Dilger
Дата:
Сообщение: Reduce the dependence on access/xlog_internal.h