SQL로그 남기기(log4jdbc-log4j2)

pom.xml

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

src/main/resources/log4jdbc.log4j2.properties

log4jdbc.spylogdelegator.name=net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator

root-context.xml 수정

	<!-- DriverClassName과 jdbcUrl을 수정해주어야 함 -->
	<bean id="hikariConfig" class="com.zaxxer.hikari.HikariConfig" >
	   <property name="driverClassName" value="net.sf.log4jdbc.sql.jdbcapi.DriverSpy"></property>
	   <property name="jdbcUrl" value="jdbc:log4jdbc:oracle:thin:@localhost:1521:XE"></property>
	   <property name="username" value="c##book_ex"></property>
	   <property name="password" value="book_ex"></property>
	</bean>