Mercurial > hg > monetdb-java

comparison src/main/java/org/monetdb/jdbc/MonetDriver.java.in @ 642:dd9b4fb14256

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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 06d69b82d409
children 108123ca6889
comparison
equal deleted inserted replaced
641:fac0ed642af2 642:dd9b4fb14256
350 typeMap.put("oid", Integer.valueOf(Types.BIGINT)); 350 typeMap.put("oid", Integer.valueOf(Types.BIGINT));
351 // typeMap.put("ptr", Integer.valueOf(Types.???)); 351 // typeMap.put("ptr", Integer.valueOf(Types.???));
352 typeMap.put("real", Integer.valueOf(Types.REAL)); 352 typeMap.put("real", Integer.valueOf(Types.REAL));
353 typeMap.put("sec_interval", Integer.valueOf(Types.DECIMAL)); 353 typeMap.put("sec_interval", Integer.valueOf(Types.DECIMAL));
354 typeMap.put("smallint", Integer.valueOf(Types.SMALLINT)); 354 typeMap.put("smallint", Integer.valueOf(Types.SMALLINT));
355 typeMap.put("str", Integer.valueOf(Types.VARCHAR)); // MonetDB prepare <stmt> uses type 'str' (instead of varchar) for the schema, table and column metadata output 355 typeMap.put("str", Integer.valueOf(Types.VARCHAR)); // MonetDB prepare <stmt> uses type 'str' (instead of varchar) for the schema, table and column metadata output. DO NOT REMOVE this entry!
356 // typeMap.put("table", Integer.valueOf(Types.???)); 356 // typeMap.put("table", Integer.valueOf(Types.???));
357 typeMap.put("time", Integer.valueOf(Types.TIME)); 357 typeMap.put("time", Integer.valueOf(Types.TIME));
358 typeMap.put("timestamp", Integer.valueOf(Types.TIMESTAMP)); 358 typeMap.put("timestamp", Integer.valueOf(Types.TIMESTAMP));
359 typeMap.put("timestamptz", Integer.valueOf(Types.TIMESTAMP_WITH_TIMEZONE)); // new in Java 8: Types.TIMESTAMP_WITH_TIMEZONE (value 2014) 359 typeMap.put("timestamptz", Integer.valueOf(Types.TIMESTAMP_WITH_TIMEZONE)); // new in Java 8: Types.TIMESTAMP_WITH_TIMEZONE (value 2014)
360 typeMap.put("timetz", Integer.valueOf(Types.TIME_WITH_TIMEZONE)); // new in Java 8: Types.TIME_WITH_TIMEZONE (value 2013) 360 typeMap.put("timetz", Integer.valueOf(Types.TIME_WITH_TIMEZONE)); // new in Java 8: Types.TIME_WITH_TIMEZONE (value 2013)
361 typeMap.put("tinyint", Integer.valueOf(Types.TINYINT)); 361 typeMap.put("tinyint", Integer.valueOf(Types.TINYINT));
362 typeMap.put("url", Integer.valueOf(Types.VARCHAR)); 362 typeMap.put("url", Integer.valueOf(Types.VARCHAR));
363 typeMap.put("uuid", Integer.valueOf(Types.VARCHAR)); 363 typeMap.put("uuid", Integer.valueOf(Types.VARCHAR));
364 typeMap.put("varchar", Integer.valueOf(Types.VARCHAR)); 364 typeMap.put("varchar", Integer.valueOf(Types.VARCHAR));
365 typeMap.put("wrd", Integer.valueOf(Types.BIGINT)); // keep it in for older MonetDB servers 365 typeMap.put("wrd", Integer.valueOf(Types.BIGINT)); // keep it in for old (pre Dec2016) MonetDB servers
366 typeMap.put("xml", Integer.valueOf(Types.VARCHAR)); // used when "CREATE TYPE xml EXTERNAL NAME xml;" is executed
366 } 367 }
367 368
368 /** 369 /**
369 * Returns the java.sql.Types equivalent of the given MonetDB type name. 370 * Returns the java.sql.Types equivalent of the given MonetDB type name.
370 * 371 *