Re: JDBC and composite types - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: JDBC and composite types
Date
Msg-id Pine.BSO.4.64.0705211122380.2299@leary.csoft.net
Whole thread Raw
In response to JDBC and composite types  (Marcin Gala <mailing@siec.mine.nu>)
List pgsql-jdbc

On Sat, 19 May 2007, Marcin Gala wrote:

> Could anyone tell me, how to read table's columns that are of composite type?
> I was trying to use getObject with different types of casting, however
> nothing worked

Technically getObject on a complex type should return an instance of
java.sql.Struct by default or an instance of java.sql.SQLData if the type
has been mapped to a specific java class.  This has not been implemented
in the pg driver yet though.

> :( Also getString doesn't give me a string representation of type...
>

It does for me.  See the attached example.

Kris Jurka

Attachment

pgsql-jdbc by date:

Previous
From: Marcin Gala
Date:
Subject: JDBC and composite types
Next
From: Kris Jurka
Date:
Subject: Re: Insert (or update) to a partitioned table returns 0 rows updated