c3p0配置

ゞ浴缸里的玫瑰 2022-06-13 04:50 211阅读 0赞

<?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-3.0.xsd
    			http://www.springframework.org/schema/context
    			http://www.springframework.org/schema/context/spring-context-3.0.xsd
    			http://www.springframework.org/schema/tx
    			http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
    			http://www.springframework.org/schema/aop
    			http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">
    	
    	<context:component-scan base-package="cn.dental" />
    
    	
    	<context:property-placeholder location="classpath:jdbc.properties" />
    
    	
    	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    		<property name="driverClass" value="${jdbc.driverClass}" />
    		<property name="jdbcUrl" value="${jdbc.jdbcUrl}" />
    		<property name="user" value="${jdbc.user}" />
    		<property name="password" value="${jdbc.password}" />
    		
    		
    		<property name="initialPoolSize" value="3" />
    		
    		<property name="minPoolSize" value="3" />
    		
    		<property name="maxPoolSize" value="15" />
    		
    		<property name="acquireIncrement" value="3" />
    		
    		<property name="maxStatements" value="8" />
    		
    		<property name="maxStatementsPerConnection" value="5" />
    		
    		<property name="maxIdleTime" value="1800" />
    	</bean>
    
    	
    	<bean id="sessionFactory"
    		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
    		<property name="dataSource" ref="dataSource"/>
    		<property name="hibernateProperties">
    			<props>
    				
    				<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
    				
    				<prop key="hibernate.show_sql">true</prop>
    				<prop key="hibernate.hbm2ddl.auto">update</prop>
    			</props>
    		</property>
    		<property name="mappingDirectoryLocations">
    			<list>
    				<value>cn/dental/domain/</value>
    			</list>
    		</property>
    	</bean>
    
    	
    	<bean id="txManager"
    		class="org.springframework.orm.hibernate3.HibernateTransactionManager">
    		<property name="sessionFactory" ref="sessionFactory" />
    	</bean>
    	
    	<tx:annotation-driven transaction-manager="txManager" />
    </beans>