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