You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by David Van Couvering <da...@vancouvering.com> on 2007/07/21 00:25:14 UTC

ConnectionPoolDataSource - does it actually do pooling?

I could check this out myself, but time is limited, and I thought
someone might have a quick answer.

On the Phobos (JavaScript in Glassfish) email list, the following
statement is made:

"in Apache Derby there is a regular data source class
(org.apache.derby.jdbc.ClientDataSource) which does not pool
connections, but there's also a data source class with connection
pooling (org.apache.derby.jdbc.ClientConnectionPoolDataSource). In the
preconfigured Phobos data sources we use the latter, so connection
pooling is on by default"

I thought ConnectionPoolDataSource *enabled* pooling but did not
actually *do* it.  Does it actually do connection pooling?

Thanks,

David

Re: ConnectionPoolDataSource - does it actually do pooling?

Posted by David Van Couvering <da...@vancouvering.com>.

Thanks, Kristian.

I checked the DBCP site.  It does appear to be a fully functioning
connection pool that can work with a container or outside of a
container.

David

On 7/24/07, Kristian Waagan <Kr...@sun.com> wrote:
> David Van Couvering wrote:
> > I could check this out myself, but time is limited, and I thought
> > someone might have a quick answer.
> >
> > On the Phobos (JavaScript in Glassfish) email list, the following
> > statement is made:
> >
> > "in Apache Derby there is a regular data source class
> > (org.apache.derby.jdbc.ClientDataSource) which does not pool
> > connections, but there's also a data source class with connection
> > pooling (org.apache.derby.jdbc.ClientConnectionPoolDataSource). In the
> > preconfigured Phobos data sources we use the latter, so connection
> > pooling is on by default"
> >
> > I thought ConnectionPoolDataSource *enabled* pooling but did not
> > actually *do* it.  Does it actually do connection pooling?
>
> No.
>
> I haven't checked this lately, but I can't remember any activity in this
> area. You will need a connection pool from elsewhere. I am not familiar
> with connection pool products, but I know Apache has an initiative;
> Commons DBCP. I do not know if this is ready-to-go, or just a framework
> to write your own. Does anyone have more information on this?
>
>
> regards,
> --
> Kristian
>
> >
> > Thanks,
> >
> > David
>
>

Re: ConnectionPoolDataSource - does it actually do pooling?

Posted by Kristian Waagan <Kr...@Sun.COM>.

David Van Couvering wrote:
> I could check this out myself, but time is limited, and I thought
> someone might have a quick answer.
> 
> On the Phobos (JavaScript in Glassfish) email list, the following
> statement is made:
> 
> "in Apache Derby there is a regular data source class
> (org.apache.derby.jdbc.ClientDataSource) which does not pool
> connections, but there's also a data source class with connection
> pooling (org.apache.derby.jdbc.ClientConnectionPoolDataSource). In the
> preconfigured Phobos data sources we use the latter, so connection
> pooling is on by default"
> 
> I thought ConnectionPoolDataSource *enabled* pooling but did not
> actually *do* it.  Does it actually do connection pooling?

No.

I haven't checked this lately, but I can't remember any activity in this 
area. You will need a connection pool from elsewhere. I am not familiar 
with connection pool products, but I know Apache has an initiative; 
Commons DBCP. I do not know if this is ready-to-go, or just a framework 
to write your own. Does anyone have more information on this?

regards,
-- 
Kristian

> 
> Thanks,
> 
> David