monetdb-java: ChangeLog annotate

annotate ChangeLog @ 427:e79bfbd0553e

Added support for escaped wildcards (\% en \_) in String arguments of DatabaseMetaData methods which return a ResultSet, such as getTables(), getColumns(), etc. When you do not want the characters % or _ to be interpreted as wildcards but as normal characters you can prefix them with a backslash (so \% and \_). Note: be sure all wildcards characters in the String argument are escaped else the search must still use a LIKE operator instead of an = comparison operator. This fixes: https://github.com/MonetDB/monetdb-java/issues/3

author	Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date	Wed, 03 Feb 2021 19:41:44 +0100 (2021-02-03)
parents	163b784aa93b
children	bc39810b3faa

rev	line source
89 a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 53 diff changeset	1 # ChangeLog file for monetdb-java
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	2 # This file is updated with Maddlog
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	3
427 e79bfbd0553e Added support for escaped wildcards (\% en \_) in String arguments of Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 421 diff changeset	4 * Wed Feb 3 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
e79bfbd0553e Added support for escaped wildcards (\% en \_) in String arguments of Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 421 diff changeset	5 - Added support for escaped wildcards (\% en \_) in String arguments of
e79bfbd0553e Added support for escaped wildcards (\% en \_) in String arguments of Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 421 diff changeset	6 DatabaseMetaData methods which return a ResultSet, such as getTables(),
e79bfbd0553e Added support for escaped wildcards (\% en \_) in String arguments of Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 421 diff changeset	7 getColumns(), etc. When you do not want the characters % or _ to be
e79bfbd0553e Added support for escaped wildcards (\% en \_) in String arguments of Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 421 diff changeset	8 interpreted as wildcards but as normal characters you can prefix them
e79bfbd0553e Added support for escaped wildcards (\% en \_) in String arguments of Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 421 diff changeset	9 with a backslash (so \% and \_). Note: be sure all wildcards characters
e79bfbd0553e Added support for escaped wildcards (\% en \_) in String arguments of Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 421 diff changeset	10 in the String argument are escaped else the search must still use a
e79bfbd0553e Added support for escaped wildcards (\% en \_) in String arguments of Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 421 diff changeset	11 LIKE operator instead of an = comparison operator.
e79bfbd0553e Added support for escaped wildcards (\% en \_) in String arguments of Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 421 diff changeset	12 This fixes: https://github.com/MonetDB/monetdb-java/issues/3
e79bfbd0553e Added support for escaped wildcards (\% en \_) in String arguments of Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 421 diff changeset	13
420 a0f99a81ce8e Extend the generation of FOREIGN KEY CONSTRAINTS with ON UPDATE and ON DELETE rules. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 419 diff changeset	14 * Thu Jan 28 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
421 163b784aa93b Added full ordering to correct issues when retrieving columns from fks where a table has multiple fks to the same table. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 420 diff changeset	15 - Corrected the ordering of the output of DatabaseMetaData methods
163b784aa93b Added full ordering to correct issues when retrieving columns from fks where a table has multiple fks to the same table. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 420 diff changeset	16 getImportedKeys(), getExportedKeys() and getCrossReference(). In cases
163b784aa93b Added full ordering to correct issues when retrieving columns from fks where a table has multiple fks to the same table. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 420 diff changeset	17 where a table would have multiple fks to the same external table,
163b784aa93b Added full ordering to correct issues when retrieving columns from fks where a table has multiple fks to the same table. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 420 diff changeset	18 the output was not as expected. This has been corrected, so the columns
163b784aa93b Added full ordering to correct issues when retrieving columns from fks where a table has multiple fks to the same table. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 420 diff changeset	19 now appear in the order as defined in the creation of the fks.
163b784aa93b Added full ordering to correct issues when retrieving columns from fks where a table has multiple fks to the same table. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 420 diff changeset	20
163b784aa93b Added full ordering to correct issues when retrieving columns from fks where a table has multiple fks to the same table. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 420 diff changeset	21 * Thu Jan 28 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
420 a0f99a81ce8e Extend the generation of FOREIGN KEY CONSTRAINTS with ON UPDATE and ON DELETE rules. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 419 diff changeset	22 - The dumping of table definitions from JdbcClient program has been
a0f99a81ce8e Extend the generation of FOREIGN KEY CONSTRAINTS with ON UPDATE and ON DELETE rules. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 419 diff changeset	23 improved. It now includes the ON UPDATE and ON DELETE rules for foreign
a0f99a81ce8e Extend the generation of FOREIGN KEY CONSTRAINTS with ON UPDATE and ON DELETE rules. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 419 diff changeset	24 key constraints. Also it no longer generates CREATE INDEX statements
a0f99a81ce8e Extend the generation of FOREIGN KEY CONSTRAINTS with ON UPDATE and ON DELETE rules. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 419 diff changeset	25 for foreign key constraints whose name is not system generated but
a0f99a81ce8e Extend the generation of FOREIGN KEY CONSTRAINTS with ON UPDATE and ON DELETE rules. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 419 diff changeset	26 user specified.
a0f99a81ce8e Extend the generation of FOREIGN KEY CONSTRAINTS with ON UPDATE and ON DELETE rules. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 419 diff changeset	27
415 50e43af49d47 Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 405 diff changeset	28 * Thu Jan 14 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
50e43af49d47 Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 405 diff changeset	29 - Improved DatabaseMetaData.getTypeInfo() output for temporal data
50e43af49d47 Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 405 diff changeset	30 types: sec_interval, day_interval, month_interval, date, time, timetz,
50e43af49d47 Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 405 diff changeset	31 timestamp and timestamptz.
50e43af49d47 Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 405 diff changeset	32
405 6242351e8802 Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 391 diff changeset	33 * Wed Jan 6 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
6242351e8802 Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 391 diff changeset	34 - Corrected output of resultset columns UPDATE_RULE and DELETE_RULE
6242351e8802 Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 391 diff changeset	35 when calling DatabaseMetaData API methods getImportedKeys() or
6242351e8802 Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 391 diff changeset	36 getExportedKeys() or getCrossReference(). These columns used to
6242351e8802 Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 391 diff changeset	37 always return DatabaseMetaData.importedKeyNoAction but now they
6242351e8802 Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 391 diff changeset	38 can also report the other values when set:
6242351e8802 Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 391 diff changeset	39 DatabaseMetaData.importedKeyCascade
6242351e8802 Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 391 diff changeset	40 or DatabaseMetaData.importedKeyRestrict
6242351e8802 Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 391 diff changeset	41 or DatabaseMetaData.importedKeySetNull
6242351e8802 Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 391 diff changeset	42 or DatabaseMetaData.importedKeySetDefault.
6242351e8802 Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 391 diff changeset	43
391 f523727db392 Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.* Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 386 diff changeset	44 * Thu Nov 12 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
f523727db392 Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.* Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 386 diff changeset	45 - Moved Java classes from packages starting with nl.cwi.monetdb.*
f523727db392 Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.* Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 386 diff changeset	46 to package org.monetdb.* This naming complies to the Java Package
f523727db392 Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.* Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 386 diff changeset	47 Naming convention as MonetDB's main website is www.monetdb.org.
f523727db392 Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.* Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 386 diff changeset	48 To prevent problems with existing Java programs and JDBC driver
f523727db392 Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.* Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 386 diff changeset	49 configurations we still support usage of the following classes:
f523727db392 Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.* Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 386 diff changeset	50 nl.cwi.monetdb.jdbc.MonetDriver
f523727db392 Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.* Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 386 diff changeset	51 nl.cwi.monetdb.jdbc.types.INET
f523727db392 Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.* Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 386 diff changeset	52 nl.cwi.monetdb.jdbc.types.URL
f523727db392 Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.* Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 386 diff changeset	53 nl.cwi.monetdb.mcl.net.MapiSocket
f523727db392 Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.* Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 386 diff changeset	54 nl.cwi.monetdb.client.JdbcClient
f523727db392 Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.* Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 386 diff changeset	55 They are implemented as simple wrappers of their org.monetdb.* equivalents.
415 50e43af49d47 Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 405 diff changeset	56 Note: These nl.cwi.monetdb.* classes are now marked as deprecated and may
50e43af49d47 Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 405 diff changeset	57 be removed in a future release. If you still use them in your Java code or
50e43af49d47 Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 405 diff changeset	58 configuration files, update them to use the new package names.
391 f523727db392 Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.* Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 386 diff changeset	59
386 15b87fd68052 Extended JdbcClient program with 3 new commands to quickly validate data integrity: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 383 diff changeset	60 * Thu Oct 29 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
15b87fd68052 Extended JdbcClient program with 3 new commands to quickly validate data integrity: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 383 diff changeset	61 - Extended JdbcClient program with 3 new commands to quickly validate
15b87fd68052 Extended JdbcClient program with 3 new commands to quickly validate data integrity: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 383 diff changeset	62 data integrity:
15b87fd68052 Extended JdbcClient program with 3 new commands to quickly validate data integrity: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 383 diff changeset	63 \vsci validate sql system catalog integrity
15b87fd68052 Extended JdbcClient program with 3 new commands to quickly validate data integrity: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 383 diff changeset	64 \vsi <schema> validate integrity of data in the given schema
15b87fd68052 Extended JdbcClient program with 3 new commands to quickly validate data integrity: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 383 diff changeset	65 \vdbi validate integrity of data in all user schemas in the database
15b87fd68052 Extended JdbcClient program with 3 new commands to quickly validate data integrity: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 383 diff changeset	66 The current validations include:
15b87fd68052 Extended JdbcClient program with 3 new commands to quickly validate data integrity: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 383 diff changeset	67 - Primary Key uniqueness
15b87fd68052 Extended JdbcClient program with 3 new commands to quickly validate data integrity: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 383 diff changeset	68 - Primary Key column(s) being NOT NULL (currently only for \vsci)
15b87fd68052 Extended JdbcClient program with 3 new commands to quickly validate data integrity: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 383 diff changeset	69 - Unique constraint uniqueness
419 d9f9e077cd03 Finish implementation of foreign key referential integrity checks for user tables. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 415 diff changeset	70 - Foreign Key referential integrity
386 15b87fd68052 Extended JdbcClient program with 3 new commands to quickly validate data integrity: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 383 diff changeset	71 - Column NOT NULL constraint
15b87fd68052 Extended JdbcClient program with 3 new commands to quickly validate data integrity: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 383 diff changeset	72 - Varchar(n) max length constraint
15b87fd68052 Extended JdbcClient program with 3 new commands to quickly validate data integrity: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 383 diff changeset	73 - Idem for char(n), clob(n), blob(n), json(n) and url(n).
415 50e43af49d47 Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 405 diff changeset	74 It can be usefull to run \vsci before and after an upgrade of MonetDB server.
386 15b87fd68052 Extended JdbcClient program with 3 new commands to quickly validate data integrity: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 383 diff changeset	75 Use \vsi my_schema to validate data in all tables of a specific schema.
15b87fd68052 Extended JdbcClient program with 3 new commands to quickly validate data integrity: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 383 diff changeset	76 Use \vdbi to validate integrity of data in all user schemas in
415 50e43af49d47 Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 405 diff changeset	77 the database. Note: this can take a while, depending on your number
50e43af49d47 Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 405 diff changeset	78 of user schemas, tables and tables sizes. Despite being tested on several
386 15b87fd68052 Extended JdbcClient program with 3 new commands to quickly validate data integrity: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 383 diff changeset	79 internal dbs the functionality is still beta, so you can get false
15b87fd68052 Extended JdbcClient program with 3 new commands to quickly validate data integrity: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 383 diff changeset	80 errors reported. If you encounter these let us know asap.
15b87fd68052 Extended JdbcClient program with 3 new commands to quickly validate data integrity: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 383 diff changeset	81
381 11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 380 diff changeset	82 * Thu Oct 8 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
383 19a5583a7b5f Improved performance of ResultSetMetaData methods isAutoIncrement(), getPrecision() and getScale() significant for columns of specific data types as in some cases no costly meta data query is executed anymore. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 381 diff changeset	83 - Improved performance of ResultSetMetaData methods isAutoIncrement(),
405 6242351e8802 Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 391 diff changeset	84 getPrecision() and getScale() significantly for columns of specific data
383 19a5583a7b5f Improved performance of ResultSetMetaData methods isAutoIncrement(), getPrecision() and getScale() significant for columns of specific data types as in some cases no costly meta data query is executed anymore. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 381 diff changeset	85 types as in some cases no costly meta data query is executed anymore.
415 50e43af49d47 Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 405 diff changeset	86
50e43af49d47 Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 405 diff changeset	87 * Thu Oct 8 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
381 11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 380 diff changeset	88 - The connection properties treat_clob_as_varchar and treat_blob_as_binary
11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 380 diff changeset	89 are now set to true by default within the JDBC driver. This is done
11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 380 diff changeset	90 as it results by default in less memory usage, (much) faster response
11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 380 diff changeset	91 and better user experience for many generic JDBC applications (like
11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 380 diff changeset	92 SQuirreL SQL, DBeaver, etc) when fetching data from CLOB or BLOB result
11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 380 diff changeset	93 columns. See release.txt for more information and how you can turn
11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 380 diff changeset	94 it off to get the old JDBC driver behavior if you require it.
11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 380 diff changeset	95
380 bf521f343172 Added support for new Java 8 java.sql.Types: Types.TIME_WITH_TIMEZONE and Types.TIMESTAMP_WITH_TIMEZONE. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 376 diff changeset	96 * Wed Oct 7 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
bf521f343172 Added support for new Java 8 java.sql.Types: Types.TIME_WITH_TIMEZONE and Types.TIMESTAMP_WITH_TIMEZONE. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 376 diff changeset	97 - Added support for new Java 8 java.sql.Types: Types.TIME_WITH_TIMEZONE and
bf521f343172 Added support for new Java 8 java.sql.Types: Types.TIME_WITH_TIMEZONE and Types.TIMESTAMP_WITH_TIMEZONE. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 376 diff changeset	98 Types.TIMESTAMP_WITH_TIMEZONE.
bf521f343172 Added support for new Java 8 java.sql.Types: Types.TIME_WITH_TIMEZONE and Types.TIMESTAMP_WITH_TIMEZONE. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 376 diff changeset	99
375 a229ac4e275c Corrected MonetDatabaseMetaData.getTypeInfo() Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 369 diff changeset	100 * Wed Sep 23 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
376 ffdc7b0e102d Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 375 diff changeset	101 - Updated JDBC driver to comply with JDBC 4.2 interface now we compile
ffdc7b0e102d Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 375 diff changeset	102 for Java 8. This includes:
ffdc7b0e102d Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 375 diff changeset	103 - adding 8 methods to MonetCallableStatement
ffdc7b0e102d Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 375 diff changeset	104 - adding 2 methods to MonetDatabaseMetaData
ffdc7b0e102d Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 375 diff changeset	105 - adding 3 methods to MonetPreparedStatement
ffdc7b0e102d Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 375 diff changeset	106 - adding 4 methods to MonetResultSet
ffdc7b0e102d Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 375 diff changeset	107 - adding 8 methods to MonetStatement
415 50e43af49d47 Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 405 diff changeset	108
50e43af49d47 Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 405 diff changeset	109 * Wed Sep 23 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
375 a229ac4e275c Corrected MonetDatabaseMetaData.getTypeInfo() Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 369 diff changeset	110 - Corrected MonetDatabaseMetaData.getTypeInfo()
376 ffdc7b0e102d Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 375 diff changeset	111 - The LITERAL_PREFIX column now includes the required casting name for
ffdc7b0e102d Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 375 diff changeset	112 types: clob, inet, json, url, uuid and blob.
ffdc7b0e102d Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 375 diff changeset	113 - The SEARCHABLE column now returns typePredBasic instead of typeSearchable
ffdc7b0e102d Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 375 diff changeset	114 for type: blob.
ffdc7b0e102d Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 375 diff changeset	115 - The AUTO_INCREMENT column now returns false for types: hugeint, decimal,
ffdc7b0e102d Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 375 diff changeset	116 oid and wrd.
375 a229ac4e275c Corrected MonetDatabaseMetaData.getTypeInfo() Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 369 diff changeset	117
363 34ce6e1b1be8 Remove support for deprecated MD5 encryption algorithm in MapiSocket. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 356 diff changeset	118 * Thu Sep 10 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
34ce6e1b1be8 Remove support for deprecated MD5 encryption algorithm in MapiSocket. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 356 diff changeset	119 - Removed support for deprecated MD5 encryption algorithm in MapiSocket.
34ce6e1b1be8 Remove support for deprecated MD5 encryption algorithm in MapiSocket. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 356 diff changeset	120
34ce6e1b1be8 Remove support for deprecated MD5 encryption algorithm in MapiSocket. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 356 diff changeset	121 * Wed Sep 9 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
34ce6e1b1be8 Remove support for deprecated MD5 encryption algorithm in MapiSocket. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 356 diff changeset	122 - Corrected Statement.executeBatch() method. It now implicitly clears the
34ce6e1b1be8 Remove support for deprecated MD5 encryption algorithm in MapiSocket. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 356 diff changeset	123 batch buffer, ready to accept new addBatch() calls without the need for
34ce6e1b1be8 Remove support for deprecated MD5 encryption algorithm in MapiSocket. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 356 diff changeset	124 an explicit clearBatch() call.
34ce6e1b1be8 Remove support for deprecated MD5 encryption algorithm in MapiSocket. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 356 diff changeset	125 See also https://www.monetdb.org/bugzilla/show_bug.cgi?id=6953
34ce6e1b1be8 Remove support for deprecated MD5 encryption algorithm in MapiSocket. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 356 diff changeset	126
356 eabbc5bf7cdb Corrected the return value of getCatalogTerm(); Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 354 diff changeset	127 * Wed Feb 19 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
eabbc5bf7cdb Corrected the return value of getCatalogTerm(); Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 354 diff changeset	128 - Corrected the return value of getCatalogTerm() to "cat".
eabbc5bf7cdb Corrected the return value of getCatalogTerm(); Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 354 diff changeset	129
354 b1f8750e6cde Switch to Java 8 compilation and distribution as Java 7 is no longer supported. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	130 * Wed Feb 12 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
b1f8750e6cde Switch to Java 8 compilation and distribution as Java 7 is no longer supported. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	131 - As Java 7 is no longer supported we now compile for Java 8 as the
b1f8750e6cde Switch to Java 8 compilation and distribution as Java 7 is no longer supported. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	132 minimum required JVM version (profile compact2).
b1f8750e6cde Switch to Java 8 compilation and distribution as Java 7 is no longer supported. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	133

Mercurial > hg > monetdb-java

annotate ChangeLog @ 427:e79bfbd0553e