问题:spring mvc mybatis 框架,server启动显示日志如下

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further detail

然后项目中没法显示 任何sql日志

解决:项目中加入sl4j pom依赖

原因:Mybatis默认使用slf4j

我的配置如下:pom

<dependency> 

 <groupId>log4j</groupId> 

 <artifactId>log4j</artifactId> 

 <version>1.2.17</version> 

 </dependency> 

 <dependency> 

 <groupId>org.slf4j</groupId> 

 <artifactId>slf4j-log4j12</artifactId> 

 <version>1.7.2</version> 

 </dependency> 

 <dependency> 

log4j.properties 

log4j.rootLogger=info,stdout, console 


log4j.appender.stdout=org.apache.log4j.ConsoleAppender 

log4j.appender.stdout.Target=System.err 

log4j.appender.stdout.layout=org.apache.log4j.SimpleLayout 


#ibatis logger config\u663E\u793ASQL\u8BED\u53E5\u90E8\u5206 

log4j.logger.com.ibatis=debug 

log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=debug 

log4j.logger.com.ibatis.common.jdbc.ScriptRunner=debug 

log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=debug 

log4j.logger.java.sql=debug,stdout 

log4j.logger.java.sql.Connection=debug 

log4j.logger.java.sql.Statement=debug 

log4j.logger.java.sql.PreparedStatement=debug,stdout 

---------------------



必须加上依赖

01 <dependency> 

02 <groupId>org.slf4j</groupId> 

03 <artifactId>slf4j-log4j12</artifactId> 

04 <version>1.7.5</version> 

05 </dependency> 

06 

07 <dependency> 

08 <groupId>org.slf4j</groupId> 

09 <artifactId>slf4j-api</artifactId> 

10 <version>1.7.5</version> 

11 </dependency>



否则是怎么配置log4j都是无法打印mybatis的sql到日志


log4j配置

1 # Direct log messages to console 

2 log4j.appender.console=org.apache.log4j.ConsoleAppender 

3 log4j.appender.console.Target=System.out 

4 log4j.appender.console.layout=org.apache.log4j.PatternLayout 

5 log4j.appender.console.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n 

6 

7 # Root logger option 

8 log4j.rootLogger=debug,console