| This is the query: NativeQuery query = entityManager.createNativeQuery("select {confpage.*} " + "from CONFANCESTORS ancestors, CONTENT {confpage} " + "where {confpage} .CONTENTID = ancestors.DESCENDENTID " + "and ancestors.ANCESTORID = ? " + "order by {confpage} .CONTENTID", "confpage", Page.class); query.setCacheable(true); query.setLong(1, page.getId()); return query.list(); |