@Test public void querydsl() { JPAQuery<Person> q = new JPAQuery<Person>(em); QPerson p = QPerson.person; List<Person> people = q.select(p).from(p).where(p.name.toLowerCase().like("p%")).fetch(); assertThat(people, hasSize(10)); }