java.lang.IllegalStateException_no data type for node: org.hibernate.hql.ast.tree.

作者：花生_TL007 | 2024-03-23 17:44:20

踩

no data type for node: org.hibernate.hql.ast.tree.identnode \-[ident] identn

java.lang.IllegalStateException: No data type for node: org.hibernate.hql.ast.tree.IdentNode
\-[IDENT] IdentNode: 'routerNumber' {originalText=routerNumber}

at org.hibernate.hql.ast.tree.SelectClause.initializeExplicitSelectClause(SelectClause.java:
145)

我的sql语句：

String sql="select agentAccount,hardware,sum(effectTimes),sum(effectTimesTemp),agentAccount,gatewayIp,lanIp,sum(desktopCount)," +
"sum(floatCount),sum(backCount),sum(shortCutCount),sum(netCount),sum(gameCount),gameSupport,sum(startOpenCount)," +
"sum(justNotify),froms , advId,sum(advClientCount) ，routerNumber from ClientClick where feeTime= ? and advId=0 group by hardware , agentAccount";

一开始这个表中有routerNumber列，后来删了，语句中没有删，所以报了这个错，总之原因就是routerNumber在数据库表中没有这个列，将sql语句中的这个名去掉就ok了

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/花生_TL007/article/detail/296648