Avatar
0
tvd12 Enlightened
tvd12 Enlightened
Lỗi: Path expected for join!
Vì sao lỗi Path expected for join! xảy ra với đoạn query dưới đây:
"SELECT e FROM UserGroupMember e " +
"INNER JOIN UserGroup a ON e.userGroupId = a.id " +
"INNER JOIN EzyCRMEventUserGroup b ON a.id = b.userGroupId " +
"INNERJOIN EzyCRMEvent c ON b.eventId = c.id " +
"INNER JOIN DataMapping d ON c.id = d.toDataId " +
"INNER JOIN EzyCRMUserGroup f ON d.fromDataId = f.id " +
"INNER JOIN EzyCRMEventUserGroup g ON f.id = g.userGroupId " +
"WHERE e.userId IN ?1 " +
"AND a.groupType = 'MATCH' " +
"AND a.status = ?2 " +
"AND c.eventType = 'ROUND' " +
"AND d.mappingName = 'player_group_round' " +
"AND f.groupType = 'AGE_GROUP' " +
"AND g.eventId = ?0 " +
"ORDER BY e.id DESC"

Lỗi:

Path expected for join! [SELECT e FROM org.youngmonkeys.ezycrm.entity.UserGroupMember e INNER JOIN org.youngmonkeys.ezycrm.entity.UserGroup a ON e.userGroupId = a.id INNER JOIN org.youngmonkeys.ezycrm.entity.EzyCRMEventUserGroup b ON a.id = b.userGroupId INNER JOIN org.youngmonkeys.ezycrm.entity.EzyCRMEvent c ON b.eventId = c.id INNER JOIN org.youngmonkeys.ezyplatform.entity.DataMapping d ON c.id = d.toDataId INNER JOIN EzyCRMUserGroup f ON d.fromDataId = f.id INNER JOIN org.youngmonkeys.ezycrm.entity.EzyCRMEventUserGroup g ON f.id = g.userGroupId WHERE e.userId IN ?1 AND a.groupType = 'MATCH' AND a.status = ?2 AND c.eventType = 'ROUND' AND d.mappingName = 'player_group_round' AND f.groupType = 'AGE_GROUP' AND g.eventId = ?0 ORDER BY e.id DESC]
  • Answer
java jpql
Remain: 5
1 Answer
Avatar
tvd12 Enlightened
tvd12 Enlightened
Lỗi là do lớp entity EzyCRMUserGroup không tồn tại, chính xác phải là UserGroup.
  • 0
  • Reply