Hibernate Community • View topic - SELECT COUNT(*) throws QueryException in NH 2.0

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

SELECT COUNT(*) throws QueryException in NH 2.0

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

Nels_P_Olsen

Post subject: SELECT COUNT(*) throws QueryException in NH 2.0

Posted: Mon Dec 29, 2008 12:32 pm

Expert

Joined: Fri Oct 28, 2005 5:38 pm
Posts: 390
Location: Cedarburg, WI

Hibernate version: 2.0.1.GA

I am trying to upgrade from NH 1.2 to 2.0. We have some queries that do SELECT COUNT(*) that used to work, now ISession.CreateQuery throws

Code:

NHibernate.QueryException: undefined alias or unknown mapping: *

The exception is thrown at PathExpressionParser.cs: 145 in the Token() method.

The documentation on [url]http://nhforge.org/doc/nh/en/index.html#queryhql
[/url] section 12.5 says that COUNT(*) is supported.

Last edited by Nels_P_Olsen on Tue Dec 30, 2008 11:14 am, edited 1 time in total.

Top

SuperMattet

Post subject:

Posted: Tue Dec 30, 2008 10:51 am

Newbie

Joined: Thu Jul 03, 2008 11:16 am
Posts: 7

Hi!

I uses this and it works fine to me!

Int64 result = CurrentSession.CreateQuery("select count(*) from Lokal").UniqueResult<Int64>();

// SuperMattet

Top

Nels_P_Olsen

Post subject:

Posted: Tue Dec 30, 2008 11:14 am

Expert

Joined: Fri Oct 28, 2005 5:38 pm
Posts: 390
Location: Cedarburg, WI

Try using a more complicated query with aliases, e.g.

Code:

SELECT COUNT(*)
FROM A AS a
JOIN a.B AS b
...

Top

Page 1 of 1

[ 3 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