How to set JDBC connection timeout

Question

Question

Eduard Lebedyuk · Dec 28, 2016

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?

Discussion (1)0

Log in or sign up to continue

score 0 · Answer 1 · 2016-12-28T15:00:00-05:00

Possible solution:

write $SYSTEM.Status.GetErrorText($SYSTEM.SQL.SetTCPKeepAlive(3600))

UPD: well, that did not work. I set it to 3600 and later to 30, and it did not help any.