Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL data types mapped Java classes for JDBC

From: Thangalin <thangalin(at)gmail(dot)com>
To: Josh Kupershmidt <schmiddy(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: PostgreSQL data types mapped Java classes for JDBC
Date: 2010-10-08 18:30:08
Message-ID: AANLkTikr6zoVZ6jJK1TtmgpvECn5itwXW5__pR=ifo0h@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi, Josh.

Thanks for the tip.

Also, I disagree that the individual adapters should be stored external to
PostgreSQL. It would be trivial to set up a relation that:

   1. Maintains a current list of PostgreSQL data types.
   2. Maintains a list of adapters (perhaps with effective dating).
   3. Maps adapters to Java types.

This would centralize the knowledge and facilitate dynamic implementations
that, for whatever reason, need to know the correct data type mapping in an
adapter-agnostic fashion. (Ideally adapters would map the PostgreSQL data
types to Java classes the same way; centralizing the list would reveal to
everyone the differences in the adapters without having to scour the web.)

This doesn't have to be packaged with PostgreSQL distributions: it could be
offered as a separate script that people can run to update the information
schema.

Dave

In response to

pgsql-novice by date

Next:From: Helgi Örn HelgasonDate: 2010-10-08 21:42:11
Subject: MySQL --> PostgreSQL with PHP
Previous:From: Tom LaneDate: 2010-10-08 16:41:49
Subject: Re: Unicode escape codes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group