我在用hibernate时 报一个 标识符无效 异常
但是我用打出来SQL去数据库里查却没问题
所报的字段在数据库里是有的select this_.SERIALNO as SERIALNO23_0_,
this_.CLAIMNO as CLAIMNO23_0_,
this_.RECSERIALNO as RECSERIA3_23_0_,
this_.TCNO as TCNO23_0_,
this_.SENDMAN as SENDMAN23_0_,
this_.SENDMANTYPE as SENDMANT6_23_0_,
this_.RECEIVEMANTYPE as RECEIVEM7_23_0_,
this_.RECEIVEMANINFO as RECEIVEM8_23_0_,
this_.RECEIVEDATE as RECEIVED9_23_0_,
this_.ACCOUNTDATE as ACCOUNT10_23_0_,
this_.RECEIVEMONEYID as RECEIVE11_23_0_,
this_.RECEIVERMBRATE as RECEIVE12_23_0_,
this_.RECEIVEMONEY as RECEIVE13_23_0_,
this_.PAYMONEY as PAYMONEY23_0_,
this_.ADVANCEPAY as ADVANCEPAY23_0_,
this_.CLAIMTYPE as CLAIMTYPE23_0_,
this_.RIGHTRATE as RIGHTRATE23_0_,
this_.COMMISSION as COMMISSION23_0_,
this_.RECEIVETYPE as RECEIVE19_23_0_,
this_.TROVERBOOKNO as TROVERB20_23_0_,
this_.SELFGETCOMMISSION as SELFGET21_23_0_,
this_.INSURANTGETCOMMISSION as INSURAN22_23_0_,
this_.COMMMONEYIN as COMMMON23_23_0_,
this_.COMMMONEYID as COMMMON24_23_0_,
this_.COMMCNYRATEREC as COMMCNY25_23_0_,
this_.WORKDATE as WORKDATE23_0_,
this_.CREDITNO as CREDITNO23_0_,
this_.DISTRIBUTENO as DISTRIB28_23_0_,
this_.REMIT as REMIT23_0_,
this_.USEMONEY as USEMONEY23_0_,
this_.REMARK as REMARK23_0_,
this_.CONFIRMNO as CONFIRMNO23_0_,
this_.ASSETSNO as ASSETSNO23_0_,
this_.CONFIRMREPLEVY as CONFIRM34_23_0_,
this_.ASSETSGATHERING as ASSETSG35_23_0_
from D_TRACEMONEY this_报的就是最后一个字段 标识符无效 但是SQL却可以正确执行
但是我用打出来SQL去数据库里查却没问题
所报的字段在数据库里是有的select this_.SERIALNO as SERIALNO23_0_,
this_.CLAIMNO as CLAIMNO23_0_,
this_.RECSERIALNO as RECSERIA3_23_0_,
this_.TCNO as TCNO23_0_,
this_.SENDMAN as SENDMAN23_0_,
this_.SENDMANTYPE as SENDMANT6_23_0_,
this_.RECEIVEMANTYPE as RECEIVEM7_23_0_,
this_.RECEIVEMANINFO as RECEIVEM8_23_0_,
this_.RECEIVEDATE as RECEIVED9_23_0_,
this_.ACCOUNTDATE as ACCOUNT10_23_0_,
this_.RECEIVEMONEYID as RECEIVE11_23_0_,
this_.RECEIVERMBRATE as RECEIVE12_23_0_,
this_.RECEIVEMONEY as RECEIVE13_23_0_,
this_.PAYMONEY as PAYMONEY23_0_,
this_.ADVANCEPAY as ADVANCEPAY23_0_,
this_.CLAIMTYPE as CLAIMTYPE23_0_,
this_.RIGHTRATE as RIGHTRATE23_0_,
this_.COMMISSION as COMMISSION23_0_,
this_.RECEIVETYPE as RECEIVE19_23_0_,
this_.TROVERBOOKNO as TROVERB20_23_0_,
this_.SELFGETCOMMISSION as SELFGET21_23_0_,
this_.INSURANTGETCOMMISSION as INSURAN22_23_0_,
this_.COMMMONEYIN as COMMMON23_23_0_,
this_.COMMMONEYID as COMMMON24_23_0_,
this_.COMMCNYRATEREC as COMMCNY25_23_0_,
this_.WORKDATE as WORKDATE23_0_,
this_.CREDITNO as CREDITNO23_0_,
this_.DISTRIBUTENO as DISTRIB28_23_0_,
this_.REMIT as REMIT23_0_,
this_.USEMONEY as USEMONEY23_0_,
this_.REMARK as REMARK23_0_,
this_.CONFIRMNO as CONFIRMNO23_0_,
this_.ASSETSNO as ASSETSNO23_0_,
this_.CONFIRMREPLEVY as CONFIRM34_23_0_,
this_.ASSETSGATHERING as ASSETSG35_23_0_
from D_TRACEMONEY this_报的就是最后一个字段 标识符无效 但是SQL却可以正确执行
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货