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:
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:
- Log on to TIBCO Spotfire Server machine as an Administrator.
- Launch the TIBCO Spotfire Server Configuration Tool and enter the password.
- From the 'System Status'> Specify Configuration' option, use the 'Export configuration from database' to export the latest server configuration
- Open the configuration.xml file in a text editor.
- Locate the <data-sources> section and find 'connection-timeout' parameter. It should look like below:
<connection-timeout>600</connection-timeout>
- Update connection-timeout value(secs) based on your requirement and save the configuration file.
- Load the newly modified configuration.xml file using the TIBCO Spotfire Server configuration tool (System Status > Specify Configuration > Load configuration from file)
- Save this configuration to the database (Configuration > Save configuration)
- Restart the TIBCO Spotfire Server service.
Comments
0 comments
Article is closed for comments.