JDBC: How to pass array in prepared statement for stored procedure execution?
JDBC: How to pass array in prepared statement for stored procedure execution?
От:
alebu <aleboo@gmail.com>
Дата:
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?
Re: JDBC: How to pass array in prepared statement for stored procedure execution?
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
alebu writes: > How can I pass an array of my objects into JDBC PreparedStatement object? The folks who would know this are more likely to notice your question if you ask on pgsql-jdbc ... regards, tom lane