Chapter 16. Advanced query options

Session session = em.unwrap(Session.class);
org.hibernate.Query query = session.createQuery(
    "select i.id as itemId, i.name as name, i.auctionEnd as auctionEnd from Item i"
);

List<Object[]> result = query.list();
<enter/>
for (Object[] tuple : result) {
    Long itemId = (Long) tuple[0];
    String name = (String) tuple[1];
    Date auctionEnd = (Date) tuple[2];
    // ...
}

query.setResultTransformer(
    ToListResultTransformer.INSTANCE
);
<enter/>
List<List> result = query.list();
<enter/>
for (List list : result) {
    Long itemId = (Long) list.get(0);
    String name = (String) list.get(1);
    Date auctionEnd = (Date) list.get(2);
    // ...
}

org.hibernate.Query entityQuery = session.createQuery(
    "select i as item, u as seller from Item i join i.seller u"
);
<enter/>
entityQuery.setResultTransformer(
    AliasToEntityMapResultTransformer.INSTANCE
);
<enter/>
List<Map> result = entityQuery.list();
<enter/>
for (Map map : result) {
    Item item = (Item) map.get("item");
    User seller = (User) map.get("seller");
<enter/>
    assertEquals(item.getSeller(), seller);
    // ...
}

query.setResultTransformer(
    new AliasToBeanResultTransformer(ItemSummary.class)
);
<enter/>
List<ItemSummary> result = query.list();
<enter/>
for (ItemSummary itemSummary : result) {
    Long itemId = itemSummary.getItemId();
    String name = itemSummary.getName();
    Date auctionEnd = itemSummary.getAuctionEnd();
    // ...
}

Item item = em.find(Item.class, ITEM_ID);
User user = em.find(User.class, USER_ID);
<enter/>
org.hibernate.Query query = session.createFilter(
    item.getBids(),
    "where this.bidder = :bidder order by this.amount desc"
);
<enter/>
query.setParameter("bidder", user);
List<Bid> bids = query.list();