Note that there's been a bug fix for jndi connection pools to work with
Oracle. See: http://jira.codehaus.org/browse/GEOS-778
It has an attached zip that shows how they did it.
Jody Garnett wrote:
Thanks for the informative discussion .. as promised here is my tough plan:
- http://docs.codehaus.org/display/GEOTOOLS/J2EE+and+Connection+Pools
Currently I only have scope to fix this problem for EPSGDefaultFactory
... I have outlined
the plan for JDBCDataStore as well.
Cheers,
Jody
Jody Garnett wrote:
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?
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?
Jody
-------------------------------------------------------------------------
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,45ddf70c49141775926497!
--
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
