This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
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>