Hi,
Im new to Hibernate and not sure (also after reading documentation) what the best way to go is.
In my code I have specified to execute the following query:
Code:
List<Auction> results = em.createQuery("select a from Auction a where lower(a.name) like #{auctionSearchNamePattern}")
.setMaxResults(pageSize + 1)
.setFirstResult(page * pageSize)
.getResultList();
The results are displayed on a JSF form, but I only show the name and description field. When I look at the select statement generated, all the fields are in the select statement.
Although this is only a small test project to get to know Seam and Hibernate, I feel it would be better to only select the fields I really need, since there is a potentially large blob in each record also.
So, should I worry about all the fields being in the select? Im wondering what the best way to go is in these kinds of situations.
Thanks s much for your time!
Login
FAQ
Search