Squirrel sql client session timeout

Question

It is not related to whatever version it is, just working to find out how to change (of course increase) session timeout value of Squirrel Sql Client. Because I really get bored of getting kind of exception "Last packet sent to the server was .. ago"

Any help would be appreciated.

Answer 1

You can keep the connection alive by doing the following:

On Aliases->Modify the Selected Alias (pencil icon)-> Properties-> Connection (tab)

Check Enable Keep-Alive

and enter a simple query, in PostgreSQL I use SELECT 1;, in Oracle should be something like SELECT 1 FROM dual

Answer 2

Solution for MySQL:

• Right-click a connection alias and select "Modify alias"
• Click "Properties" and select the "Driver properties" tab
• Set the property "autoReconnect" to "TRUE"