result set is closed. ERRORCODE=-4470, SQLSTATE=null
resultSetHoldability Specifies whether cursors remain open after a commit operation. The data type of this property is int. Valid values are:
Leave cursors open after a commit operation.
This value is not valid for a connection that is part of a distributed (XA) transaction.
Close cursors after a commit operation.
If downgradeHoldCursorsUnderXa is set to false, then an error is thrown for this scenario.
If downgradeHoldCursorsUnderXa is set to true, a cursor that is defined WITH HOLD can be opened under an XA connection. However, the cursor has the following restrictions: