File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes unexpected token: group Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Reply locked New topic
Author

unexpected token: group

diana yusof
Greenhorn

Joined: Mar 04, 2008
Posts: 2
Could anybody answer me how to make this code run.

String sql = "select MONTH(CC.createddateTs) as months , "+

"(SELECT COUNT(CC1.communicationtypeTx) from Customercommunication as CC1 "+
" where CC1.communicationtypeTx = 'Complaint' and MONTH(CC1.createddateTs)= MONTH(CC.createddateTs) "+
" group by MONTH(CC1.createddateTs) ) as complaint," +

"(SELECT COUNT(CC2.communicationtypeTx) from Customercommunication as CC2 "+
" where CC2.communicationtypeTx = 'Enquiry' and MONTH(CC2.createddateTs)= MONTH(CC.createddateTs) "+
" group by MONTH(CC2.createddateTs) ) as Enquiry "+

"from Customercommunication as CC where YEAR((CC.createddateTs) = 2008 group by MONTH(CC.createddateTs) "+
"order by MONTH(CC.createddateTs) ASC";

Query query = mSession.createQuery(sql);

when i run this code i get this error:
ERROR [org.hibernate.hql.PARSER] - <line 1:698: unexpected token: group>
Ulf Dittmer
Rancher

Joined: Mar 22, 2005
Posts: 42954
    
  73
Please do not post the same question multiple times.

Let's continue the discussion in this duplicate thread, where you have answers already.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: unexpected token: group