could not read column value from result set: USER1_10_0_; 列名无效

Hibernate: select count(*) from NSSI_ORG_USER u,NSSI_ORG_UNIT o where 1=1 and u.UNIT_ID = o.UNIT_ID
09:29:35,890 INFO SuperDaoImpl:241 - 通过原生SQL查询满足条件的List并分页
Hibernate: select * from ( select u.NAME as NAME10_0_,u.MOBILE as MOBILE10_0_,u.UNITTEL as UNITTEL10_0_,u.HOMETEL as HOMETEL10_0_,u.DUTY as DUTY10_0_,u.DH as DH10_0_,u.EMAIL as EMAIL10_0_,u.SEX as SEX10_0_,u.REMARK as REMARK10_0_,u.SORT as SORT10_0_,u.SFZHM as SFZHM10_0_ from NSSI_ORG_USER u,NSSI_ORG_UNIT o where 1=1 and u.UNIT_ID = o.UNIT_ID ) where rownum <= ?
09:29:35,906 INFO StringType:203 - could not read column value from result set: USER1_10_0_; 列名无效
09:29:35,906 WARN JDBCExceptionReporter:100 - SQL Error: 17006, SQLState: null
09:29:35,906 ERROR JDBCExceptionReporter:101 - 列名无效
org.hibernate.exception.GenericJDBCException: could not execute query

第1个回答  2012-12-12
你确定NSSI_ORG_USER、NSSI_ORG_UNIT这两个表有 UNIT_ID这个字段?追问

而且打印的sql可以查到数据哦

第2个回答  2012-12-12
查询的时候,某个列名不认识。就报这个错。仔细看看就找出来就行了本回答被提问者采纳
第3个回答  2012-12-12
看看数据库和bean里面有没有这个字段呀

相关了解……

你可能感兴趣的内容

大家正在搜

本站内容来自于网友发表,不代表本站立场,仅表示其个人看法,不对其真实性、正确性、有效性作任何的担保
相关事宜请发邮件给我们
© 非常风气网