count query

amichay2 · **Joined:** Sun Aug 29, 2004 11:45 am **Posts:** 16

Hi,

What is the required syntaxt when using count queries when the gained query is from session.createSQLQuery?

Forom some reason it is not possible to call list()/ iterate() like in queries that were created throught session.createQuery()

thanks

ledome20 · **Posted:** Wed Nov 24, 2004 11:13 am

You can try:

int numberOfHits =
((Integer)session.createQuery(query.toString()).uniqueResult()).intValue();

uniqueResult will return 0 if no match found or the number of records corresponding to your count request. With a count query UniqueResult never return null.

or you can try:

numberOfHits = ((Integer).iterate(query.toString()).next()).intValue();

Both ways works fine but i don't know wich is the best to use.

ledome20 · **Posted:** Wed Nov 24, 2004 11:17 am

ledome20 wrote:

You can try:

i forgot the word session in the second query

int numberOfHits =
((Integer)session.createQuery(query.toString()).uniqueResult()).intValue();

uniqueResult will return 0 if no match found or the number of records corresponding to your count request. With a count query UniqueResult never return null.

or you can try:

numberOfHits = ((Integer)session.iterate(query.toString()).next()).intValue();

Both ways works fine but i don't know wich is the best to use.

amichay2 · **Joined:** Sun Aug 29, 2004 11:45 am **Posts:** 16

My problem is that I am not using createQuery but createSQLQuery so what you have suggested can not work.