Pentaho BI 服务器每天重启一次的问题解决

最新推荐文章于 2021-04-13 19:54:02 发布

原创最新推荐文章于 2021-04-13 19:54:02 发布 · 972 阅读

0 ·

CC 4.0 BY-SA版权

BI 专栏收录该内容

40 篇文章

订阅专栏

本文详细介绍了如何在Tomcat服务器上通过引入C3P0连接池来优化MySQL数据库连接，包括下载C3P0驱动、配置hibernate文件以及设置关键参数以减少连接超时，从而提升系统性能。

工作数据库是mysql

Mysql服务器默认的“wait_timeout”是8小时，也就是说一个connection空闲超过8个小时，Mysql将自动断开该connection。

There is a solution introduced in the Pentaho forum for this, you can find the thread with the following link.

http://forums.pentaho.com/showthread.php?54939-Pentaho-Server-falls-each-night-..&p=178067#post178067

But above forum post is based on the JBoss server. My intention with this post is to implement the same on the tomcat server since the file structure is a bit different. Ok without further due, let get into action.

01.    Download the C3P0 driver from SourceForge
02.    Extract the c3p0-0.9.1.2.jar file into \biserver-ce\tomcat\common\lib\
03.    Open the mysql5.hibernate.cfg.xml XML file in the \biserver-ce\pentaho-solutions\system\hibernate\ folder
04.    Add the following code into the file

<!— hibernate c3p0 settings —>
<property name=”connection.provider_class”>org.hibernate.connection.C3P0ConnectionProvider</property>
<property name=”hibernate.c3p0.acquire_increment”>3</property>
<property name=”hibernate.c3p0.idle_test_period”>10</property>
<property name=”hibernate.c3p0.min_size”>5</property>
<property name=”hibernate.c3p0.max_size”>75</property>
<property name=”hibernate.c3p0.max_statements”>0</property>
<property name=”hibernate.c3p0.timeout”>25200</property>
<property name=”hibernate.c3p0.preferredTestQuery”>select 1</property>
<property name=”hibernate.c3p0.testConnectionOnCheckout”>true</property>