Mercurial > hg > monetdb-java
changeset 135:f638f5257b2e
Make Test_Dobjects independent of list of tables in sys schema.
This allows the JDBC test Test_Dobjects to run on all platforms, not just the ones which have NetCDF and Geom installed.
Instead it now lists the tables of schema tmp which are available and the same on all platforms.
Also removed dead code and improved code of dumpResultSet(ResultSet rs).
author | Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
---|---|
date | Thu, 13 Jul 2017 17:11:06 +0200 (2017-07-13) |
parents | 92a1b08a1018 |
children | 4320e6891536 |
files | tests/Test_Dobjects.java |
diffstat | 1 files changed, 7 insertions(+), 9 deletions(-) [+] |
line wrap: on
line diff
--- a/tests/Test_Dobjects.java +++ b/tests/Test_Dobjects.java @@ -7,37 +7,36 @@ */ import java.sql.*; -import java.util.*; public class Test_Dobjects { private static void dumpResultSet(ResultSet rs) throws SQLException { ResultSetMetaData rsmd = rs.getMetaData(); - System.out.println("Resultset with " + rsmd.getColumnCount() + " columns"); - for (int col = 1; col <= rsmd.getColumnCount(); col++) { + int columnCount = rsmd.getColumnCount(); + System.out.println("Resultset with " + columnCount + " columns"); + for (int col = 1; col <= columnCount; col++) { System.out.print(rsmd.getColumnName(col) + "\t"); } System.out.println(); while (rs.next()) { - for (int col = 1; col <= rsmd.getColumnCount(); col++) { + for (int col = 1; col <= columnCount; col++) { System.out.print(rs.getString(col) + "\t"); } System.out.println(); } + rs.close(); } public static void main(String[] args) throws Exception { // Class.forName("nl.cwi.monetdb.jdbc.MonetDriver"); // not needed anymore for self registering JDBC drivers Connection con = DriverManager.getConnection(args[0]); - Statement stmt = con.createStatement(); - PreparedStatement pstmt; DatabaseMetaData dbmd = con.getMetaData(); - try { // inspect the catalog by use of dbmd functions dumpResultSet(dbmd.getCatalogs()); // dumpResultSet(dbmd.getSchemas()); // this produces different outputs on different platforms due to dependency on SAMTOOLS and NETCDF. so exclude it dumpResultSet(dbmd.getSchemas(null, "sys")); - dumpResultSet(dbmd.getTables(null, "sys", null, null)); +// dumpResultSet(dbmd.getTables(null, "sys", null, null)); // this produces different outputs on different platforms due to dependency on Geom and NETCDF. + dumpResultSet(dbmd.getTables(null, "tmp", null, null)); // schema tmp has 6 tables dumpResultSet(dbmd.getUDTs(null, "sys", null, null)); int[] UDTtypes = { Types.STRUCT, Types.DISTINCT }; dumpResultSet(dbmd.getUDTs(null, "sys", null, UDTtypes)); @@ -45,7 +44,6 @@ public class Test_Dobjects { System.out.println("FAILED :( "+ e.getMessage()); System.out.println("ABORTING TEST!!!"); } - con.close(); } }