From oracle-l-bounce@freelists.org Thu Oct 20 21:55:56 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9L2tjlm014391 for ; Thu, 20 Oct 2005 21:55:51 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9L2tLvX014355 for ; Thu, 20 Oct 2005 21:55:31 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E291920A017; Thu, 20 Oct 2005 21:55:03 -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 13205-09; Thu, 20 Oct 2005 21:55:03 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 655BB209EDF; Thu, 20 Oct 2005 21:55:03 -0500 (EST) X-IronPort-AV: i="3.97,238,1125892800"; d="scan'208"; a="1708071452:sNHT14653064" Message-ID: <435881E2.3030900@chartermi.net> Date: Thu, 20 Oct 2005 22:51:30 -0700 From: Phil Singer User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Oracle-L Subject: Re: BEA and Java Connection Pooling References: <87E07E8CF4B26D4587451BE788F5C3213281FF@IAD-WPRD-XCHB02.corp.verio.net> In-Reply-To: <87E07E8CF4B26D4587451BE788F5C3213281FF@IAD-WPRD-XCHB02.corp.verio.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed X-archive-position: 27308 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: psinger1@chartermi.net Precedence: normal Reply-To: psinger1@chartermi.net X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.9 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 Michael Fontana wrote: [SNIP] > > This is, of course, as I am told by our development management, a > "DATABASE PROBLEM". Given that Oracle has similar methods to accomplish > the same things as the java connection pools are supposed to, does > anyone have any suggestions/experience/advice about the use of these > techniques? > I've had to deal with similar problems using ADO connection pooling. But , first, let me (re)tell a little story: A man was walking down the street. He saw another man on his knees under a streetlight. He asked what the problem was. The 2nd man said he had lost his wedding ring. He knelt down to help him look. After an hour he asked exactly where he was when he lost it. The response was "over there, across the street". "So, why are you looking over here?" "Because the light is so much better." I am convinced that the reason the DATABASE gets blamed (or is made the focus for the troubleshooting) is that Oracle makes it so easy to look at a single connection, that no one wants to look where the problem actually is. Troubleshooting web server logs and network traces are difficult. Querying the data dictionary (and even a sql*net trace) is duck soup. Having said that, we found that getting on the latest version of Oracle Net services fixed a great many things. And I also think (not that it's worth much) that putting up with these issues is still better than trying to deal with Oracle Net Shared Servers. -- http://www.freelists.org/webpage/oracle-l