wood burning stoves 2.0*
The moose likes Object Relational Mapping and the fly likes Rows count in hql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Rows count in hql" Watch "Rows count in hql" New topic
Author

Rows count in hql

meghana maganti
Greenhorn

Joined: Sep 13, 2005
Posts: 11
I am trying to retrieve the number of rows returned with out retrieving the data, can anyone help me how to do this.

I tried some thing like this
select count(*) from table11 join.. where ....

Usually select .. from ... returns a list but I need the result into an int variable which gives me the number of rows with out bringing in the rows.
miguel lisboa
Ranch Hand

Joined: Feb 08, 2004
Posts: 1281
Usually select .. from ... returns a list

list.size()?


java amateur
Scott Johnson
Ranch Hand

Joined: Aug 24, 2005
Posts: 518
See the Hibernate Documentation section 15.14.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Rows count in hql
 
Similar Threads
How to obtain a database table size?
how to write this query... count, unique, ??
How to find no of Rows in my ResultSet
what does "SELECT count(*) from Tablename" mean
how to count rows