Re: lingering mysql connections

2018-12-27 Thread Chris Cheshire
This is a bit of a lead but it doesn't entirely solve it. It's only cleaning up connections to one of the datasources, I still have connections for 2 of them duplicated :( If I get a chance I'll go digging some more based on the SO rabbit hole, but I can mitigate the problem by restarting tomcat

Re: lingering mysql connections

2018-12-14 Thread Greg Huber
I resolved the same using this link https://stackoverflow.com/questions/11872316/tomcat-guice-jdbc-memory-leak I created the ContextFinalizer to cleanup on shut down. Also, I had loads of strange sql issues which were resolved by switching to maria db. Cheers Greg On Thu, 13 Dec 2018 at

Re: lingering mysql connections

2018-12-13 Thread HeeGu Lee
Hi, chris. You can use apache commons-dbcp2-2.5.0. This problem is fixed in this version. And ServletContextListener is not necessary! This is make you happy. :-) Have a nice day!!! 2018년 12월 14일 (금) 오전 5:51, Chris Cheshire 님이 작성: > Tomcat 9.0.12, Debian, MySQL Server 5.7.23, Connector/J