How to get the SQL query from a PreparedStatement?

From: "Andres Olarte" <olarte(dot)andres(at)gmail(dot)com>
To: "Pgsql-Jdbc(at)Postgresql(dot)Org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: How to get the SQL query from a PreparedStatement?
Date: 2007-11-06 02:19:54
Message-ID: 3fccaa690711051819s15082dehd5c67951a6e43dee@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi!

Is it possible to get the query string (including the formatted
parameters) from a PreparedStatement?

The idea is to get the query text, to send it into an stored procedure
to be executed within the sp (with some other stuff). This is an idea
I had to simulate variable parameter lists in stored procs. Is it
possible?

Thanks in advance,

Andres

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2007-11-06 03:25:34 Re: Parsed Query Trees
Previous Message Oliver Jowett 2007-11-05 22:53:48 Re: Parsed Query Trees