KOSA Spring - log4jdbc 설정

✅ 결과가 로그에 표로 출력됨

• 디버깅 시 유용

🗺️ 구조

root-context.xml

	<bean id="hikariConfig" class="com.zaxxer.hikari.HikariConfig">
<!-- 		<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/> -->
		<property name="driverClassName" value="net.sf.log4jdbc.sql.jdbcapi.DriverSpy"/>
<!-- 		<property name="jdbcUrl" value="jdbc:oracle:thin:@localhost:1521:XE"/> -->
		<property name="jdbcUrl" value="jdbc:log4jdbc:oracle:thin:@localhost:1521:XE"/>
		<property name="username" value="agent"/>
		<property name="password" value="1234"/>
	</bean>

pom.xml

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

💁‍♂️ 테스트 결과 달라짐

//INFO : jdbc.resultset - 1. ResultSet.getString(SYSDATE) returned 2025-04-17 15:35:10.0
//INFO : jdbc.resultset - 1. ResultSet.wasNull() returned false
//INFO : jdbc.resultsettable - 
//|----------------------|
//|sysdate               |
//|----------------------|
//|2025-04-17 15:35:10.0 |
//|----------------------|
//
//INFO : jdbc.resultset - 1. ResultSet.next() returned false
//INFO : jdbc.resultset - 1. ResultSet.close() returned void
//INFO : jdbc.audit - 1. Connection.getMetaData() returned oracle.jdbc.driver.OracleDatabaseMetaData@7afbf561
//INFO : jdbc.audit - 1. PreparedStatement.isClosed() returned false
//INFO : jdbc.audit - 1. PreparedStatement.close() returned 
//INFO : jdbc.audit - 1. Connection.clearWarnings() returned 
//INFO : org.zerock.sample.DataSourceTests - 2025-04-17 15:35:10.0
//INFO : org.springframework.context.support.GenericApplicationContext - Closing org.springframework.context.support.GenericApplicationContext@50caa560: startup date [Thu Apr 17 15:35:10 KST 2025]; root of context hierarchy
//INFO : com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Shutdown initiated...
//INFO : jdbc.connection - 1. Connection closed
//INFO : jdbc.audit - 1. Connection.close() returned 
//INFO : jdbc.connection - 2. Connection closed
//INFO : jdbc.audit - 2. Connection.close() returned 
//INFO : jdbc.connection - 3. Connection opened
//INFO : jdbc.audit - 3. Connection.new Connection returned 
//INFO : jdbc.audit - 3. Connection.setReadOnly(false) returned 
//INFO : jdbc.audit - 3. Connection.setAutoCommit(true) returned 
//INFO : jdbc.connection - 3. Connection closed
//INFO : jdbc.audit - 3. Connection.close() returned 
//INFO : com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Shutdown completed.