diff options
Diffstat (limited to 'src/interfaces/jdbc/org/postgresql/test/TestUtil.java')
| -rw-r--r-- | src/interfaces/jdbc/org/postgresql/test/TestUtil.java | 39 |
1 files changed, 38 insertions, 1 deletions
diff --git a/src/interfaces/jdbc/org/postgresql/test/TestUtil.java b/src/interfaces/jdbc/org/postgresql/test/TestUtil.java index fc8dc70deb..930215ed38 100644 --- a/src/interfaces/jdbc/org/postgresql/test/TestUtil.java +++ b/src/interfaces/jdbc/org/postgresql/test/TestUtil.java @@ -110,7 +110,7 @@ public class TestUtil try { String sql = "DROP TABLE " + table; - if (con instanceof org.postgresql.jdbc1.AbstractJdbc1Connection && ((org.postgresql.jdbc1.AbstractJdbc1Connection)con).haveMinimumServerVersion("7.3")) { + if (haveMinimumServerVersion(con,"7.3")) { sql += " CASCADE "; } stmt.executeUpdate(sql); @@ -190,4 +190,41 @@ public class TestUtil String s = "0000000000".substring(0, l) + Integer.toString(v); return s.substring(s.length() - l); } + + /** + * Determine if the given connection is connected to a server with + * a version of at least the given version. + * This is convenient because we are working with a java.sql.Connection, + * not an Postgres connection. + */ + public static boolean haveMinimumServerVersion(Connection con, String version) throws SQLException { + if (con instanceof org.postgresql.jdbc1.AbstractJdbc1Connection) { + return ((org.postgresql.jdbc1.AbstractJdbc1Connection)con).haveMinimumServerVersion(version); + } + return false; + } + + /** + * Print a ResultSet to System.out. + * This is useful for debugging tests. + */ + public static void printResultSet(ResultSet rs) throws SQLException { + ResultSetMetaData rsmd = rs.getMetaData(); + for (int i=1; i<=rsmd.getColumnCount(); i++) { + if (i != 1) { + System.out.print(", "); + } + System.out.print(rsmd.getColumnName(i)); + } + System.out.println(); + while (rs.next()) { + for (int i=1; i<=rsmd.getColumnCount(); i++) { + if (i != 1) { + System.out.print(", "); + } + System.out.print(rs.getString(i)); + } + System.out.println(); + } + } } |
