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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group