From users-return-98513-apmail-cocoon-users-archive=cocoon.apache.org@cocoon.apache.org Fri Feb 12 21:56:51 2010 Return-Path: Delivered-To: apmail-cocoon-users-archive@www.apache.org Received: (qmail 48035 invoked from network); 12 Feb 2010 21:56:50 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 12 Feb 2010 21:56:50 -0000 Received: (qmail 16878 invoked by uid 500); 12 Feb 2010 21:56:47 -0000 Delivered-To: apmail-cocoon-users-archive@cocoon.apache.org Received: (qmail 16806 invoked by uid 500); 12 Feb 2010 21:56:47 -0000 Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: users@cocoon.apache.org List-Id: Delivered-To: mailing list users@cocoon.apache.org Received: (qmail 16775 invoked by uid 99); 12 Feb 2010 21:56:47 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 12 Feb 2010 21:56:47 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of pjoseph@gmail.com designates 209.85.212.51 as permitted sender) Received: from [209.85.212.51] (HELO mail-vw0-f51.google.com) (209.85.212.51) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 12 Feb 2010 21:56:37 +0000 Received: by vws8 with SMTP id 8so957514vws.24 for ; Fri, 12 Feb 2010 13:56:16 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:subject:references:in-reply-to :content-type:content-transfer-encoding; bh=SdtZGgKqearuKNZFmPgbeJ4aBV27fsUVllaJPhgQWwc=; b=CE4txDNJAApvnfqAW7Mtx7CLMhYACez8i5Pqh5AiSLOWHLJDwbR5slo+T/FH9TLqYg 323Z/5CN5YvzUwQzc1mI0wzVA5Czz1P7alEzq0nJ0f9uMvmdZQ/z9QbbriWmr3tGPH/E QlFoF11vC8DGV9tuTAI6DvZIx4ikD1PyOJcOY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type:content-transfer-encoding; b=Goe2fJSgv/S6/3zVgndkr0hSJR9scRwYUse+v8mayCrL/rR+Rh9YcD4xklJ/ix+M0G jPmEPnkfhmWc2j8Uy7WD5hZzLL/Kr1rV5jVsvh2sk7Zm98OUtTuJAqR6P5L6xXXnUkOv tPPauQGHKhAh8g+qKYNQSWBMr/rNCBWZMFJwY= Received: by 10.220.127.68 with SMTP id f4mr1238269vcs.237.1266011774323; Fri, 12 Feb 2010 13:56:14 -0800 (PST) Received: from ?192.168.1.5? (pool-98-110-180-179.bstnma.fios.verizon.net [98.110.180.179]) by mx.google.com with ESMTPS id 36sm36943652vws.15.2010.02.12.13.56.13 (version=TLSv1/SSLv3 cipher=RC4-MD5); Fri, 12 Feb 2010 13:56:13 -0800 (PST) Message-ID: <4B75CE7C.3030408@gmail.com> Date: Fri, 12 Feb 2010 16:56:12 -0500 From: Paul Joseph User-Agent: Thunderbird 2.0.0.23 (Windows/20090812) MIME-Version: 1.0 To: users@cocoon.apache.org Subject: Re: Database Connection Leak - When too many pipelines References: <4B75B1A8.7080903@principle.com> <4B75C075.3020304@gmail.com> <4B75CB94.5080100@principle.com> In-Reply-To: <4B75CB94.5080100@principle.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org I have to confess my ignorance of Spring's framework...I suggest googling on dbcp and data leaks and you may see if the method is common to both? Shahriar Aghajani wrote: > Thanks Paul. > > I'm not certain, but it doesn't look like i'm using commons-dbcp. > > I think the spring DriverManagerDataSource is replacing it in this case? > > Below is what I'm using for my connector: > > Cheers. > > name="org.apache.avalon.excalibur.datasource.DataSourceComponent/workshop_admin" > class="org.apache.cocoon.databases.bridge.spring.avalon.SpringToAvalonDataSourceWrapper"> > > > > class="org.springframework.jdbc.datasource.DriverManagerDataSource" > > value="org.postgresql.Driver"/> > > > > > > > > > > > Paul Joseph wrote: >> I vaguely recall having this problem in Cocoon 2.1.11 and that it >> seemed to go away when I replaced my commons-dbcp jar with the latest >> I could find (commons-dbcp-1.2.2.jar) >> >> Shahriar Aghajani wrote: >>> Hello, >>> >>> I wonder if anybody can help me or point me in the right direction. >>> >>> I get database connection leaks if I'm including pipelines which >>> reference other pipelines too many times. >>> >>> I'm using Cocoon 2.2 >>> PostgreSQL 8.3 with postgresql-8.3-605.jdbc3.jar >>> >>> Here's what I got: >>> >>> Data comes from the parent sitemap, and the child sitemap uses that >>> data. >>> I've tried including the data using map:aggregate, XInclude, >>> Include, and XSLT/document()... all lead to the leaks one way or >>> another. >>> For each of the "bad" piplines, I get a new idle postgres connection >>> hanging around indefinitely. >>> >>> Below, >>> for the via-agg.xml pipeline, the 3rd include does the job. If I >>> remove that one, then I don't get a leak. >>> for the via-include.xml pipeline, if I use only one of the "CULPRIT" >>> includes, everything is fine. But if I use any 2 of the includes, >>> then I get a leak. >>> >>> Any ideas? >>> >>> >>> Thank you very much for your help. >>> >>> Regards, >>> Shahriar Aghajani. >>> >>> >>> Parent Sitemap: >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> Sub Sitemap: >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> Seed File: >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org >>> For additional commands, e-mail: users-help@cocoon.apache.org >>> >>> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org >> For additional commands, e-mail: users-help@cocoon.apache.org >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org > For additional commands, e-mail: users-help@cocoon.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org For additional commands, e-mail: users-help@cocoon.apache.org