hibernate使用select ifnull报错但是在mysql直接运行没问题
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB原创
- 2016-06-06 09:35:171614浏览
mysqlselecthibernate
<code> String sql = "select ifnull(pushtoken,0) from user where id="+user.getId(); Session session = this.getHibernateTemplate().getSessionFactory() .openSession(); Query q = session.createSQLQuery(sql); List list = q.list(); 查询的时候报错</code>
[10:40:59|INFO |(org.hibernate.type.StringType)]=[could not read column value from result set: ; Column '' not found.]
[10:40:59|WARN |(org.hibernate.util.JDBCExceptionReporter)]=[SQL Error: 0, SQLState: S0022]
[10:40:59|ERROR|(org.hibernate.util.JDBCExceptionReporter)]=[Column '' not found.]
org.hibernate.exception.SQLGrammarException: could not execute query
声明：
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn