From oracle-l-bounce@freelists.org Wed Apr 7 20:09:49 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3819nZ21978 for ; Wed, 7 Apr 2004 20:09:49 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i3819mo21973 for ; Wed, 7 Apr 2004 20:09:49 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 41B816347D9; Wed, 7 Apr 2004 20:05:10 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 12412-07; Wed, 7 Apr 2004 20:05:10 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 952386346FF; Wed, 7 Apr 2004 20:05:09 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 07 Apr 2004 20:04:01 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A9917634700 for ; Wed, 7 Apr 2004 20:04:00 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11192-90 for ; Wed, 7 Apr 2004 20:04:00 -0500 (EST) Received: from web60504.mail.yahoo.com (web60504.mail.yahoo.com [216.109.116.125]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 48B86634708 for ; Wed, 7 Apr 2004 20:04:00 -0500 (EST) Message-ID: <20040408011326.97371.qmail@web60504.mail.yahoo.com> Received: from [24.136.220.254] by web60504.mail.yahoo.com via HTTP; Wed, 07 Apr 2004 18:13:26 PDT Date: Wed, 7 Apr 2004 18:13:26 -0700 (PDT) From: Michael Thomas Subject: Re: Stuck session help To: oracle-l@freelists.org In-Reply-To: <40747C98.E34DDFBD@sun.com> MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 2749 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mhthomas@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Questions for you: Pt1) Does Oracle automatically kill the session after a timeout period? Pt2) What does your application do after the 'sticking' followed by the Oracle timeout? --- Daniel Fink wrote: > We've got an application that is having problems > with the > processing becoming 'stuck'. I'm now stuck trying to I've seen 'sticking' applications (connected via JDBC), but I was not aware of the Metalink 'bug' discussed here. Our application workaround was a big problem because the 'connection object' did not have a robust way to recover after 'sticking' nor after Oracle's timeout, and therefore the application process failed. We attributed our 'sticking' to a poor network, because it only seemed to happen in one of our client buildings, but not to other users of the web tier. Maybe we missed the Metalink 'bug', I don't have any way to know, now. Regarding my Pt2 question, I remember researching Metalink (it was over a year ago, sorry) and finding that Oracle's TOPLink product had a 'connection object' designed to perform a robust connection recovery. It is possible to design something that 'reconnects' if there is some type of failure, but 'usually' developers don't build connect objects with this much detail in error handling. The Metalink discussions of this were helpful. Good luck. Regards, Mike Thomas __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------