Page 1 of 1
Getting an error when running JDBC_FreeResult(results)
Posted: Wed Dec 11, 2024 10:36 pm
by Angel.Bermudez
When I execute JDBC_FreeResult(results) (results has a valid address). I get the error -- DBGP0003E Program received unmonitored exception RNX0301: Java exception received when calling Java method. when it is executing stmt = rs_getStatement(rs);
Do I need to run JDBC_FreeResult()?
Re: Getting an error when running JDBC_FreeResult(results)
Posted: Thu Dec 12, 2024 2:16 pm
by Angel.Bermudez
I see what the issue is. In the code below when IsResultSet = JDBC_getMoreResults( callStmt ); is executed
and IsResultSet becomes false rs is no longer pointing to a result set and need not be freed.
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
dow IsResultSet;
rs = JDBC_getResultSet( callStmt );
dow JDBC_nextRow(rs);
DL_Count_res.logId = %int(JDBC_getCol(rs: 1));
DL_Count_res.process = JDBC_getCol(rs: 2);
DL_Count_res.pdfCount = %int(JDBC_getCol(rs: 3));
DL_Count_res.attachmentCount = %int(JDBC_getCol(rs: 4));
DL_Count_res.extracted = %int(JDBC_getCol(rs: 5));
DL_Count_res.processStart = JDBC_getCol(rs: 6);
DL_Count_res.processEnd = JDBC_getCol(rs: 7);
DL_Count_res.runTime = JDBC_getCol(rs: 8);
DL_Count_res.extractStart = JDBC_getCol(rs: 9);
DL_Count_res.extractEnd = JDBC_getCol(rs: 10);
DL_Count_res.extractTime = JDBC_getCol(rs: 11);
DL_Count_res.mergeStart = JDBC_getCol(rs: 12);
DL_Count_res.mergeEnd = JDBC_getCol(rs: 13);
DL_Count_res.timeTime = JDBC_getCol(rs: 14);
enddo;
IsResultSet = JDBC_getMoreResults( callStmt );
enddo;
FreeResult();
FreeCallStmt();
\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/