Advertisement
Guest User

Untitled

a guest
Mar 26th, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.15 KB | None | 0 0
  1. Entity SystemRules{
  2. @OneToMany(mappedBy = "systemRule", fetch = FetchType.EAGER, cascade = CascadeType.ALL)
  3. private List<ServiceActionMap> serviceActionMap;
  4. }
  5.  
  6. Entity ServiceActionMap{
  7. @ManyToOne(fetch = FetchType.EAGER)
  8. @JoinColumn(name = "SYSTEM_RULE_ID")
  9. private SystemRules systemRule;
  10.  
  11. @ManyToOne(fetch = FetchType.EAGER)
  12. @JoinColumn(name = "RFS_TYPE_ID", nullable = true)
  13. private RfsTypeMap rfsType;
  14. }
  15.  
  16. Entity RfsTypeMap{
  17. @Id
  18. @Column(name="RFS_TYPE_ID" ,nullable=false)
  19. private BigDecimal rfsTypeId;
  20.  
  21. @Column(name="RFS_NAME")
  22. private String rfsName;
  23. }
  24.  
  25. CriteriaQuery<SystemRules> query = cb.createQuery(SystemRules.class);
  26. Root<SystemRules> root= query.from(SystemRules.class);
  27. root.fetch(SystemRules_.serviceActionMap).fetch(ServiceActionMap_.rfsType, JoinType.LEFT);
  28.  
  29. cb.desc(cb.upper(systemRules.get("serviceActionMap").get("rfsType").get("rfsName").as(String.class)));
  30.  
  31. SELECT DISTINCT s FROM SystemRules s INNER JOIN FETCH s.serviceActionMap INNER JOIN FETCH s.serviceActionMap INNER JOIN FETCH s.ruleProperty INNER JOIN FETCH s.ruleProperty where ... ORDER BY UPPER(s.serviceActionMap.rfsType.rfsName)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement