Fast Lane Reader / EJB3

[kostaboss]

Hi,
i was wondering if there is a smart way to implement the "Fast Lane Reader"-Design paradigm on ejb3.
Best would be a way, so that it uses the Datasource and Hibernate-Dialect that is set up already for the Entitymanager.

I'm facing the problem of needing to get a List of all Objects of an Entity in the DBMS for Display Purposes. So using JDBC obviously makes more sense then creating Objects for each line, marshalling and demarschalling them.

Any Help, Docu, wiki or tips on this ?

[ronaldmathies]

At the bottom of the following URL there is something about fast lane reader:

http://blog.hibernate.org/cgi-bin/blosxom.cgi/Gavin%20King/ejb3part1.html?seemore=y

@Stateless
public class AuctionImpl implements Auction {
 ...

 public List<ItemSummary> getItemSummaries() {
 String query = "select new "
 + "ItemSummary(item.shortDescription, item.id, max(bid.amount)) "
 + "from Item item left outer join item.bids bid";

 return (List<ItemSummary>) em.createQuery(query)
 .listResults();
 }
}

You just have to make shure that the ItemSummary class in this example has the appropriate constructor.