Re: Getting query SQL from a JDBC PreparedStatement
- From: IchBin <weconsul@xxxxxxx>
- Date: Mon, 05 Jun 2006 15:17:31 -0400
Larry Coon wrote:
Using Sybase JConnect's implementation of JDBC in Java 1.5.
For logging/debug purposes, I want to get the SQL query text from
a PreparedStatement (which is a SybPreparedStatement in this
implementation). Something like:
String query = "select xxx from mytable where aaa = ? and bbb = ?";
SybPreparedStatement s = (SybPreparedStatement)
connection.prepareStatement(query);
s.setString(1, "sarg1");
s.setString(2, "sarg2");
------
At this point I want to get the query text, i.e.:
select xxx from mytable where aaa = "sarg1" and bbb = "sarg2"
From the prepared statement. toString() doesn't return the query,
it returns a string like:
com.sybase.jdbc2.jdbc.SybPreparedStatement@1f630dc
And I see no other methods that return a String. What am I missing
here?
This maybe a backwards way of doing it. I would use a debugger and step thru the instructions to find SybPreparedStatement and look it its content.
Thanks in Advance...
IchBin, Pocono Lake, Pa, USA http://weconsultants.servebeer.com/JHackerAppManager
__________________________________________________________________________
'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)
.
- References:
- Getting query SQL from a JDBC PreparedStatement
- From: Larry Coon
- Getting query SQL from a JDBC PreparedStatement
- Prev by Date: Getting query SQL from a JDBC PreparedStatement
- Next by Date: Re: Getting query SQL from a JDBC PreparedStatement
- Previous by thread: Getting query SQL from a JDBC PreparedStatement
- Next by thread: Re: Getting query SQL from a JDBC PreparedStatement
- Index(es):
Relevant Pages
|
