Re: Wrong SqlType for boolean columns - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Wrong SqlType for boolean columns
Date
Msg-id alpine.BSO.2.00.1007281255450.9018@leary.csoft.net
Whole thread Raw
In response to Re: Wrong SqlType for boolean columns  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-jdbc

On Wed, 28 Jul 2010, Thomas Kellerer wrote:

> Oliver Jowett, 28.07.2010 10:59:
>> It is not a bug. BOOLEAN does not exist in earlier JDBC versions,
>> and drivers can map boolean types to either BIT or BOOLEAN. We pick
>> BIT so we can build drivers for earlier JDBC versions. (BIT is
>> something of a confusing type, as the mappings defined by JDBC for
>> the JDBC BIT type only really make sense for a single boolean value,
>> not a SQL BIT(n) type)
>
> Wouldn't it make sense to map this to BOOLEAN if the driver is built for
> JDBC4 and to BIT if is built for JDBC3?
>

Actually BIT is JDBC2 and BOOLEAN is JDBC3.  Since we no longer build
JDBC2 releases for the latest drivers, we could make this change, I'm just
not sure I see the point.  I guess we'd get fewer of these complaints.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: [HACKERS] Trouble with COPY IN
Next
From: James William Pye
Date:
Subject: Re: [HACKERS] Trouble with COPY IN