0

I want to know to how to log the prepared statement query after binding with variables in java.

In the program I added log4j jar file and created log4j.properties also.

log4j.rootLogger=debug,stdout,R

log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{MMM dd yyyy HH:mm:ss} [%c] %p - %m%n

log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
log4j.logger.java.sql.ResultSet=DEBUG

By using this log4j properties. In output I get prepared statement as a object only not as query .What mistake I did in this?

Paakiya
  • 11
  • 4
  • There might be sufficient explanations here https://stackoverflow.com/questions/2382532/how-can-i-get-the-sql-of-a-preparedstatement or here https://stackoverflow.com/questions/2683214/get-query-from-java-sql-preparedstatement – Andreas Nov 15 '21 at 14:48

0 Answers0