`
gcgmh
  • 浏览: 355919 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

hibernate3.3.2配置proxool连接池

阅读更多
proxool的jar包版本为:proxool-0.8.3.jar,最新的0.9的据说不好配置
1、hibernate.cfg.xml配置为:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
	"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
	"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
	<session-factory>
		<!--  
		<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
		<property name="hibernate.connection.url">jdbc:mysql://127.0.0.1/oa</property>
		<property name="hibernate.connection.username">root</property>
		<property name="hibernate.connection.password">root</property>
		-->
		<property name="hibernate.proxool.pool_alias">pool1</property>
		<property name="hibernate.proxool.xml">proxool.cfg.xml</property>
		<property name="hibernate.connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider</property>
		
		<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
		<property name="hibernate.show_sql">true</property>
		<property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
		
		
		
		<mapping resource="com/oa/model/Person.hbm.xml"/>
		
		
	</session-factory>
</hibernate-configuration>


2.在hibernate.cfg.xml文件下增加的proxool.cfg.xml内容:
<?xml version="1.0" encoding="utf-8"?>
<!-- the proxool configuration can be embedded within your own application's.
Anything outside the "proxool" tag is ignored. -->
<something-else-entirely>
    <proxool>
        <alias>pool1</alias>
<!--proxool只能管理由自己产生的连接-->
        <driver-url>jdbc:mysql://localhost:3306/oa</driver-url>
        <driver-class>org.gjt.mm.mysql.Driver</driver-class>
        <driver-properties>
            <property name="user" value="root"/>
            <property name="password" value="8888"/>
        </driver-properties>
<!-- proxool自动侦察各个连接状态的时间间隔(毫秒),侦察到空闲的连接就马上回收,超时的销毁-->
        <house-keeping-sleep-time>90000</house-keeping-sleep-time>
<!-- 指因未有空闲连接可以分配而在队列中等候的最大请求数,超过这个请求数的用户连接就不会被接受-->
        <maximum-new-connections>20</maximum-new-connections>
<!-- 最少保持的空闲连接数-->
        <prototype-count>5</prototype-count>
<!-- 允许最大连接数,超过了这个连接,再有请求时,就排在队列中等候,最大的等待请求数由maximum-new-connections决定-->
        <maximum-connection-count>100</maximum-connection-count>
<!-- 最小连接数-->
        <minimum-connection-count>10</minimum-connection-count>
    </proxool>
</something-else-entirely>

注:在proxool.cfg.xml里面不要有中文注释,不然会报解析xml文件错!

分享到:
评论
Global site tag (gtag.js) - Google Analytics