java hql in_[程序设计]在java中 hibernate 查询时用in 为什么超过1000条数据时就报错,用的是oracl...

}else{

age2 = idOrage.split("-");

hql="select t.employeeInformId from EmployeeArchivesHistory t where to_Char(t.historyDate,'yyyy-MM')=? and t."+str+" in("+

list.toString().replace("[", "").replace("]", "").replace("null", "")+") " +

"and (t.age between " + age2[0] + "and " +age2[1]+") and t.employeeState = 1";

emplyeeHistoryIds=this.find(hql,dateStr);

}

if(emplyeeHistoryIds !=null && emplyeeHistoryIds.size()>0){

viewEmployeeAllList = this.find("from ViewEmployeeArchivesAll t where t.id in" +

"("+emplyeeHistoryIds.toString().replace("[", "").replace("]", "").replace("null", "")+")");

//return emplyeeHistoryIds;

}