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是可以跑 的select *
from (select product0_.ID as ID75_,
product0_.name as name75_,
product0_.smpic as smpic75_,
product0_.etPrice as etPr4_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_.eting as eting75_,
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
from (select product0_.ID as ID75_,
product0_.name as name75_,
product0_.smpic as smpic75_,
product0_.etPrice as etPr4_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_.eting as eting75_,
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
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货