Model cannot be cast - internal error in spring boot and Criteria API Join

I am trying to join and retrieve joined result using spring boot and criteria API join. Here I am trying to retrieve role id from second table where a user id match found by joining with first table. When I am running my query I am getting the error like,

Error Update


"timestamp": "2018-09-10T10:54:01.163+0000",
"status": 500,
"error": "Internal Server Error",
"message": "com.example.model.Roles cannot be cast to


Here I did not used metamodel generated classes. Without using that I implemented. But still getting the same error.

1 Answer
1

Two things are wrong:

multiselect()

javax.persistence.criteria.Join

nuserId

Users

If you just want to get both User and its UserRoleMapping at the same time, you can try:

User

UserRoleMapping

CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery<Users> cq = cb.createQuery(Users.class);
Root<Users> rootRoles = cq.from(Users.class);
rootRoles.fetch("roleUserRoleMappingMappingJoin", JoinType.LEFT);

cq.select(rootRoles).where(cb.equal(rootRoles.get("nuserId"),nuserID));
List<Users> roleJoinResultObj = em.createQuery(cq).getResultList();


Thanks for contributing an answer to Stack Overflow!

But avoid …

To learn more, see our tips on writing great answers.

Required, but never shown

Required, but never shown

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.