# HG changeset patch
# User Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
# Date 1622581458 -7200
# Node ID e239f02fe8b66f97bb2cb0b69c6540afb2c82a70
# Parent  0e30bc245838610d2e15e08962721ed8a6ed3c64
Add code to close the resultset after use to free resources on the server.

diff --git a/tests/JDBC_API_Tester.java b/tests/JDBC_API_Tester.java
--- a/tests/JDBC_API_Tester.java
+++ b/tests/JDBC_API_Tester.java
@@ -829,10 +829,13 @@ final public class JDBC_API_Tester {
 			stmt = con.createStatement();
 			// query sys.types to find out if sql datatype hugeint is supported
 			rs = stmt.executeQuery("SELECT sqlname from sys.types where sqlname = 'hugeint';");
-			if (rs != null && rs.next()) {
-				String sqlname = rs.getString(1);
-				if ("hugeint".equals(sqlname))
-					supportsHugeInt = true;
+			if (rs != null) {
+				if (rs.next()) {
+					if ("hugeint".equals(rs.getString(1)))
+						supportsHugeInt = true;
+				}
+				rs.close();
+				rs = null;
 			}
 		} catch (SQLException e) {
 			sb.append("FAILED: ").append(e.getMessage()).append("\n");