Re: How to get the SQL query from a PreparedStatement?

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(at)opencloud(dot)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
>