Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group