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>

출처 : https://code.google.com/p/log4jdbc-remix/ 외