[Spring] HikariCP 커넥션 풀 Java 8 버전 설정

라이브러리 추가

< pom.xml > 코드 추가

<!-- HikariCP -->
<dependency>
   <groupId>com.zaxxer</groupId>
   <artifactId>HikariCP</artifactId>
   <version>4.0.3</version>
</dependency>

 

 

DataSource 설정

< root-context.xml > 코드 추가

<bean id="hikariConfig" class="com.zaxxer.hikari.HikariConfig"> 
    <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property> 
    <property name="jdbcUrl" value="jdbc:oracle:thin:@localhost:1521:orcl"></property> 
    <property name="username" value="book_ex"></property> 
    <property name="password" value="book_ex"></property> 
</bean> 
 
<bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource" destroy-method="close"> 
    <constructor-arg ref="hikariConfig"></constructor-arg> 
</bean>

 

테스트 코드

package com.peisia.persistence;

import java.sql.Connection;

import javax.sql.DataSource;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("file:src/main/webapp/WEB-INF/spring/root-context.xml")
public class DataSourceTests {
 
    @Autowired
    private DataSource dataSource;
    
    @Test
    public void testConnection() {
      
        try(Connection con = dataSource.getConnection();){
            
            System.out.println("con = " + con);
            
        } catch(Exception e) {
            
            e.printStackTrace();
            
        }
        
    }
    
}

 

Log4jdbc-log4j2 사용 시

DataSource 설정

< root-context.xml > 코드 변경

<property name="driverClassName" value="net.sf.log4jdbc.sql.jdbcapi.DriverSpy"></property>
<property name="jdbcUrl" value="jdbc:log4jdbc:oracle:thin:@localhost:1521:orcl"></property>