[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2820) Can not set HOLD_CURSORS_OVER_COMMIT when creating ScrollableResults

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2820?page=c... ] jose commented on HHH-2820: --------------------------- Since Hibernate 3.x the default behaviour for property "hibernate.connection.release_mode" is: - JTATransactionFactory, this returns ConnectionReleaseMode.AFTER_STATEMENT; - JDBCTransactionFactory, this returns ConnectionReleaseMode.AFTER_TRANSACTION note: in my case, every commit release (close) the JDBC Connection => clossing openned ResultSet But you can set ON_CLOSE (default behaviour for hibernate 2.x): The Hibernate session obatins a connection when it first needs to perform some JDBC access and holds unto that connection until the session is closed. <property name="hibernate.connection.release_mode">on_close</property> works fine !! note: this "temporary" solution change holdability at Connection level (instead of *Statement level) see: http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#transactio... for more info -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira