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

Поиск
Список
Период
Сортировка
От Andres Olarte
Тема Re: How to get the SQL query from a PreparedStatement?
Дата
Msg-id 3fccaa690711110946l764ea585w3cb0539892474e4a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to get the SQL query from a PreparedStatement?  (Oliver Jowett <oliver@opencloud.com>)
Список 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 по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: gborg -> pgfoundry
Следующее
От: joël Winteregg
Дата:
Сообщение: Re: XAResource implementation