Re: 8.2dev-500.jdbc3 driver: PreparedStatement.toString() is buggy

From: "j(dot)random(dot)programmer" <javadesigner(at)yahoo(dot)com>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: 8.2dev-500.jdbc3 driver: PreparedStatement.toString() is buggy
Date: 2005-12-19 23:36:08
Message-ID: 20051219233608.15135.qmail@web32002.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Oliver:

> I don't think the driver or the spec has ever
> claimed that toString()
> gives you a valid SQL statement.

True :-)

However, note that it *used* to do so. This is a
regression from the past driver. And it would
be nice to have anyway, won't it ?

Also note in the past, booleans would get
converted to '1' and stored in BIT columns.
With the latest driver, java booleans are sent as
the number 1 (no quotes) and thus cannot be
stored in a BIT column, in direct contradiction to
the JDBC spec. (that's a different issue, see my
other post but I have a feeling it may somehow
be related).

Best regards,
--j

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message j.random.programmer 2005-12-19 23:41:36 Re: Bug: Driver(8.2dev-500.jdbc3) does not handle boolean->BIT correctly
Previous Message Oliver Jowett 2005-12-19 23:32:00 Re: Bug: Driver(8.2dev-500.jdbc3) does not handle boolean->BIT