一、先下载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连接(待完成)