Re: get the query created by PreparedStatement

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: Garry Thuna <garry(dot)thuna-pgsql-jdbc(at)tacticalExecutive(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: get the query created by PreparedStatement
Date: 2001-03-20 14:37:17
Message-ID: 985099037.3ab76b1dd46d0@webmail.retep.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Quoting Garry Thuna <garry(dot)thuna-pgsql-jdbc(at)tacticalExecutive(dot)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(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Julian Richardson 2001-03-20 14:49:32 pg703: support for Large objects via JDBC PreparedStatement.setBi naryStream()
Previous Message Garry Thuna 2001-03-20 14:19:18 Re: get the query created by PreparedStatement