From: <leg...@at...> - 2003-12-05 16:23:41
|
The following comment has been added to this issue: Author: Sebastien Cesbron Created: Fri, 5 Dec 2003 10:23 AM Body: I had to change 'getPersister' with 'getClassPersister' on line 3430 in the 'count' method of the 'SessionImpl' class. Otherwise it seems to do the job for me. --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-474 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-474 Summary: adding Criteria.count() method Type: Patch Status: Unassigned Priority: Major Project: Hibernate2 Versions: 2.1 2.1 rc1 Assignee: Reporter: Chris Nelson Created: Sun, 16 Nov 2003 12:53 PM Updated: Fri, 5 Dec 2003 10:23 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...> - 2004-01-09 08:18:25
|
The following comment has been added to this issue: Author: Sebastien Cesbron Created: Fri, 9 Jan 2004 2:17 AM Body: As it was mentionned on the issue 143, the count method should also be added to the query interface --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-474 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-474 Summary: adding Criteria.count() method Type: Patch Status: Unassigned Priority: Major Project: Hibernate2 Versions: 2.1 2.1 rc1 Assignee: Reporter: Chris Nelson Created: Sun, 16 Nov 2003 12:53 PM Updated: Fri, 9 Jan 2004 2:17 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...> - 2004-01-27 10:19:33
|
The following comment has been added to this issue: Author: Chris Nelson Created: Sun, 25 Jan 2004 4:43 PM Body: Note, the second, slightly larger version of patch.txt is against the 2.1.1 source code. There did not appear to be a way to give it a different name in JIRA (that I could figure out). Maybe one of the JIRA admins would be kind enough to remove the old patch.txt --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=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: Sun, 25 Jan 2004 4:43 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...> - 2004-04-25 19:23:51
|
The following comment has been added to this issue: Author: Michael Wyraz Created: Sun, 25 Apr 2004 2:31 PM Body: Is there a patch against 2.1.2? Or better a precompiled hibernate-2.1.2.jar? I hope the patch will be accepted in the next release. I couldn't believe they forgott the count() function until i found this bug report ;) --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_12984 --------------------------------------------------------------------- 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: Sun, 25 Apr 2004 2:31 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...> - 2004-04-26 05:15:45
|
The following comment has been added to this issue: Author: Emmanuel Bernard Created: Mon, 26 Apr 2004 12:22 AM Body: Don't expect that in 2.1.x. See the devel list archive for more information on what we think of that. --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_12988 --------------------------------------------------------------------- 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, 26 Apr 2004 12:22 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...> - 2004-04-29 20:54:08
|
The following comment has been added to this issue: Author: Brad Koehn Created: Thu, 29 Apr 2004 4:01 PM Body: What about this: Build an aggregate class instead, that takes a criteria as a parameter. Similar to the Expression class, it would have static methods to build the aggregate functions: Criteria q; int count = Aggregate.count(q).execute(); String property; double sum = Aggregate.sum(q, property).execute(); In this way it's possible to use the Aggregates inside of criteria as well, to find the cats with more than 3 kittens, etc, by embedding these into an Expression object using eq, gt, ... (without calling execute, of course). That seems much more in tune with the existing Criteria API, and should solve a ton of problems. --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_13028 --------------------------------------------------------------------- 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: Thu, 29 Apr 2004 4:01 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...> - 2004-05-29 16:43:51
|
The following comment has been added to this issue: Author: Carlos Sanchez Created: Sat, 29 May 2004 11:56 AM Body: I've read all posts about counting Criteria results and all the problems related. I don't mind if this is the patch applied or any other, all I know is that I *really* need this functionality. Thanks --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_13300 --------------------------------------------------------------------- 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: Sat, 29 May 2004 11:56 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...> - 2004-07-27 19:18:31
|
The following comment has been added to this issue: Author: William F. DeMoss II Created: Tue, 27 Jul 2004 2:41 PM Body: Comment by Ryoko Mitake [02/Jun/04 02:43 PM] Adds a count() method to the Criteria class. Did you apply the same patch at 211, if not, could you please post the patch? --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_13846 --------------------------------------------------------------------- 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, 27 Jul 2004 2:41 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...> - 2004-08-06 15:46:47
|
The following comment has been added to this issue: Author: Matthew Payne Created: Fri, 6 Aug 2004 11:11 AM Body: Whats the status of this? Will there be a patched 2.1.5? Will this ever be an offical feature? --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_13973 --------------------------------------------------------------------- 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: Fri, 6 Aug 2004 11:11 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...> - 2004-08-06 15:52:47
|
The following comment has been added to this issue: Author: Christian Bauer Created: Fri, 6 Aug 2004 11:17 AM Body: I doubt we will get a Criteria projection API in Hibernate 2.1. --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_13974 --------------------------------------------------------------------- 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: Fri, 6 Aug 2004 11:17 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...> - 2004-09-15 02:36:08
|
The following comment has been added to this issue: Author: Christian Aust Created: Tue, 14 Sep 2004 11:58 AM Body: I'd really love to see that feature, too. Getting record count of huge queries (>100k objects) isn't properly done otherwise. --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_14415 --------------------------------------------------------------------- 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, 14 Sep 2004 11:58 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...> - 2004-10-18 11:20:06
|
The following comment has been added to this issue: Author: eric bellard Created: Mon, 18 Oct 2004 6:54 AM Body: Hi, I'm very interesting with this issue. I plan to use Query by example as default query model for my application. The query result is displayed in an html table. (10,15, 30 or 50 rows at the same time) I'd like to count all the result of the query to display at the top down of the table like "page x on y". I need a solution for this. The count on the criteria api is the one I'd like. Cordially, Eric --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_14626 --------------------------------------------------------------------- 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, 18 Oct 2004 6:54 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...> - 2004-12-16 12:00:35
|
The following comment has been added to this issue: Author: Zdenek Hrib Created: Thu, 16 Dec 2004 5:59 AM Body: this is a Great(tm) thing. I think that anyone who wants to make a pageable list in web app must download this patch sooner or later. I am quite surprised that it is not included in standard distribution o Hibernate2. Anyway I was also thinking about a method to do something like bulk updates through the criteria interface. For example if I could do Critera.setProperty("propertyName", "myValue") and this would update specified property to the specified value on all objects that are covered by the critera it would be also very helpful. --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_15198 --------------------------------------------------------------------- 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: Thu, 16 Dec 2004 5:59 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...> - 2004-12-30 11:07:47
|
The following comment has been added to this issue: Author: Lu=C3=ADs Miranda Created: Thu, 30 Dec 2004 5:07 AM Body: I am using this patch and it works well. However, since subselects are not = supported by Criteria, I find that the count() method is not as useful as i= t could be because the result of running the query can contain duplicates. How much effort would it be to implement a count("myProperty") method that = would perform a select count(distinct 'myProperty') statement? Or is there = a different way to achieve the same effect? --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=3Dc= omments#action_15419 --------------------------------------------------------------------- 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:=20 core Versions: 2.1 2.1 rc1 Assignee:=20 Reporter: Chris Nelson Created: Sun, 16 Nov 2003 12:53 PM Updated: Thu, 30 Dec 2004 5:07 AM Description: Adds a count() method to the Criteria class that does a modified query to r= eturn 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-11 13:05:15
|
The following comment has been added to this issue: Author: Kai Pr=C3=BCnte Created: Tue, 11 Jan 2005 7:04 AM Body: Thank you very much for the patch, it works fine and is very useful! However I have got a problem with it. If Class A is an implementation of the interface MyInterface: session.createCriteria(MyInterface.class).list() works fine session.createCriteria(MyInterface.class).count() fails with : net.sf.hibernate.MappingException: Unknown entity class: MyInterface.cl= ass session.createCriteria(A.class).count() works fine again Is there something missing in the patch? Another point, makes it sense that count() returns long, but setFirstResult= (int)? Again, thank you for count(). --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=3Dc= omments#action_15533 --------------------------------------------------------------------- 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:=20 core Versions: 2.1 2.1 rc1 Assignee:=20 Reporter: Chris Nelson Created: Sun, 16 Nov 2003 12:53 PM Updated: Tue, 11 Jan 2005 7:04 AM Description: Adds a count() method to the Criteria class that does a modified query to r= eturn 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-11 15:35:15
|
The following comment has been added to this issue: Author: Eitan Suez Created: Tue, 11 Jan 2005 9:33 AM Body: kai wrote: > If Class A is an implementation of the interface MyInterface: > session.createCriteria(MyInterface.class).list() works fine > session.createCriteria(MyInterface.class).count() fails with : > net.sf.hibernate.MappingException: Unknown entity class: MyInterface.class > session.createCriteria(A.class).count() works fine again > > Is there something missing in the patch? i don't think this has anything to do with this patch. for example: take the criteria api out of the equation and fall back to hql instead: can you perform hql queries based on interfaces?? i don't think so. e.g.: from <interfacename> will surely throw an "Unknown Entity Class" exception. / eitan --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_15534 --------------------------------------------------------------------- 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, 11 Jan 2005 9: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: <leg...@at...> - 2005-01-11 16:15:12
|
The following comment has been added to this issue: Author: Christian Bauer Created: Tue, 11 Jan 2005 10:13 AM Body: No, it will work just fine if you say, "from Serializable". --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_15535 --------------------------------------------------------------------- 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, 11 Jan 2005 10:13 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-11 18:53:16
|
The following comment has been added to this issue: Author: Eitan Suez Created: Tue, 11 Jan 2005 12:52 PM Body: > No, it will work just fine if you say, "from Serializable". thanks for the clarification. i'm not sure i understand. i was assuming the intent was to fetch all objects of a type that implement a given interface. wouldn't the name of the interface be required in the hql specification?? can you point me to any documentation or information about this feature? thank you, / eitan --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_15537 --------------------------------------------------------------------- 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, 11 Jan 2005 12:52 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-11 18:59:07
|
The following comment has been added to this issue: Author: Emmanuel Bernard Created: Tue, 11 Jan 2005 12:58 PM Body: Please use the forum for user question, this is a bug tracking system http://www.hibernate.org/hib_docs/reference/en/html_single/#queryhql-polymorphism --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_15538 --------------------------------------------------------------------- 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, 11 Jan 2005 12:58 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-12 11:33:08
|
The following comment has been added to this issue: Author: Damien LY Created: Wed, 12 Jan 2005 5:32 AM Body: Bonjour, Is it possible to make a patch for the 2.1.7c issue? Thanks --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_15541 --------------------------------------------------------------------- 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: Wed, 12 Jan 2005 5:32 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-12 12:03:09
|
The following comment has been added to this issue: Author: Shoaib Created: Wed, 12 Jan 2005 6:02 AM Body: Hello, You people have a great product..... But i wonder why dont u add count method in query interface.............please do add it it save A LOT OF TIME....otherwise we have to do jdbc query to get count of query results which lessens the reasons for using HIBERNATE --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_15543 --------------------------------------------------------------------- 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: Wed, 12 Jan 2005 6:02 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-13 12:26:12
|
The following comment has been added to this issue: Author: Paul Feaviour Created: Thu, 13 Jan 2005 6:25 AM Body: I am using Hibernate 2.1.7c and would like to use the Criteria.count functionality, however, I am not sure if the patches supplied at the top of this thread are suitable for the release of Hibernate that I am using. Could somebody please shed some light on this issue and also whether this is intended to be apart of the production release at any time soon rather than a patch? Paul --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_15564 --------------------------------------------------------------------- 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: Thu, 13 Jan 2005 6: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: <leg...@at...> - 2005-01-17 11:14:11
|
The following comment has been added to this issue: Author: Michael Kantarovich Created: Mon, 17 Jan 2005 5:13 AM Body: Hi, Need it a lot!!! Please post a patch for 2.1.7 or 2.1.6 Tnaks! Michael. --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_15595 --------------------------------------------------------------------- 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 5:13 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-17 15:32:12
|
The following comment has been added to this issue: Author: Chris Nelson Created: Mon, 17 Jan 2005 9:31 AM Body: All, As the originator of this patch, I have at this point given up on the existing Hibernate Criteria API as it is. The count issue, the awkwardness of using subcriteria, the lack of ability to do ordering on related object properties, there were simply too many problems that made it unusable for the purposes of our applications. Instead, we developed our own Criteria API that generates HQL. At this point we have been using it for a year and it is pretty mature. It is able to do nested properties to an arbitrary level, do auto-joins across collection properties, supports projection and aggregration, etc. If there is interest, I can talk to my client about releasing it as open source. However, as I'm sure the Hibernate dev team will tell you, I see absolutely NO chance it will ever be included in the main Hibernate code base. I would, howevery, be happy to put it up on dev.java.net if there is interest and my client is willing. But since I no longer use the Hibernate Criteria API, I will not be supporting this count() patch anymore. --Chris --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_15597 --------------------------------------------------------------------- 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 9:31 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-17 18:53:11
|
The following comment has been added to this issue: Author: Gavin King Created: Mon, 17 Jan 2005 12:52 PM Body: Now listen up. I am starting to get really a bit sick of all this bitching. We have to prioritize here. Improvements to the Criteria API, including projection/aggregation are scheduled for 3.1. Please cut us some slack and wait until 3.1, when we will actually have time to do this properly! Its not like we are all sitting around watching TV all day. --------------------------------------------------------------------- View this comment: http://opensource.atlassian.com/projects/hibernate/browse/HB-474?page=comments#action_15599 --------------------------------------------------------------------- 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 12:52 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 |