Hibernate整合连接池

最新推荐文章于 2021-02-22 02:13:54 发布

原创最新推荐文章于 2021-02-22 02:13:54 发布 · 566 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

JavaEE 同时被 2 个专栏收录

121 篇文章

订阅专栏

hibernate

21 篇文章

订阅专栏

本文介绍如何在Hibernate中整合C3P0连接池，包括导入jar包、配置参数等步骤，并通过示例演示了如何验证C3P0连接池的有效性。

整合c3p0(连接池)

整合c3p0：

步骤一：导入c3p0 jar包

步骤二：hibernate.cfg.xml 配置

hibernate.connection.provider_classorg.hibernate.connection.C3P0ConnectionProvider

c3p0具体配置参数：

###########################

### C3P0 Connection Pool###

###########################

#hibernate.c3p0.max_size 2

#hibernate.c3p0.min_size 2

#hibernate.c3p0.timeout 5000

#hibernate.c3p0.max_statements 100

#hibernate.c3p0.idle_test_period 3000

#hibernate.c3p0.acquire_increment 2

#hibernate.c3p0.validate false

配置：

<!--
	告诉Hibernate,我要使用C3p0连接池
 hibernate.connection.provider_class org.hibernate.connection.C3P0ConnectionProvider -->
	<property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
<!-- 
#hibernate.c3p0.max_size 2
#hibernate.c3p0.min_size 2
#hibernate.c3p0.timeout 5000
#hibernate.c3p0.max_statements 100
#hibernate.c3p0.idle_test_period 3000
#hibernate.c3p0.acquire_increment 2
#hibernate.c3p0.validate false
 -->
 <property name="hibernate.c3p0.max_size">5</property>
 <property name="hibernate.c3p0.min_size">2</property>

case：

package com.hcx.e_api;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Restrictions;
import org.junit.Test;

import com.hcx.domain.Customer;
import com.hcx.utils.HibernateUtils;

public class Demo {
	@Test
	//验证c3p0连接池
	public void fun1(){
		Session session = HibernateUtils.openSession();
		session.beginTransaction();
		//------------------------------------------------
		System.out.println(session);
		//------------------------------------------------
		session.getTransaction().commit();
		session.close(); // 游离状态
	}
}