[hibernate-issues] [Hibernate-JIRA] Created: (HHH-2786) SQL Server dialect fails to set com.microsoft.sqlserver.jdbc.SQLServerResultSet.TYPE_SS_SERVER_CURSOR_FORWARD_ONLY when needed

SQL Server dialect fails to set com.microsoft.sqlserver.jdbc.SQLServerResultSet.TYPE_SS_SERVER_CURSOR_FORWARD_ONLY when needed ------------------------------------------------------------------------------------------------------------------------------ Key: HHH-2786 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2786 Project: Hibernate3 Issue Type: Bug Components: query-sql Affects Versions: 3.2.0.ga Environment: Windows. Microsoft SQL Server JDBC driver version 1.1. Reporter: Benson Margulies If I leave the selectMethod=cursor out of my JDBC URL, and use a FORWARD_ONLY to the scroll() method, I still run out of memory trying to retrieve the entire contents of the database from the server. As I read the MS dfoc, the com.microsoft.sqlserver.jdbc.SQLServerResultSet.TYPE_SS_SERVER_CURSOR_FORWARD_ONLY option should get used by the dialect to have the desired effect without the connection option. -- 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