PreparedStatement and prewiev SQL query

Thread view:

Enable EMail Alerts

Start New Thread

tomas - 16 Sep 2006 15:15 GMT

I have question it is posible to see SQL query when I use PreparedStatement
and print SQL query to console ?

Reply to this Message

Arne Vajhøj - 16 Sep 2006 16:25 GMT

> I have question it is posible to see SQL query when I use
> PreparedStatement and print SQL query to console ?

Yes. But only with the ? not with the data.

Arne

Reply to this Message

Tom Cole - 16 Sep 2006 16:31 GMT

> I have question it is posible to see SQL query when I use PreparedStatement
> and print SQL query to console ?

Not all drivers support this, and it's not part of the standard, but
many will allow you to call toString() (after you've set your
parameters) and see the SQL Statement.

Connector/J does this, the PostgreSQL driver does this as well. I
haven't tried jTDS or the JDBC/ODBC Bridge...

You may also find this useful:

http://www.javaworld.com/javaworld/jw-01-2002/jw-0125-overpower.html

Reply to this Message

Bomber - 16 Sep 2006 17:14 GMT

Thy this software, it intercepts the database call and prints out both
the original sql and the sql with the substitution values into a log
file.

http://www.p6spy.com/

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...