Re: Object types and ResultSets (java.sql.Struct) - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Object types and ResultSets (java.sql.Struct)
Date
Msg-id alpine.BSO.2.00.1001291637590.31378@leary.csoft.net
Whole thread Raw
In response to Object types and ResultSets (java.sql.Struct)  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: Object types and ResultSets (java.sql.Struct)  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc

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

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: ParameterMetaData getPrecision() always zero?
Next
From: Andrew Lindesay
Date:
Subject: Re: LIKE and ESCAPING in JDBC Select Statement