配置Hibernate使用C3P0连接池-优快云博客

本文详细介绍了Hibernate框架的配置文件设置，包括数据库连接参数、方言选择、SQL日志输出配置及C3P0连接池的参数设定等内容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<?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>
	<session-factory>
		<!-- JDBC驱动程序-->
		<property name="connection.username">sa</property>
		<property name="connection.url">
			jdbc:jtds:sqlserver://localhost:1433/userinfo
		</property>
		<!--指定连接的语言-->
		<property name="dialect">
			org.hibernate.dialect.SQLServerDialect
		</property>
		<property name="connection.password">sa</property>
		<property name="connection.driver_class">
			net.sourceforge.jtds.jdbc.Driver
		</property>
		<!--是否将运行期生成的SQL输出到日志以供调试-->
		<property name="show_sql">true</property>
		<property name="format_sql">true</property>

		<!-- 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">5</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">2</property>
		<mapping resource="com/lovo/po/UserPO.hbm.xml" />
	</session-factory>
</hibernate-configuration>