Re: binding variable length array

Chris,

You can use the getArray() method to return a java.sql.Array object.
Currently there isn't any good way to set an array value, but selecting
one should be fine. There is a pending patch in the queue to better
support setting arrays.

thanks,
--Barry

Chris Faulkner wrote:
> Hello
>
> I have an variable length array in a table that I need to fetch into a Java
> structure via JDBC. What is the best way of doing this ? AT the moment, I am
> doing this
>
> select array[1], array[2], array[3], array[4] ..
>
> This only works because I know that whilst it varies in size, the array will
> never be larger than 4. But this is obviously not very nice.
>
> Thanks
>
> Chris
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>