hibernate 配置 proxool连接池 示例

hibernate 配置proxool连接池 示例

在Hibernate.hbm.xml文件中加入以下代码：

<hibernate-configuration>

<session-factory>
<property name="hibernate.show_sql">true</property>
<property name="hibernate.connection.provider_class">//以下配置加载Proxool连接池的类文件,不同的连接池可能用的加载类不一样
org.hibernate.connection.ProxoolConnectionProvider
</property>
<property name="hibernate.proxool.pool_alias">DBPool</property>//这里是给的别名
<property name="hibernate.proxool.xml">pool.xml</property>//这里是用到的Proxool文件

</session-factory>

</hibernate-configuration>

编写Proxool的配置文件:proxool.xml




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

<something-else-entirely>

<proxool>
<alias>DBPool</alias>
<driver-url>
jdbc:mysql://localhost:3306/shopping
//数据库地址
</driver-url>

<driver-class>com.mysql.jdbc.Driver</driver-class>//驱动程序

<driver-properties>

<property name="user" value="用户名" />

<property name="password" value="密码" />

</driver-properties>

<house-keeping-sleep-time>90000</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>
</proxool>

</something-else-entirely>