squirrel-sql-users

[Squirrel-sql-users] Anything to do about timed-out sessions with oracle?

[Karr, D. <dav...@wa...>]

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.

Re: [Squirrel-sql-users] Anything to do about timed-out sessions with oracle?

[Gerd W. <bir...@t-...>]

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

Hope this helps.

Gerd

Re: [Squirrel-sql-users] Anything to do about timed-out sessions with oracle?

[Robert M. <rob...@gm...>]

On 1/14/07, Gerd Wagner <bir...@t-...> 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

Re: [Squirrel-sql-users] Anything to do about timed-out sessions with oracle?

[Karr, D. <dav...@wa...>]

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

> -----Original Message-----
> From: Robert Manning [mailto:rob...@gm...]=20
> Sent: Sunday, January 14, 2007 10:57 AM
> To: Gerd Wagner
> Cc: Karr, David; squ...@li...
> Subject: Re: [Squirrel-sql-users] Anything to do about=20
> timed-out sessions with oracle?
>=20
> On 1/14/07, Gerd Wagner <bir...@t-...> wrote:
> > Karr, David wrote:
> > > One minor nit I have with SQuirreL is that if I let a=20
> connection sit=20
> > > for too long, the connection sort of times out, but the=20
> only way I=20
> > > can fix is to close the session with the db and open it=20
> again.  I've=20
> > > just gotten used to doing this, but I guess I should ask=20
> if there's=20
> > > a way to make this work better.  I've tried the "Refresh Object=20
> > > 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,=20
> close and re-open session.  It's very handy and I use from=20
> time to time.  Mostly with older (that is, buggy) MySQL=20
> server/driver which seems to drop the connection if the SQL=20
> syntax isn't perfect.
>=20
> Rob
>=20