配置log4jdbc4 来显示jdbc真正的使用,及sql和sql时间
要用log4j或者slf4j,不支持logback
配置pom
<dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> <version>1.2.14</version> </dependency>
配置log4j.properties
log4j.rootCategory=INFO, stdout
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %t %c{2}:%L - %m%n
log4j.category.org.springframework.beans.factory=error
#log4jdbc
log4j.logger.jdbc.sqlonly=OFF
log4j.logger.jdbc.sqltiming=INFO
log4j.logger.jdbc.audit=OFF
log4j.logger.jdbc.resultset=OFF
log4j.logger.jdbc.connection=OFF
配置listener
<context-param> <param-name>log4jConfigLocation</param-name> <param-value>classpath:/log4j.properties</param-value> </context-param> <!-- 加载log4j配置文件 --> <listener> <listener-class> org.springframework.web.util.Log4jConfigListener </listener-class> </listener>
最后修改数据库连接配置:
把
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc\:mysql\://172.16.128.134\:3306/woqi_b2b_dev?useUnicode\=true&characterEncoding
\=UTF-8
修改为:
jdbc.driver=net.sf.log4jdbc.DriverSpy
jdbc.url=jdbc\:log4jdbc\:mysql\://172.16.128.134\:3306/woqi_b2b_dev?useUnicode\=true&characterEncoding\=UTF-8
重新启动就OK了