Hi,
I've just finished committing the connection pooling
changes to geotools trunk.
This means you can update gt2 and geoserver trunk and
test the new connection pooling (put it under stress,
see how it performs, give it few connections, restart
the db on the back of Geoserver, and so on).
Oh, once you update, you'll notice you have new parameters
in the datastore factories, namely:
* max connection (default 10): no more than this number of
connections will be opened, no matter what. Extra requests
do wait.
* min connection (default 4): the number of idle connection
that can sit in the pool doing nothing. The others get
removed.
* validate connection: if true, a fast query will be issued
to the db before returning the connection to test the
connection is still alive. This allows you to disconnect
the network, restart the db, and still have Geoserver happy
and serving (well, the db must be reachable when you do
requests, the old connections will be thrown away and new
ones will be used instead).
Let me know how it goes.
Cheers
Andrea