Skip to main content
Language Selector

  1. Other Languages

    (machine translation)

Planview Customer Success Center

How can I override the default socket timeout for my operational database?

  1. Last updated
  2. Save as PDF

Last Updated:    |  Applicable Hub Versions: All

Answer

The default socket timeout for external operational databases is set to 10 minutes in Planview Hub versions 20.1+, 19.4.4+, and 19.3.15+. You can override this default setting by following the instructions below:

Oracle

Set the Hub system property oracle.jdbc.ReadTimeout to the desired time in milliseconds.

MySQL, PostgreSQL, Microsoft SQL Server

Provide the 'soccketTimeout' property in the database connection URL (in seconds for PostgreSQL, and in milliseconds for MySQL and Microsoft SQL Server). 

It can go anywhere in the properties of the URL. For example, both of the following would be valid:

  • jdbc:sqlserver://<server-name>:1433;encrypt=true;trustServerCertificate=false;socketTimeout=60000 
  • jdbc:sqlserver://<server-name>:1433;socketTimeout=60000;encrypt=true;trustServerCertificate=false