Viewing SQL from PreparedStatements

[Ben Klug]

Hi,

is there a way to view the SQL-Statement that was created from a PreparedStatement? I'd like to view it filled with parameters instead of ?'s for debug reasons.

Thanks, b.

[David O'Meara]

You almost answered your own question
Search for DebuggableStatement

[Avi Abrami]

Ben,
Perhaps P6 Spy will be of help.

David,
Were you referring to the JavaWorld article entitled Overpower the PreparedStatement?

Good Luck,
Avi.
[ February 14, 2005: Message edited by: Avi Abrami ]

[David O'Meara]

That's the one. I've found it very useful many times.