Re: [Squirrel-sql-users] Connection Timeout/Drop

Hi Ethan,

> I am attempting to connection to a remote oracle database over the 
> internetand through the remote network's firewall.  I can 
> establish a connection,
> but because I am going through the remote network's fire wall I 
> have only
> one minute of idle time before the connection is terminated.
> 
> I can ssh through the remote network's fire wall and the timeout 
> does not
> occur because my local ssh client(Putty) sends keep alive packets 
> every 15
> seconds.
> 
> Is there a way to keep my connection in squirrel alive 
> automatically using
> some sort of sql heartbeat?  Or is there a way I can make squirrel 
> use the
> connection established by my local ssh client?

Currently in Squirrel theres no way to have a "heartbeat" sent to the
server, it would be possible for somebody to write a plugin to do this.

The connection to the database is under the control of the JDBC driver
that you are using so you'd need to check the documentation for your 
driver to see if it is possible to piggyback your existing ssh
connection.

Although it doesn't solve your problem there is a "Reconnect" option
on the session menu which will attempt to close the existing connection
and open a new one using the user name and password that you used to
establish the initial connection. This would be more convenient than
going back to the aliases list and reslogging on.

--
Colin Bell
http://squirrel-sql.sf.net