From: <leg...@at...> - 2003-12-05 03:34:11
|
The following comment has been added to this issue: Author: Gavin King Created: Thu, 4 Dec 2003 8:04 PM Body: A question: what do you use ScrollableResults for? I always think that its a bit bloaty... --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-521 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-521 Summary: ScrollableResults from Criteria class Type: New Feature Status: Unassigned Priority: Minor Project: Hibernate2 Components: core Assignee: Reporter: Don DeLuca Created: Thu, 4 Dec 2003 10:00 AM Updated: Thu, 4 Dec 2003 8:04 PM Environment: JDBC 2.0 compliant database that supports result set scrolling. Description: I've been using the Criteria API provided by Hibernate. Its really excellent. Would it be possible to provide scrolling functionality in the Criteria API similar to that in the Query API which has a scroll() method that returns a ScrollableResults object. --------------------------------------------------------------------- JIRA INFORMATION: 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.jspa If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
From: <leg...@at...> - 2003-12-05 13:26:41
|
The following comment has been added to this issue: Author: Don DeLuca Created: Fri, 5 Dec 2003 7:26 AM Body: I'm using ScrollableResults as a way to iterate through a large result set. I have some business logic that will iterate through this and process each row. I don't want to take the hit of buffering all the rows into a List. For my use case I don't need all the "scrolling" functionality but I want to leverage how its a facade over the underlying JDBC ResultSet. If I understand the Criteria.list() and Query.list() methods correctly these fetch all the rows and returns a fully populated List. I don't want to take the resource hit if I can avoid it. --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-521 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-521 Summary: ScrollableResults from Criteria class Type: New Feature Status: Unassigned Priority: Minor Project: Hibernate2 Components: core Assignee: Reporter: Don DeLuca Created: Thu, 4 Dec 2003 10:00 AM Updated: Fri, 5 Dec 2003 7:26 AM Environment: JDBC 2.0 compliant database that supports result set scrolling. Description: I've been using the Criteria API provided by Hibernate. Its really excellent. Would it be possible to provide scrolling functionality in the Criteria API similar to that in the Query API which has a scroll() method that returns a ScrollableResults object. --------------------------------------------------------------------- JIRA INFORMATION: 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.jspa If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
From: <leg...@at...> - 2003-12-06 02:13:41
|
The following comment has been added to this issue: Author: Gavin King Created: Fri, 5 Dec 2003 8:13 PM Body: I'm not really sure that this is such a great approach. Use query pagination setMaxResults()/setFirstResult() instead... --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-521 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-521 Summary: ScrollableResults from Criteria class Type: New Feature Status: Unassigned Priority: Minor Project: Hibernate2 Components: core Assignee: Reporter: Don DeLuca Created: Thu, 4 Dec 2003 10:00 AM Updated: Fri, 5 Dec 2003 8:13 PM Environment: JDBC 2.0 compliant database that supports result set scrolling. Description: I've been using the Criteria API provided by Hibernate. Its really excellent. Would it be possible to provide scrolling functionality in the Criteria API similar to that in the Query API which has a scroll() method that returns a ScrollableResults object. --------------------------------------------------------------------- JIRA INFORMATION: 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.jspa If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
From: <leg...@at...> - 2003-12-06 02:15:41
|
The following comment has been added to this issue: Author: Gavin King Created: Fri, 5 Dec 2003 8:14 PM Body: Although I suppose the query pagination does have the risk of "missing" rows. --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-521 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-521 Summary: ScrollableResults from Criteria class Type: New Feature Status: Unassigned Priority: Minor Project: Hibernate2 Components: core Assignee: Reporter: Don DeLuca Created: Thu, 4 Dec 2003 10:00 AM Updated: Fri, 5 Dec 2003 8:14 PM Environment: JDBC 2.0 compliant database that supports result set scrolling. Description: I've been using the Criteria API provided by Hibernate. Its really excellent. Would it be possible to provide scrolling functionality in the Criteria API similar to that in the Query API which has a scroll() method that returns a ScrollableResults object. --------------------------------------------------------------------- JIRA INFORMATION: 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.jspa If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
From: <leg...@at...> - 2004-08-09 07:42:19
|
The following comment has been added to this issue: Author: CVS Notification Service Created: Mon, 9 Aug 2004 3:07 AM Body: CVS COMMIT LOG: SUBJECT: [Hibernate-commits] Hibernate3/src/org/hibernate/hql QueryTranslatorImpl.java,1.14,1.15 support scroll() for native SQL queries and Criteria queries HB-521 --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-521?page=comments#action_14027 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-521 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-521 Summary: ScrollableResults from Criteria class Type: New Feature Status: Closed Priority: Minor Resolution: FIXED Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Fix Fors: 3.0 alpha Assignee: Reporter: Don DeLuca Created: Thu, 4 Dec 2003 10:00 AM Updated: Mon, 9 Aug 2004 3:07 AM Environment: JDBC 2.0 compliant database that supports result set scrolling. Description: I've been using the Criteria API provided by Hibernate. Its really excellent. Would it be possible to provide scrolling functionality in the Criteria API similar to that in the Query API which has a scroll() method that returns a ScrollableResults object. --------------------------------------------------------------------- JIRA INFORMATION: 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.jspa If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
From: <leg...@at...> - 2004-08-09 07:42:20
|
The following comment has been added to this issue: Author: CVS Notification Service Created: Mon, 9 Aug 2004 3:07 AM Body: CVS COMMIT LOG: SUBJECT: [Hibernate-commits] Hibernate3/src/org/hibernate/hql/ast QueryLoader.java,1.9,1.10 support scroll() for native SQL queries and Criteria queries HB-521 --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-521?page=comments#action_14028 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-521 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-521 Summary: ScrollableResults from Criteria class Type: New Feature Status: Closed Priority: Minor Resolution: FIXED Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Fix Fors: 3.0 alpha Assignee: Reporter: Don DeLuca Created: Thu, 4 Dec 2003 10:00 AM Updated: Mon, 9 Aug 2004 3:07 AM Environment: JDBC 2.0 compliant database that supports result set scrolling. Description: I've been using the Criteria API provided by Hibernate. Its really excellent. Would it be possible to provide scrolling functionality in the Criteria API similar to that in the Query API which has a scroll() method that returns a ScrollableResults object. --------------------------------------------------------------------- JIRA INFORMATION: 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.jspa If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
From: <leg...@at...> - 2004-08-09 07:42:20
|
The following comment has been added to this issue: Author: CVS Notification Service Created: Mon, 9 Aug 2004 3:07 AM Body: CVS COMMIT LOG: SUBJECT: [Hibernate-commits] Hibernate3/src/org/hibernate Criteria.java,1.3,1.4 support scroll() for native SQL queries and Criteria queries HB-521 --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-521?page=comments#action_14026 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-521 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-521 Summary: ScrollableResults from Criteria class Type: New Feature Status: Closed Priority: Minor Resolution: FIXED Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Fix Fors: 3.0 alpha Assignee: Reporter: Don DeLuca Created: Thu, 4 Dec 2003 10:00 AM Updated: Mon, 9 Aug 2004 3:07 AM Environment: JDBC 2.0 compliant database that supports result set scrolling. Description: I've been using the Criteria API provided by Hibernate. Its really excellent. Would it be possible to provide scrolling functionality in the Criteria API similar to that in the Query API which has a scroll() method that returns a ScrollableResults object. --------------------------------------------------------------------- JIRA INFORMATION: 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.jspa If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
From: <leg...@at...> - 2004-08-09 07:42:36
|
The following comment has been added to this issue: Author: CVS Notification Service Created: Mon, 9 Aug 2004 3:07 AM Body: CVS COMMIT LOG: SUBJECT: [Hibernate-commits] Hibernate3/src/org/hibernate/engine SessionImplementor.java,1.12,1.13 support scroll() for native SQL queries and Criteria queries HB-521 --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-521?page=comments#action_14029 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-521 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-521 Summary: ScrollableResults from Criteria class Type: New Feature Status: Closed Priority: Minor Resolution: FIXED Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Fix Fors: 3.0 alpha Assignee: Reporter: Don DeLuca Created: Thu, 4 Dec 2003 10:00 AM Updated: Mon, 9 Aug 2004 3:07 AM Environment: JDBC 2.0 compliant database that supports result set scrolling. Description: I've been using the Criteria API provided by Hibernate. Its really excellent. Would it be possible to provide scrolling functionality in the Criteria API similar to that in the Query API which has a scroll() method that returns a ScrollableResults object. --------------------------------------------------------------------- JIRA INFORMATION: 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.jspa If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
From: <leg...@at...> - 2004-08-09 07:42:36
|
The following comment has been added to this issue: Author: CVS Notification Service Created: Mon, 9 Aug 2004 3:07 AM Body: CVS COMMIT LOG: SUBJECT: [Hibernate-commits] Hibernate3/src/org/hibernate/impl CriteriaImpl.java,1.4,1.5 SQLQueryImpl.java,1.1,1.2 ScrollableResultsImpl.java,1.6,1.7 SessionImpl.java,1.25,1.26 support scroll() for native SQL queries and Criteria queries HB-521 --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-521?page=comments#action_14031 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-521 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-521 Summary: ScrollableResults from Criteria class Type: New Feature Status: Closed Priority: Minor Resolution: FIXED Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Fix Fors: 3.0 alpha Assignee: Reporter: Don DeLuca Created: Thu, 4 Dec 2003 10:00 AM Updated: Mon, 9 Aug 2004 3:07 AM Environment: JDBC 2.0 compliant database that supports result set scrolling. Description: I've been using the Criteria API provided by Hibernate. Its really excellent. Would it be possible to provide scrolling functionality in the Criteria API similar to that in the Query API which has a scroll() method that returns a ScrollableResults object. --------------------------------------------------------------------- JIRA INFORMATION: 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.jspa If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
From: <leg...@at...> - 2004-08-09 07:42:36
|
The following comment has been added to this issue: Author: CVS Notification Service Created: Mon, 9 Aug 2004 3:07 AM Body: CVS COMMIT LOG: SUBJECT: [Hibernate-commits] Hibernate3/src/org/hibernate/loader CriteriaLoader.java,1.9,1.10 Loader.java,1.21,1.22 SQLLoader.java,1.6,1.7 support scroll() for native SQL queries and Criteria queries HB-521 --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-521?page=comments#action_14030 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-521 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-521 Summary: ScrollableResults from Criteria class Type: New Feature Status: Closed Priority: Minor Resolution: FIXED Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Fix Fors: 3.0 alpha Assignee: Reporter: Don DeLuca Created: Thu, 4 Dec 2003 10:00 AM Updated: Mon, 9 Aug 2004 3:07 AM Environment: JDBC 2.0 compliant database that supports result set scrolling. Description: I've been using the Criteria API provided by Hibernate. Its really excellent. Would it be possible to provide scrolling functionality in the Criteria API similar to that in the Query API which has a scroll() method that returns a ScrollableResults object. --------------------------------------------------------------------- JIRA INFORMATION: 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.jspa If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |