egov 전자정부프레임워크 mariadb mybatis 로그 출력 (log4j2)

※ egov 전자정부프레임워크는 log4jdbc-remix가 사용되지 않습니다.

 

1. pom.xml

<!-- mybatis log4jdbc-log4j2 라이브러리 -->
        <dependency>
            <groupId>org.bgee.log4jdbc-log4j2</groupId>
            <artifactId>log4jdbc-log4j2-jdbc4</artifactId>
            <version>1.16</version>
        </dependency>
        <dependency>
            <groupId>net.sf</groupId>
            <artifactId>log4jdbc3</artifactId>
            <version>1.1</version>
        </dependency>

 

2. context-datasource.xml

DataBase.DriverClassName=org.mariadb.jdbc.Driver
=>DataBase.DriverClassName=net.sf.log4jdbc.sql.jdbcapi.DriverSpy
 
DataBase.Url=jdbc:mariadb://localhost:3306/utilMakeDB 
=>DataBase.Url=jdbc:log4jdbc:mariadb://localhost:3306/utilMakeDB

 

3. ( resources > ) log4jdbc.log4j2.properties 

log4jdbc.drivers=org.mariadb.jdbc.Driver
log4jdbc.spylogdelegator.name=net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator
log4jdbc.dump.sql.maxlinelength=0

 

4. ( resources > ) logback.xml

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
    <include resource="org/springframework/boot/logging/logback/base.xml"/>
    <!-- log4jdbc-log4j2 -->
    <logger name="jdbc.sqlonly" level="DEBUG"/>
    <logger name="jdbc.sqltiming" level="INFO"/>
    <logger name="jdbc.audit" level="WARN"/>
    <logger name="jdbc.resultset" level="ERROR"/>
    <logger name="jdbc.resultsettable" level="ERROR"/>
    <logger name="jdbc.connection" level="INFO"/>
</configuration>

 

5. ( resources > ) log4j2.xml 

<?xml version="1.0" encoding="UTF-8"?>
<Configuration>
    <Appenders>
        <!-- Console 출력을 위한 Appender -->
        <Console name="console" target="SYSTEM_OUT">
            <PatternLayout pattern="%d %5p [%c] %m%n" />
        </Console>
        <!-- 로그파일 생성을 위한 Appender -->
        <RollingFile name="dailyRollingFileAppender" fileName="d:/tdms_logs/tdms.log" filePattern="d:/tdms_logs/tdms_%d{yyyy-MM-dd}.log" append="true">
        <PatternLayout pattern="%d %5p [%c] %m%n" />
        <Policies>
        <TimeBasedTriggeringPolicy interval="1" modulate="true"/>
        </Policies>
    </RollingFile>
    </Appenders>
    <Loggers>
        <Logger name="java.sql" level="INFO" additivity="false">
            <AppenderRef ref="console" />
            <AppenderRef ref="dailyRollingFileAppender" />
        </Logger>
        <Logger name="egovframework" level="DEBUG" additivity="false">
            <AppenderRef ref="console" />
            <AppenderRef ref="dailyRollingFileAppender" />
        </Logger>
        <!-- log SQL with timing information, post execution -->
        <Logger name="jdbc.sqltiming" level="INFO" additivity="false">
            <AppenderRef ref="console" />
            <AppenderRef ref="dailyRollingFileAppender" />
        </Logger>
        <Logger name="org.springframework" level="INFO" additivity="false">
            <AppenderRef ref="console" />
            <AppenderRef ref="dailyRollingFileAppender" />
        </Logger>
        <Root level="INFO">
            <AppenderRef ref="console" />
            <AppenderRef ref="dailyRollingFileAppender" />
        </Root>
    </Loggers>
</Configuration>

 

차례대로 추가 및 수정

 

출처 : https://rhkdgus0779.tistory.com/53

egov 정부프레임워크 mariaDB MyBatis 로그 출력(log4j2)

 

출처의 출처 : https://www.leafcats.com/45