GeoUser ha scritto: > Hey all! > > Ok, here's the deal: > > I downloaded geoserver 1.6.3 (same goes for 1.6.4) war and oracle plugin. > Then i created an oracle data store and then feature type. All went well and > i was able to make requests (getmap, getfeature...) > > But then i noticed (in database administration tool, network monitor) that > geoserver was making connections to the database very often (no SQLs, just > connect/disconnect (very simple packets) ). This happened every ~~20 seconds > even if GS was perfectly idle (no requests were being made). So i loaded > 1.6.3 source into eclipse and debugged a little. I discovered where all this > connection to the database come from: the GenericObjectPool from > commons-dbcp-1.2.2. > > The function org.geotools.data.jdbc.datasource.buildDefaultDataSource(...) > creates a datasource with hardcoded > dataSource.setMinEvictableIdleTimeMillis(1000 * 20); > > So my question is: why is this propery set to 20 seconds? It bothers me > since it creates sooo many connections to the database (at least they get > closed properly). What would happen if i would to set this val to lets say > -1? > > p.s. > > In GS 1.5.x this wasn't happening.
My understanding of that setting was that it would not kill connections from the pool when the number is equal to the minimum you set in the configuration page. The default is 4. Does the connection go lower than this in your case? Cheers Andrea ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Geoserver-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-devel
