Andrea Aime wrote:
Jody Garnett ha scritto:
Thanks Andrea! That was a great overview of the trade-offs.
I am looking at how we do connection pools in GeoTools - but more
towards JNDI lookup then
handling of prepared statements. Is there anything you would like me to
look out for when
I do this work?
Yeah. Not everybody is using JNDI, so please leave the door open for
manually configured pools where JNDI is not available.
I would really like to see some kind of pluggable API allowing the
usage of DBCP, C3PO and the like, JNDI being a player like the others.
And have a default pooling too, maybe based on DBCP.
+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
!DSPAM:1003,45ddd67118251971556521!
--
Chris Holmes
The Open Planning Project
http://topp.openplans.org
begin:vcard
fn:Chris Holmes
n:Holmes;Chris
org:The Open Planning Project
adr:;;349 W. 12th Street, #3;New York;NY;10014;USA
email;internet:[EMAIL PROTECTED]
title:Managing Director, Strategic Development
x-mozilla-html:FALSE
url:http://topp.openplans.org
version:2.1
end:vcard
-------------------------------------------------------------------------
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
