数据库连接池c3p0与Hibernate的整合

1、数据库连接池c3p0与Hibernate的整合

     加入c3p0相关的jar文件

2、hibernate.cfg.xml的配置文件

<!--C3P0配置 -->
		<property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
		<property name="hibernate.c3p0.max_size">20</property>
		<property name="hibernate.c3p0.min_size">8</property>
		<property name="hibernate.c3p0.timeout">120</property>
		<property name="hibernate.c3p0.max_statements">100</property>
		<property name="hibernate.c3p0.idle_test_period">120</property>
		<property name="hibernate.c3p0.acquire_increment">1</property>
		<property name="c3p0.testConnectionOnCheckout">true</property>
		<property name="c3p0.idleConnectionTestPeriod">18000</property>
		<property name="c3p0.maxIdleTime">25000</property>

3、查看c3p0连接池是不是起作用

3.1：修改log4j的log4j.properties，修改log4j.rootLogger=debug，看日志信息有没有显示c3p0数据库连接池的信息

log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
log4j.rootLogger=debug, stdout

5、运行截图

6、测试代码

Hibernate和C3P0的整合