[hibernate-issues] [Hibernate-JIRA] Reopened: (HHH-7022) AbstractMultiTenantConnectionProvider never closes connections causing resource exhaustion

AbstractMultiTenantConnectionProvider never closes connections causing resource exhaustion ------------------------------------------------------------------------------------------ Key: HHH-7022 URL: https://hibernate.onjira.com/browse/HHH-7022 Project: Hibernate ORM Issue Type: Bug Components: core Affects Versions: 4.0.1 Environment: Hibernate 4.0.1.Final, any database, but tested locally with MySQL 5.1.58 Reporter: Tomas Salfischberger Priority: Critical Labels: multi-tenancy Fix For: 4.1.0 In org.hibernate.service.jdbc.connections.spi.AbstractMultiTenantConnectionProvider the call to releaseConnection(String tenantIdentifier, Connection connection) does not actually close the connection. The method was probably copied from getConnection(String tenantIdentifier) resulting in this code: {code}@Override public void releaseConnection(String tenantIdentifier, Connection connection) throws SQLException { selectConnectionProvider( tenantIdentifier ).getConnection(); }{code} Which opens a new connection anytime a connection is supposed to be closed and thus quickly exhausts all available connections.