#Oracle Database
jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
#Database URL's (We're using a wallet)
jdbc.db_main.url=jdbc:oracle:oci:/@db_main
jdbc.db_node1.url=jdbc:oracle:oci:/@db_node1
jdbc.db_node2.url=jdbc:oracle:oci:/@db_node2
jdbc.db_node3.url=jdbc:oracle:oci:/@db_node3

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName"><value>${jdbc.driverClassName}</value></property>
    <property name="url"><value>${jdbc.db_main.url}</value></property>
    <property name="poolPreparedStatements"><value>true</value></property>
    <property name="maxActive"><value>150</value></property>
    <property name="maxIdle"><value>50</value></property>
    <property name="validationQuery"><value>Select 1 from dual</value></property>
    <property name="testWhileIdle"><value>true</value></property>
    <property name="maxWait" value="5000" />
    <property name="removeAbandoned" value="true" />
    <property name="removeAbandonedTimeout" value="300" />
    <property name="logAbandoned" value="true" />
    <property name="testOnBorrow" value="true" />
    <property name="testOnReturn" value="true" />
</bean>