From: | "Skidmore, Walt" <walt(dot)skidmore(at)medinex(dot)com> |
---|---|
To: | "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | RE: f is not a valid bitstring |
Date: | 2001-02-23 23:17:39 |
Message-ID: | 965AEE931EB1D411BB0B00B0D0207AB90E19C2@EXCH01 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
An update: I looked through the documentation, and found that the bool type
might be better suited. So, after changing the field type, I'm getting a
new error:
java.sql.SQLException: ERROR: pg_atoi: error in "f": can't parse "f"
Any ideas?
Thanks...
> -----Original Message-----
> From: Skidmore, Walt
> Sent: Friday, February 23, 2001 9:00 AM
> To: 'pgsql-jdbc(at)postgresql(dot)org'
> Subject: f is not a valid bitstring
>
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Mount | 2001-02-24 17:43:41 | Re: Fw: jdbc.postgresql.org/docs/ |
Previous Message | Bob Kline | 2001-02-23 20:49:32 | Re: unable to find postgresql.jar |