稳定系统配置文件

关键你给的分太少!如下是上线达1年,稳定运行的配置。
---------------------------------------------------------、
属性文件
c3p0.driverClass=com.mysql.jdbc.Driver
c3p0.user=root
c3p0.password=edwin
c3p0.jdbcUrl=jdbc\:mysql\://192.168.1.123\:3306/edwin?useUnicode\=true&characterEncoding\=utf-8
c3p0.minPoolSize = 1
c3p0.maxPoolSize = 50
c3p0.initialPoolSize = 1
c3p0.maxIdleTime = 25000
c3p0.acquireIncrement = 1
c3p0.acquireRetryAttempts = 30
c3p0.acquireRetryDelay = 1000
c3p0.testConnectionOnCheckin = true
c3p0.automaticTestTable = t_c3p0
c3p0.idleConnectionTestPeriod = 18000
c3p0.checkoutTimeout=5000
---------------------------------------------------------
spring配置

<?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: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/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
           http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd" default-autowire="byName" default-lazy-init="false"> 
 <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> 
    <property name="location"> 
     <value>classpath:com/edwin/db/config/c3p0.properties</value> 
    </property>
 </bean>
 <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"> 
    <property name="driverClass"> 
     <value>${c3p0.driverClass}</value> 
    </property> 
    <property name="jdbcUrl"> 
     <value>${c3p0.jdbcUrl}</value> 
    </property> 
    <property name="user"> 
     <value>${c3p0.user}</value> 
    </property> 
    <property name="password"> 
     <value>${c3p0.password}</value> 
    </property> 
    <property name="minPoolSize"> 
     <value>${c3p0.minPoolSize}</value>
    </property>
    <property name="maxPoolSize"> 
     <value>${c3p0.maxPoolSize}</value> 
    </property> 
    <property name="initialPoolSize"> 
     <value>${c3p0.initialPoolSize}</value> 
    </property> 
    <property name="maxIdleTime"> 
     <value>${c3p0.maxIdleTime}</value> 
    </property> 
    <property name="acquireIncrement"> 
     <value>${c3p0.acquireIncrement}</value> 
    </property> 
    <property name="acquireRetryAttempts"> 
     <value>${c3p0.acquireRetryAttempts}</value> 
    </property> 
    <property name="acquireRetryDelay"> 
     <value>${c3p0.acquireRetryDelay}</value> 
    </property> 
    <property name="testConnectionOnCheckin"> 
     <value>${c3p0.testConnectionOnCheckin}</value> 
    </property>
        <property name="automaticTestTable"> 
     <value>${c3p0.automaticTestTable}</value> 
    </property> 
    <property name="idleConnectionTestPeriod"> 
     <value>${c3p0.idleConnectionTestPeriod}</value> 
    </property>
   <property name="checkoutTimeout"> 
     <value>${c3p0.checkoutTimeout}</value> 
    </property> 
 </bean>
 
</beans> 
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值