JBOSS 下如何配置C3P0的连接池(解决Mysql 8小时的问题)

JBOSS 下如何配置C3P0的连接池(解决Mysql 8小时的问题)

问题引起：
在公司配置文档管理系统(OPENKM)时，把数据源切换到Mysql数据源下，经过测试，发现经过8小时后，数据库连接自动断开。

解决办法：
把原来的openkm-ds.xml删除掉。原openkm-ds.xml的内容如下：

<?xml version="1.0" encoding="UTF-8"?>

<datasources>

<local-tx-datasource>
<jndi-name>OKMActivityDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/openkm</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>123456</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
<track-statements/>

<prepared-statement-cache-size>32</prepared-statement-cache-size>
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>

</local-tx-datasource>


<local-tx-datasource>
<jndi-name>OKMAuthDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/openkm</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>123456</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
<track-statements/>

<prepared-statement-cache-size>32</prepared-statement-cache-size>
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>

</local-tx-datasource>



<local-tx-datasource>
<jndi-name>OKMDashboardStatsDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/openkm</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>123456</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
<track-statements/>

<prepared-statement-cache-size>32</prepared-statement-cache-size>
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>

</local-tx-datasource>

  
  <local-tx-datasource>
    <jndi-name>OKMWorkflowDS</jndi-name>
    <connection-url>jdbc:mysql://localhost:3306/openkm</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>root</user-name>
    <password>123456</password>
    <min-pool-size>5</min-pool-size>
    <max-pool-size>20</max-pool-size>
    <idle-timeout-minutes>0</idle-timeout-minutes>
    <track-statements/>
    
    <prepared-statement-cache-size>32</prepared-statement-cache-size>
    <metadata>
      <type-mapping>mySQL</type-mapping>
    </metadata>
  </local-tx-datasource>
</datasources>

在{JBOSS_HOME}\server\default\deploy目录下新建 c3p0-service.xml 文件；文件内容如下

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE server>
<server>
    <mbean code="com.mchange.v2.c3p0.jboss.C3P0PooledDataSource" name="jboss:service=C3P0PooledDataSourceOKMWorkflowDS">
    <attribute name="JndiName">java:OKMWorkflowDS</attribute>
    <attribute name="JdbcUrl">jdbc:mysql://localhost:3306/openkm</attribute>
    <attribute name="DriverClass">com.mysql.jdbc.Driver</attribute>
    <attribute name="User">root</attribute>
    <attribute name="Password">123456</attribute>
    
    
    <attribute name="AcquireIncrement">2</attribute>
    <attribute name="AcquireRetryAttempts">30</attribute>
    
    
    
    <attribute name="BreakAfterAcquireFailure">true</attribute>
    
    
    
    
    
    
    
    <attribute name="IdleConnectionTestPeriod">40</attribute>
    <attribute name="InitialPoolSize">2</attribute>
    
    
    <attribute name="MaxIdleTime">1800</attribute>
    
    <attribute name="MaxPoolSize">15</attribute>
    <attribute name="MaxStatements">0</attribute>
    
    <attribute name="MinPoolSize">1</attribute>
    
    
    
    <attribute name="TestConnectionOnCheckout">false</attribute>
    
    
    <depends>jboss:service=Naming</depends>
    </mbean>
    <mbean code="com.mchange.v2.c3p0.jboss.C3P0PooledDataSource" name="jboss:service=C3P0PooledDataSourceOKMDashboardStatsDS">
    <attribute name="JndiName">java:OKMDashboardStatsDS</attribute>
    <attribute name="JdbcUrl">jdbc:mysql://localhost:3306/openkm</attribute>
    <attribute name="DriverClass">com.mysql.jdbc.Driver</attribute>
    <attribute name="User">root</attribute>
    <attribute name="Password">123456</attribute>
    
    
    <attribute name="AcquireIncrement">2</attribute>
    <attribute name="AcquireRetryAttempts">30</attribute>
    
    
    
    <attribute name="BreakAfterAcquireFailure">true</attribute>
    
    
    
    
    
    
    
    <attribute name="IdleConnectionTestPeriod">40</attribute>
    <attribute name="InitialPoolSize">2</attribute>
    
    
    <attribute name="MaxIdleTime">1800</attribute>
    
    <attribute name="MaxPoolSize">15</attribute>
    <attribute name="MaxStatements">0</attribute>
    
    <attribute name="MinPoolSize">1</attribute>
    
    
    
    <attribute name="TestConnectionOnCheckout">false</attribute>
    
    
    <depends>jboss:service=Naming</depends>
    </mbean>
    <mbean code="com.mchange.v2.c3p0.jboss.C3P0PooledDataSource" name="jboss:service=C3P0PooledDataSourceOKMAuthDS">
    <attribute name="JndiName">java:OKMAuthDS</attribute>
    <attribute name="JdbcUrl">jdbc:mysql://localhost:3306/openkm</attribute>
    <attribute name="DriverClass">com.mysql.jdbc.Driver</attribute>
    <attribute name="User">root</attribute>
    <attribute name="Password">123456</attribute>
    
    
    <attribute name="AcquireIncrement">2</attribute>
    <attribute name="AcquireRetryAttempts">30</attribute>
    
    
    
    <attribute name="BreakAfterAcquireFailure">true</attribute>
    
    
    
    
    
    
    
    <attribute name="IdleConnectionTestPeriod">40</attribute>
    <attribute name="InitialPoolSize">2</attribute>
    
    
    <attribute name="MaxIdleTime">1800</attribute>
    
    <attribute name="MaxPoolSize">15</attribute>
    <attribute name="MaxStatements">0</attribute>
    
    <attribute name="MinPoolSize">1</attribute>
    
    
    
    <attribute name="TestConnectionOnCheckout">false</attribute>
    
    
    <depends>jboss:service=Naming</depends>
    </mbean>
    <mbean code="com.mchange.v2.c3p0.jboss.C3P0PooledDataSource" name="jboss:service=C3P0PooledDataSourceOKMActivityDS">
    <attribute name="JndiName">java:OKMActivityDS</attribute>
    <attribute name="JdbcUrl">jdbc:mysql://localhost:3306/openkm</attribute>
    <attribute name="DriverClass">com.mysql.jdbc.Driver</attribute>
    <attribute name="User">root</attribute>
    <attribute name="Password">123456</attribute>
    
    
    <attribute name="AcquireIncrement">2</attribute>
    <attribute name="AcquireRetryAttempts">30</attribute>
    
    
    
    <attribute name="BreakAfterAcquireFailure">true</attribute>
    
    
    
    
    
    
    
    <attribute name="IdleConnectionTestPeriod">40</attribute>
    <attribute name="InitialPoolSize">2</attribute>
    
    
    <attribute name="MaxIdleTime">1800</attribute>
    
    <attribute name="MaxPoolSize">15</attribute>
    <attribute name="MaxStatements">0</attribute>
    
    <attribute name="MinPoolSize">1</attribute>
    
    
    
    <attribute name="TestConnectionOnCheckout">false</attribute>
    
    
    <depends>jboss:service=Naming</depends>
    </mbean>

</server>

最后一步，把C3P0的JAR c3p0-09.1.11.jar COPY 到{JBOSS_HOME}\server\default\lib 目录下即可。

posted on 2010-01-19 17:28 MikyTan 阅读(3179) 评论(0) 编辑收藏所属分类: JAVA

新用户注册刷新评论列表


只有注册用户登录后才能发表评论。




网站导航: 博客园 IT新闻 Chat2DB C++博客博问管理
相关文章: IBM JDK 、SUN JDK、HP JDK如何产生Heapdump文件毕业心得。。。。。 JBOSS 下如何配置C3P0的连接池(解决Mysql 8小时的问题) Jetty启动时不能修改 js等静态文件的解决解决Maven中的OutOfMemory错误 Struts2 字符串截取 JSP 中使用Struts2的值 (Strust2 中调用JAVA的公共类方法) xmlbeans dom level 3 not implemented String 和 InputStream 的转换 Struts2 之 CheckBox 小记

banxitan

导航

随笔分类

随笔档案

文章档案

统计

留言簿(2)

阅读排行榜

评论排行榜

JBOSS 下如何配置C3P0的连接池(解决Mysql 8小时的问题)