Hibernate & Proxool or C3p0

来源：互联网发布：零投资网络赚钱项目编辑：程序博客网时间：2024/05/18 01:51

一、Hibernate with Proxool

1、基本环境搭建

Hibernate 必须jar包，Porxool以0.9.1为列，将proxool-0.9.1.jar、proxool-cglib.jar放入classpath中

2、hibernate配置文件

以oracle 10为例

<?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.proxool.pool_alias">dbpool</property><property name="hibernate.proxool.xml">proxool.xml</property><property name="connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider</property><property name="dialect">org.hibernate.dialect.OracleDialect</property><property name="current_session_context_class">thread</property><property name="hbm2ddl.auto">update</property><property name="show_sql">false</property><property name="format_sql">true</property><property name="hibernate.cache.use_second_level_cache">true</property><property name="hibernate.cache.use_query_cache">true</property><property name="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</property><property name="hibernate.generate_statistics">true</property><property name="hibernate.connection.autocommit">true </property></session-factory></hibernate-configuration>

3、proxool配置文件

proxool.xml

<?xml version="1.0" encoding="utf-8"?><something-else-entirely> <proxool> <alias>dbpool</alias> <driver-url>jdbc:oracle:thin:@xxxx:1521:sid </driver-url> <driver-class>oracle.jdbc.driver.OracleDriver </driver-class> <driver-properties> <property name="user" value="xxxx" /> <property name="password" value="xxxx" /> </driver-properties> <house-keeping-sleep-time>90000</house-keeping-sleep-time> <prototype-count>2</prototype-count> <maximum-connection-count>10</maximum-connection-count> <minimum-connection-count>5</minimum-connection-count> <proxool.simultaneous-build-throttle>100</proxool.simultaneous-build-throttle> <house-keeping-test-sql>select CURRENT_DATE from dual</house-keeping-test-sql> </proxool></something-else-entirely>

Note:不同数据库<house-keeping-test-sql />写法不一样，比如如果是mysql，select current_date(sysdate)

4、web.xml

连接池监控

<servlet> <servlet-name>proxool</servlet-name> <servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class> </servlet> <servlet-mapping> <servlet-name>proxool</servlet-name> <url-pattern>/proxool</url-pattern> </servlet-mapping>

可以通过http://xxxx:port/xxx/proxool 查看连接池的具体情况

参考：

http://proxool.sourceforge.net/

二、Hibernate with C3P0

C3P0为HB默认的连接池。

1、所需C3P0 jar包，（c3p0-0.9.1.2.jar）

2、hibernate配置文件

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE hibernate-configuration PUBLIC"-//Hibernate/Hibernate Configuration DTD//EN""http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"><hibernate-configuration> <session-factory>  <property name="hibernate.dialect"> org.hibernate.dialect.OracleDialect </property> <property name="hibernate.connection.driver_class"> oracle.jdbc.driver.OracleDriver </property> <property name="hibernate.connection.url"> jdbc:oracle:thin:@xxxx:1521:sid </property> <property name="hibernate.connection.username"> username </property> <property name="hibernate.connection.password"> password </property>     <property name="hibernate.show_sql">true</property>  <property name="current_session_context_class">thread</property>  </session-factory></hibernate-configuration>