Hibernate Community • View topic - count() in named query

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

count() in named query

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

iamvraj

Post subject: count() in named query

Posted: Wed May 11, 2005 6:32 am

Newbie

Joined: Mon May 09, 2005 5:50 am
Posts: 6

Hi,

I have classes as follows;

Code:

Class Fax { 
Integer faxId 
String faxNumber 
Document document 
} 


Class Document { 
Integer documentId 
String documentType 
String documentName 
Date createdTime 
}

Can anyone pls give me a named query to find the total number of Faxes. Also I do not know to read the result in this case. Anyone help pls.

Thx,
Vraj

Top

rcbeuker

Post subject:

Posted: Wed May 11, 2005 6:47 am

Beginner

Joined: Fri Mar 11, 2005 7:52 am
Posts: 34

In the Fax or Document Dao:

Code:

  public Integer getFaxCount()
  {
     Session lSession = HibernateUtil.getSession();
     Integer lFaxCount = (Integer)lSession.createQuery("select count(*) from Fax").uniqueResult();
     return lFaxCount ;
  }

Top

iamvraj

Post subject:

Posted: Wed May 11, 2005 7:30 am

Newbie

Joined: Mon May 09, 2005 5:50 am
Posts: 6

Thanks that worked..!!

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum