From: | Andreas Joseph Krogh <andreak(at)officenet(dot)no> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Object types and ResultSets (java.sql.Struct) |
Date: | 2010-08-10 21:00:49 |
Message-ID: | 4C61BE01.8010505@officenet.no |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On 08/10/2010 10:00 PM, Kris Jurka wrote:
>
>
> 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.
>
What about this?
>> 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.
Without proper support for Struct returning custom-types (i.e. arrays of
arrays) becomes a pain. Any word on this?
--
Andreas Joseph Krogh<andreak(at)officenet(dot)no>
Senior Software Developer / CTO
------------------------+---------------------------------------------+
OfficeNet AS | The most difficult thing in the world is to |
Rosenholmveien 25 | know how to do a thing and to watch |
1414 Trollåsen | somebody else doing it wrong, without |
NORWAY | comment. |
| |
Tlf: +47 24 15 38 90 | |
Fax: +47 24 15 38 91 | |
Mobile: +47 909 56 963 | |
------------------------+---------------------------------------------+
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2010-08-10 21:05:18 | Re: Object types and ResultSets (java.sql.Struct) |
Previous Message | Kris Jurka | 2010-08-10 20:00:38 | Re: Object types and ResultSets (java.sql.Struct) |