Spring配C3P0连接池

applicationContext.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:jee="http://www.springframework.org/schema/jee"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-2.0.xsd">
	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
		<property name="driverclass">
			<value>com.mysql.jdbc.Driver</value>
		</property>
		<property name="jdbcUrl">
			<value>jdbc:mysql://192.168.3.110:3306/DBName?useUnicode=true&characterEncoding=GBK</value>
		</property>
		<property name="user">
			<value>root</value>
		</property>
		<property name="password">
			<value>root</value>
		</property>
 
 		
        <property name="minPoolSize">
            <value>5</value>
        </property>
 
 		
        <property name="maxPoolSize">
            <value>30</value>
        </property>
 
		
        <property name="initialPoolSize">
            <value>10</value>
        </property>
 
 		
        <property name="maxIdleTime">
            <value>60</value>
        </property>
 
 		
        <property name="acquireIncrement">
            <value>5</value>
        </property>
 
 		
        <property name="maxStatements">
            <value>0</value>
        </property>
 
 		
        <property name="idleConnectionTestPeriod">
            <value>60</value>
        </property>
 
 		
        <property name="acquireRetryAttempts">
            <value>30</value>
        </property>
 
 		
        <property name="breakAfterAcquireFailure">
            <value>true</value>
        </property>
 
 		
        <property name="testConnectionOnCheckout">
            <value>false</value>
        </property>
    </bean>
	
	<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource">
			<ref local="dataSource" />
		</property>
		<property name="mappingResources">
			<list>
				<value>com/xh/hibernate/vo/User.hbm.xml</value>
			</list>
		</property>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
				<prop key="hibernate.show_sql">true</prop>
				<prop key="hibernate.generate_statistics">true</prop>
				<prop key="hibernate.connection.release_mode">auto</prop>
				<prop key="hibernate.autoReconnect">true</prop>
			</props>
		</property>
	</bean>
</beans>

文章出处：http://www.javaeedev.com/blog/article.jspx?articleId=ff8080811a2a52f2011a383e5baf09da

Biegral Blog

Spring配C3P0连接池

阅读排行

分类

归档