Hi everyone,
When show_sql is set to true, we get message like that, with ? Sign in place of the bind parameter:
Hibernate: select t_activi0_.ID_ACO as ID_ACO__, ..., t_activi0_.ID_CC as ID_CC from DET.T_ACTIVITE_COMMERCIALE t_activi0_ where t_activi0_.ID_CC=?
Is it possible to replace those ? marks by the corresponding bind parameter? I tried logging with log4J as explained in the section 2.7 of the Hibernate2 Reference Documentation, but hibernate seems not to see log4J. I placed the following file in my class path:
### direct log messages to stdout ###
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
### direct messages to file hibernate.log ###
log4j.appender.file=org.apache.log4j.FileAppender
log4j.appender.file.File=hibernate.log
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
### set log levels - for more verbose logging change 'info' to 'debug' ##
log4j.rootLogger=warn, stdout
log4j.logger.net.sf.hibernate=debug
### enable the following line if you want to track down connection ###
### leakages when using DriverManagerConnectionProvider ###
#log4j.logger.net.sf.hibernate.connection.DriverManagerConnectionProvider=trace
### log JDBC bind parameters ###
log4j.logger.net.sf.hibernate.type=debug
### log prepared statement cache activity ###
log4j.logger.net.sf.hibernate.ps.PreparedStatementCache=debug
And also placed the log4j.jar file in my classpath. Bug this doesn't work. Does someone knows how to achieve that?
Thanks
Philip St-Pierre
Loto-Québec - Projet IRIS (Centre de livraison)
Analyste-Programmeur