Question

用hibernate的Session的createQuery(sql).setParameter(0,"").iterate()方法后遍历返回Map报错？

sql语句：String sql = "
SELECT d.uid,d.uidViewModel,d.uidViewEntityDetail,d.uidControl,
d.strName,d.strText,d.strText_en,d.strDataType,d.uidRefer,
d.strReferType,d.strReferRule,d.strDefaultValue,d.isReadOnly,
d.isHidden,d.isNotNull,d.strPosition,d.intWidth,d.intHeight,
d.intTop,d.intLeft,d.intRadixPoint,d.isAmount,d.isFixLength,
d.strAmountRule,d.strFont,d.intColLength,d.intIndex,d.dg_isMutilSelect,
d.dg_isShowSelect,d.dg_isScrollView,d.dg_isColSortable,
c.strControlName,c.strControlText,e.uidQuery
FROM pl_viewModelDetail d
LEFT JOIN d.uidControl c
LEFT JOIN d.uidViewEntityDetail ed
LEFT JOIN ed.uidViewEntity e
WHERE d.uidViewModel.uid=? ORDER BY d.intIndex
";

错误如下：
java.lang.ClassCastException: [Ljava.lang.Object; cannot be cast to java.util.List
at tSinge.test.dao.Demo.testSysHbm(Demo.java:153)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
不明白什么原因？

Answer 1

java.lang.ClassCastException: [Ljava.lang.Object; cannot be cast to java.util.List

你返回的是object对象，你强制转换成list
类型转换错误