Re: UDT arrays

On Feb 8, 12:26 am, Lukas Eder <lukas(dot)e(dot)(dot)(dot)(at)gmail(dot)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...