|
From: Drav S. <hol...@dr...> - 2013-05-26 10:45:15
|
urbanmojo wrote: > I'm working with Squirrel 3.4.0 connecting to Oracle over a shaky VPN > connection using the Oracle Thin JDBC driver. > > I've noticed that even if Squirrel is sitting idle for some time and, during > that time, I lose connection to the database and then come back and try to > run a query that it doesn't run and I get something like a "closed > connection error". (even though I currently do have connectivity when > attempting to run it). > > The only way I see is to close my query window and reconnect to the alias. > > Question 1: > 1. Is this an issue with Squirrel, the driver, or Oracle? A thin driver connection is a tcp connection (and therefore stateful) which relies on a permanent net connection. If this fails then the connection will drop. > 2. Any way around this? You can issue the "reconnect" command Session > Reconnect (quick shortcut of Crtl-Alt-T), which will save you having to reopen the window. You may or may have some success with a "keepalive" command. Right click on the Alias and goto Alias Properties, select the connection tab, enable keep alive and set some sql to run (select sysdate from dual as an example). However this may make your connection drop more quickly. Regards D. |
