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-08-10 20:00:38
Message-ID: alpine.BSO.2.00.1008101559590.3528@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbc

On Fri, 29 Jan 2010, Kris Jurka wrote:

> 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.

I've applied a fix to this for 8.3, 8.4, and 9.0 in CVS.

Kris Jurka

In response to

Responses

pgsql-jdbc by date

Next:From: Andreas Joseph KroghDate: 2010-08-10 21:00:49
Subject: Re: Object types and ResultSets (java.sql.Struct)
Previous:From: Kris JurkaDate: 2010-08-10 18:19:28
Subject: Re: Concurrency issue in EscapedFunctions

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