Mybatis의 로그 log4jdbc-log4j2 설정

디펜던시 추가

<dependency>          

  <groupId>org.bgee.log4jdbc-log4j2</groupId>            

<artifactId>log4jdbc-log4j2-jdbc4</artifactId>           

 <version>1.16</version>

</dependency>

메이븐 디펜던시에 

slf4j-log4j12-1.6.6.jar 파일이 추가됬는지 확인

root-contex.xml 파일 수정 

<bean id=“hikariConfig” class=“com.zaxxer.hikari.HikariConfig”>
<!– <property name=“driverClassName” 
value=“oracle.jdbc.driver.OracleDriver”></property>
<property name=“jdbcUrl” value=“jdbc:oracle:thin:@localhost:1521:xe”></property> –>
<property name=“driverClassName”
value=“net.sf.log4jdbc.sql.jdbcapi.DriverSpy”></property>
<property name=“jdbcUrl”
value=“jdbc:log4jdbc:oracle:thin:@localhost:1521:xe”></property>
<property name=“username” value=“jspexam”></property>
<property name=“password” value=“m1234”></property>
</bean>

하고 log4j.xml파일에 추가및 수정

<logger name=“jdbc.audit”>
<level value=“warn”/>
</logger>
<logger name=“jdbc.resultset”>
<level value=“warn”/>
</logger>
<logger name=“jdbc.connection”>
<level value=“warn”/>
</logger>
<!– Root Logger –>
<root>
<priority value=“info” />
<appender-ref ref=“console” />
</root>

그리고 timemappertests파일 junit 실행