How to set JDBC connection timeout
I use DataGrip (JDBC client) to query Caché server via JDBC.
The problem I encountered, is that if I wait 10 or more minutes between queries I get an error:
[08S01][461] Communication link failure: Socket closed
To fix that I need to disconnect and connect to server again. Is there a JDBC timeout setting somewhere I can change?
Possible solution:
write $SYSTEM.Status.GetErrorText($SYSTEM.SQL.SetTCPKeepAlive(3600))
About TCPKeepAlive.
UPD: well, that did not work. I set it to 3600 and later to 30, and it did not help any.