Postgres Pro
Downloads
Home   >   mailing lists

Re: Why is bool == java.sql.Types.BIT ?? - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Why is bool == java.sql.Types.BIT ??
Date
Msg-id 43850037.5000608@opencloud.com
Whole thread Raw
In response to Re: Why is bool == java.sql.Types.BIT ??  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: Why is bool == java.sql.Types.BIT ??  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-jdbc
Tree view 
Thomas Kellerer wrote:

> The problem comes when supporting multiple DBMS. With MS SQL Server a
> bit column can only store 0/1 (which is not what the driver returns, as
> it uses a java.lang.Boolean) but PG only accepts the literals
> true/false. That's why I stumbled over this in the first place.
>
> So I'll have to check the native type rather then the JDBC type to be sure.

Can't you use setBoolean()/getBoolean()? I think that's specified to
always work on a BIT column, whatever the real underlying type is.

-O

pgsql-jdbc by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Why is bool == java.sql.Types.BIT ??
Next
From: Oliver Jowett
Date:
Subject: Re: Logging from multiple connections