[DBCP] Using Other ConnectionPoolDataSource implementations

[Todd Carmichael <to...@concur.com>]

Has anyone seen better performance/scalability in using a driver's
implementation of the ConnectionPoolDataSource rather than the
org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS?  Any gotchas with
regards to configuration of the pool?

Thanks.

ToddC


-----Original Message-----
From: Martin van den Bemt [mailto:mllist@mvdb.net] 
Sent: Monday, January 26, 2004 1:54 PM
To: Jakarta Commons Users List
Subject: Re: [DBCP] Hanging


Most attachments get stripped from the message. I think only txt is allowed
or something...

Mvgr,
Martin

On Mon, 2004-01-26 at 21:32, Mike Zatko wrote:
> John Zoetebier wrote:
> 
> > On Mon, 26 Jan 2004 09:21:39 -0500, Mike Zatko <mz...@boscovs.com>
> > wrote:
> >
> >> Dirk Verbeeck wrote:
> >>
> >>> Some questions:
> >>> What is the DBCP configuration you use? DriverManager? Are there 
> >>> network connection between you application and the database when 
> >>> the getConnection hangs? How much idle time?
> >>>
> >>> -- Dirk
> >>>
> >>> Mike Zatko wrote:
> >>>
> >>>> Hello,
> >>>>    I am using DBCP to connect to a MySQL 4.0.14-max-nt database.
> >>>> The program is a web application. It works fine until the app sits 
> >>>> idle for a period of time. When that happens, my call to the 
> >>>> DriverManager for a getConnection just hangs indefinately. No error 
> >>>> or anything. Does anyone have an idea of how to prevent this?
> >>>
> >
> > Must be a problem at your side.
> > My messages come throgh each and every time.
> > Check your PC, TCP/IP setting, firewall, proxy server and ISP. Use 
> > an other PC on the same network or an other PC outside your network.
> >
> I'm in contact with Henri Yandell about it. It appears to be a problem
> posting XML such as a JOCL script like this:
> 
> http://www.apache.org/~bayard/mike.xml
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-user-help@jakarta.apache.org
-- 
Mvgr,
Martin


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

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

Re: [DBCP] Using Other ConnectionPoolDataSource implementations

[Dirk Verbeeck <di...@pandora.be>]

Don't use it myself but I know of a problem with the MySQL implementation.
See:
http://issues.apache.org/eyebrowse/ReadMsg?listName=commons-user@jakarta.apache.org&msgNo=3792

-- Dirk

Todd Carmichael wrote:

> Has anyone seen better performance/scalability in using a driver's
> implementation of the ConnectionPoolDataSource rather than the
> org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS?  Any gotchas with
> regards to configuration of the pool?
> 
> Thanks.
> 
> ToddC




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