JDBC: How to pass array in prepared statement for stored procedure execution?

Поиск
Список
Период
Сортировка
От alebu
Тема JDBC: How to pass array in prepared statement for stored procedure execution?
Дата
Msg-id 69e5d1d90811030719j4c422f77g418ac90755cc8a53@mail.gmail.com
обсуждение исходный текст
Ответы Re: JDBC: How to pass array in prepared statement for stored procedure execution?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi list,
This question is general for any database JDBC but I think it's ok if
I post it here.
Lets say I have s stored procedure which gets an array of objects like
one of it IN parameters.
How can I pass an array of my objects into JDBC PreparedStatement object?
The only recomendation I saw was to pass an object which implements
Array interface,
but it looks quite complex for such a common task and not all methods
are well understandable to me.
Can anyone give a simple example of how it can be done?

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Are there plans to add data compression feature to postgresql?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: JDBC: How to pass array in prepared statement for stored procedure execution?