！！！问一个HQL 和SQL 的问题 SQL 可以跑 HQL 出问题！！！急！！
HQL 是这样的

SELECT u FROM Product u WHERE u.vvshop =true and u.commend = true and u.id in ( SELECT v.productId FROM (SELECT distinct rp.product.id,rp.recommendNum FROM RecommondProType rp where rp.recommondType in (:recommondTypes) and rp.warehouse=:warehouseId order by rp.recommendNum desc) v )?

SQL是可以跑 的

Java code

select *  from (select product0_.ID                    as ID75_,               product0_.name                  as name75_,               product0_.smpic                 as smpic75_,               product0_.marketPrice           as marketPr4_75_,               product0_.brand                 as brand75_,               product0_.brandName             as brandName75_,               product0_.brandSerialNum        as brandSer7_75_,               product0_.newAttributes         as newAttri8_75_,               product0_.status                as status75_,               product0_.model                 as model75_,               product0_.properPayType         as properP11_75_,               product0_.productClass          as product12_75_,               product0_.memberPrice           as memberP13_75_,               product0_.unit                  as unit75_,               product0_.store                 as store75_,               product0_.supplier              as supplier75_,               product0_.parking               as parking75_,               product0_.weight                as weight75_,               product0_.volume                as volume75_,               product0_.description2          as descrip20_75_,               product0_.otherExplain2         as otherEx21_75_,               product0_.howtobuy              as howtobuy75_,               product0_.spec                  as spec75_,               product0_.tags                  as tags75_,               product0_.commend               as commend75_,               product0_.dealerAdd             as dealerAdd75_,               product0_.onlineSale            as onlineSale75_,               product0_.tradingAmount         as trading28_75_,               product0_.vvshop                as vvshop75_,               product0_.booking               as booking75_,               product0_.ifEntity              as ifEntity75_,               product0_.getProductDay         as getProd32_75_,               product0_.pinyinIndex           as pinyinI33_75_,               product0_.no                    as no75_,               product0_.marketing             as marketing75_,               product0_.iternationalCode      as iternat36_75_,               product0_.iternationalCodeNote  as iternat37_75_,               product0_.adminusername         as adminus38_75_,               product0_.companyname           as company39_75_,               product0_.productlevel          as product40_75_,               product0_.procurementuser       as procure41_75_,               product0_.packagemodel          as package42_75_,               product0_.productCountry        as product43_75_,               product0_.productrovince        as product44_75_,               product0_.productcity           as product45_75_,               product0_.saletype              as saletype75_,               product0_.productcolour         as product47_75_,               product0_.recommendNum          as recomme48_75_,               product0_.createDate            as createDate75_,               product0_.publishDate           as publish50_75_,               product0_.specialSize           as special51_75_,               product0_.delChange             as delChange75_,               product0_.purchasePrice         as purchas53_75_,               product0_.specParameter         as specPar54_75_,               product0_.proContentDetail      as proCont55_75_,               product0_.afterSellService      as afterSe56_75_,               product0_.presentBelong         as present57_75_,               product0_.orderOverQty          as orderOv58_75_,               product0_.productModel          as product59_75_,               product0_.consignmentPrice      as consign60_75_,               product0_.isEditInvContent      as isEditI61_75_,               product0_.productAnnotation     as product62_75_,               product0_.productSaleRankNo     as product63_75_,               product0_.oldForNew             as oldForNew75_,               product0_.pfDateFlag            as pfDateFlag75_,               product0_.shelfLife             as shelfLife75_,               product0_.packStandard          as packSta67_75_,               product0_.stockUpLimit          as stockUp68_75_,               product0_.stockLowerLimit       as stockLo69_75_,               product0_.classification        as classif70_75_,               product0_.fragileFlag           as fragile71_75_,               product0_.qualityCheckFlag      as quality72_75_,               product0_.allowNoStockSale      as allowNo73_75_,               product0_.factorySendFlag       as factory74_75_,               product0_.length                as length75_,               product0_.width                 as width75_,               product0_.height                as height75_,               product0_.contractPurchasePrice as contrac78_75_,               product0_.taxrate               as taxrate75_,               product0_.isSent                as isSent75_,               product0_.process               as process75_,               product0_.sentTime              as sentTime75_,               product0_.receiveTime           as receive83_75_,               product0_.picPath               as picPath75_,               product0_.isNotStock            as isNotStock75_,               product0_.joinFanli             as joinFanli75_,               product0_.commentCount          as comment87_75_,               product0_.satisfactionScore     as satisfa88_75_,               product0_.fanliPrice            as fanliPrice75_,               product0_.level_                as level90_75_          from HOMEVV_PRODUCT product0_         where product0_.vvshop = 1           and product0_.commend = 1           and (product0_.ID in               (select v.productId                   from (                   (select distinct recommondp1_.productId,                                          recommondp1_.recommendNum                            from HOMEVV_RECOMMOND_PRO_TYPE recommondp1_                           where (recommondp1_.recommondType in ('index'))                             and recommondp1_.warehouse =                                 'ff808081316003c60131606ef17127d8'                           order by recommondp1_.recommendNum desc)                           ) v                           )                           )) where rownum <= 10; 
 

感觉问题就出在这个SELECT v.productId 问题上 但是不知道怎么解决



报错是这样的
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: ( near line 1, column 131

[解决办法]
SELECT v.productId FROM (SELECT distinct rp.product.id,rp.recommendNum FROM RecommondProType rp where rp.recommondType in (:recommondTypes) and rp.warehouse=:warehouseId order by rp.recommendNum desc) V 这里hibernate好像是不能做嵌套的子查询的 好像是hibernate不能把V映射成一个实体类的问题
[解决办法]
什么数据库，是不是rownum出错。
[解决办法]
rp.product.id后面加一句改为 rp.product.id as productId
[解决办法]
不然它是找不到V有productId这个字段的。
[解决办法]
WHERE u.vvshop =true and u.commend = true

在sql里没有这种写法啊,应该是u.vvshop =1 and u.commend = 1