在spring中使用proxool连接池

首先在spring的配置文件里，进行配置

		</property>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">
					org.hibernate.dialect.Oracle9Dialect
				</prop>
				<prop key="hibernate.show_sql">false</prop>
				<prop key="hibernate.generate_statistics">true</prop>


				<prop key="hibernate.cglib.use_reflection_optimizer">true</prop>
				<prop key="hibernate.proxool.xml">com/cinwa/creditnet/entity/proxool.xml</prop>
				<prop key="hibernate.proxool.pool_alias">DBPool</prop>

                <prop key="hibernate.connection.release_mode">auto</prop>


			</props>
		</property>

这里要说明的是<prop key="hibernate.connection.release_mode">auto</prop>，一定要设置成auto，不然的话链接不会被释放。
proxool的配置文件

<proxool-config>
	<proxool>
		<alias>DBPool</alias>
		<driver-url>jdbc:oracle:thin:@192.168.1.6:1521:orcl</driver-url>
		<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
		<driver-properties>
			<property name="user" value="d21315" />
			<property name="password" value="d21315" />
		</driver-properties>

		<house-keeping-sleep-time>10000</house-keeping-sleep-time>
		<maximum-new-connections>20</maximum-new-connections>
		<prototype-count>5</prototype-count>
		<maximum-connection-count>100</maximum-connection-count>
		<minimum-connection-count>10</minimum-connection-count>

		<house-keeping-test-sql>
			select 1 from dual
		</house-keeping-test-sql>
	</proxool>
</proxool-config>