tomcat Server-database-connection-pool-configs.xml

tomcat-server-db-conn-pool.xml

<bean id="XXX" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
2
      <property name="driverClassName" value="oracle.jdbc.OracleDriver"/>
3
      <property name="url" value="${oracle.url}"/>
4
      <property name="username" value="${oracle.user}"/>
5
      <property name="password" value="${oracle.password}"/>
6
      <property name="initialSize" value="10"/>
7
      <property name="minIdle" value="10"/>
8
      <property name="maxIdle" value="30"/>
9
      <property name="maxActive" value="50"/>
10
      <property name="testOnBorrow" value="true"/>
11
      <property name="testOnReturn" value="true"/>
12
      <property name="testWhileIdle" value="true"/>
13
      <property name="validationQuery" value="SELECT 1 FROM DUAL"/>
14
      <property name="connectionProperties" value="oracle.jdbc.ReadTimeout=10000"/>
15
      <property name="timeBetweenEvictionRunsMillis" value="-1"/>
16
</bean>