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

Re: Re: [INTERFACES] BIT type still not working

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: iand(at)metamousetrap(dot)com, PostgreSQL jdbc list <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Re: [INTERFACES] BIT type still not working
Date: 2001-01-25 17:07:53
Message-ID: 980442473.3a705d691f08b@webmail.retep.org.uk (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-jdbc
Quoting Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>:

> 
> Anyone want to address this?

Added to the top of the list for Saturday. After looking at it, there's a 
couple of bits in the code I'm a bit suspicious of (with Boolean's).

Peter

> 
> [ 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
> 



-- 
Peter Mount peter(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/

In response to

pgsql-interfaces by date

Next:From: Adam LangDate: 2001-01-25 17:13:07
Subject: Re: RE: [PATCHES] ODBC Patch for OJs/Large Querys & Rows
Previous:From: Dave PageDate: 2001-01-25 16:53:11
Subject: RE: [ODBC] RE: [PATCHES] ODBC Patch for OJs/Large Querys & Rows

pgsql-jdbc by date

Next:From: Peter T MountDate: 2001-01-25 17:09:01
Subject: Re: Open items
Previous:From: Peter EisentrautDate: 2001-01-25 16:37:08
Subject: Re: Open 7.1 items

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