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. -- View this message in context: http://www.nabble.com/geoserver-1.6.4-and-connection-pool-tp18773300p18773300.html Sent from the GeoServer - Dev mailing list archive at Nabble.com. ------------------------------------------------------------------------- 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
