Re: PostgreSQL data types mapped Java classes for JDBC

From: dmp <danap(at)ttc-cmc(dot)net>
To: Thangalin <thangalin(at)gmail(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: PostgreSQL data types mapped Java classes for JDBC
Date: 2010-10-08 20:33:27
Message-ID: 4CAF8017.90607@ttc-cmc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Thangalin wrote:
> Hi, all.
>
>
> Where are all the PostgreSQL data types mapped to Java classes? I have
> found the following from an old mailing list message:
>
> 1 data_type_id Data Type Id java.lang.Integer int4 11
>
>
>
>
>
That list was generated by my application which I use to do exactly
what is indicated. Create/track changes that might occur in the JDBC
and database backend for the data types. The application creates the
data types mapping dynamically for each table and its critical that
I know if changes occur. I have not created the re-generated list for
the current 9.0 release, yet. I have the basics scripts and the app
generates the list. It usually only takes a few minutes. I could probably
put something together so others could run has needed to check
their configurations. I haven't checked lately if all the data types
are covered, I know enum aren't in the list.

danap.

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2010-10-08 22:27:02 Re: PostgreSQL data types mapped Java classes for JDBC
Previous Message Thangalin 2010-10-08 19:00:40 Re: PostgreSQL data types mapped Java classes for JDBC