Luckycall/ProcessLuckyCard/etc/database.xmlY

<c3p0-config>
  <timeout-config>
  	<!-- time out query DB (s) -->
  	<property name="queryDbTimeout">60</property>
  	<!-- thoi gian toi da khi thuc hien ham DB (ms) -->
  	<property name="timeBreak">90000</property>
  	<!-- thoi gian toi da khi thuc hien xoa record time out (ms) -->
  	<property name="timeBreakDeleteRecordTimeOut">120000</property>
  </timeout-config>

  <named-config name="database">   
	<property name="driver">oracle.jdbc.driver.OracleDriver</property>
	<property name="connection">jdbc:oracle:thin:@(description=(address_list=(address=(host=10.228.33.80)(protocol=tcp)(port=1521)) (address=(host=10.228.33.80)(protocol=tcp)(port=1521))(load_balance=yes)(failover=yes))(connect_data=(service_name=vas)))</property>
	<property name="username">RECHARGE_ADD_POINT</property>
	<property name="password">RECHARGE_ADD_POINT</property>
    	<property name="initialPoolSize">1</property>   
    	<property name="maxPoolSize">2</property>
    	<property name="minPoolSize">1</property>
	<!-- cau hinh timeout & check ket noi-->
	<property name="readTimeout">60000</property><!-- milisecond-->
	<property name="maxIdleTime">300</property><!-- second-->
    	<property name="checkoutTimeout">30000</property> <!-- milisecond-->
		<property name="connectTimeout">60000</property><!-- milisecond-->
    	<property name="idleConnectionTestPeriod">30</property><!-- second-->
	<property name="preferredTestQuery">select 1 from dual</property>
	<property name="testConnectionOnCheckin">true</property>
	<property name="testConnectionOnCheckout">true</property>	
	<property name="unreturnedConnectionTimeout">900</property>
  </named-config>

  
  <named-config name="dbPre">   
	<property name="driver">oracle.jdbc.driver.OracleDriver</property>
	<property name="connection">jdbc:oracle:thin:@(description=(address_list=(address=(host=10.228.33.18)(protocol=tcp)(port=1521)) (address=(host=10.228.33.15)(protocol=tcp)(port=1521))(load_balance=yes)(failover=yes))(connect_data=(service_name=pre)))</property>
	<property name="username">VAS_MI_APP</property>
	<property name="password">VAS@123</property>
    	<property name="initialPoolSize">1</property>   
    	<property name="maxPoolSize">10</property>
    	<property name="minPoolSize">1</property>
	<!-- cau hinh timeout & check ket noi-->
	<property name="readTimeout">60000</property><!-- milisecond-->
	<property name="maxIdleTime">300</property><!-- second-->
    	<property name="checkoutTimeout">30000</property> <!-- milisecond-->
		<property name="connectTimeout">60000</property><!-- milisecond-->
    	<property name="idleConnectionTestPeriod">30</property><!-- second-->
	<property name="preferredTestQuery">select 1 from dual</property>
	<property name="testConnectionOnCheckin">true</property>
	<property name="testConnectionOnCheckout">true</property>	
	<property name="unreturnedConnectionTimeout">900</property>
  </named-config> 
  
  
</c3p0-config>