[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-4624) QueryImpl.list() closes connection

QueryImpl.list() closes connection ---------------------------------- Key: HHH-4624 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4624 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.3.2 Environment: linux, postgres 8.3 (same on oracle 11g, mssql 2005 and mysql) Reporter: Dieter Freismuth Priority: Critical Original Estimate: 5 minutes Remaining Estimate: 5 minutes if an outer query.iterate() calls within an iteration step a query.list() the connection is closed and the next outer iteration step causes: org.hibernate.exception.JDBCConnectionException: could not get next iterator result at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:97) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52) at org.hibernate.impl.IteratorImpl.next(IteratorImpl.java:156) the exception is only thrown if there is no transaction! (works fine if done within an transaction) call hierarchy: QueryImpl.list() -> SessionImpl.list(String query, QueryParameters queryParameters) -> afterOperation(success); // within finally block -> JDBCContext.afterNontransactionalQuery( success ) -> ConnectionManager.afterTransaction() -> ConnectionManager.aggressiveRelease() // within if ( isAfterTransactionRelease() ) { -> ConnectionManager.closeConnection()