1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
<!-- mysql 접속 datasource 풀생성 -->
    <bean id="dataSource-hrdmarket" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="" />
        <!-- <property name="url" value="" /> -->
        <property name="username" value="" /> 
        <property name="password" value="" /> 
        <!-- validationQuery:유효 검사용 쿼리 --> 
        <property name="validationQuery" value="select 1"/>
        <!-- testWhileIdle:컨넥션이 놀고 있을때 -_-; validationQuery 를 이용해서 유효성 검사를 할지 여부. -->
        <property name="testWhileIdle" value="true"/>
        <!-- timeBetweenEvictionRunsMillis:해당 밀리초마다 validationQuery 를 이용하여 유효성 검사 진행 -->
        <property name="timeBetweenEvictionRunsMillis" value="7200000"/>
    </bean>
 
cs


'SQL' 카테고리의 다른 글

오라클 WITH  (0) 2018.07.11
oracle date YYYY-MM-DD 변환  (0) 2017.05.11
mysql 날짜 차이구하기  (0) 2017.02.26
프로시저  (0) 2017.02.26
MySql 테이블 명세서 쿼리  (0) 2017.02.26

+ Recent posts