Mailing-List: contact user-help@commons.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Commons Users List" <user@commons.apache.org>
Received-SPF: pass (athena.apache.org: domain of newadminbg@gmail.com
 designates 74.125.78.145 as permitted sender)
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;
        b=jl+2r4UHjsZbrhC4y9L+Z1aMWbPYRJzs8rmpF0iXAK35EZ284E+sldVYwNL13Qc4YC
         XoHzkm2IBTUX018wW/Eds6CNn2D0IuHY1bxWpxMilxb7mfi6syxgArEE6cpMhdt6wmSD
         rzfIn+G8Lq7N9Vuq4bL6LqwpC5U3Ie79MX6vk=
Message-ID: <49363622.2090201@gmail.com>
Date: Wed, 03 Dec 2008 09:32:50 +0200
From: Martin Dyulgerov <newadminbg@gmail.com>
User-Agent: Thunderbird 2.0.0.12 (X11/20080213)
MIME-Version: 1.0
To: Commons Users List <user@commons.apache.org>
Subject: Re: DBCP problem with idle object
References: <49341C36.5090607@gmail.com> <4934960F.5030406@gmail.com>
 <49354756.2080306@gmail.com> <4935E9DA.2000405@gmail.com>
In-Reply-To: <4935E9DA.2000405@gmail.com>
Content-Type: multipart/mixed;
 boundary="------------080403060708090108050302"

--------------080403060708090108050302
Content-Type: text/plain; charset=windows-1251; format=flowed
Content-Transfer-Encoding: 7bit

Phil Steitz wrote:
> Looks like you may not be closing your connections on all control 
> paths.  Are you sure there are not exception conditions that could 
> cause your close() activations to be missed?
Hello again. I am sure that in every JSP or servlet I am closing thje 
connections with the following piece of code:

            try
            {
                pConn.close(); // my connections, gained from the 
PoolingDataSource, they are of type Connection
            }
            catch(Exception exc)
            {
                System.out.println("Exception: "+exc.getMessage());
                out.println("Exception: "+exc.getMessage());
            }
MySQL shows opened only one connection when the pool seems to be 
working. I dont know what is causing the pool to stop working and giving 
the exception. As a result of my further research on the problem on the 
Internet yesterday, I am now using the following settings for the pool:

GenericObjectPool.Config config=new GenericObjectPool.Config();
config.maxActive=50;
config.maxWait=-1;
config.testOnBorrow=true;
config.defaultAutoCommit=true;
config.minIdle=0;
config.testWhileIdle=false;

I am going to continue my work on the project, so if the exception shows 
again I'll know in a matter of hours. Thanks for your replies.

Martin


--------------080403060708090108050302
Content-Type: text/plain; charset=us-ascii

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
For additional commands, e-mail: user-help@commons.apache.org
--------------080403060708090108050302--