db2 resultSet关闭时提示结果集已关闭异常

db2 resultSet关闭时提示结果集已关闭异常

这个就是db2自己的行为特性，在所有行被取出来之后自动关闭。解决办法就是不去关闭它就好了。

Problem(Abstract)

After upgrading the JDBC driver from the Legacy JDBC Type 2 driver (db2java.zip) to the Data Server Driver for JDBC (db2jcc.jar) the following error now occurs “Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null”

Symptom

com.ibm.db2.jcc.am.SqlException: [jcc][t4][10120] [10898][4.11.77] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null

Cause

The IBM Data Server Driver for JDBC and SQLJ automatically closes the cursor when all rows have been retrieved from a ResultSet. When ResultSet.next is executed after the cursor is closed the SQLException is thrown. This behavior differs from the DB2 JDBC Type 2 drive where the cursor is not automatically closed upon retrieving all rows from a ResultSet.