Postgres Pro
Downloads
Home   >   mailing lists

Re: get the query created by PreparedStatement - Mailing list pgsql-jdbc

From Peter T Mount
Subject Re: get the query created by PreparedStatement
Date
Msg-id 985099037.3ab76b1dd46d0@webmail.retep.org.uk
Whole thread Raw
In response to Re: get the query created by PreparedStatement  (Garry Thuna <garry.thuna-pgsql-jdbc@tacticalExecutive.com>)
List pgsql-jdbc
Tree view 
Quoting Garry Thuna <garry.thuna-pgsql-jdbc@tacticalExecutive.com>:

> Eric,
>
> I have always wanted the same thing for both debugging as well as
> logging.

How about the toString() method ;-)

Ok, may not be standard JDBC, but:

PreparedStatement ps = ....;

// later
org.postgresql.jdbc2.PreparedStatement ps2 =
      (org.postgresql.jdbc2.PreparedStatement) ps;
System.out.println(ps2.toString());

Peter

--
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/

pgsql-jdbc by date:

Previous
From: Garry Thuna
Date:
Subject: Re: get the query created by PreparedStatement
Next
From: Julian Richardson
Date:
Subject: pg703: support for Large objects via JDBC PreparedStatement.setBi naryStream()