Connection Pool cannot be shutdown.

[sheki]

trafficstars

I am using ApachePoolingDatabaseFactory as shown in the example, There is no way to shutdown the connection Pool.

The app just hangs.

Seing the code as well, there is no Method to shutdown the App.

[bigtoast]

I am running into a similar issue where I need to programmatically close some/all the database connections. I too am using the ApachePoolingDatabaseFactory and I have gone through the code and there seems to way to get to the underlying pool or connections and there are no close/stop/shutdown methods.

-Andy

P.S. I really like this library. Good job with it!

[sheki]

Yup the library is pretty awesome. Great work.

I have forked the project https://github.com/sheki/querulous and added support for c3p0 pool with a shutdown. I have removed the stuff I do not use, so there is just, the core. It builds with sbt.

You can implement shutdown for Apache DBPool similarly.

If we can come up with a proper contract for shutdown, we can put in a trait and implement for all Factory's.