Re: [Squirrel-sql-users] Oracle Disconnect

[John H. <jh...@im...>]

On Sun, 26 May 2013, Drav Sloan wrote:

> 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.

One important piece of that is: if your IP address changes. If the VPN 
connection drops, gets restored, and you get assigned the same IP address, 
the TCP connection *should* recover unless the timeouts have been set 
fairly short.

>> 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.

-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jh...@im...    FALaholic #11174     pgpk -a jh...@im...
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
   Maxim XXIX: The enemy of my enemy is my enemy's enemy. No more.
   No less.
-----------------------------------------------------------------------
  Tomorrow: Memorial Day - honor those who sacrificed for our liberty