log4j 설정

* MyBatis 의 로그 log4jdbc-log4j2 설정

1) pom.xml --> 추가

<!-- https://mvnrepository.com/artifact/org.bgee.log4jdbc-log4j2/log4jdbc-log4j2-jdbc4 -->
<dependency>
    <groupId>org.bgee.log4jdbc-log4j2</groupId>
    <artifactId>log4jdbc-log4j2-jdbc4</artifactId>
    <version>1.16</version>
</dependency>

 

2) root-context.xml --> 주석처리, 추가

<!-- db연결 -->
<!-- <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
    <property name="url" value="jdbc:mysql://localhost:3306/spring"></property>
    <property name="username" value="root"></property>
    <property name="password" value="1111"></property>
</bean> -->

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="net.sf.log4jdbc.sql.jdbcapi.DriverSpy"></property>
    <property name="url" value="jdbc:log4jdbc:mysql://localhost:3306/spring"></property>
    <property name="username" value="root"></property>
    <property name="password" value="1111"></property>
</bean>

 

3) log4jdbc.log4j2.properties

(1) src/main/resources 우클릭 > new > other > general - untitled Text File > finish 

 

(2) log4jdbc.spylogdelegator.name=net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator 입력 후 ctrl + s

 

(3) file name : log4jdbc.log4j2.properties

     경로 : 프로젝트 명 > src > main > resources (mappers 있는 곳)

 

4) log4j.xml --> 추가

<!-- SQL Logger -->
<logger name="jdbc.connection" additivity="false">
    <level value="warn" />
    <appender-ref ref="console"/> 
</logger>

<logger name="jdbc.audit" additivity="false"> 
    <level value="warn"/>  
    <appender-ref ref="console"/> 
</logger>

<logger name="jdbc.resultset" additivity="false">
    <level value="warn" />
    <appender-ref ref="console"/> 
</logger>

<logger name="jdbc.sqlonly" additivity="false"> 
    <level value="info"/> 
    <appender-ref ref="console"/> 
</logger>

<logger name="jdbc.resultsettable" additivity="false"> 
    <level value="info"/>  
    <appender-ref ref="console"/> 
</logger> 

<logger name="jdbc.sqltiming" additivity="false">
    <level value="warn" />
    <appender-ref ref="console"/> 
</logger>

---

logger 어노테이션 사용 

@Log4j
public class MemberController {

log.info("hello===");

}

 

pom.xml --> logging 부분 맨밑에 runtime 주석처리하기

<!-- Logging -->
<scope>runtime</scope>