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

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

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. 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.

Doc: Database Connectivity

• https://docs.tibco.com/pub/spotfire_server/12.0.3/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/database_connectivity.html

Doc: Manually editing the server configuration in an XML or text editor

• https://docs.tibco.com/pub/spotfire_server/12.0.3/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/manually_editing_the_server_configuration_in_an_xml_or_text_editor.html