Hibernate下配置proxool資料庫連接池

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.provider_class">org.hibernate.connection.ProxoolConnectionProvider</property>
<property name="hibernate.proxool.pool_alias">DBPool</property>
<property name="hibernate.proxool.xml">proxoolconf.xml</property>
  <property name="connection.url">
   jdbc:oracle:thin:@192.168.0.121:1521:hrms
  </property>
  <property name="connection.driver_class">
   oracle.jdbc.driver.OracleDriver
  </property>
  <property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
  <property name="myeclipse.connection.profile">Oracle</property>
  <property name="connection.username">hrms</property>
  <property name="connection.password">hrms</property>
  <property name="hibernate.show_sql">false</property>
  <property name="hibernate.format_sql">false</property>
                <property name="hibernate.jdbc.fetch_size">25</property>
                <property name="hibernate.jdbc.batch_size">20</property> 
 <mapping resource="basedata/BaseData.hbm.xml"></mapping>
        <mapping resource="basedata/BaseDataInfo.hbm.xml"></mapping>
        <mapping resource="rolegrant/HrGrant.hbm.xml"></mapping>
        <mapping resource="rolegrant/HrRole.hbm.xml"></mapping>
        <mapping resource="rolegrant/RoleAndGrant.hbm.xml"></mapping>
        <mapping resource="rolegrant/HrRoleSe.hbm.xml"></mapping>
        <mapping resource="rolegrant/EmpVsRole.hbm.xml"></mapping>
        <mapping resource="basedata/EmployeeInfo.hbm.xml"></mapping>
        <mapping resource="basedata/DbDepartMent.hbm.xml"></mapping>
        <mapping resource="basedata/Family.hbm.xml"></mapping>
        <mapping resource="basedata/CompanyInfo.hbm.xml"></mapping>
        <mapping resource="basedata/ChangePost.hbm.xml"></mapping>
        <mapping resource="basedata/Career.hbm.xml"></mapping>
        <mapping resource="basedata/TechNameManage.hbm.xml"></mapping>
        <mapping resource="basedata/Profession.hbm.xml"></mapping>
        <mapping resource="basedata/Retire.hbm.xml"></mapping>
        <mapping resource="basedata/Educate.hbm.xml"></mapping>
        <mapping resource="basedata/LanguageAbility.hbm.xml"></mapping>
        <mapping resource="basedata/Govstatus.hbm.xml"></mapping>
        <mapping resource="basedata/DeptChange.hbm.xml"></mapping>
        <mapping resource="basedata/PunishInfo.hbm.xml"></mapping>
        <mapping resource="basedata/Team.hbm.xml"></mapping>
        <mapping resource="basedata/DepartId.hbm.xml"></mapping>
        <mapping resource="basedata/PersonIn.hbm.xml"></mapping>
        <mapping resource="basedata/PersonOut.hbm.xml"></mapping>
        <mapping resource="basedata/Punish.hbm.xml"></mapping>
        <mapping resource="basedata/Hort.hbm.xml"></mapping>
        <mapping resource="basedata/EmployeeId.hbm.xml"></mapping>
        <mapping resource="basedata/Horts.hbm.xml"></mapping>
         <mapping resource="basedata/HortsId.hbm.xml"></mapping>
       
 </session-factory>

</hibernate-configuration>

proxoolconf.xml的內容如下，但是這個檔案得上面的那個檔案是在同一個目錄下面的

<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
<proxool>
   
<alias>DBPool</alias>

<driver-url>
jdbc:oracle:thin:@192.168.0.121:1521:hrms
</driver-url>

<driver-class> oracle.jdbc.driver.OracleDriver</driver-class>
<driver-properties>
<property name="user" value="hrms"/>
<property name="password" value="hrms"/>
</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>

接下來就是去 http://proxool.sourceforge.net下載這個jar包