How to change the timeout length of idle data source connections (Information Services) in TIBCO Spotfire Server configuration file

Product:TIBCO Spotfire Server
Versions:All Versions

Summary:
This article explains how to change the timeout seconds of Idle Data Source connections (Information Services) in TIBCO Spotfire Server configuration file

Details:
By default Spotfire uses the "WAIT" connection pool algorithm for connecting to JDBC compliant data sources through Information Services. When the connection is initialized, the connection pool creates a number of idle database connections equal to the min-connections parameter. 

In WAIT mode, the connection pool can never have more open (active or idle) connections than the value of the max-connections parameter. Whenever a database connection is returned, it is put in the pool of idle connections, unless it is used immediately to fulfill an already waiting request.

Resolution:
Idle connections in the database connection pool eventually time out if they are not used. The 'connection-timeout' parameter defines how long (in seconds) a connection can remain idle in the connection pool before being closed and discarded.

Here is a step-by-step procedure to change 'connection-timeout' value:

1. Log on to TIBCO Spotfire Server machine as an Administrator.
2. Launch the TIBCO Spotfire Server Configuration Tool and enter the password.
3. From the 'System Status'> Specify Configuration' option, use the 'Export configuration from database' to export the latest server configuration
4. Open the configuration.xml file in a text editor.
5. Locate the <data-sources> section and find 'connection-timeout' parameter. It should look like below:

   <connection-timeout>600</connection-timeout>

6. Update connection-timeout value(secs) based on your requirement and save the configuration file.
7. Load the newly modified configuration.xml file using the TIBCO Spotfire Server configuration tool (System Status > Specify Configuration > Load configuration from file)
8. Save this configuration to the database (Configuration > Save configuration)
9. Restart the TIBCO Spotfire Server service.