DB2 操作无效：已关闭 result set。 ERRORCODE=-4470, SQLSTATE=null

int rowCount = 1;
while(rs.next())
{

millseconds=""+rs.getLong("millseconds");
email_send = rs.getInt("type_email");
sms_send = rs.getInt("type_sms");
group_temp = CD.doNull(rs.getString("group_no"));
basic_ok_temp = CD.doNull(rs.getString("basic_ok"));


group_name="";
if(group_temp.length()>0){
strsql="SELECT group_name from job_groups where group_no = ?";
psmt1 = con.prepareStatement(strsql);
psmt1.setString(1,group_temp);
rs1 = psmt1.executeQuery();
if(rs1.next())
group_name = rs1.getString("group_name");

rs1.close();
rs1 = null;
psmt1.close();
psmt1 = null;

}

解决方法：

   把资源关闭放

  rs1.close();
rs1 = null;
psmt1.close();
psmt1 = null;

放到while循环外，可能DB2不支持那么写吧！！希望对你有帮助