Spring 실행 쿼리문 콘솔 출력 - log4jdbc-remix (feat. 메이븐)
mybatis를 쓰면서 실행쿼리문을 콘솔에서 확인하고 싶은데 알아본 것은 log4jdbc다.
하지만 log4jdbc는 메이븐을 지원하지 않아 좀 더 찾아본 결과 log4jdbc-remix가 있었다.
pom.xml
<!-- log4jdbc-remix -->
<dependency>
<groupId>org.lazyluke</groupId>
<artifactId>log4jdbc-remix</artifactId>
<version>0.2.7</version>
</dependency>
jdbc.properties
jdbc.driverClass=net.sf.log4jdbc.DriverSpy
jdbc.url=jdbc:log4jdbc:oracle:thin:@.....
log4j.xml
<!-- log4jdbc option log the jdbc results as a table -->
<logger name="jdbc.sqltiming" additivity="false">
<level value="debug" />
<appender-ref ref="console" />
</logger>
mybatis-context.xml
<bean id="dataSourceSpied" class="...">
<property name="driverClass" value="$"/>
<property name="jdbcUrl" value="$"/>
<property name="user" value="$"/>
<property name="password" value="$"/>
...
</bean>
<bean id="dataSource" class="net.sf.log4jdbc.Log4jdbcProxyDataSource">
<constructor-arg ref="dataSourceSpied" />
</bean>