Re: UDT arrays

On Feb 8, 12:26 am, Lukas Eder <lukas.e...@gmail.com> wrote:
> I was wondering, is JDBC driver support for the combination of UDT's
> and arrays planned for the near future? I couldn't find any
> documentation on the JDBC drivers website.

After the rather confusing input about a third-party JDBC driver, I
can confirm that access to UDT arrays is possible via the standard
JDBC driver, if done like this:

    // This returns a serialised array. Not very convenient
    ResultSet rs =...
    String serialised = rs.getObject(index);

Or like this

    // This allows for iterating over array elements
    // and assembling it manually. I'll use this method
    // in jOOQ
    ResultSet rs =...
    ResultSet iterator = rs.getArray(index).getResultSet();

But not like this

    // This would be most convenient
    ResultSet rs =...
    Object[] array = rs.getArray(index).getArray();

> Is there any specific reason (apart from the fact that UDT's and/or
> ARRAYs are not used often) for this lack of implementation? Clearly,
> the database itself supports this combination. I can easily insert and
> select data from a table holding UDT arrays

The question was answered in another thread. I can live with the above
workaround...