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

Quoting Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>:

>
> Is this a bug? Can someone submit a patch?

Why not setBoolean(parameterIndex,((Boolean)x),booleanValue());

Also, unless it's changed postgres accepts 't' & 'f' not 'true' or 'false'?

Also, which PreparedStatement.java are we taking about, as there are 2 of them?

Peter

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