sql - What is wrong with JPQL (count and select) -
below query rows parent table , count of each id child table. @query("select cnt idcount, person person person,(select count(child.id) cnt child child child.id :input_id) idcount person.id :input_id") list<person> searchpersonwithcount(@param("input_id") long input_id); i below error: caused by: org.hibernate.hql.internal.ast.querysyntaxexception: unexpected token: idcount near line 1, column 12 [select cnt idcount, person com.myc.cc.domain.person person,(select count(child.id) cnt com.myc.cc.domain.child child child.id :input_id) idcount person.id :input_id] @ org.hibernate.hql.internal.ast.querysyntaxexception.convert(querysyntaxexception.java:54) when execute in oracle sqldeveloper able results. native query executed in qracle sql developer: select cnt idcount, person.* person person,(select count(*) cnt child child id = '1235') idcount id = '1235' result: idcount id name 2 1235 p...