Thread: binding variable length array

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

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.
>

Have you tried getArray(int) for 'SELECT array ...'?

--
Fernando Nasser
Red Hat Canada Ltd.                     E-Mail:  fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario   M4P 2C9

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
>