How to reconnect a timed out session.
633432Oct 15 2008 — edited Oct 16 2008Naturally my work environment is set up to timeout sessions which have been inactive for 15-30 minutes; we get a standard "Could not connect to database: Closed Connection"
To test I opened a SQL Developer connection and an SQLPLUS connection and waited for about 40 minutes. Sure enough, SQLPLUS was disconnected. I then tried clicking the Refresh button on the Connections tab. (I am new to SQLDeveloper and used to TOAD, so I thought at first that button refreshed the "left side" AKA the tree view--which of course it doesn't.) Immediately I got a window saying it's refreshing the table list--that's what I had open--but then lapsed after a few seconds to the "Closed Connection" error.
I can refresh a connection in TOAD, albeit slowly. Is there a way in SQL Developer to refresh the connection? I hate to have to always find out the hard way, then disconnect and reconnect.