StringBuffer hql = new StringBuffer();
hql.append("from table a where a.foreignId = '");
hql.append(indexId + "' order by cast(a.columnOrder as int)");
List<table> cols = this.findByHql(hql.toString());
return cols;
cast(a.columnOrder as int)
StringBuffer hql = new StringBuffer();
hql.append("from table a where a.foreignId = '");
hql.append(indexId + "' order by cast(a.columnOrder as int)");
List<table> cols = this.findByHql(hql.toString());
return cols;
cast(a.columnOrder as int)