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?

  • 0
  • 0
  • 672
  • 1
  • 0

Comments

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.