Getting query SQL from a JDBC PreparedStatement



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?
.



Relevant Pages