JDBC: How to pass array in prepared statement for stored procedure execution? - Mailing list pgsql-general

From alebu
Subject JDBC: How to pass array in prepared statement for stored procedure execution?
Date
Msg-id 69e5d1d90811030719j4c422f77g418ac90755cc8a53@mail.gmail.com
Whole thread Raw
Responses Re: JDBC: How to pass array in prepared statement for stored procedure execution?
List 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 by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Are there plans to add data compression feature to postgresql?
Next
From: Tom Lane
Date:
Subject: Re: JDBC: How to pass array in prepared statement for stored procedure execution?