proxool.xml构造

<?xml version="1.0" encoding="UTF-8"?>

<something-else-entirely>

	<proxool>

		<alias>spring_pro_pool</alias>

	<driver-url>jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=10.12.18.21)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)))</driver-url>

		<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

		<driver-properties>

			<property name="user" value="orcl" />

			<property name="password" value="<span style="font-family: Arial, Helvetica, sans-serif;">orcl</span><span style="font-family: Arial, Helvetica, sans-serif;">" /></span>

		</driver-properties>

		<house-keeping-sleep-time>90000</house-keeping-sleep-time>

		<maximum-new-connections>400</maximum-new-connections>

		<prototype-count>10</prototype-count>

		<maximum-connection-count>100</maximum-connection-count>

		<minimum-connection-count>10</minimum-connection-count>

		<house-keeping-test-sql>select CURRENT_DATE from dual</house-keeping-test-sql>

	</proxool>

</something-else-entirely>

spring配置文件配置

<bean id="placeholderConfig"

		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">

		<property name ="locations">

			<list>

				<value>/WEB-INF/spring/myQuartzConfig.properties</value>

			</list>

		</property>

	</bean>

    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" destroy-method="close">

   		 <property name="driverClassName">

             <value>org.logicalcobwebs.proxool.ProxoolDriver</value>

         </property>

         <property name="url">

             <value>proxool.spring_pro_pool</value>

         </property>

    </bean>