S2SH配置proxool连接池

来源：互联网发布：混合矩阵报价编辑：程序博客网时间：2024/06/06 08:32

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><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><house-keeping-sleep-time>90000</house-keeping-sleep-time><maximum-new-connections>300</maximum-new-connections><simultaneous-build-throttle>150</simultaneous-build-throttle><maximum-active-time>300000</maximum-active-time><maximum-connection-lifetime>14400000</maximum-connection-lifetime><house-keeping-test-sql>set names 'UTF-8';</house-keeping-test-sql></proxool></something-else-entirely>