PENTAHO连接超时问题

1.下载http://sourceforge.net/projects/c3p0

2.将c3p0-0.9.2.jar 和 mchange-commons-java-0.2.3.3.jar 解压到     /usr/local/pentaho/biserver-ce/tomcat/webapps/pentaho/WEB-INF/lib目录及/usr/local/pentaho/administration-console/lib

3.编辑mysql5.hibernate.cfg.xml 增加下面配置(在<session-factory> 和  <!-- MySQL Configuration -->之间 )

<!--
            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>
        <!--
            hibernate cache settings
        -->
 <!-- End of patch added Friday April 3, 2009 to address issues of the database connection going dead
 -->