Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How to "keep alive" connection cache?

6 posts in General Discussion (old) Last posting was on 2000-02-15 17:20:49.0Z
Victor Rasputnis Posted on 2000-02-14 21:36:19.0Z
Newsgroups: sybase.public.easerver
From: "Victor Rasputnis" <VictorRasputnis@toast.net>
Subject: How to "keep alive" connection cache?
Date: Mon, 14 Feb 2000 16:36:19 -0500
Lines: 13
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: bk01.bankofny.com 160.254.115.80
Message-ID: <347_#bvZGQzd$GA.327@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28717
Article PK: 160841

Hello everyone.

My DBA's got habit of disconnecting a connection once it is idle for 20
minutes.
I guess this is not a good thing for ConnectionCache.

Are there any remedies, out there, to keep connection cache in good
standing?

Thanks in advance,
Victor


Dave Wolf [Sybase] Posted on 2000-02-14 23:44:16.0Z
Newsgroups: sybase.public.easerver
From: "Dave Wolf [Sybase]" <dwolf@sybase.com>
Subject: Re: How to "keep alive" connection cache?
Date: Mon, 14 Feb 2000 18:44:16 -0500
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: 158.159.8.63
Message-ID: <347_z5VHlX0d$GA.184@forums.sybase.com>
References: <347_#bvZGQzd$GA.327@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28696
Article PK: 160822

Why not make a service component that every n minutes requests a connection
from the cache and pings on it, and puts it back.

Dave Wolf
Internet Applications Division

Victor Rasputnis <VictorRasputnis@toast.net> wrote in message
news:#bvZGQzd$GA.327@forums.sybase.com...
> Hello everyone.
>
> My DBA's got habit of disconnecting a connection once it is idle for 20
> minutes.
> I guess this is not a good thing for ConnectionCache.
>
> Are there any remedies, out there, to keep connection cache in good
> standing?
>
> Thanks in advance,
> Victor
>
>


BSI Posted on 2000-02-15 14:34:40.0Z
Newsgroups: sybase.public.easerver
From: "BSI" <easerver2k@hotmail.com>
Subject: Re: How to "keep alive" connection cache?
Date: Tue, 15 Feb 2000 09:34:40 -0500
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: rte-wall.rte-asset.com 207.245.78.18
Message-ID: <347_VEDroJ8d$GA.324@forums.sybase.com>
References: <347_#bvZGQzd$GA.327@forums.sybase.com> <347_z5VHlX0d$GA.184@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28662
Article PK: 160792

Your previous suggestion is better, I think. And at least as effective.
Plus it's lots more fun for the developer. ;>)

--

"Dave Wolf [Sybase]" <dwolf@sybase.com> wrote in message
news:z5VHlX0d$GA.184@forums.sybase.com...
> Why not make a service component that every n minutes requests a
connection
> from the cache and pings on it, and puts it back.
>
> Dave Wolf
> Internet Applications Division
>
> Victor Rasputnis <VictorRasputnis@toast.net> wrote in message
> news:#bvZGQzd$GA.327@forums.sybase.com...
> > Hello everyone.
> >
> > My DBA's got habit of disconnecting a connection once it is idle for 20
> > minutes.
> > I guess this is not a good thing for ConnectionCache.
> >
> > Are there any remedies, out there, to keep connection cache in good
> > standing?
> >
> > Thanks in advance,
> > Victor
> >
> >
>
>


Jim O'Neil [Sybase] Posted on 2000-02-14 23:14:54.0Z
Newsgroups: sybase.public.easerver
Date: Mon, 14 Feb 2000 18:14:54 -0500
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: How to "keep alive" connection cache?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 17
NNTP-Posting-Host: joneil-nt.sybase.com 204.167.42.111
Message-ID: <347_38A88C6E.B17EFD4F@sybase.com>
References: <347_#bvZGQzd$GA.327@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28703
Article PK: 160828


Victor Rasputnis wrote:

> Hello everyone.
>
> My DBA's got habit of disconnecting a connection once it is idle for 20
> minutes.
> I guess this is not a good thing for ConnectionCache.
>
> Are there any remedies, out there, to keep connection cache in good
> standing?
>
> Thanks in advance,
> Victor

If you turn the sanity check on when setting up the cache, Jaguar will
detect that the connection is bad (or nonexistant) and reestablish it
automatically for you. The 'check' occurs everytime a connection is
requested from the cache, so there is a tiny bit of overhead.
--
Jim O'Neil
Senior Technical Support Engineer
Sybase, Inc


Dave Wolf [Sybase] Posted on 2000-02-14 23:48:08.0Z
Newsgroups: sybase.public.easerver
From: "Dave Wolf [Sybase]" <dwolf@sybase.com>
Subject: Re: How to "keep alive" connection cache?
Date: Mon, 14 Feb 2000 18:48:08 -0500
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: 158.159.8.63
Message-ID: <347_IRmdvZ0d$GA.332@forums.sybase.com>
References: <347_#bvZGQzd$GA.327@forums.sybase.com> <347_38A88C6E.B17EFD4F@sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28691
Article PK: 154704

Smacking your DBA is a resonable solution as well :)

Dave Wolf
Internet Applications Division

Jim O'Neil [Sybase] <joneil@sybase.com> wrote in message
news:38A88C6E.B17EFD4F@sybase.com...
> Victor Rasputnis wrote:
>
> > Hello everyone.
> >
> > My DBA's got habit of disconnecting a connection once it is idle for 20
> > minutes.
> > I guess this is not a good thing for ConnectionCache.
> >
> > Are there any remedies, out there, to keep connection cache in good
> > standing?
> >
> > Thanks in advance,
> > Victor
>
> If you turn the sanity check on when setting up the cache, Jaguar will
> detect that the connection is bad (or nonexistant) and reestablish it
> automatically for you. The 'check' occurs everytime a connection is
> requested from the cache, so there is a tiny bit of overhead.
> --
> Jim O'Neil
> Senior Technical Support Engineer
> Sybase, Inc
>
>


Jim O'Neil [Sybase] Posted on 2000-02-15 17:20:49.0Z
Newsgroups: sybase.public.easerver
Date: Tue, 15 Feb 2000 12:20:49 -0500
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: How to "keep alive" connection cache?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 9
NNTP-Posting-Host: joneil-nt.sybase.com 204.167.42.111
Message-ID: <347_38A98AF0.41ACC040@sybase.com>
References: <347_#bvZGQzd$GA.327@forums.sybase.com> <347_38A88C6E.B17EFD4F@sybase.com> <347_IRmdvZ0d$GA.332@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28643
Article PK: 160776


"Dave Wolf [Sybase]" wrote:

> Smacking your DBA is a resonable solution as well :)
>
> Dave Wolf
> Internet Applications Division
>

Well, gee I kind thought he would have already done that .... Apologies for
overlooking the obvious ;>)
--
Jim O'Neil
Senior Technical Support Engineer
Sybase, Inc