Course course3 = newCourse("Biology");
Course course4 = newCourse("Not Biology");
Course course5 = newCourse("Biology");
Course course6 = newCourse("Not Biology");
persistInTxn(course1, course2, course3, course4, course5, course6);
Student student = newStudent(10, course1, course2);
Student student2 = newStudent(11, course3, course4);
Student student3 = newStudent(10, course5, course6);
persistInTxn(student, student2, student3);
beginTxn();
Query q = em.createQuery(
"select from " + Student.class.getName() + " s JOIN s.coursesAlias c where "
+ "c.department = 'Biology' and "
+ "s.grade = 10");
q.setFirstResult(1);
assertEquals(student3.getId(), ((Student) q.getSingleResult()).getId());
q = em.createQuery(
"select from " + Student.class.getName() + " s JOIN s.coursesAlias c where "
+ "c.department = 'Biology' and "
+ "s.grade = 10");
q.setFirstResult(2);