Two Laptop Bag*
The moose likes JDBC and the fly likes PreparedStatment Logging Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "PreparedStatment Logging" Watch "PreparedStatment Logging" New topic
Author

PreparedStatment Logging

Gobind Singh
Ranch Hand

Joined: Aug 04, 2006
Posts: 62
Please can someone tell me how to print out (or log via log 4j) the preparedstatment sent through JDBC.

If I have a java.sql.Statement object which uses a query like:
select name from company where sector = 'USA'
then I can print out this entire query to my log file every time it is executd.

If I have a preparedStatement like:
select name from company where sector = ?

Then when I print the sql I get "select name from company where sector = ?
"
But I want to be able to see what has binded to the ? parameter marker at runtime.

Any ideas?
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Its always worth searching the forum before posting. Your question may have already been answered.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: PreparedStatment Logging