comparison tests/OnClientTester.java @ 607:69b0bcf5f62d

On failure do not forget to close the resultset resource first.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 23 Dec 2021 15:09:50 +0100 (2021-12-23)
parents 8e5dbe2ebe7d
children 6aa38e8c0f2d
comparison
equal deleted inserted replaced
606:f15df1ae41bc 607:69b0bcf5f62d
837 } 837 }
838 final ResultSet rs = stmt.getResultSet(); 838 final ResultSet rs = stmt.getResultSet();
839 final ResultSetMetaData metaData = rs.getMetaData(); 839 final ResultSetMetaData metaData = rs.getMetaData();
840 assertEq("column count", 1, metaData.getColumnCount()); 840 assertEq("column count", 1, metaData.getColumnCount());
841 if (!rs.next()) { 841 if (!rs.next()) {
842 rs.close();
842 fail("Result set is empty"); 843 fail("Result set is empty");
843 } 844 }
844 final int result = rs.getInt(1); 845 final int result = rs.getInt(1);
845 if (rs.next()) { 846 if (rs.next()) {
847 rs.close();
846 fail("Result set has more than one row"); 848 fail("Result set has more than one row");
847 } 849 }
848 rs.close(); 850 rs.close();
849 checked("row count", 1); 851 checked("row count", 1);
850 assertEq("query result", expected, result); 852 assertEq("query result", expected, result);
861 } 863 }
862 final ResultSet rs = stmt.getResultSet(); 864 final ResultSet rs = stmt.getResultSet();
863 final ResultSetMetaData metaData = rs.getMetaData(); 865 final ResultSetMetaData metaData = rs.getMetaData();
864 assertEq("column count", 1, metaData.getColumnCount()); 866 assertEq("column count", 1, metaData.getColumnCount());
865 if (!rs.next()) { 867 if (!rs.next()) {
868 rs.close();
866 fail("Result set is empty"); 869 fail("Result set is empty");
867 } 870 }
868 final String result = rs.getString(1); 871 final String result = rs.getString(1);
869 if (rs.next()) { 872 if (rs.next()) {
873 rs.close();
870 fail("Result set has more than one row"); 874 fail("Result set has more than one row");
871 } 875 }
872 rs.close(); 876 rs.close();
873 checked("row count", 1); 877 checked("row count", 1);
874 return result; 878 return result;