From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | iand(at)metamousetrap(dot)com |
Cc: | PostgreSQL jdbc list <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: [INTERFACES] BIT type still not working |
Date: | 2001-01-24 14:56:36 |
Message-ID: | 200101241456.JAA21411@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces pgsql-jdbc |
Anyone want to address this?
[ Charset ISO-8859-1 unsupported, converting... ]
> Is this true. If so, is there anytime schedule for a fix?
>
> Thanks, Ian
>
> Dan,
>
> I really think there is something wrong with the boolean (bit) type setting
> within the PostgreSQL JDBC driver. After checking w/ news groups and
> receiving one answer below, I think the only way I can accomplish what I
> need to is to go to postresql itself. Do you have any ideas?
>
> Hi Joe,
>
> I appreciate your response. I put in a workaround if I'm dealing with
> postgresql like the following:
>
>
> if (value instanceof Boolean &&
> getType().equals(PersistentStore.PostgreSQL))
> {
> Trace.println("Setting Boolean value for "+objAttr.getName()+"="+value);
> preparedStatement.setBoolean(i, ((Boolean)value).booleanValue());
> }
> else
> {
> preparedStatement.setObject(i, value);
> }
>
> and saw the output:
>
> ..
> SQL: insert into Car (License,Color,Logo,Sunroof) values (?,?,?,?)
> Setting Boolean value for Sunroof=false
> ..
>
> with exactly the same problem, so calling setBoolean didn't work either. Do
> you have any suggestions on how to get in touch with the appropriate
> PostgreSQL people?
> Thanks, Ian
>
> -----Original Message-----
> From: Joe Weinstein [mailto:joe(at)bea(dot)com]
> Sent: Monday, January 08, 2001 5:31 PM
> To: Ian deSouza
> Subject: Re: org.postgresql.Driver Problem?
>
>
>
> Ian deSouza wrote:
>
> Sorry, the value was equals to true when I get zpbit_in: t is not a valid
> bitstring and when value
> is false I get
> zpbit_in: f is not a valid bitstring .
>
> Hi Ian.
> You shouldn't use setObject() unless you are sending
> the driver a Driver-understandable java.sql Object.
> In this case, you should probably just use setBoolean().
>
>
>
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-01-24 15:59:45 | Re: problems connecting to postgresql with unixodbc |
Previous Message | Bruce Momjian | 2001-01-24 14:19:02 | Re: [INTERFACES] jdbc driver: Support for 'BOOL' |
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 2001-01-24 17:42:06 | Re: emails |
Previous Message | Mirko Zeibig | 2001-01-24 14:43:38 | JDBC: java.lang.ArrayIndexOutOfBoundsException: 256 |