logging parameters of prepared statements

[Phil Cruz]

In my hibernate log I'm get entries like

03/17 13:43:38 [ajp-bio-8014-exec-1] HIBERNATE DEBUG - select addons0_.subscriptionID as subscrip2_20_1_, addons0_.addOnID as addOnID21_1_, addons0_.addOnID as addOnID21_0_, addons0_.subscriptionID as subscrip2_21_0_, addons0_.orderNumber as orderNum3_21_0_ from addOns addons0_ where addons0_.subscriptionID=?

I want to see what the ? was bound to. I think I have that enabled by

log4j.logger.org.hibernate.type=DEBUG, HIBERNATELOGFILE

but it's not working. What am I missing? Here's the whole .properties file.

Thanks,
Phil

# Set root category priority to INFO and its only appender to CONSOLE.
log4j.rootCategory=INFO, CONSOLE
#log4j.rootCategory=INFO, CONSOLE, LOGFILE

### Setup Axis Log
log4j.logger.org.apache.axis=WARN, AXISCONSOLE
log4j.additivity.org.apache.axis=false

# Set the enterprise logger category to FATAL and its only appender to CONSOLE.
log4j.logger.org.apache.axis.enterprise=FATAL, AXISCONSOLE

###--------------- Hibernate Log Settings ------
### Set Hibernate log
log4j.logger.org.hibernate=ERROR, HIBERNATELOGFILE, HIBERNATECONSOLE

### log just the SQL
log4j.logger.org.hibernate.SQL=DEBUG, HIBERNATELOGFILE, HIBERNATECONSOLE
log4j.additivity.org.hibernate.SQL=false
### Also log the parameter binding to the prepared statements.
log4j.logger.org.hibernate.type=DEBUG, HIBERNATELOGFILE

### log schema export/update ###
#log4j.logger.org.hibernate.tool.hbm2ddl=ERROR

### log cache activity ###
log4j.logger.org.hibernate.cache=ERROR, HIBERNATECONSOLE
#---------------------------------------------

log4j.logger.net.sf.ehcache=ERROR

# CONSOLE is set to be a ConsoleAppender using a PatternLayout.
log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
log4j.appender.CONSOLE.Threshold=INFO
log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.CONSOLE.layout.ConversionPattern=%d{MM/dd HH:mm:ss} [%t] %-5p %m%n

# AXISCONSOLE is set to be a ConsoleAppender for Axis using a PatternLayout.
log4j.appender.AXISCONSOLE=org.apache.log4j.ConsoleAppender
log4j.appender.AXISCONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.AXISCONSOLE.layout.ConversionPattern=%d [%t] AXIS %-5p %c - %m%n

# LOGFILE is set to be a File appender using a PatternLayout.
log4j.appender.LOGFILE=org.apache.log4j.FileAppender
log4j.appender.LOGFILE.File=axis.log
log4j.appender.LOGFILE.Append=true
log4j.appender.LOGFILE.Threshold=INFO
log4j.appender.LOGFILE.layout=org.apache.log4j.PatternLayout
log4j.appender.LOGFILE.layout.ConversionPattern=%-4r [%t] %-5p %c %x - %m%n

# HibernateConsole is set to be a ColsoleAppender for Hibernate message using a PatternLayout.
log4j.appender.HIBERNATECONSOLE=org.apache.log4j.ConsoleAppender
log4j.appender.HIBERNATECONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.HIBERNATECONSOLE.layout.ConversionPattern=%d{MM/dd HH:mm:ss} [%t] HIBERNATE %-5p - %m%n%n

# HibernateLogFile is set to be a FileAppender for Hibernate message using a PatternLayout.
log4j.appender.HIBERNATELOGFILE=org.apache.log4j.FileAppender
log4j.appender.HIBERNATELOGFILE.layout=org.apache.log4j.PatternLayout
log4j.appender.HIBERNATELOGFILE.layout.ConversionPattern=%d{MM/dd HH:mm:ss} [%t] HIBERNATE %-5p - %m%n%n
log4j.appender.HIBERNATELOGFILE.File=C:/ColdFusion11/cfusion/logs/hibernatesql.log
log4j.appender.HIBERNATELOGFILE.Append=false
log4j.appender.HIBERNATELOGFILE.MaxFileSize=500KB
log4j.appender.HIBERNATELOGFILE.MaxBackupIndex=3

[Phil Cruz]

It should be

log4j.logger.org.hibernate.type=trace

http://stackoverflow.com/questions/1710476/print-query-string-in-hibernate-with-parameter-values