I faced this in my recent experiment with h2. And I foudn the interface was ConnectionPoolDataSource. Adapting what we have to that interace would not be too hard.
> > +1. The current state is that we've essentially rolled our own (less > feature complete) version of DBCP. I looked in to it a bit ago and it > shouldn't be that hard to stick different connection pool plug-ins > behind an interface, but I believe it'll require a slight change in what > we pass from the factory to the datastore - we pass in our > ConnectionPool object now, and it should be a more standard JDBC > interface that all connection pool plug-ins can generate (think maybe > DataSource?). > > C > >> >>> It sounds from your email that a shared connection pool in a J2EE >>> setting (ie shared with >>> other web applications) may result in a glut of cached prepared >>> statements? >> >> Yeah, it would. It's usually best to configure one connection pool >> for application. That's what I've seen in production environments >> around here, each app is given a small but private connection pool, >> usually around 10 connections. >> If you have a shared one, the most active app using prepared statement >> will rule the pool (ps wise). >> >> Cheers >> Andrea >> >> ------------------------------------------------------------------------- >> Take Surveys. Earn Cash. Influence the Future of IT >> Join SourceForge.net's Techsay panel and you'll get the chance to >> share your >> opinions on IT & business topics through brief surveys-and earn cash >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >> _______________________________________________ >> Geotools-devel mailing list >> Geotools-devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/geotools-devel >> >> >> > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > !DSPAM:1004,45ddd82720912081064789! > > > ------------------------------------------------------------------------ > > _______________________________________________ > Geotools-devel mailing list > Geotools-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geotools-devel > > > !DSPAM:1004,45ddd82720912081064789! -- Justin Deoliveira The Open Planning Project http://topp.openplans.org ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Geotools-devel mailing list Geotools-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
