Re: hibernate: prepis s HQL do hibernate criteria

[Vladimir Balaz]

Dobry den,

   Vnoreny dotaz sa da reprezentovat vytvorenim instancie 
DetachedCriteria, ktoru potom pridate beznym sposobom do nadradeneho 
Criteria objektu. V principe asi takto:

DetachedCriteria subquery = 
DetachedCriteria.forClass(TenderBid.class).setProjection(Projections.property("id"));
Criteria crit = 
session.createCriteria(ResultItem.class).add(Subqueries.propertyIn("id", 
subquery));

Ivan Polák wrote:
zdravim konferenciu,

mam problem s prepisom nasledovneho HQL dotazu na hibernate criteria, 
neviete ako na to:

return getHibernateTemplate().find("select new com......ResultItem(" +
               "tender, tb) " +
               "from TenderBid tb, Tender tender " +
               "where tender = tb.tender " +
               "and tb.o = ? " +
               "and tb.bidPrice = (" +
               "select min(b.bidPrice) " +
               "from TenderBid b " +
               "where b.carrier = tb.carrier " +
               "and b.tender = tb.tender)", o);

konkretne v vnorenym selectom na ziskanie minima.

dakujem

Ivan