Nasty Connection Pool Bug

hibernatebob · **Joined:** Wed Jan 12, 2011 12:02 pm **Posts:** 3

I think I've found a bug that is causing me problems in the handling of Proxool connection pools.

The close() method of ProxoolConnectionProvider closes _ALL_ pools handled by Proxool and not just the one being referred to by proxoolAlias.

It is an easy fix I think:

ProxoolFacade.shutdown(0);

Should be replaced with something like:

ProxoolFacade.removeConnectionPool(proxoolAlias);

Please advise.

hibernatebob · **Joined:** Wed Jan 12, 2011 12:02 pm **Posts:** 3

Actually it looks like filthy witchcraft happens to proxoolAlias so the actual fix seems to be:

ProxoolFacade.removeConnectionPool(proxoolAlias.substring(PROXOOL_JDBC_STEM.length()));

hibernatebob · **Joined:** Wed Jan 12, 2011 12:02 pm **Posts:** 3

Have raised as HHH-5838.

sanne.grinovero · **Posted:** Thu Jan 13, 2011 7:20 am

thank you!
impressive that such a bug wasn't noticed before.