hibernate oracle char character 只查出一个字符

canca

2010-03-20 00:54

public List queryTradeConfirmBusinFlag() {
final String sql = "select C_BUSINFLAG, C_BUSINNAME from tbusinflag";
return (List) getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException {
Query query = session.createSQLQuery(sql);
List<InitBusinFlag> list = query.list();
Iterator iter = list.iterator();
list = new ArrayList<InitBusinFlag>();
while(iter.hasNext()) {
Object[] obj = (Object[])iter.next();
InitBusinFlag businFlag = new InitBusinFlag();
businFlag.setBusinFlag(obj[0].toString());
businFlag.setBusinName(obj[1].toString());
list.add(businFlag);
}
logger.debug("读取交易确认查询交易类型数据成功...");
return list;
}
});
}

C_BUSINFLAG 只能查出一个字符来

C_BUSINFLAG 在oracle数据库中是char(2)类型

改成final String sql = "select cast(C_BUSINFLAG as varchar2(2)), C_BUSINNAME from tbusinflag";