From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Why is bool == java.sql.Types.BIT ?? |
Date: | 2005-11-24 16:34:00 |
Message-ID: | dm4q1m$qk1$1@sea.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Oliver Jowett wrote on 24.11.2005 00:50:
> 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.
>
Yes of course I can and actually I do when using PreparedStatements
But when I'm generating SQL Scripts I need to use the correct literal
for such a column.
Regards
Thomas
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2005-11-24 19:52:28 | Re: org.postgresql.util.PSQLException Column name candidates.id |
Previous Message | Roman Chervotkin | 2005-11-24 13:58:11 | org.postgresql.util.PSQLException Column name candidates.id wasn't found in the ResultSet |