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

Reply via email to