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

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

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

Oliver Jowett

2005-12-20, 3:24 am

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Sponsored Links