적자생존

pom.xml

	<properties>
		<log4j.version>2.3.2</log4j.version>
	</properties>

	<dependencies>
	    <dependency>
	        <groupId>org.apache.logging.log4j</groupId>
	        <artifactId>log4j-api</artifactId>
	        <version>${log4j.version}</version>
	    </dependency>
	    <dependency>
	        <groupId>org.apache.logging.log4j</groupId>
	        <artifactId>log4j-core</artifactId>
	        <version>${log4j.version}</version>
	    </dependency>
	    <dependency>
	        <groupId>org.apache.logging.log4j</groupId>
	        <artifactId>log4j-1.2-api</artifactId>
	        <version>${log4j.version}</version>
	    </dependency>

	    <dependency>
		    <groupId>org.bgee.log4jdbc-log4j2</groupId>
		    <artifactId>log4jdbc-log4j2-jdbc4.1</artifactId>
		    <version>1.16</version>
		</dependency>
	</dependencies>

log4j2.xml

<?xml version="1.0" encoding="UTF-8"?>
<Configuration status="WARN">
    <Appenders>
        <Console name="console" target="SYSTEM_OUT">
            <PatternLayout pattern="%d{HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg \n"/>
        </Console>

        <Console name="sql_console" target="SYSTEM_OUT">
            <PatternLayout pattern="%d{HH:mm:ss.SSS} - %msg%n"/>
        </Console>
    </Appenders>

    <Loggers>
        <Logger name="jdbc" level="OFF" additivity="false">
            <AppenderRef ref="sql_console"/>
        </Logger>
        <Logger name="jdbc.sqlonly" level="OFF" additivity="false">
            <AppenderRef ref="sql_console"/>
        </Logger>
        <Logger name="jdbc.sqltiming" level="INFO" additivity="false">
            <AppenderRef ref="sql_console"/>
        </Logger>
        <Logger name="jdbc.audit" level="ERROR" additivity="false">
            <AppenderRef ref="sql_console"/>
        </Logger>
        <Logger name="jdbc.resultset" level="OFF" additivity="false">
            <AppenderRef ref="sql_console"/>
        </Logger>
        <Logger name="jdbc.resultsettable" level="OFF" additivity="false">
            <AppenderRef ref="sql_console"/>
        </Logger>
        <Logger name="jdbc.connection" level="OFF" additivity="false">
            <AppenderRef ref="sql_console"/>
        </Logger>

        <Logger name="java.sql" level="INFO" additivity="false">
            <AppenderRef ref="console"/>
        </Logger>
        <Logger name="egovframework" level="DEBUG" additivity="false">
            <AppenderRef ref="console"/>
        </Logger>
        <Logger name="org.springframework" level="DEBUG" additivity="false">
            <AppenderRef ref="console"/>
        </Logger>
        <Logger name="org.mep.mobile" level="INFO" additivity="false">
            <AppenderRef ref="console"/>
        </Logger>

        <Root level="ERROR">
            <AppenderRef ref="console"/>
        </Root>
    </Loggers>
</Configuration>

log4jdbc.log4j2.properties

log4jdbc.spylogdelegator.name=net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator
log4jdbc.dump.sql.maxlinelength=0
log4jdbc.dump.resultset.type=table
log4jdbc.trim.sql=true
log4jdbc.drivers=Altibase.jdbc.driver.AltibaseDriver,oracle.jdbc.driver.OracleDriver

log4jdbc url , driver class nane

DriverClassName=net.sf.log4jdbc.sql.jdbcapi.DriverSpy 
Url=jdbc:log4jdbc:oracle:thin:@1.1.1.1:1521:test

jboss-deployment-structure.xml

<?xml version="1.0" encoding="UTF-8"?>
<jboss-deployment-structure>

    <deployment>
        <exclude-subsystems>
            <subsystem name="logging" />
        </exclude-subsystems>
        <exclusions>
            <module name="org.apache.commons.logging" />
            <module name="org.apache.log4j" />
            <module name="org.slf4j" />
        </exclusions>
    </deployment>

</jboss-deployment-structure>