2-3. DBCP를 HikariCP로 변경하기

1. porm.xml에 dependency코드 추가

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

코드 추가 후 저장하고 기다리면 HikariCP jar파일이 생긴다.

 

2. context-spring-annotation.xml 에 코드 추가하고 오라클 조건에 맞게 코드 수정

<bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource" destroy-method="close">
        <constructor-arg>
            <bean class="com.zaxxer.hikari.HikariConfig">
                <constructor-arg>
                    <props>
                        <prop key="jdbcUrl">jdbc:oracle:thin:@localhost:1521:xe</prop><!--수정-->
                        <prop key="username">hr</prop><!--수정-->
                        <prop key="password">hr</prop><!--수정-->
                    </props>
                </constructor-arg>
                <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/><!--수정-->
                <property name="minimumIdle" value="5" />
                <property name="maximumPoolSize" value="10" />
                <property name="connectionTestQuery" value="select 1 from sys.dual" />
                <property name="connectionTimeout"  value="300000" />
            </bean>
        </constructor-arg>
    </bean>

 

3. mainSpring3.java파일에서 run 하면 콘솔창에 db결과가 잘 뜨는 것을 확인할 수 있다.

 

+ 잘 작성한 사례로 올라온 코드

 

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

<been id="hikariConfig" class="com.zexxer.hikari.HikariConfig">
 		<property name="diverClassName" value="oracle.jbdc.driver.OrcleDriver"></property>
 		<property name="jdbcUrl" value="jdbc:oracle:thin:@localhost:1521:xe"></property>
 		<property name="username" value="test"></property>
 		<property name="password" value="test"></property>
 	</been>
 	
 	<!-- HikariCP configuration -->
 	
 	<been id="dataSource" class="com.zexxer.hikari.HikariDataSource" destroy-method="close">
 		<constructor-arg ref="hikiariConfig"/>
 	</been>