Hi Pal,

Am getting the following error while executing this code

Hibernate Version = 2.0.0

Code :
int countIdx = countString.indexOf("order");
String queryString = "select count(*) from (" +countString.substring(0,countIdx) + ") as A ";
Query countQuery = SessionCreator.currentSession(NewGDCConstants.CURRENT_SESSION).createQuery(queryString);
int recordCount = Integer.parseInt(((Object[])countQuery.list().iterator().next())[0].toString());

Error:"net.sf.hibernate.QueryException: in expected: select [select count(*) from (select distinct "- followed by aggregate query.

Can You post me the solution if any of you face this problem here before.

Thanks
Giri

Hi

please tell me what is the countString is.

Amila

Hi,
countString is another HQL which contain order by field in "where" clause.

Thanks
Giri