S2SH配置proxool连接池

1、用连接池的话，就不用配置dataSource数据源了,需要的jar包 proxool-cglib.jar 和proxool-0.9.1.jar

<bean id="sessionFactory"
		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="mappingDirectoryLocations">
			<list>
				<value>classpath:com/beckham/model</value>
			</list>
		</property>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">
					org.hibernate.dialect.MySQLDialect
				</prop>
				<prop key="hibernate.show_sql">true</prop>
				<!-- 配置proxool连接池 -->
				<prop key="hibernate.proxool.pool_alias">DBPool</prop>
				<prop key="hibernate.proxool.xml">proxool.xml</prop>
				<prop key="hibernate.connection.provider_class">
					org.hibernate.connection.ProxoolConnectionProvider
				</prop>
				
				<!-- 设置缓存 -->
				<prop key="hibernate.cache.use_query_cache ">true</prop>
				<prop key="hibernate.cache.use_second_level_cache">true</prop>
				 <prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop>  
                <prop key="hibernate.cache.configurationResourceName">ehcache.xml</prop> 
                <prop key="hibernate.connection.autocommit">true</prop>
			</props>
		</property>
	</bean>

2、在src目录下新建proxool.xml文件

<?xml version="1.0" encoding="UTF-8" ?> 
 <something-else-entirely>
 <proxool>
  <alias>DBPool</alias>
    <driver-url>jdbc:mysql://localhost:3306/menhu</driver-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
 <driver-properties>
 <property name="user" value="root"/>
      <property name="password" value="root"/>
  </driver-properties>
<!-- 最小的数据库连接数  -->
		<minimum-connection-count>10</minimum-connection-count>
		<!-- 最大的数据库连接数  -->
		<maximum-connection-count>50</maximum-connection-count>
		<!-- 最少保持的空闲连接数 -->
		<prototype-count>10</prototype-count>
		<!-- proxool自动侦察各个连接状态的时间间隔(毫秒),侦察到空闲的连接就马上回收,超时的销毁。 -->
		<house-keeping-sleep-time>90000</house-keeping-sleep-time>
		<!-- 指因未有空闲连接可以分配而在队列中等候的最大请求数,超过这个请求数的用户连接就不会被接受 -->
		<maximum-new-connections>300</maximum-new-connections>
		<!-- 某一时间点的最大连接数 -->
		<simultaneous-build-throttle>150</simultaneous-build-throttle>
		<!-- 一个线程持有一个连接的最长时间5分钟，单位毫秒(默认5分钟)  -->
		<maximum-active-time>300000</maximum-active-time>
		<!-- 一个连接的最长活动时间4小时，单位毫秒(默认4小时) -->
		<maximum-connection-lifetime>
			14400000
		</maximum-connection-lifetime>
		<house-keeping-test-sql>
			set names 'UTF-8';
		</house-keeping-test-sql>
	</proxool>
</something-else-entirely>