hibernate a sub-select

[Ivan Polák]

return getHibernateTemplate().find("select new 
com.freightservice.model.TenderCarrierBestBidInformationResultItem(" +
                "tender, tenderBid) " +
                "from Tender tender, TenderBid tenderBid " +
                "where tender = tenderBid.tender " +
                "and tenderBid.carrier = ? " +
                "and tenderBid.bidPrice = (" +
                "select min(b.bidPrice) " +
                "from tenderBid b " +
                "where b.carrier = tenderBid.carrier " +
                "and b.tender = tenderBid.tender)", carrier);

vygeneruje to nasledovny select:


select
        tender0_.id as col_0_0_,
        tenderbid1_.id as col_1_0_
    from
        tender tender0_,
        tender_bid tenderbid1_
    where
        tender0_.id=tenderbid1_.fk_tender_id
        and tenderbid1_.fk_carrier_id=?
        and tenderbid1_.bid_price=(
            select
                min(tenderbid1_.bid_price)
            from
                tender_bid tenderbid1_
            where
                tenderbid1_.fk_carrier_id=tenderbid1_.fk_carrier_id
                and tenderbid1_.fk_tender_id=tenderbid1_.fk_tender_id
        )

pre tabulku tender_bid je pouzity rovnaky alias : tenderbid1_

dakujem

Ivan

Jiří Mareš  wrote / napísal(a):
> Ahoj,
>
> to mi prijde divny, ja jsem si myslel, ze alias se vytvari castecne ze jmena tabulky a castecne pomoci poradoveho cisla
> tabulky, tudiz tam 2 stejne aliasy byt nemuzou. Neni problem jinde. Pouzivate aliasy v originalnim HQL dotazu?
>
> Zkuste sem poslat ten HQL dotaz ...
>
> S pozdravem
>
> Ivan Polák napsal(a):
>   
>> pouzivam v Hibernate vytvaranie select-ov pomocou HQL
>> getHibernateTemplate().find("select....."). mam ale select, kde pouzivam
>> v "hlavnom select-e" 2 tabulky (prepojene cez id-cka) a vo where
>> podmienke je sub-select, kde pouzivam jednu z tych 2 tabuliek co v
>> hlavnom selecte.
>>
>> a tu je prave problem Hibernate si pri vytvarani SQL dotazu vytvori pre
>> tieto tabulky v hlavnom dotaze a sub-selecte rovnaky alias, takze
>> samozrejme dostavam iny select a nie to co som chcel.
>>
>> neviete prosim, ako tento problem odstranit.
>>