Hikari - 히카리 커넥션 풀(Connection pool) 사용해보기

 

시작 이전에 필요한 라이브러리를 받아줘야 한다.

1. HikariCP

HikariCP-4.0.3.jar

0.15MB

2. slf4j-api

slf4j-api-1.7.36.jar

0.04MB

---

 

- DBconn.java

package utils;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Properties;

import javax.sql.DataSource;

import com.zaxxer.hikari.HikariConfig;
import com.zaxxer.hikari.HikariDataSource;

public class DBconn {
	public static Connection getConnection() throws SQLException, ClassNotFoundException {
		HikariConfig hikariConfig = new HikariConfig();
		hikariConfig.setDriverClassName("oracle.jdbc.driver.OracleDriver");
		hikariConfig.setJdbcUrl("jdbc:oracle:thin:@localhost:1521/xe");
		hikariConfig.setUsername("hr");
		hikariConfig.setPassword("1234");
		
		@SuppressWarnings("resource")
		Connection conn = new HikariDataSource(hikariConfig).getConnection();

		return conn;
	}
}

 

- 커넥션 확인

public static void main(String[] args) throws Exception{ // 커넥션 정산인지 테스트.
		System.out.println(getConnection());
//		CallableStatement cstmt = getConnection().prepareCall("{call proc_test(?)}");
//		cstmt.setString(1, "javamail2");
//		cstmt.executeUpdate();
	}

DB HR에 HikariCP를 통한 계정 접속 확인 

 

- DB의 HR계정에 생성한 'PROC_TEST'  프로시저 

 

값 넣어보기

public static void main(String[] args) throws Exception{ 
//		System.out.println(getConnection());
		CallableStatement cstmt = getConnection().prepareCall("{call proc_test(?)}");
		cstmt.setString(1, "javamail2");
		cstmt.executeUpdate();
	}

 

HIKARICP를 통한 데이터 입력 완료