hibernate Exception when execute the jpa sub query

Question

query=entityManager.createQuery(" select a.birthDate from PersonalDetailsDomain a where a.empCode=(select b.empCode from User b where b.userId=?)");
    query.setParameter(1,userId);
    Date dob =(Date)query.getSingleResult();

Excetion:

java.lang.IllegalArgumentException: org.hibernate.QueryException: could not resolve property: empCode of: com.erp.hrms.User [ select a.birthDate from com.erp.hrms.newjoinee.PersonalDetailsDomain a where a.empCode=(select b.empCode from com.erp.hrms.User b where b.userId=?)]

Does your "User" entity have an "empCode" property with getters and setters? — mael, Jul 25 '13 at 06:46
As you are writing Pure SQL Query not the HSQL , you have to given the table name not the POJO Class name of that individual table — , Jul 25 '13 at 06:47
Have you looked at these other questions about jpa & subquries: http://stackoverflow.com/questions/13460235/jpa-2-criteria-using-in-and-subqueries http://stackoverflow.com/questions/11187188/jpa-criteria-query-with-subquery http://stackoverflow.com/questions/4662336/subquery-in-select-clause http://stackoverflow.com/questions/4483576/jpa-2-0-criteria-api-subqueries-in-expressions http://stackoverflow.com/questions/7269010/jpa-hibernate-subquery-in-from-clause — Trevor Gowing, Jul 25 '13 at 06:47

score 0 · Answer 1 · answered Jul 25 '13 at 06:50

Use ':userId' instead of '?' and also use method createSQLQuery for native sql queries.

query=entityManager.createSQLQuery(" select a.birthDate from PersonalDetailsDomain a where a.empCode=(select b.empCode from User b where b.userId= :userId)");

query.setParameter("userId", userId);

Date dob =(Date)query.getSingleResult();

score 0 · Answer 2 · answered Jul 25 '13 at 06:50

0

Are you sure to have correctly mapped the field (or relative accessor) for User.empCode?
Attach User definition, would help.

answered Jul 25 '13 at 06:50

Luca Basso Ricci

17,829
2
47
69

hibernate Exception when execute the jpa sub query

2 Answers2