数据库连接池c3p0的设置

spring-hibernate.xml配置

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans
           http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
           http://www.springframework.org/schema/context
           http://www.springframework.org/schema/context/spring-context-2.5.xsd
           http://www.springframework.org/schema/aop
           http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
           http://www.springframework.org/schema/tx 
           http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">
   <!-- 注解扫描包 -->
<!--     <context:component-scan base-package="com.web.controller" />   -->
    
<!-- 	<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">   -->
	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
		<property name="driverClass" 	value="com.mysql.jdbc.Driver"/>
		<property name="jdbcUrl" 				value="jdbc:mysql://109.110.100.56/tsdr"/> 
		<property name="user" 		value="root"/> 
		<property name="password" 		value=""/>
		<!--连接池中保留的最小连接数。-->            
	    <property name="minPoolSize" value="10" />        
	    <!--连接池中保留的最大连接数。Default: 15 -->         
	    <property name="maxPoolSize" value="100" />        
	    <!--最大空闲时间,1800秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0 -->               
	    <property name="maxIdleTime" value="180" />        
	    <!--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。Default: 3 -->               
	    <property name="acquireIncrement" value="3" />        
	    <property name="maxStatements" value="1000" />         
	    <property name="initialPoolSize" value="10" />          
	    <!--每60秒检查所有连接池中的空闲连接。Default: 0 -->       
	    <property name="idleConnectionTestPeriod" value="60" />          
	    <!--定义在从数据库获取新连接失败后重复尝试的次数。Default: 30 -->       
	    <property name="acquireRetryAttempts" value="30" /> 
	    <!--重新尝试的时间间隔，默认为：1000毫秒-->  
	     <property name="acquireRetryDelay" value="1000" />         
	    <property name="breakAfterAcquireFailure" value="true" />             
	    <property name="testConnectionOnCheckout" value="false" />
	</bean>
	
	<bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">  
        <property name="dataSource" ref="dataSource"/>  
        <property name="hibernateProperties">  
            <props>  
        		<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
        		<prop key="hibernate.hbm2ddl.auto">update</prop>
        		<prop key="hibernate.show_sql">true</prop>
        		<prop key="hibernate.format_sql">true</prop>
        	</props>
        </property>
        <property name="configLocations">
        	<list>
        		<value>
        			classpath*:com/web/controller/hibernate/hibernate.cfg.xml
        		</value>
        	</list>
        </property>	
	</bean>
	
	<!-- 定义事务管理器（声明式的事务） -->    
    <bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">  
        <property name="sessionFactory" ref="sessionFactory"></property>  
    </bean>  
    <tx:annotation-driven transaction-manager="transactionManager" />  
      
</beans>  

需要下载c3p0的jar包

转载于:https://www.cnblogs.com/wujixing/p/6000032.html