Re: Object types and ResultSets (java.sql.Struct)

On Sat, 23 Jan 2010, Thomas Kellerer wrote:

> DatabaseMetaData.getColumns() will return a java.sql.Types.STRUCT for the
> column "contact".
> That seems to be correct to me - at least this is what I expected ;)
>
> When running a "SELECT * FROM contacts", ResultSetMetaData.getColumnType()
> will return java.sql.Types.OTHER  (for the contact column)
>
> This seems to be inconsistent to me.
>
> My expectation was that ResultSetMetaData.getColumnType() should also return
> java.sql.Types.STRUCT

That should be easy enough to fix.  I'll take a look.

>  and that the object returned by getObject() on the
> ResultSet should implement java.sql.Struct (which it doesn't)
>

That one will take some more work.  I wouldn't hold my breath on that one.

Kris Jurka