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 phil.steitz@gmail.com
 designates 209.85.213.43 as permitted sender)
Message-ID: <4E46FC76.9090109@gmail.com>
Date: Sat, 13 Aug 2011 15:36:38 -0700
From: Phil Steitz <phil.steitz@gmail.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7;
 rv:5.0) Gecko/20110624 Thunderbird/5.0
MIME-Version: 1.0
To: Commons Users List <user@commons.apache.org>
Subject: Re: [dbcp] PoolingDataSource setup problem
References: <4E439433.4000500@xlbit.com> <4E439475.2060903@sodomaco.it>
In-Reply-To: <4E439475.2060903@sodomaco.it>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

On 8/11/11 1:36 AM, Andrea Sodomaco wrote:
>  Hi,
>
> I tried to follow this example
> http://svn.apache.org/viewvc/commons/proper/dbcp/trunk/doc/PoolingDataSourceExample.java?view=markup
>
>
> but at lines 148/149
> 148 PoolableConnectionFactory poolableConnectionFactory =
> 149         new PoolableConnectionFactory(connectionFactory);
>
> it fails because, according to
> http://commons.apache.org/dbcp/api-1.4/index.html
> <http://commons.apache.org/dbcp/api-1.4/index.html>, all
> constructors need an ObjectPool
> but also all costructors of GenericObjectPool need a
> PoolableObjectFactory!
>
> I "solved" the problem by this work-around
> PoolableConnectionFactory poolableConnectionFactory =
>                   new
> PoolableConnectionFactory(connectionFactory,*new
> GenericObjectPool()*,null,null,false,false);
>
> ObjectPool connectionPool =    new
> GenericObjectPool(poolableConnectionFactory);
> poolableConnectionFactory.setPool(connectionPool);
>
>
> that uses a  "fake"  GenericObjectPool.
> I don't think this is the right solution. What I am missing?

Sorry for the slow response.  The example at the URL above is for
the (still stabilizing) 2.0 version of DBCP.  The funny setup that
you have pointed out is being fixed in 2.0..  What you need to do in
1.x, is to follow the example here:
http://svn.apache.org/viewvc/commons/proper/dbcp/tags/DBCP_1_4/doc/ManualPoolingDataSourceExample.java?revision=910071&view=markup

To work around the circularity, the example creates a
GenericObjectPool with a null factory and then passes the pool to
the PoolableConnectionFactory constructor, which as a side effects
calls the pool's setFactory method to associated it with the pool.

Phil
>
> Thanks in advance.
> Andrea
>
>


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