Advertisement
Guest User

Untitled

a guest
Nov 27th, 2014
145
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.91 KB | None | 0 0
  1. @Where(clause = 'state='ACTIVE'")
  2. @Entity
  3. public class Place {
  4.  
  5. @Column(name="id_place")
  6. private String placeId;
  7.  
  8. @Column(name="name")
  9. private String palceName;
  10.  
  11. @OneToMany(mappedBy = "place")
  12. private Set<PlaceTag> placeTag;
  13.  
  14. ...
  15. ...
  16. }
  17.  
  18. @Where(clause = 'state='ACTIVE'")
  19. @Entity
  20. public class Tag {
  21.  
  22. @Column(name="id_tag")
  23. private String tagId;
  24.  
  25. @Column(name="name")
  26. private String tagName;
  27.  
  28. @OneToMany(mappedBy = "tag")
  29. private Set<PlaceTag> placeTag;
  30. ...
  31. ...
  32. }
  33.  
  34. @Where(clause = 'poi.state='ACTIVE' AND tag.state='ACTIVE")
  35. @Entity
  36. public class PlaceTag {
  37.  
  38. @Column(name="id")
  39. private String id;
  40.  
  41. @ManyToOne(cascade = CascadeType.DETACH, fetch = FetchType.LAZY)
  42. @JoinColumn(name = "place_id")
  43. private Place place;
  44.  
  45. @ManyToOne(cascade = CascadeType.DETACH, fetch = FetchType.LAZY)
  46. @JoinColumn(name = "tag_id")
  47. private Tag tag;
  48.  
  49. ...
  50. ...
  51.  
  52. }
  53.  
  54. SELECT pt FROM PlaceTag pt;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement