Re: 8.2dev-500.jdbc3 driver: PreparedStatement.toString() is buggy - Mailing list pgsql-jdbc

From j.random.programmer
Subject Re: 8.2dev-500.jdbc3 driver: PreparedStatement.toString() is buggy
Date
Msg-id 20051219233608.15135.qmail@web32002.mail.mud.yahoo.com
Whole thread Raw
In response to Re: 8.2dev-500.jdbc3 driver: PreparedStatement.toString()  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: 8.2dev-500.jdbc3 driver: PreparedStatement.toString()  (Oliver Jowett <oliver@opencloud.com>)
List 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

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Bug: Driver(8.2dev-500.jdbc3) does not handle boolean->BIT
Next
From: "j.random.programmer"
Date:
Subject: Re: Bug: Driver(8.2dev-500.jdbc3) does not handle boolean->BIT correctly