Author: sletellier Date: 2011-05-09 14:39:54 +0200 (Mon, 09 May 2011) New Revision: 869 Url: http://nuiton.org/repositories/revision/wikitty/869 Log: Fix tests : tables columns are in upper case in H2 Modified: trunk/wikitty-jdbc/src/main/java/org/nuiton/wikitty/jdbc/WikittyJDBCUtil.java Modified: trunk/wikitty-jdbc/src/main/java/org/nuiton/wikitty/jdbc/WikittyJDBCUtil.java =================================================================== --- trunk/wikitty-jdbc/src/main/java/org/nuiton/wikitty/jdbc/WikittyJDBCUtil.java 2011-05-09 10:33:48 UTC (rev 868) +++ trunk/wikitty-jdbc/src/main/java/org/nuiton/wikitty/jdbc/WikittyJDBCUtil.java 2011-05-09 12:39:54 UTC (rev 869) @@ -363,11 +363,14 @@ } public static boolean tableExist(Connection connection, String tableName) throws SQLException { + + // In postgres, tablenames are in lower case, in H2, is in upper case, so we test both DatabaseMetaData metaData = connection.getMetaData(); - ResultSet tables = metaData.getTables(null, null, tableName, null); + boolean existInLowerCase = metaData.getTables(null, null, tableName, null).next(); + boolean existInUpperCase = metaData.getTables(null, null, tableName.toUpperCase(), null).next(); - return tables.next(); + return existInLowerCase || existInUpperCase; } public static String getSupportedBinaryType(Connection connection) throws SQLException {