Hibernate下配置proxool数据库连接池

最新推荐文章于 2017-04-21 14:58:02 发布

转载最新推荐文章于 2017-04-21 14:58:02 发布 · 1k 阅读

文章标签：

#数据库连接池 #hibernate #encoding #jdbc #oracle #class

Hibernate 专栏收录该内容

47 篇文章

订阅专栏

本文详细介绍了Hibernate配置文件hibernate.cfg.xml的内容及proxool连接池配置。针对Oracle数据库进行了具体设置，并列出了多个实体映射文件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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包