적자생존

<!-- pom.xml -->
<dependency>
    <groupId>ch.qos.logback</groupId>
    <artifactId>logback-classic</artifactId>
    <version>1.3.14</version>
</dependency>

<dependency>
    <groupId>org.lazyluke</groupId>
    <artifactId>log4jdbc-remix</artifactId>
    <version>0.2.7</version>
</dependency>

<!--
<exclusions>
    <exclusion>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
    </exclusion>
    <exclusion>
        <groupId>org.apache.logging.log4j</groupId>
        <artifactId>log4j-core</artifactId>
    </exclusion>
    <exclusion>
        <groupId>org.apache.logging.log4j</groupId>
        <artifactId>log4j-slf4j-impl</artifactId>
    </exclusion>
    <exclusion>
        <groupId>egovframework.rte</groupId>
        <artifactId>egovframework.rte.fdl.logging</artifactId>
    </exclusion>
</exclusions>
-->


<!-- logback.xml -->
<?xml version="1.0" encoding="UTF-8"?>
<configuration scan="false" scanPeriod="30 seconds">

	<appender name="console" class="ch.qos.logback.core.ConsoleAppender">
		<encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
			<pattern>%d{yyyy-MM-dd HH:mm:ss} [%thread] %-5level %logger{36} - %msg\n</pattern>
		</encoder>
	</appender>

	<appender name="console" class="ch.qos.logback.classic.AsyncAppender">
		<discardingThreshold>0</discardingThreshold>
		<queueSize>65536</queueSize>
		<appender-ref ref="console" />
	</appender>
	
	
	<!-- SQL Logger -->
	<logger name="jdbc" 				level="OFF" 	additivity="false"> <appender-ref ref="console" /> </logger>
	<logger name="jdbc.sqlonly" 		level="INFO" 	additivity="false"> <appender-ref ref="console" /> </logger>
	<logger name="jdbc.sqltiming" 		level="INFO" 	additivity="false"> <appender-ref ref="console" /> </logger>
	<logger name="jdbc.audit" 			level="OFF" 	additivity="false"> <appender-ref ref="console" /> </logger>
	<logger name="jdbc.resultset" 		level="OFF" 	additivity="false"> <appender-ref ref="console" /> </logger>
	<logger name="jdbc.resultsettable" 	level="INFO" 	additivity="false"> <appender-ref ref="console" /> </logger>
	<logger name="jdbc.connection" 		level="OFF" 	additivity="false"> <appender-ref ref="console" /> </logger>

	<logger name="java.sql" 			level="INFO" 	additivity="false"> <appender-ref ref="console" /> </logger>
	<logger name="egovframework" 		level="DEBUG" 	additivity="false"> <appender-ref ref="console" /> </logger>
	<logger name="org.springframework" 	level="INFO" 	additivity="false"> <appender-ref ref="console" /> </logger>

	<root level="INFO">
		<appender-ref ref="console" />
	</root>
	

</configuration>



<!-- datasource -->
<!-- cubrid -->
<bean id="dataSource-cubrid-spied" class="org.apache.commons.dbcp2.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="${Globals.DriverClassName}"/>
    <property name="url" value="${Globals.Url}" />
    <property name="username" value="${Globals.UserName}"/>
    <property name="password" value="${Globals.Password}"/>
</bean>

<bean id="dataSource-cubrid" class="net.sf.log4jdbc.Log4jdbcProxyDataSource">
    <constructor-arg ref="dataSource-cubrid-spied" />
    <property name="logFormatter">
        <bean class="net.sf.log4jdbc.tools.Log4JdbcCustomFormatter">
            <property name="loggingType" value="MULTI_LINE" />
            <property name="sqlPrefix" value="SQL::::      " />
        </bean>
    </property>
</bean>