Getting query SQL from a JDBC PreparedStatement
- From: Larry Coon <lcnospam@xxxxxxxxxx>
- Date: Mon, 05 Jun 2006 11:39:32 -0700
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?
.
- Follow-Ups:
- Re: Getting query SQL from a JDBC PreparedStatement
- From: joeNOSPAM@xxxxxxx
- Re: Getting query SQL from a JDBC PreparedStatement
- From: IchBin
- Re: Getting query SQL from a JDBC PreparedStatement
- Prev by Date: Re: To hibernate or not to hibernate?
- Next by Date: Re: Getting query SQL from a JDBC PreparedStatement
- Previous by thread: hibernate - what is wrong??
- Next by thread: Re: Getting query SQL from a JDBC PreparedStatement
- Index(es):
Relevant Pages
|