Avatar
0
tvd12 Enlightened
tvd12 Enlightened
Các fix lỗi Not supported for DML operations
<div class="markdown-block">Tôi có hàm:</div><div class="markdown-block">@EzyQuery(</div><div class="markdown-block">"UPDATE Term e " +</div><div class="markdown-block">"SET e.displayOrder = e.displayOrder + ?2, " +</div><div class="markdown-block">"e.updatedAt = ?3 " +</div><div class="markdown-block">"WHERE e.name = ?0 " +</div><div class="markdown-block">"AND e.termType = ?1"</div><div class="markdown-block">)</div><div class="markdown-block">int increaseDisplayOrderByNameAndTermType(</div><div class="markdown-block">String name,</div><div class="markdown-block">String termType,</div><div class="markdown-block">long value,</div><div class="markdown-block">LocalDateTime updatedAt</div><div class="markdown-block">);</div><div class="markdown-block">Nhưng khi chạy tôi gặp lỗi:</div><div class="markdown-block">Not supported for DML operations [UPDATE org.youngmonkeys.ezyarticle.sdk.entity.Term e SET e.displayOrder = e.displayOrder + ?2,e.updatedAt = ?3 WHERE e.name = ?0 AND e.termType = ?1]</div><div class="markdown-block">Hãy chỉ cách fix giúp tôi</div>
Answer
Avatar
0
tvd12 Enlightened
tvd12 Enlightened
Lỗi: Path expected for join!
<div class="markdown-block">Vì sao lỗi Path expected for join! xảy ra với đoạn query dưới đây:</div><div class="markdown-block">"SELECT e FROM UserGroupMember e " +</div><div class="markdown-block">"INNER JOIN UserGroup a ON e.userGroupId = a.id " +</div><div class="markdown-block">"INNER JOIN EzyCRMEventUserGroup b ON a.id = b.userGroupId " +</div><div class="markdown-block">"INNERJOIN EzyCRMEvent c ON b.eventId = c.id " +</div><div class="markdown-block">"INNER JOIN DataMapping d ON c.id = d.toDataId " +</div><div class="markdown-block">"INNER JOIN EzyCRMUserGroup f ON d.fromDataId = f.id " +</div><div class="markdown-block">"INNER JOIN EzyCRMEventUserGroup g ON f.id = g.userGroupId " +</div><div class="markdown-block">"WHERE e.userId IN ?1 " +</div><div class="markdown-block">"AND a.groupType = 'MATCH' " +</div><div class="markdown-block">"AND a.status = ?2 " +</div><div class="markdown-block">"AND c.eventType = 'ROUND' " +</div><div class="markdown-block">"AND d.mappingName = 'player_group_round' " +</div><div class="markdown-block">"AND f.groupType = 'AGE_GROUP' " +</div><div class="markdown-block">"AND g.eventId = ?0 " +</div><div class="markdown-block">"ORDER BY e.id DESC"</div><div class="markdown-block">Lỗi:</div><div class="markdown-block">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.EzyCRMEventU</div>
Answer