[Spring]Connection Pool

[Connection Pool 설정 순서]

1. HikariCP lib 추가.
2. Oracle 접속(datasource) 정보가 필요. (스프링 빈으로 관리).
3. HikariCP와 datasource의 의존관계 설정 필요

[Dependency 추가]

<dependency>
	<groupId>com.zaxxer</groupId>
	<artifactId>HikariCP</artifactId>
	<version>2.7.4</version>
</dependency>

[접속정보 설정]

• root-context.xml에서 설정
• 접속정보 설정 후 datasource 의존성 추가

<!--hikaricp 라이브러리 추가-->
<bean id="hikariConfig" class="com.zaxxer.hikari.HikariConfig">
	<!--<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />-->
	<!--<property name="jdbcUrl" value="jdbc:oracle:thin:@61.98.217.46:1521:XE" />-->
	<property name="driverClassName" value="net.sf.log4jdbc.sql.jdbcapi.DriverSpy" />
	<property name="jdbcUrl" value="jdbc:log4jdbc:oracle:thin:@61.98.217.46:1521:XE" />
	<property name="username" value="book_ex" />
	<property name="password" value="book_ex" />
</bean>
	<!--hikaricp <> dataSource 의존성 추가-->
	<bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource" destroy-method="close">
		<constructor-arg ref="hikariConfig" />
	</bean>

[접속 방법]

@Setter(onMethod_ = @Autowired)
private DataSource dataSource;

public void testConnection() {
    try (Connection con = dataSource.getConnection()) {
        log.info(con);
    } catch (Exception e) {
        fail(e.getMessage());
    }
}