log4日志文件只写入hibernate执行的sql语句怎么实现
我按照网上配置log4j.properties,配置如下:
# Root logger option
log4j.rootLogger=DEBUG,stdout,file
#log4j.rootLogger=INFO, stdout
log4j.logger.org.hibernate.type.descriptor.sql.BasicBinder=TRACE
log4j.logger.org.hibernate.type.descriptor.sql.BasicExtractor=TRACE
log4j.logger.org.hibernate.SQL=DEBUG
log4j.logger.org.hibernate.engine.QueryParameters=DEBUG
log4j.logger.org.hibernate.engine.query.HQLQueryPlan=DEBUG
# Redirect log messages to a log file
# Redirect log messages to a log file
log4j.appender.file=org.apache.log4j.RollingFileAppender
log4j.appender.file.Append=true
log4j.appender.file.File=d://log1.log
log4j.appender.file.MaxFileSize=5MB
log4j.appender.file.MaxBackupIndex=10
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %-5p %c{1}:%L - %m%n
日志文件格式打印类似如下:
2017-07-26 19:12:56 DEBUG DefaultListableBeanFactory:249 - Returning cached instance of singleton bean 'bdf2.applicationCache'
2017-07-26 19:12:56 DEBUG DefaultListableBeanFactory:249 - Returning cached instance of singleton bean 'bdf2.urlService'
2017-07-26 19:12:56 DEBUG DefaultListableBeanFactory:1595 - Invoking afterPropertiesSet() on bean with name 'bdf2.componentMetadataSource'
2017-07-26 19:12:56 DEBUG JdbcTemplate:443 - Executing SQL query [SELECT R.ID_,R.COMPANY_ID_,R.ENABLED_ FROM BDF2_ROLE R]
2017-07-26 19:12:56 DEBUG DataSourceUtils:110 - Fetching JDBC Connection from DataSource
2017-07-26 19:12:56 DEBUG DataSourceUtils:327 - Returning JDBC Connection to DataSource
2017-07-26 19:12:56 DEBUG JdbcTemplate:691 - Executing prepared SQL query
2017-07-26 19:12:56 DEBUG JdbcTemplate:625 - Executing prepared SQL statement [SELECT M.ID_,M.USERNAME_,M.DEPT_ID_,M.POSITION_ID_,M.GROUP_ID_,M.GRANTED_ FROM BDF2_ROLE_MEMBER M WHERE M.ROLE_ID_=?]
但是不想要sql执行上面的信息,只要sql语句,请问怎么实现