Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0HFjk027819 for ; Wed, 17 Jan 2001 10:45:46 -0500 (EST) (envelope-from pgsql-bugs-owner@postgresql.org) Received: from p1.selectacast.net (p1.selectacast.net [206.41.1.251]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0FJrr099616; Mon, 15 Jan 2001 14:53:53 -0500 (EST) (envelope-from jks@selectacast.net) Received: from selectacast.net (IDENT:jks@d1 [209.219.91.66]) by p1.selectacast.net (8.9.3/8.9.3) with ESMTP id OAA16139; Mon, 15 Jan 2001 14:53:36 -0500 Message-ID: <3A635540.E420BD96@selectacast.net> Date: Mon, 15 Jan 2001 14:53:36 -0500 From: Joseph Shraibman Organization: Xtenit, Inc. http://www.xtenit.com X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.4.0 i686) X-Accept-Language: en MIME-Version: 1.0 To: =?iso-8859-1?Q?Jos=E9?= Antonio Matute Calvo CC: pgsql-bugs@postgresql.org, pgsql-interfaces@postgresql.org Subject: Re: [INTERFACES] jdbc driver: Support for 'BOOL' References: <93i2nh$2do8$1@news.tht.net> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200101/87 X-Sequence-Number: 462 "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