Need java.sql.Array impl for PreparedStatement.setArray()
Posted by: Dan Cooperstock
Date: June 13, 2005 11:57AM

I want to be able to call setArray on a PreparedStatement to set the value of a prepared parameter to an array value, for instance if the SQL is something like:

SELECT * from table WHERE column IN (?)

However, the type of the required 2nd argument to setArray that I need to call is the interface java.sql.Array, of which there does not appear to be any implementation.

Where would I get an implementation of this so that I can use it? For that matter, does this even work in MySQL?

I could take a crack at creating an implementation of Array, but it has a lot of methods, and it would sure help to know which ones really need to be implemented for the setArray() call to work.

Thanks.
-------------------------------------------------------------------
Dan Cooperstock, Senior Software Developer, Quest Software
260 King St. E., Toronto ON Canada M5A 4L5
dan.cooperstock@quest.com 416-933-5165

With Quest Software, you can expect more ... more performance, more productivity, more value from your IT investments.

Visit www.quest.com to learn how.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.