1 Reply Latest reply on Jun 7, 2004 4:57 PM by adrian.brock

Database resource leak in Jive Forums

pants Jun 4, 2004 12:01 PM

I've been profiling the Jive forum software (running under JBoss 3.2.1) and have noticed that it isn't explicitly closing resultsets. It expects that closing the statement that the resultset was created from will close the resultset as well.

While this is a Jive problem, I was wondering if JBoss will tolerate this behaviour or will it result in leaked database resources.

Tomcat, for instance, won't tolerate this behaviour and will leak connections.

1. Re: Database resource leak in Jive Forums

adrian.brock Jun 7, 2004 4:57 PM (in response to pants)

As long as it is closing the Statement and you don't use a prepared statement cache
there will be no problem. Closing the Statement, closes the ResultSet.
I thought Jive had its own connection pool? When we used Jive we had a number
of problems with the it.
Actions