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.