配备Hibernate使用C3P0连接池

配置Hibernate使用C3P0连接池

<?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>