[FTPSERVER-453] pooled db connections not being closed

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.0.6, 1.1.0
• Component/s: Core
• Environment: ftpserver running in Tomcat on Windows and Linux using a JNDI datasource
• Assignee: Unassigned
• Reporter: Ken Kress
• Created: 04/Feb/14 21:19
• Updated: 31/Mar/14 14:22

Description

I set maxActive to 10 and started getting errors while testing. The log showed that I was running out of connections, which lead me to believe the connections were not being closed. I could not find a problem in the source code, but as I played around with it I inadvertently created a new problem ... I double closed a connection in DbUserManager.selectUserByName and got errors from DbUserManager.authenticate. Researching this new problem, I found a solution to both: http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html#Random_Connection_Closed_Exceptions.
I'm not sure why this applies, but I no longer have abandoned connections being reclaimed.