Hi,

I am doing performance testing on an application which uses Hibernate and runs on MySQL and Tomcat. When I run about 100 concurrent users on the site for about 15 minutes, i start to see exceptions with the following error message:

DBCP object created 2005-06-30 11:23:45 by the following code was never closed:
. . . . (followed by a stack trace)

It seems that the database connection isn't closed properly, but I'm not sure how this could be since Hibernate should handle the connections. Has anyone else seen this exception or does anyone know why it could be happening?

Thanks

You need to show your transaction code as an example of what you are doing. In anycase, the docs (even the API docs for session) have examples of correct transaction code arrangement.

I'm not sure what you mean by transaction code but I am pasting in the code that is used in my DAO classes. Basically I am using something called a HibernateTemplate that is part of the spring framework. I think the Spring class HibernateDAOSupport, which is extended somewhere, creates the session . . . I don't know if anyone here is familiar with Spring but here is the code anyway, hope this helps:

public class PersonDAOHibernate extends BaseDAOHibernate implements PersonDAO {

public Person getPerson(Long id) {
Person person = (Person) getHibernateTemplate().get(Person.class, id);

if (person == null) {
throw new ObjectRetrievalFailureException(Person.class, id);
}

return person;
}

public void savePerson(Person person) {
getHibernateTemplate().saveOrUpdate(person);
}

public void removePerson(Long id) {
// object must be loaded before it can be deleted
getHibernateTemplate().delete(getPerson(id));
}
}

Use the Spring forum, we only discuss untainted Hibernate here.