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

Re: Re: [INTERFACES] jdbc driver: Support for 'BOOL'

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Joseph Shraibman <jks(at)selectacast(dot)net>, =?ISO-8859-1?Q?Jos=E9_Antonio?=Matute Calvo <cmaj(at)encomix(dot)es>, pgsql-bugs(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Re: [INTERFACES] jdbc driver: Support for 'BOOL'
Date: 2001-01-26 09:26:16
Message-ID: 980501176.3a7142b89a36f@webmail.retep.org.uk (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-interfacespgsql-jdbc
Quoting Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>:

> 
> Seems the BIT type works in Java 7.1 beta now.

Has anything changed with boolean types in the backend then, as nothing has 
been done on the JDBC side?

> 
> [ Charset ISO-8859-1 unsupported, converting... ]
> > "Jos? Antonio Matute Calvo" wrote:
> > > 
> > > Problem:
> > >     If try to use field of type "java.sql.Types.BIT" obtains error
> "Unknown
> > > Types Value"
> > > 
> > > Resolution:
> > > 
> > >     Add this:
> > > 
> > >     PreparedStatement.java
> > >     460,461d459
> > >     <                       case Types.BIT:
> > >     <                               set(parameterIndex,
> > > ((Boolean)x).booleanValue() ? "true" : "false");
> > 
> > Why not set(parameterIndex,x.toString())?
> > 
> > 
> > -- 
> > Joseph Shraibman
> > jks(at)selectacast(dot)net
> > Increase signal to noise ratio.  http://www.targabot.com
> > 
> 
> 
> -- 
>   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-bugs by date

Next:From: Peter T MountDate: 2001-01-26 09:31:13
Subject: Re: [JDBC] Re: no way in LargeObject API to detect short read?
Previous:From: Michael RichardsDate: 2001-01-26 05:59:10
Subject: Re: Postgres int rounding

pgsql-interfaces by date

Next:From: cbellDate: 2001-01-26 20:26:31
Subject: obtaining results from trigger
Previous:From: Michael MeskesDate: 2001-01-26 07:09:09
Subject: Re: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG

pgsql-jdbc by date

Next:From: Peter T MountDate: 2001-01-26 09:29:16
Subject: Re: [JDBC] Open 7.1 items
Previous:From: Hiroshi InoueDate: 2001-01-26 04:18:15
Subject: Re: Open 7.1 items

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