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

Re: Wrong SqlType for boolean columns

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Wrong SqlType for boolean columns
Date: 2010-07-28 09:15:42
Message-ID: i2osfu$vem$1@dough.gmane.org (view raw or flat)
Thread:
Lists: 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


In response to

Responses

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2010-07-28 09:19:47
Subject: Re: Wrong SqlType for boolean columns
Previous:From: Oliver JowettDate: 2010-07-28 08:59:47
Subject: Re: Wrong SqlType for boolean columns

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