现在的位置: 首页 > 综合 > 正文

spring中进行连接池使用c3p0进行配置,参考代码

2013年10月30日 ⁄ 综合 ⁄ 共 1842字 ⁄ 字号 评论关闭
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
        "http://www.springframework.org/dtd/spring-beans.dtd"
>
<beans>
    
<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        
<property name="location">
            
<value>classpath:jdbc.properties</value>
        
</property>
    
</bean>

    <bean id="c3p0DataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
          destroy-method
="close">
        
<property name="driverClass">
            
<value>${db.driverClass}</value>
        
</property>
        
<property name="jdbcUrl">
            
<value>${db.url}</value>
        
</property>
        
<property name="properties">
            
<props>
                
<prop key="c3p0.acquire_increment">5</prop>
                
<prop key="c3p0.idle_test_period">100</prop>
                
<prop key="c3p0.max_size">100</prop>
                
<prop key="c3p0.max_statements">0</prop>
                
<prop key="c3p0.min_size">10</prop>
                
<prop key="user">${db.user}</prop>
                
<prop key="password">${db.pass}</prop>
            
</props>
        
</property>
    
</bean>

    <bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
        
<property name="hibernateProperties">
            
<props>
                
<prop key="hibernate.dialect">${hibernate.dialect}</prop>
                
<prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
            
</props>
        
</property>
        
<property name="dataSource" ref="c3p0DataSource"/>
        
<property name="annotatedClasses" value="martin.dwr.demo.model.User"/>
    
</bean>

    <bean id="userDao" class="martin.dwr.demo.dao.hibernate.HibernateUserDAO">
        
<property name="sessionFactory" ref="sessionFactory"/>
    
</bean>
</beans> 

抱歉!评论已关闭.