Skip site navigation (1) Skip section navigation (2)

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

From: Kris Jurka <books(at)ejurka(dot)com>
To: Thomas Kellerer <spam_eater(at)gmx(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Object types and ResultSets (java.sql.Struct)
Date: 2010-01-29 21:43:31
Message-ID: alpine.BSO.2.00.1001291637590.31378@leary.csoft.net (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-jdbc by date

Next:From: Andrew LindesayDate: 2010-01-29 21:48:56
Subject: Re: LIKE and ESCAPING in JDBC Select Statement
Previous:From: Kris JurkaDate: 2010-01-29 21:35:50
Subject: Re: ParameterMetaData getPrecision() always zero?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group