Re: passing user defined data types to stored procedures

Поиск
Список
Период
Сортировка
От Jay Howard
Тема Re: passing user defined data types to stored procedures
Дата
Msg-id 7569a8ec0811151020v4e4be7a8ld527f05f77508b80@mail.gmail.com
обсуждение исходный текст
Ответ на Re: passing user defined data types to stored procedures  (Kris Jurka <books@ejurka.com>)
Ответы Re: passing user defined data types to stored procedures
Список pgsql-jdbc
Actually it may not have been an array of integers.  I was doing stuff with composite types, so that may be the problem.  The message I got from getArray() indicated that the "full" version of that method, which it must call internally, wasn't implemented.  I'll verify tonight and respond with some sample code.

On Sat, Nov 15, 2008 at 12:02 PM, Kris Jurka <books@ejurka.com> wrote:


On Sat, 15 Nov 2008, Jay Howard wrote:

Is it possible to return (and pass) arrays using java.sql.Array?

I wrote a test proc that returns an array of integers.  I can retrieve it on
the java side as a Jdbc3Array, which implements java.sql.Array.

Unfortunately, getArray() (and its variants) seem not to have been
implemented yet by Jdbc3Array.


getArray is implemented and should work.  Perhaps you're getting confused because you're expecting to receive int[] and you're getting Integer[] instead?  It's tough to say what's going wrong without some example code.

Kris Jurka

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: passing user defined data types to stored procedures
Следующее
От: fschmidt
Дата:
Сообщение: committing an aborted transaction