[Java] 나만의 Log4j

이건 저만의 설정인데요

^^.. 설명은 생략해볼게요

 

 

log4jdbc.log4j2.properties

log4jdbc.spylogdelegator.name=net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator
log4jdbc.dump.sql.maxlinelength=0


pom.xml

<!-- Custom maven :S -->
	<dependency>
		<groupId>org.bgee.log4jdbc-log4j2</groupId>
		<artifactId>log4jdbc-log4j2-jdbc4.1</artifactId>
		<version>1.16</version>
	</dependency>
<!-- Custom maven :E -->


datasource

driver-class-name: net.sf.log4jdbc.sql.jdbcapi.DriverSpy
jdbc-url: jdbc:log4jdbc:mariadb


log4j.xml

<configuration>
	<appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
		<encoder>
			<pattern>%green(%d{yyyyMMdd HH:mm:ss.SSS}) %cyan([%thread]) %highlight(%-3level) %yellow(%logger{5}) - %white(%msg) %n</pattern>
		</encoder>
	</appender>

	<logger name="jdbc" level="OFF"/>
	<logger name="jdbc.sqlonly" level="INFO"/>
	<logger name="jdbc.sqltiming" level="INFO"/>
	<logger name="jdbc.audit" level="OFF"/>
	<logger name="jdbc.resultset" level="OFF"/>
	<logger name="jdbc.resultsettable" level="INFO"/>
	<logger name="jdbc.connection" level="OFF"/>

	<root level="INFO">
		<appender-ref ref="STDOUT" />
	</root>
</configuration>


sqlSessionFactory

/* Custom DataSource : S */
	Log4jdbcProxyDataSource log4jdbcProxyDataSource = new Log4jdbcProxyDataSource(dataSource);
	Log4JdbcCustomFormatter log4JdbcCustomFormatter = new Log4JdbcCustomFormatter();
	log4JdbcCustomFormatter.setLoggingType(LoggingType.MULTI_LINE);
	log4JdbcCustomFormatter.setSqlPrefix("\nSQL ::::: ㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡ\n");
	log4jdbcProxyDataSource.setLogFormatter(log4JdbcCustomFormatter);
	final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
	sessionFactory.setDataSource(dataSource);
	sessionFactory.setDataSource(log4jdbcProxyDataSource);

/* Custom DataSource : E */