From: <leg...@at...> - 2005-01-17 20:26:09
|
The following comment has been added to this issue: Author: Christian Aust Created: Mon, 17 Jan 2005 2:24 PM Body: Gavin, no need for hard feelings. However, this request has been around for almost 18 months now, getting lots of votes (by far more than any other patch submission), comments and even unofficial patches to implement it. Maybe the issue could be considered a little more actively, since almost everyone dealing with this functionality has a solution of his own, more or less incompatible with the official API. Kind regards, Christian --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_15602 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-474 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-474 Summary: adding Criteria.count() method Type: Patch Status: Unassigned Priority: Major Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Versions: 2.1 2.1 rc1 Assignee: Reporter: Chris Nelson Created: Sun, 16 Nov 2003 12:53 PM Updated: Mon, 17 Jan 2005 2:24 PM Description: Adds a count() method to the Criteria class that does a modified query to return the count without returning entire query. --------------------------------------------------------------------- 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...> - 2005-01-17 20:28:04
|
The following comment has been added to this issue: Author: Chris Nelson Created: Mon, 17 Jan 2005 2:27 PM Body: Gavin, I am perfectly well aware that the enhancements to the Criteria API did not make the cut for 2.1 or even 3.0, so rather than "bitch" as you suggest, I created a solution that works quite well for our project. After seeing the flurry of activity on this issue in the past few days, I thought it would be the decent thing to do to offer it to other folks if they wanted it. I'm not sure why this warrants such hostility. Incidentally, the issues I ran into with Criteria were not limited to Projection and Aggregation. Were that so, I would have continued to use (and support) this patch. If anyone is interested in my alternative HQL based Criteria API, contact me via email at cnelson at yahooo dot komm. Thanks, Chris Nelson --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_15603 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-474 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-474 Summary: adding Criteria.count() method Type: Patch Status: Unassigned Priority: Major Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Versions: 2.1 2.1 rc1 Assignee: Reporter: Chris Nelson Created: Sun, 16 Nov 2003 12:53 PM Updated: Mon, 17 Jan 2005 2:27 PM Description: Adds a count() method to the Criteria class that does a modified query to return the count without returning entire query. --------------------------------------------------------------------- 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...> - 2005-01-18 10:22:10
|
The following comment has been added to this issue: Author: Paul Feaviour Created: Tue, 18 Jan 2005 4:21 AM Body: Hi Chris, I have tried to email on the address you specified by I get it bounced back from yahooo saying that you don't have an account? Paul --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_15628 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-474 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-474 Summary: adding Criteria.count() method Type: Patch Status: Unassigned Priority: Major Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Versions: 2.1 2.1 rc1 Assignee: Reporter: Chris Nelson Created: Sun, 16 Nov 2003 12:53 PM Updated: Tue, 18 Jan 2005 4:21 AM Description: Adds a count() method to the Criteria class that does a modified query to return the count without returning entire query. --------------------------------------------------------------------- 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...> - 2005-01-18 11:30:21
|
The following comment has been added to this issue: Author: Cameron Braid Created: Tue, 18 Jan 2005 5:29 AM Body: I have had the same issue with sending chris an email at that address. --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_15629 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-474 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-474 Summary: adding Criteria.count() method Type: Patch Status: Unassigned Priority: Major Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Versions: 2.1 2.1 rc1 Assignee: Reporter: Chris Nelson Created: Sun, 16 Nov 2003 12:53 PM Updated: Tue, 18 Jan 2005 5:29 AM Description: Adds a count() method to the Criteria class that does a modified query to return the count without returning entire query. --------------------------------------------------------------------- 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...> - 2005-01-18 15:09:07
|
The following comment has been added to this issue: Author: Chris Nelson Created: Tue, 18 Jan 2005 9:08 AM Body: DOH!! My correct email is cnelson4eii at yahooo dot kom. I am in the process of checking with the client, since there is at least some level of interest. I'll add a comment here if they are yeah or nay on releasing it. --Chris --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_15635 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-474 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-474 Summary: adding Criteria.count() method Type: Patch Status: Unassigned Priority: Major Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Versions: 2.1 2.1 rc1 Assignee: Reporter: Chris Nelson Created: Sun, 16 Nov 2003 12:53 PM Updated: Tue, 18 Jan 2005 9:08 AM Description: Adds a count() method to the Criteria class that does a modified query to return the count without returning entire query. --------------------------------------------------------------------- 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: <no...@at...> - 2005-01-27 05:51:47
|
The following comment has been added to this issue: Author: Cameron Braid Created: Wed, 26 Jan 2005 11:49 PM Body: fantastic.. well done ! and thanks :) --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_15799 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-474 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-474 Summary: adding Criteria.count() method Type: Patch Status: Closed Priority: Major Resolution: FIXED Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Fix Fors: 3.0 beta 3 Versions: 2.1 2.1 rc1 Assignee: Gavin King Reporter: Chris Nelson Created: Sun, 16 Nov 2003 12:53 PM Updated: Wed, 26 Jan 2005 11:49 PM Description: Adds a count() method to the Criteria class that does a modified query to return the count without returning entire query. --------------------------------------------------------------------- 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: <no...@at...> - 2005-04-25 04:25:56
|
The following comment has been added to this issue: Author: Kammau Created: Sun, 24 Apr 2005 11:23 PM Body: I cannot find Criteria.count() in Hibernate3. Could anyone tell me the reason. Is this method added into Hibernate3? Thanks --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_17355 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-474 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-474 Summary: adding Criteria.count() method Type: Patch Status: Closed Priority: Major Resolution: FIXED Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Fix Fors: 3.0 beta 3 Versions: 2.1 2.1 rc1 Assignee: Gavin King Reporter: Chris Nelson Created: Sun, 16 Nov 2003 12:53 PM Updated: Sun, 24 Apr 2005 11:23 PM Description: Adds a count() method to the Criteria class that does a modified query to return the count without returning entire query. --------------------------------------------------------------------- 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: <no...@at...> - 2005-04-25 08:15:49
|
The following comment has been added to this issue: Author: Christian Bauer Created: Mon, 25 Apr 2005 3:14 AM Body: Read the documentation! --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_17357 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-474 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-474 Summary: adding Criteria.count() method Type: Patch Status: Closed Priority: Major Resolution: FIXED Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Fix Fors: 3.0 beta 3 Versions: 2.1 2.1 rc1 Assignee: Gavin King Reporter: Chris Nelson Created: Sun, 16 Nov 2003 12:53 PM Updated: Mon, 25 Apr 2005 3:14 AM Description: Adds a count() method to the Criteria class that does a modified query to return the count without returning entire query. --------------------------------------------------------------------- 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: <no...@at...> - 2005-04-25 08:24:47
|
The following comment has been added to this issue: Author: Kammau Created: Mon, 25 Apr 2005 3:24 AM Body: Thanks for your reply. But I still cannot find this method in the API and src code. Could u please tell me which document I should read? Thanks! --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_17358 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-474 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-474 Summary: adding Criteria.count() method Type: Patch Status: Closed Priority: Major Resolution: FIXED Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Fix Fors: 3.0 beta 3 Versions: 2.1 2.1 rc1 Assignee: Gavin King Reporter: Chris Nelson Created: Sun, 16 Nov 2003 12:53 PM Updated: Mon, 25 Apr 2005 3:24 AM Description: Adds a count() method to the Criteria class that does a modified query to return the count without returning entire query. --------------------------------------------------------------------- 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: <no...@at...> - 2005-04-25 08:28:47
|
The following comment has been added to this issue: Author: Max Rydahl Andersen Created: Mon, 25 Apr 2005 3:28 AM Body: http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#querycriteria-projection --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_17359 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-474 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-474 Summary: adding Criteria.count() method Type: Patch Status: Closed Priority: Major Resolution: FIXED Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Fix Fors: 3.0 beta 3 Versions: 2.1 2.1 rc1 Assignee: Gavin King Reporter: Chris Nelson Created: Sun, 16 Nov 2003 12:53 PM Updated: Mon, 25 Apr 2005 3:28 AM Description: Adds a count() method to the Criteria class that does a modified query to return the count without returning entire query. --------------------------------------------------------------------- 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: <no...@at...> - 2005-04-25 13:37:13
|
The following comment has been added to this issue: Author: Zdenek Hrib Created: Mon, 25 Apr 2005 8:36 AM Body: Try the chapter "Projection" in the documentation ... --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_17361 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-474 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-474 Summary: adding Criteria.count() method Type: Patch Status: Closed Priority: Major Resolution: FIXED Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Fix Fors: 3.0 beta 3 Versions: 2.1 2.1 rc1 Assignee: Gavin King Reporter: Chris Nelson Created: Sun, 16 Nov 2003 12:53 PM Updated: Mon, 25 Apr 2005 8:36 AM Description: Adds a count() method to the Criteria class that does a modified query to return the count without returning entire query. --------------------------------------------------------------------- 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: <no...@at...> - 2005-04-25 15:19:51
|
The following comment has been added to this issue: Author: Kammau Created: Mon, 25 Apr 2005 10:18 AM Body: I really appreciate your reply. Do u mean that Criteria.count() cannot be used directly any more? I have used it for a long time. --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_17365 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-474 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-474 Summary: adding Criteria.count() method Type: Patch Status: Closed Priority: Major Resolution: FIXED Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Fix Fors: 3.0 beta 3 Versions: 2.1 2.1 rc1 Assignee: Gavin King Reporter: Chris Nelson Created: Sun, 16 Nov 2003 12:53 PM Updated: Mon, 25 Apr 2005 10:18 AM Description: Adds a count() method to the Criteria class that does a modified query to return the count without returning entire query. --------------------------------------------------------------------- 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: <no...@at...> - 2005-04-25 15:27:04
|
The following comment has been added to this issue: Author: Gavin King Created: Mon, 25 Apr 2005 10:25 AM Body: What do you mean "anymore". Criteria.count() *never* existed in the official build of Hibernate. I specifically never committed this patch because I knew we would have something different eventually. Just take a look at the above discussions! --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_17366 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-474 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-474 Summary: adding Criteria.count() method Type: Patch Status: Closed Priority: Major Resolution: FIXED Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Fix Fors: 3.0 beta 3 Versions: 2.1 2.1 rc1 Assignee: Gavin King Reporter: Chris Nelson Created: Sun, 16 Nov 2003 12:53 PM Updated: Mon, 25 Apr 2005 10:25 AM Description: Adds a count() method to the Criteria class that does a modified query to return the count without returning entire query. --------------------------------------------------------------------- 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: <no...@at...> - 2005-04-26 01:56:50
|
The following comment has been added to this issue: Author: Kammau Created: Mon, 25 Apr 2005 8:56 PM Body: sorry for my inappropriate wording. --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_17373 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-474 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-474 Summary: adding Criteria.count() method Type: Patch Status: Closed Priority: Major Resolution: FIXED Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Fix Fors: 3.0 beta 3 Versions: 2.1 2.1 rc1 Assignee: Gavin King Reporter: Chris Nelson Created: Sun, 16 Nov 2003 12:53 PM Updated: Mon, 25 Apr 2005 8:56 PM Description: Adds a count() method to the Criteria class that does a modified query to return the count without returning entire query. --------------------------------------------------------------------- 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: <no...@at...> - 2005-05-30 13:59:24
|
The following comment has been added to this issue: Author: Shoaib Akhtar Created: Mon, 30 May 2005 8:57 AM Body: So finally using Criteria api we can get the row count. But when will this feature will be available for HQL ?. I dont think that it will be too difficult for such talented people. Maybe u can return the query in form of string and people can append select count(*) in start (I know this is not good solution at all). But what is see is that it is very easy to add inside the HQL implementtaion where u can get the count as well. Thanks and regards Shoaib Akhtar --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_17982 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-474 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-474 Summary: adding Criteria.count() method Type: Patch Status: Closed Priority: Major Resolution: FIXED Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Fix Fors: 3.0 beta 3 Versions: 2.1 2.1 rc1 Assignee: Gavin King Reporter: Chris Nelson Created: Sun, 16 Nov 2003 12:53 PM Updated: Mon, 30 May 2005 8:57 AM Description: Adds a count() method to the Criteria class that does a modified query to return the count without returning entire query. --------------------------------------------------------------------- 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: <no...@at...> - 2005-05-31 07:34:27
|
The following comment has been added to this issue: Author: Shoaib Akhtar Created: Tue, 31 May 2005 2:33 AM Body: Hi, Great work hibernate Team to fix this issue in Hibernate3 Criteria API. But still this is not resolved in Query API (HQL). It is usually very cubersome while making queries dynamically also Hibernate does not return the query as stringf so ppl can append select count(*) in start toi get count easily and due to usage of named parameters (not qury as string) we have to made the query twic once for count and one for results so it would be great if you ppl can add it to HQL as well. Regards, Shoaib Akhtar --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_17998 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-474 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-474 Summary: adding Criteria.count() method Type: Patch Status: Closed Priority: Major Resolution: FIXED Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Fix Fors: 3.0 beta 3 Versions: 2.1 2.1 rc1 Assignee: Gavin King Reporter: Chris Nelson Created: Sun, 16 Nov 2003 12:53 PM Updated: Tue, 31 May 2005 2:33 AM Description: Adds a count() method to the Criteria class that does a modified query to return the count without returning entire query. --------------------------------------------------------------------- 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: <no...@at...> - 2005-05-31 07:38:20
|
The following comment has been added to this issue: Author: Shoaib Akhtar Created: Tue, 31 May 2005 2:36 AM Body: Hi, Please read my earlier post too. I want to say that it is wrong to say that this issue has been fixed, rather it is not duplicate to criteria.count() and Query.count() as it is only half of thta issue aka criteria.count(). The Query.count() is still missing so that issue should be opened once again. Regards, Shoaib Akhtar --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_17999 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-474 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-474 Summary: adding Criteria.count() method Type: Patch Status: Closed Priority: Major Resolution: FIXED Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Fix Fors: 3.0 beta 3 Versions: 2.1 2.1 rc1 Assignee: Gavin King Reporter: Chris Nelson Created: Sun, 16 Nov 2003 12:53 PM Updated: Tue, 31 May 2005 2:36 AM Description: Adds a count() method to the Criteria class that does a modified query to return the count without returning entire query. --------------------------------------------------------------------- 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: <no...@at...> - 2005-07-04 07:52:17
|
The following comment has been added to this issue: Author: chokchai chalermwattanatrai Created: Mon, 4 Jul 2005 2:51 AM Body: found the problem on oracle system SEVERE: java.sql.SQLException: ORA-01000: maximum open cursors exceeded it may be preparestatement don't close. can I call "session.getBatcher().closeQueryStatement(ps, rs);" to close it. public long count(SessionImplementor session) throws HibernateException, SQLException { List values = new ArrayList(); List types = new ArrayList(); ... ... ... // ResultSet rs = session.getBatcher().getResultSet(ps); // return (rs.next()) ? rs.getLong(1) : 0; ResultSet rs = session.getBatcher().getResultSet(ps); long count = (rs.next()) ? rs.getLong(1) : 0; session.getBatcher().closeQueryStatement(ps, rs); return count; } --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_18615 --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HB-474 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-474 Summary: adding Criteria.count() method Type: Patch Status: Closed Priority: Major Resolution: FIXED Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate2 Components: core Fix Fors: 3.0 beta 3 Versions: 2.1 2.1 rc1 Assignee: Gavin King Reporter: Chris Nelson Created: Sun, 16 Nov 2003 12:53 PM Updated: Mon, 4 Jul 2005 2:51 AM Description: Adds a count() method to the Criteria class that does a modified query to return the count without returning entire query. --------------------------------------------------------------------- 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 |