网上关于C3P0在spring中的配置,几乎没有完全正确的:

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"    destroy-method="close">
          
<property name="driverClass"><value>${jdbc.driverClassName}</value></property>
          
<property name="jdbcUrl"><value>${jdbc.url}</value></property>               
          
<property name="user"><value>${jdbc.username}</value></property>
          
<property name="password"><value>${jdbc.password}</value></property>
          
          
<property name="minPoolSize"><value>1</value></property>
          
<property name="maxPoolSize"><value>20</value></property>
          
<property name="maxIdleTime"><value>1800</value></property>
          
<property name="acquireIncrement"><value>2</value></property>
          
<property name="maxStatements"><value>0</value></property>
          
<property name="initialPoolSize"><value>2</value></property>
          
<property name="idleConnectionTestPeriod"><value>1800</value></property>
          
<property name="acquireRetryAttempts"><value>30</value></property>
          
<property name="breakAfterAcquireFailure"><value>true</value></property>
          
<property name="testConnectionOnCheckout"><value>false</value></property>           
</bean>


<!-- Hibernate SessionFactory -->
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
   
<property name="dataSource" ref="dataSource"/>
   
<property name="mappingDirectoryLocations">
       
<list>
    
<value>classpath:/com/licaionline/domain/</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>
                 
<prop key="hibernate.cglib.use_reflection_optimizer">true</prop>
    
</props>
   
</property>
</bean>