Re: Anything to do about timed-out sessions with oracle?

Yes, it looks like that will help.  In the case of Oracle, it just seems
like the connection times out after a while.  I have to deal with that
in WebLogic by having it renew the connection every few minutes.

I did notice that the menu mnemonic for "Reconnect" conflicts with
"Transaction".  I filed a bug on that. 

> -----Original Message-----
> From: Robert Manning [mailto:robert.m.manning@xxxxxxxxx] 
> Sent: Sunday, January 14, 2007 10:57 AM
> To: Gerd Wagner
> Cc: Karr, David; squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
> Subject: Re: [Squirrel-sql-users] Anything to do about 
> timed-out sessions with oracle?
> 
> On 1/14/07, Gerd Wagner <birgit-und-gerd@xxxxxxxxxxx> wrote:
> > Karr, David wrote:
> > > One minor nit I have with SQuirreL is that if I let a 
> connection sit 
> > > for too long, the connection sort of times out, but the 
> only way I 
> > > can fix is to close the session with the db and open it 
> again.  I've 
> > > just gotten used to doing this, but I guess I should ask 
> if there's 
> > > a way to make this work better.  I've tried the "Refresh Object 
> > > Tree" button, but that doesn't help in this case.
> > In the Session menu there is an item "Reconnect".
> >
> Yes, reconnect keeps you from having to save your script, 
> close and re-open session.  It's very handy and I use from 
> time to time.  Mostly with older (that is, buggy) MySQL 
> server/driver which seems to drop the connection if the SQL 
> syntax isn't perfect.
> 
> Rob
> 

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV