Re: f is not a valid bitstring - Mailing list pgsql-jdbc

From Peter Mount
Subject Re: f is not a valid bitstring
Date
Msg-id 5.0.2.1.0.20010224180327.009f8930@mail.retep.org.uk
Whole thread Raw
In response to f is not a valid bitstring  ("Skidmore, Walt" <walt.skidmore@medinex.com>)
List pgsql-jdbc
At 09:00 23/02/01 -0800, Skidmore, Walt wrote:

>I have an entity bean that uses a boolean for a field, and that boolean
>maps to a bit field in the database.  Is this the proper field I should be
>mapping to?  Under Sybase and MSSQL 7, there were no problems with sending
>"true" or "false" through the bean - something took care of it and mapped
>it properly.  Under Postgres 7.0.3, however, I consistently get this error:
>
>java.sql.SQLException: ERROR:  zpbit_in: f is not a valid bitstring
>
>I've traced it back, and found that it's taking the first letter of the
>boolean value and trying to put that into the bit field instead of
>changing it to a 1 or 0.  Any suggestions?


Ok, first what version are you using. Second what methods are you (or the
bean container) using to set it.

Peter


>Thanks a bunch...
>
>Walt Skidmore


pgsql-jdbc by date:

Previous
From: Peter Mount
Date:
Subject: Re: [DOCS] Java class documentation
Next
From: Peter Mount
Date:
Subject: Re: [INTERFACES] unable to find postgresql.jar