Hello, thanks for the tip. I was surfing around the API and didn't even see BasicDataSource. I guess because it's in a different package -- org.apache.commons.dbcp , whereas SharedDataSource is in org.apache.commons.dbcp.datasources.
Anyway, looking at the BasicDataSource I see that all methods having to do with abandoned connections are deprecated! So is there a way to use DBCP/Pool and have it manage your connections (log available and abandonded connections, do garbage collection, etc.) I would prefer not to have to put my own System.out.println() or log.print() statements, especially since the methods I would be calling (eg. getAbandonedConnections() ) are deprecated! Many thanks, syg --- Dirk Verbeeck <[EMAIL PROTECTED]> wrote: > Hi Robert, > > The configuration web page was written for the > BasicDataSource > connection pool implementation. The other pools do > not support all > params listed. > In this case you are correct that > SharedDataSourceFactory doesn't > support the "abandoned" parameters (only > BasicDataSource does). > > Regards > Dirk > > > Robert Bowen wrote: > > Hello everyone. > > > > I am using DBCP (with Torque) for my J2EE app. I > > believe I have a connection leak somewhere and I > am > > trying to find out where. When I try to initialize > the > > pool with parameters for dealing with and > debugging > > abandoned connections, I am getting errors with > the > > following params: > > > > Property: removeAbandoned, Value: true > > Property: logAbandoned, Value: true > > Property: removeAbandonedTimeout, Value: 300 > > > > The error is always the same: "<param> value: > <value> > > is not supported by DataSource: > > > org.apache.commons.dbcp.datasources.SharedPoolDataSource > > > > All three of these parameters appear on the DBCP > > Configuration page > > > (http://jakarta.apache.org/commons/dbcp/configuration.html). > > > > > > I believe I have all the correct versions of all > jars: > > > > commons-beanutils-1.7.0 > > commons-dbcp-1.2.1 > > commons-pool-1.2 > > commons-collections-3.0 > > commons-configuration-1.1 > > > > ... but it doesn't want to work. The method that > craps > > out is in AbstractDataSourceFactory, > setProperty(). > > Line 147: > > > > Class propertyType = > PropertyUtils.getPropertyType(ds, > > property); > > > > propertyType is always null. > > > > Can anyone give me a hand with this? It seems that > the > > SharedDataSourceFactory doesn't allow these > params, > > but according to the documentation it does. Any > ideas? > > > > Many thanks, > > syg > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > > ____________________________________________________ Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
