Re: JPOX Types.CHAR error - Mailing list pgsql-jdbc

From Andy Jefferson
Subject Re: JPOX Types.CHAR error
Date
Msg-id 200605160908.05250.andy@jpox.org
Whole thread Raw
In response to JPOX Types.CHAR error  ("Jason Porter" <Jason.Porter@student.neumont.edu>)
Responses Re: JPOX Types.CHAR error  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
> A quick check reveals nothing obviously wrong with how
> DatabaseMetaData.getTypeInfo returns data for Types.CHAR.

Well that depends on your point of view ;-)
PSQL 8.1-405 JDBC driver now returns SQL type "char" as Types.OTHER (instead
of Types.CHAR), and returns "bpchar" as Types.CHAR. Since PSQL has always
supported "char" as Types.CHAR (since it kinda seems reasonable), JPOX uses
that as the default ... and it is no longer there (yet is in PSQL 8.0). I can
set up JPOX to fake this type for users so they see no change but it would
make more sense (to me) to have the JDBC driver return consistent with
previous incarnations. Maybe there was a good reason why "char" is no longer
Types.CHAR ?

--
Andy

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: jdbc driver problem?
Next
From: Kris Jurka
Date:
Subject: Re: JPOX Types.CHAR error