pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Peter T Mount <peter@retep.org.uk>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Joseph Shraibman <jks@selectacast.net>
Cc: José AntonioMatute Calvo <cmaj@encomix.es>
Cc: pgsql-bugs@postgresql.org, pgsql-interfaces@postgresql.org, PostgreSQL jdbc list <pgsql-jdbc@postgresql.org>
Subject: Re: Re: [INTERFACES] jdbc driver:  Support for 'BOOL'
Date: Thu, 25 Jan 2001 08:26:50 -0500 (EST)
Message-ID: <980429210.3a70299abcb42@webmail.retep.org.uk> (raw)
In-Reply-To: <200101241419.JAA15011@candle.pha.pa.us>
References: <200101241419.JAA15011@candle.pha.pa.us>

Quoting Bruce Momjian <pgman@candle.pha.pa.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@selectacast.net
> > Increase signal to noise ratio.  http://www.targabot.com
> > 
> 
> 
> -- 
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.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@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/



view thread (5+ messages)  latest in thread

Message-ID: <980429210.3a70299abcb42@webmail.retep.org.uk>
Permalink:  ../980429210.3a70299abcb42@webmail.retep.org.uk/
Also on:    postgresql.org/message-id/980429210.3a70299abcb42@webmail.retep.org.uk

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: peter@retep.org.uk, pgman@candle.pha.pa.us, jks@selectacast.net, cmaj@encomix.es, pgsql-jdbc@postgresql.org
  Subject: Re: Re: [INTERFACES] jdbc driver:  Support for 'BOOL'
  In-Reply-To: <980429210.3a70299abcb42@webmail.retep.org.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox