如何关掉hibernate的SQL的log？

[miracleheaven]

我在log4j中的配置是这样子的，可是我的tomcat的console里每次都会有hibernate的SQL的log,怎样才能关掉呢？

### 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:%L - %m%n

### direct messages to files ###
#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:%L - %m%n

### direct messages to rollingfile ###
log4j.appender.rolling_file=org.apache.log4j.RollingFileAppender
log4j.appender.rolling_file.Threshold=debug
log4j.appender.rolling_file.File=rolling-hwms.log
log4j.appender.rolling_file.Append=true
log4j.appender.rolling_file.MaxFileSize=100KB
log4j.appender.rolling_file.MaxBackupIndex=1
log4j.appender.rolling_file.layout=org.apache.log4j.PatternLayout
log4j.appender.rolling_file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c:%L - %m%n

### set log levels - for more verbose logging change 'info' to 'debug' ###

log4j.rootLogger=debug, rolling_file

log4j.logger.net.sf.hibernate=warn, rolling_file

### log just the SQL
log4j.logger.net.sf.hibernate.SQL=error, rolling_file

### log JDBC bind parameters ###
#log4j.logger.net.sf.hibernate.type=info

### log schema export/update ###
#log4j.logger.net.sf.hibernate.tool.hbm2ddl=debug

### log cache activity ###
#log4j.logger.net.sf.hibernate.cache=debug

### log jdbc resource acquisition
#log4j.logger.net.sf.hibernate.impl.BatcherImpl=debug

### enable the following line if you want to track down connection ###
### leakages when using DriverManagerConnectionProvider ###
#log4j.logger.net.sf.hibernate.connection.DriverManagerConnectionProvider=trace

[zhenyang2002]

看看hibernate.cfg.xml 中 设定了 Show_sql 为 true 没有。

[EANFS]

只留这句log4j.rootLogger=debug

[YuLimin]

hibernate.cfg.xml中设置show_sql 为 false