Skip site navigation (1) Skip section navigation (2)

Re: f is not a valid bitstring

From: Peter Mount <peter(at)retep(dot)org(dot)uk>
To: "Skidmore, Walt" <walt(dot)skidmore(at)medinex(dot)com>, "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: f is not a valid bitstring
Date: 2001-02-24 18:04:23
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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.


>Thanks a bunch...
>Walt Skidmore

In response to

pgsql-jdbc by date

Next:From: Peter MountDate: 2001-02-24 18:06:59
Subject: Re: unable to find postgresql.jar
Previous:From: Peter MountDate: 2001-02-24 18:03:03
Subject: Re: Java class documentation

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group