[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-4557) Query stealing connection from another query

Query stealing connection from another query -------------------------------------------- Key: HHH-4557 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4557 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.2.6 Environment: 3.2.6.ga, Oracle 10, Windows XP sp3 Reporter: Beto Neto Attachments: hibernateBug.zip To reproduce the bug: Create a custom ConnectionProvider to close any connection at "closeConnection(Connection)" (extends from DriverManagerConnectionProvider), and plug it in hibernate using the system proerty "hibernate.connection.provider_class". Than execute this test: // set up the sessionFactory, and acquire a session.. Query qry = session.createQuery("select * from TABLE_WITH_2_RECORDS"); ScrollableResult sr = qry.scroll(); sr.next(); // now, before close the ScrollableResult, execute a uniqueResult... qry = session.createQuery("select FIELD_1 from TABLE_WITH_2_RECORDS order by FIELD_1"); qry.uniqueResult(); sr.next(); // at this time occour a SQLException "Connection Closed: next" The BUG occours when the uniqueResult() runs, because internaly it returns the connection to the Pool, and the current ConnectionProvider has the logic about CLOSE all connections returned.