hibernate配置c3p0连接池

一、先下载hibernate相关的jar组件

1、到官网下载hibernate组件，里面就有c3p0等jar包

2、注意要下载适合自己使用的hibernate版本，本人下载的是hibernate-release-4.3.11.Final，解压后如图

3、lib下的required文件夹的jar包是hibernate必备的包，把里面的jar引到项目中

4、optional中的是其他第三方的包，把c3p0的包也引到项目中

二、通过hibernate的cfg配置文件配置c3p0连接池，如果不配置c3p0连接池，默认会使用hibernate默认的连接池。本人连的mssql 2012数据库，配置如下

<?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>
    <!-- 配置C3P0数据源,用于项目开发 -->
    <session-factory>
    	<property name="hibernate.bytecode.use_reflection_optimizer">false</property>
        <property name="hibernate.connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
        <property name="hibernate.connection.password">Passw0rd</property>
        <property name="hibernate.connection.url">jdbc:sqlserver://127.0.0.1:1433;DatabaseName=YHDB;</property>
        <property name="hibernate.connection.username">sa</property>
        <property name="hibernate.default_schema">dbo</property>
        <property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
        <property name="hibernate.search.autoregister_listeners">false</property>
        <property name="hibernate.show_sql">true</property>
        <property name="hibernate.validator.apply_to_ddl">false</property>
        <!-- 配置C3P0数据源 -->
		<property name="hibernate.connection.provider_class">org.hibernate.c3p0.internal.C3P0ConnectionProvider</property>
		<property name="hibernate.c3p0.max_size">20</property>
		<property name="hibernate.c3p0.max_statements">100</property>
		<property name="hibernate.c3p0.min_size">5</property>
		<property name="hibernate.c3p0.timeout">5000</property>
		<property name="hibernate.c3p0.idle_test_period">120</property>
		<property name="hibernate.c3p0.acquire_increment">2</property>
	    <property name="hibernate.c3p0.validate">true</property> 
        <mapping resource="entity/User1AppLoginRecord.hbm.xml" />
    </session-factory>
</hibernate-configuration>

配置后，编写代码即可获得数据库对象

//读取hibernate.cfg.xml文件  
Configuration cfg = new Configuration().configure("hibernate-c3p0.cfg.xml");  
//建立SessionFactory  
factory = cfg.buildSessionFactory();  
Session session = factory.openSession();

三、通过spring配置hibernate的c3p0连接（待完成）