hibernate查询带有text数据类型的表时,只要text字段为null,则整条记录都为null。为什么会出现这种情况,怎么解决?
是通过hql查询的。
hql如下:
String hql="from WorkflowManager wm where wm.id.objid=64";
//==========================WorkflowFormdetailinfo
public class WorkflowFormdetailinfo implements java.io.Serializable {
private static final long serialVersionUID = 8846869441129102056L;
private WorkflowFormdetailinfoId id;
}
//==========================WorkflowManagerId
public class WorkflowManagerId implements java.io.Serializable {
private static final long serialVersionUID = -5671604519961286913L;
private Integer objid;
private Integer objtype;
private String managers; //数据库中该字段为text类型
}
//===========================实体映射
//==================table result
objid objtype managers
int int text
64 2 NULL
//=====================================================
查询时因为text数据类型的managers字段为空,导致list内整条记录为空。取到[null].
我想要即使managers为空也能取到其他的值.