Re: How to get the SQL query from a PreparedStatement? - Mailing list pgsql-jdbc

From Andres Olarte
Subject Re: How to get the SQL query from a PreparedStatement?
Date
Msg-id 3fccaa690711110946l764ea585w3cb0539892474e4a@mail.gmail.com
Whole thread Raw
In response to Re: How to get the SQL query from a PreparedStatement?  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Then, is it possible to use the driver just to format the parameters
into the PG format?  My guess is that it should be done somewhere, for
example when using setXXX methods.  But I haven't looked deep enough
in the source.  Would it be possible to use this functionality so I
don't have to reinvent the wheel?

On Nov 6, 2007 1:45 AM, Oliver Jowett <oliver@opencloud.com> wrote:
> Andres Olarte wrote:
>
> > Is it possible to get the query string (including the formatted
> > parameters) from a PreparedStatement?
>
> In general you can't because the query's not sent like that (the
> parameter values are sent out of line from the query).
>
> IIRC, PreparedStatement.toString() will give you an approximation, but
> I'm not sure how accurate the results are (and it's not part of the spec)
>
> -O
>

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: gborg -> pgfoundry
Next
From: joël Winteregg
Date:
Subject: Re: XAResource implementation