Postgres Pro
Downloads
Home   >   mailing lists

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

From Oliver Jowett
Subject Re: 8.2dev-500.jdbc3 driver: PreparedStatement.toString()
Date
Msg-id 43A74230.8030706@opencloud.com
Whole thread Raw
In response to 8.2dev-500.jdbc3 driver: PreparedStatement.toString() is buggy  ("j.random.programmer" <javadesigner@yahoo.com>)
Responses Re: 8.2dev-500.jdbc3 driver: PreparedStatement.toString() is buggy  ("j.random.programmer" <javadesigner@yahoo.com>)
Meta Information about columns of a domain datatype ?  ("j.random.programmer" <javadesigner@yahoo.com>)
List pgsql-jdbc
Tree view 
j.random.programmer wrote:

> There seems to be a bug with the 8.2dev-500
> driver, running against a postgres 8.1 database.
>
> If I have a PreparedStatement, then when I say:
>
> System.out.println(ps)
>
> the the prepared statement that is printed is
> *missing* single quotes around data/time AND
> character/string values. This means that I
> cannot copy that preparedstatment and paste
> it directly into a psql session etc.

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

-O

pgsql-jdbc by date:

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