HikariCP
HikariCP copied to clipboard
maxLifetime Configuration MSSQL Clarification
The README states the following in reference to maxLifetime
:
We strongly recommend setting this value, and it should be several seconds shorter than any database or infrastructure imposed connection time limit.
Which exact configuration fields should I be looking at, and how exactly do I access/view them?
For example using another databse, MySQL, this is as easy as executing the following query SHOW VARIABLES like '%timeout%';
and looking at the wait_timeout
field. What is the equivalent research process for MSSQL/TSQL?
For complete clarity I am using the following SQL Server Docker Image: mcr.microsoft.com/mssql/server:2019-CU15-ubuntu-20.04