String sql="select tr ,tcz.tczmc from TrainRecord as tr,TczBean as tcz where tr.lcxxbh in (select axle.axlepk.lcxxbh from AxleRecord as axle where axle.axlepk.tag=:TAGID) and tcz.tczjd(+)=tr.tczjd"; 大家帮忙看看这个复合查询有什么问题!报出的错误如下!!!
null Hibernate Exception: Message:select tr ,tcz.tczmc from TrainRecord as tr,TczBean as tcz where tr.lcxxbh in (select axle.axlepk.lcxxbh from AxleRecord as axle where axle.axlepk.tag=:TAGID) and tcz.tczjd(+)=tr.tczjd and tr.gcsj >= :STARTTIMEcould not resolve property: axlepk.tag of: cc502.tads.zhyi.hibernate.AxleRecord [select tr ,tcz.tczmc from cc502.tads.zhyi.hibernate.TrainRecord as tr,cc502.tads.zhyi.hibernate.TczBean as tcz where tr.lcxxbh in (select axle.axlepk.lcxxbh from cc502.tads.zhyi.hibernate.AxleRecord as axle where axle.axlepk.tag=:TAGID) and tcz.tczjd(+)=tr.tczjd and tr.gcsj >= :STARTTIME]null. Cause:{1}
null Hibernate Exception: Message:select tr ,tcz.tczmc from TrainRecord as tr,TczBean as tcz where tr.lcxxbh in (select axle.axlepk.lcxxbh from AxleRecord as axle where axle.axlepk.tag=:TAGID) and tcz.tczjd(+)=tr.tczjd and tr.gcsj >= :STARTTIMEcould not resolve property: axlepk.tag of: cc502.tads.zhyi.hibernate.AxleRecord [select tr ,tcz.tczmc from cc502.tads.zhyi.hibernate.TrainRecord as tr,cc502.tads.zhyi.hibernate.TczBean as tcz where tr.lcxxbh in (select axle.axlepk.lcxxbh from cc502.tads.zhyi.hibernate.AxleRecord as axle where axle.axlepk.tag=:TAGID) and tcz.tczjd(+)=tr.tczjd and tr.gcsj >= :STARTTIME]null. Cause:{1}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货