Re: meta data information returned for domains - Mailing list pgsql-jdbc

From Iain
Subject Re: meta data information returned for domains
Date
Msg-id 000a01c4d90f$613a8b20$7201a8c0@mst1x5r347kymb
Whole thread Raw
In response to meta data information returned for domains  ("Iain" <iain@mst.co.jp>)
Responses Re: meta data information returned for domains
List pgsql-jdbc
An update.

So far I've tried using the "SOURCE_DATA_TYPE" column of the result set
returned by getColumns but this column doesn't exist.

Next I tried calling getUDTs but apparently this method isn't implemented
yet.

I noticed some discussion about implementing the getUDTs method in the lists
and references to it in the change log so maybe this has been done already
and I just need a more recent version. I'm using pg74.215.jdbc3.jar (on
7.4.6).

...regards
Iain
----- Original Message -----
From: "Iain" <iain@mst.co.jp>
To: <pgsql-jdbc@postgresql.org>
Sent: Friday, December 03, 2004 12:13 PM
Subject: [JDBC] meta data information returned for domains


> Hi guys,
>
> I'm hoping someone can give me some advice for handling postgres domains
> withing JDBCs metadata...
>
> I'm using the JDBC database metadata facilities to get information about
> tables for the purposes of auto generating program code. This has all been
> working fine until I got to testing it on a database that uses domains as
> the datatypes for the columns.
>
> I havn't had a chance to investigate it thoroughly yet, but it I'm getting
> a datatype code of 1111 when the columns datatype is a domain. , I don't
> know if this has any special meaning or not, but it doesn't correspond to
> any of the java.sql types that I was comparing it to, so for now my code
> is broken.
>
> I had a look around for information on this but didn't come up with
> anything... (yet) so I'm hoping someone here could point me in the right
> direction. Most essentially, I'd like to know if there is a standard way
> to get the base datatype information as that is what I need for code
> generation.
>
> regards
> Iain
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings


pgsql-jdbc by date:

Previous
From: "Iain"
Date:
Subject: meta data information returned for domains
Next
From: "Markus Wollny"
Date:
Subject: Re: java.net.SocketException: Connection reset by peer: socket write error