Re: Wrong SqlType for boolean columns

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