This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes PreparedStatment Logging Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "PreparedStatment Logging" Watch "PreparedStatment Logging" New topic

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

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:
subject: PreparedStatment Logging
It's not a secret anymore!