|
From: Colin B. <col...@te...> - 2002-12-11 22:40:30
|
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 |
