Mercurial > hg > monetdb-java
diff tests/JDBC_API_Tester.java @ 642:dd9b4fb14256
Added recognition of 'xml' type.
Use default mapping to Types.VARCHAR for easy and fast (as java.lang.String) retrieval, display and setting data of columns of type 'xml'.
| author | Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
|---|---|
| date | Thu, 10 Feb 2022 15:12:30 +0100 (2022-02-10) |
| parents | fac0ed642af2 |
| children | 1f444b5ad7d2 |
line wrap: on
line diff
--- a/tests/JDBC_API_Tester.java +++ b/tests/JDBC_API_Tester.java @@ -690,6 +690,14 @@ final public class JDBC_API_Tester { } try { + int response = stmt.executeUpdate("CREATE TYPE xml EXTERNAL NAME xml"); + if (response != Statement.SUCCESS_NO_INFO) + sb.append("Creating type xml failed to return -2!! It returned: " + response + "\n"); + } catch (SQLException e) { + sb.append("failed to create type xml: ").append(e.getMessage()); + } + + try { DatabaseMetaData dbmd = con.getMetaData(); // inspect the catalog by use of dbmd functions @@ -780,7 +788,8 @@ final public class JDBC_API_Tester { "null sys inet org.monetdb.jdbc.types.INET 2000 inet null\n" + "null sys json java.lang.String 2000 json null\n" + "null sys url org.monetdb.jdbc.types.URL 2000 url null\n" + - "null sys uuid java.lang.String 2000 uuid null\n"); + "null sys uuid java.lang.String 2000 uuid null\n" + + "null sys xml java.lang.String 2000 xml null\n"); int[] UDTtypes = { Types.STRUCT, Types.DISTINCT }; compareResultSet(dbmd.getUDTs(null, "sys", null, UDTtypes), "getUDTs(null, sys, null, UDTtypes",