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

From Thomas Kellerer
Subject Re: Wrong SqlType for boolean columns
Date
Msg-id i2osfu$vem$1@dough.gmane.org
Whole thread Raw
In response to Re: Wrong SqlType for boolean columns  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: Wrong SqlType for boolean columns  (Oliver Jowett <oliver@opencloud.com>)
Re: Wrong SqlType for boolean columns  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Oliver Jowett, 28.07.2010 10:59:
>> i found out that my postgres driver maps a boolean column to the
>> sqlType -7, wich is java.sql.Types.BIT and not
>> java.sql.Types.Boolean (Boolean is 16). This is a very strange
>> behavior.
>>
>
> 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?

Regards
Thomas

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Wrong SqlType for boolean columns
Next
From: Oliver Jowett
Date:
Subject: Re: Wrong SqlType for boolean columns