f is not a valid bitstring

From: "Skidmore, Walt" <walt(dot)skidmore(at)medinex(dot)com>
To: "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: f is not a valid bitstring
Date: 2001-02-23 17:00:14
Message-ID: 965AEE931EB1D411BB0B00B0D0207AB90E19BD@EXCH01
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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?

Thanks a bunch...

Walt Skidmore

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Peter Eisentraut 2001-02-23 19:32:34 Re: Java class documentation
Previous Message Thomas Lockhart 2001-02-23 16:00:26 Re: Java class documentation