Connection to SQL Workbench/J gets disconnected frequently

Question

The connection to SQL Workbench/J gets disconnected very frequently. Where can I change the settings so that it does not lose the connections for atleast an hour.

Thanks

Answer 1

This works for me with using PostgreSQL...

1. Go to Connection Window
2. Select the connection you want to keep alive
3. Click the "Connect scripts" button
4. Write "Select 1" in the third box titled "Statement to keep connection alive"
5. Write "1m" in fourth box titled "Idle time"

SQL Workbench/J (screenshot)

Answer 2

What OS are you using and what type of database are you connecting to?

I had the same issue using Windows connecting to a Redshift database. I followed the instructions on Amazon doing the following:

• Edit (or otherwise create if not already existing in my case) the values for the following registry settings under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters:

  • KeepAliveTime: 30000
  • KeepAliveInterval: 1000
  • TcpMaxDataRetransmissions: 10

Reference here: http://docs.aws.amazon.com/redshift/latest/mgmt/connecting-firewall-guidance.html