How to increase the connection timeout to the Yellowfin database

Summary

By default, Yellowfin has a 5 minute connection timeout to the Yellowfin database.

Sometimes it is necessary to increase the timeout duration, for example, you might be doing a import of a large export file that exceeds 5 minutes in which case the import will fail and there will be an error in the logs something to effect of "the connection object is closed".

Changing the JDBCTimeout value

To increase the length of time before the connection times out, add the JDBCTimeout parameter and value to the web.xml file ( Yellowfin\appserver\webapps\ROOT\WEB-INF) anywhere in the InitConnectionPool servlet as shown at the bottom of the code below.

The value is in seconds, thus the example below is 10 minutes.

You can read more about how JDBCTimeout works here.