mysql Hibernate 查询时用别名报错

0 0

mysql Hibernate 查询时用别名报错5

注意,我用的不是hql,是纯Sql的.
SELECT ROLE_ID ,SNAME FROM SYS_ROLE ORDER BY ROLE_ID
去掉别名,代码执行是正常的,加上别名,代码执行报错,晕.但工具中执行正常.
大神快来,帮帮.

Hibernate: SELECT ROLE_ID AS VALUE,SNAME AS TEST FROM SYS_ROLE ORDER BY ROLE_ID
[INFO ] 2014-07-27 09:53:17,993 org.hibernate.type.NullableType.nullSafeGet(NullableType.java:182) 479634 -could not read column value from result set: ROLE_ID; Column 'ROLE_ID' not found.
[WARN ] 2014-07-27 09:53:17,993 org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:77) 479634 -SQL Error: 0, SQLState: S0022
[ERROR] 2014-07-27 09:53:17,993 org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:78) 479634 -Column 'ROLE_ID' not found.

public List<Map<String, Object>> listAllRoleCombox() {

String sql = "SELECT ROLE_ID AS VALUE,SNAME AS TEST FROM SYS_ROLE ORDER BY ROLE_ID";
logger.info("获取所有角色sql ：" +sql);
List<Map<String, Object>> list = roleDao.executeByPage(sql);
return list;
}

public <T> List<T> executeByPage(final String sqlName) {

Object o = this.getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
Query query = session.createSQLQuery(sqlName);
query.setCacheable(false);
return query.setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP).list();
}
});
return (List<T>) o;
}

Hibernate

2014年7月27日 09:55

ycy1003757
25
0 0 2

5个答案按时间排序按投票排序

0 0

SELECT ROLE_ID AS VALUE,SNAME AS TEST FROM SYS_ROLE ORDER BY VALUE

2014年7月28日 20:45

hw_imxy
2
0 0 8

添加评论

0 0

用AliasToEntityMapResultTransformer 试试吧

Query query = session.createSQLQuery(sqlName); 
query.setCacheable(false); 
return query.setResultTransformer(AliasToEntityMapResultTransformer.INSTANCE).list();

2014年7月27日 23:20