Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @Entity
- @Table(name="usergroup")
- public class UserGroup{
- @Id
- @Column(name = "id")
- @GeneratedValue(strategy = GenerationType.IDENTITY)
- private Long id;
- @Column(name="date")
- private Timestamp date;
- @Column(name="name")
- private String name;
- @OneToMany(mappedBy="userGroup",
- cascade= {CascadeType.PERSIST, CascadeType.MERGE,
- CascadeType.DETACH, CascadeType.REFRESH}, fetch = FetchType.LAZY)
- private List<User> users= new ArrayList<>();
- //constructor, getter and setter
- @Entity
- @Table(name="user")
- public class User{
- @Id
- @Column(name = "id")
- @GeneratedValue(strategy = GenerationType.IDENTITY)
- private Long id;
- @Column(name = "name")
- private String name;
- @ManyToOne(fetch = FetchType.LAZY, cascade= {CascadeType.PERSIST, CascadeType.MERGE,
- CascadeType.DETACH, CascadeType.REFRESH}, optional = false)
- @JoinColumn(name="user_group_id", referencedColumnName = "id")
- private UserGroup userGroup;
- //constructor, getter and setter
- public class ResponseFromDatabase {
- private Long id;
- private String groupName;
- private Timestamp date;
- //constructor, getter and setter
- @Query(value = "SELECT new com.java.test.ResponseFromDatabase(ug.id, ug.groupName, u.date) FROM UserGroup ug JOIN ug.users u WHERE u.id =:userGroupId ORDER BY u.date")
- List<ResponseFromDatabase > findAllUserInformation(@Param("userGroupId") Long userGroupId, @Param("date") Timestamp date;
- }
- "Expected arguments are: long, String, java.util.Date"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement