hibernate中使用 proxool 数据库连接池
proxool.xml

<?xml version="1.0" encoding="utf-8"?>
<something-else-entirely>
<proxool>
<alias>proxool</alias>
<driver-url>
jdbc:oracle:thin:@localhost:1521:carddb
</driver-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver-properties>
<property name="user" value="" />
<property name="password" value="" />
</driver-properties>
<house-keeping-sleep-time>3000</house-keeping-sleep-time>
<maximum-new-connections>20</maximum-new-connections>
<prototype-count>10</prototype-count>
<maximum-connection-count>1000</maximum-connection-count>
<minimum-connection-count>100</minimum-connection-count>
<house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
<trace>true</trace>
<statistics>15m,1h,1d</statistics>
</proxool>
</something-else-entirely>

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">

<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>

<session-factory>
<property name="proxool.pool_alias">proxool</property>
<property name="proxool.xml">proxoolConfig.xml</property>
<property name="hibernate.connection.release_mode">auto</property>
<property name="hibernate.cglib.use_reflection_optimizer">true</property>
<property name="connection.provider_class">
org.hibernate.connection.ProxoolConnectionProvider
</property>
<property name="connection.autoReconnect">true</property>
    <property name="connection.autoReconnectForPools">true</property>
<property name="hibernate.proxool.existing_pool">false</property>
<property name="show_sql">false</property>
<property name="statement_cache.size">25</property>
    <property name="jdbc.fetch_size">50</property>
    <property name="jdbc.batch_size">50</property>
<!-- <property name="connection.autocommit">false</property> -->
<mapping
    resource="com/watchdata/db/hibernate/table/Load.hbm.xml" />
<mapping
resource="com/db/hibernate/table/LoadResult.hbm.xml" />

</session-factory>

</hibernate-configuration>


HibernateSessionFactory


import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;

/**
* Configures and provides access to Hibernate sessions, tied to the
* current thread of execution.  Follows the Thread Local Session
* pattern, see {@link http://hibernate.org/42.html }.
*/
public class HibernateSessionFactory {

    /**
     * Location of hibernate.cfg.xml file.
     * Location should be on the classpath as Hibernate uses 
     * #resourceAsStream style lookup for its configuration file.
     * The default classpath location of the hibernate config file