Hibernate Community • View topic - Count don't work! I am dummy?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

Count don't work! I am dummy?

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

Kernel Panic

Post subject: Count don't work! I am dummy?

Posted: Fri Mar 23, 2007 12:13 pm

Newbie

Joined: Wed Sep 06, 2006 8:33 am
Posts: 19

NHibernate version: 1.2

Name and version of the database you are using: Firebird

I try to get the number of records in a table with this expression:

Code:

string query="SELECT COUNT(T) FROM Class1 as T";
this.Session.CreateQuery(query).UniqueResult();

And i receive this exception:

Code:

path expression ends in a composite value [SELECT COUNT(T) FROM Class1 as T]

Note: My class have a composite-id, this same expression in other class works fine.

Any ideas?

Top

anuarneto

Post subject: Really don't works.

Posted: Fri Mar 23, 2007 12:17 pm

Beginner

Joined: Fri Oct 20, 2006 8:02 am
Posts: 36

I've also tried to do that and it didn't work.

I couldn't find the erro to.

Some one knows what is wrong with it?

Top

sergey

Post subject:

Posted: Fri Mar 23, 2007 12:34 pm

Contributor

Joined: Wed May 11, 2005 4:59 pm
Posts: 1766
Location: Prague, Czech Republic

Use count(*).

Top

Kernel Panic

Post subject:

Posted: Fri Mar 23, 2007 1:43 pm

Newbie

Joined: Wed Sep 06, 2006 8:33 am
Posts: 19

Really, I am dummy!

thanks sergey

Top

Page 1 of 1

[ 4 posts ]

Board index » Hibernate & Java Persistence » NHibernate 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