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.