Squirrel Hangs when Connection dropped by network
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
I am using SQuirreL 3.0.3 On Windows XP and when the database drops the connection after 20 min of inactivity the next command I execute is always hard on my patience limit until I get the error message.
But SQuirreL does come around eventually (one day I will time it) but it feels definitely too long. During that time I cannot switch to other tabs; typing in advance often results in a messed up command.
Maybe we should open a feature request for an optional heartbeat function? (Although I am not sure whether it will help with the VPN problem)
You are in luck. The latest snapshot here:
https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/Snapshot-20091229_2105/squirrel-sql-Snapshot-20091229_2105-install.jar/download
has a "heartbeat" feature that allows you to configure (per alias properties) an SQL statement to execute and how often (in seconds). You will never be "inactive" again :)
Rob