Mercurial > hg > monetdb-java
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; |