Which LoginTimeout property is used by the Spotfire Information Service and Metadata database?

Which LoginTimeout property is used by the Spotfire Information Service and Metadata database?

book

Article ID: KB0137146

calendar_today

Updated On:

Products Versions
Spotfire 12.1

Description

It may be necessary to increase the timeout value for the database connection. To do this, the connection property `LoginTimeout` will be used by Spotfire the Information Service and the Metadata database, which will take the input value for the key from `$m{loginTimeoutSeconds}`.

Resolution

Spotfire Information Services uses the same underlying connection pool implementation as Spotfire Server for connecting to its own database(i.e., the Spotfire metadata database).

If connection property spotfire.pooling.data.source.login.timeout mentioned in the data source template, then it will use that property. However, if not, it will use information-services.jdbc.connection-login-timeout which has a default value of 10.

Under Database-->Configure Database Properties-->Connection properties input for parameter  $m{loginTimeoutSeconds} is taken from the Login timeout (seconds) property. PFA image.

image.png

 

Issue/Introduction

Which LoginTimeout property is used by the Spotfire Information Service and Metadata database?

Additional Information