Connection to SQL Workbench/J gets disconnected frequently

user_5429010 0
Viewed 6528

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

sql-workbench-j database-connection
2 Answers

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)

user_69017860
Related