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

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: "j(dot)random(dot)programmer" <javadesigner(at)yahoo(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: 8.2dev-500.jdbc3 driver: PreparedStatement.toString()
Date: 2005-12-19 23:28:48
Message-ID: 43A74230.8030706@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

In response to

Responses

Browse pgsql-jdbc by date

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