| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Iain <iain(at)mst(dot)co(dot)jp> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: meta data information returned for domains |
| Date: | 2004-12-06 09:13:49 |
| Message-ID: | Pine.BSO.4.56.0412060412160.4347@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On Fri, 3 Dec 2004, Iain wrote:
> 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.
1111 = Types.OTHER. We could consider resolving domains to their base
types and reporting that as the sql type. That seems like it would be
helpful in this situation.
Kris Jurka
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2004-12-06 09:19:08 | Re: meta data information returned for domains |
| Previous Message | Kris Jurka | 2004-12-06 09:10:18 | Re: ResultSet got NullPointerException on getMetaData calls |