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

Odpovedet emailem