Mercurial > hg > monetdb-java

comparison ChangeLog-Archive @ 445:8867403ec322

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add content of ChangeLog to ChangeLog-Archive
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Wed, 17 Feb 2021 21:03:40 +0100 (2021-02-17)
parents 71a79126a390
children 73cfc519ec1e
comparison
equal deleted inserted replaced
444:bc39810b3faa 445:8867403ec322
1 # ChangeLog-Archive file for monetdb-java 1 # ChangeLog-Archive file for monetdb-java
2 # This file contains all past monetdb-java ChangeLog entries 2 # This file contains all past monetdb-java ChangeLog entries
3 # For every new release the ChangeLog is prepended to this file. 3 # For every new release the ChangeLog is prepended to this file.
4
5 * Wed Feb 17 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
6 - Compiled and released new jar files: monetdb-jdbc-3.0.jre8.jar,
7 monetdb-mcl-1.19.jre8.jar and jdbcclient.jre8.jar
8
9 monetdb-jdbc-3.0.jre8.jar is a new major release of the MonetDB JDBC driver.
10 The MonetDB JDBC Driver is now compliant with the Javaâ„¢ Database
11 Connectivity (JDBC) 4.2 specification as defined in Java 8 and requires
12 Java 8 runtime (profile compact2) as minimum version.
13
14 Important: the MonetDB JDBC driver class name has also been changed in
15 this release to: org.monetdb.jdbc.MonetDriver. The old driver class
16 (nl.cwi.monetdb.jdbc.MonetDriver) is also included in the jar file, but
17 only to ease the transition for existing deployments. It will be removed
18 in a future release of this JDBC driver. Please use the new driver
19 class name if this is used in your configuration files or Java code.
20
21 The JdbcClient program (jdbcclient.jre8.jar) has been extended with
22 functionality to validate the integrity of the system tables (\vsci) or
23 to validate the integrity of data in tables of a specific schema (\vsi xyz)
24 based on defined declarative constraints (pkey, fkey, not null, etc.).
25 This will be usefull to find and report inconsistencies in your database.
26 This functionality is a beta release. Please let us know if you
27 encounter any issues running it. See below for more information.
28
29 Besides a few bug fixes also performance has been improved in multiple areas.
30
31 * Wed Feb 3 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
32 - Added support for escaped wildcards (\% en \_) in String arguments of
33 DatabaseMetaData methods which return a ResultSet, such as getTables(),
34 getColumns(), etc. When you do not want the characters % or _ to be
35 interpreted as wildcards but as normal characters you can prefix them
36 with a backslash (so \% and \_). Note: be sure all wildcards characters
37 in the String argument are escaped else the search must still use a
38 LIKE operator instead of an = comparison operator.
39 This fixes: https://github.com/MonetDB/monetdb-java/issues/3
40
41 * Thu Jan 28 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
42 - Corrected the ordering of the output of DatabaseMetaData methods
43 getImportedKeys(), getExportedKeys() and getCrossReference(). In cases
44 where a table would have multiple fks to the same external table,
45 the output was not as expected. This has been corrected, so the columns
46 now appear in the order as defined in the creation of the fks.
47
48 * Thu Jan 28 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
49 - The dumping of table definitions from JdbcClient program has been
50 improved. It now includes the ON UPDATE and ON DELETE rules for foreign
51 key constraints. Also it no longer generates CREATE INDEX statements
52 for foreign key constraints whose name is not system generated but
53 user specified.
54
55 * Thu Jan 14 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
56 - Improved DatabaseMetaData.getTypeInfo() output for temporal data
57 types: sec_interval, day_interval, month_interval, date, time, timetz,
58 timestamp and timestamptz.
59
60 * Wed Jan 6 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
61 - Corrected output of resultset columns UPDATE_RULE and DELETE_RULE
62 when calling DatabaseMetaData API methods getImportedKeys() or
63 getExportedKeys() or getCrossReference(). These columns used to
64 always return DatabaseMetaData.importedKeyNoAction but now they
65 can also report the other values when set:
66 DatabaseMetaData.importedKeyCascade
67 or DatabaseMetaData.importedKeyRestrict
68 or DatabaseMetaData.importedKeySetNull
69 or DatabaseMetaData.importedKeySetDefault.
70
71 * Thu Nov 12 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
72 - Moved Java classes from packages starting with nl.cwi.monetdb.*
73 to package org.monetdb.* This naming complies to the Java Package
74 Naming convention as MonetDB's main website is www.monetdb.org.
75 To prevent problems with existing Java programs and JDBC driver
76 configurations we still support usage of the following classes:
77 nl.cwi.monetdb.jdbc.MonetDriver
78 nl.cwi.monetdb.jdbc.types.INET
79 nl.cwi.monetdb.jdbc.types.URL
80 nl.cwi.monetdb.mcl.net.MapiSocket
81 nl.cwi.monetdb.client.JdbcClient
82 They are implemented as simple wrappers of their org.monetdb.* equivalents.
83 Note: These nl.cwi.monetdb.* classes are now marked as deprecated and may
84 be removed in a future release. If you still use them in your Java code or
85 configuration files, update them to use the new package names.
86
87 * Thu Oct 29 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
88 - Extended JdbcClient program with 3 new commands to quickly validate
89 data integrity:
90 \vsci validate sql system catalog integrity
91 \vsi <schema> validate integrity of data in the given schema
92 \vdbi validate integrity of data in all user schemas in the database
93 The current validations include:
94 - Primary Key uniqueness
95 - Primary Key column(s) being NOT NULL (currently only for \vsci)
96 - Unique constraint uniqueness
97 - Foreign Key referential integrity
98 - Column NOT NULL constraint
99 - Varchar(n) max length constraint
100 - Idem for char(n), clob(n), blob(n), json(n) and url(n).
101 It can be usefull to run \vsci before and after an upgrade of MonetDB server.
102 Use \vsi my_schema to validate data in all tables of a specific schema.
103 Use \vdbi to validate integrity of data in all user schemas in
104 the database. Note: this can take a while, depending on your number
105 of user schemas, tables, columns and rows. Despite being tested on several
106 internal dbs the functionality is still beta, so you can get false
107 errors reported. If you encounter any let us know asap.
108
109 * Thu Oct 8 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
110 - Improved performance of ResultSetMetaData methods isAutoIncrement(),
111 getPrecision() and getScale() significantly for columns of specific data
112 types as in some cases no costly meta data query is executed anymore.
113
114 * Thu Oct 8 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
115 - The connection properties treat_clob_as_varchar and treat_blob_as_binary
116 are now set to true by default within the JDBC driver. This is done
117 as it results by default in less memory usage, (much) faster response
118 and better user experience for many generic JDBC applications (like
119 SQuirreL SQL, DBeaver, etc) when fetching data from CLOB or BLOB result
120 columns. See release.txt for more information and how you can turn
121 it off to get the old JDBC driver behavior if you require it.
122
123 * Wed Oct 7 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
124 - Added support for new Java 8 java.sql.Types: Types.TIME_WITH_TIMEZONE and
125 Types.TIMESTAMP_WITH_TIMEZONE.
126
127 * Wed Sep 23 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
128 - Updated JDBC driver to comply with JDBC 4.2 interface now we compile
129 for Java 8. This includes:
130 - adding 8 methods to MonetCallableStatement
131 - adding 2 methods to MonetDatabaseMetaData
132 - adding 3 methods to MonetPreparedStatement
133 - adding 4 methods to MonetResultSet
134 - adding 8 methods to MonetStatement
135
136 * Wed Sep 23 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
137 - Corrected MonetDatabaseMetaData.getTypeInfo()
138 - The LITERAL_PREFIX column now includes the required casting name for
139 types: clob, inet, json, url, uuid and blob.
140 - The SEARCHABLE column now returns typePredBasic instead of typeSearchable
141 for type: blob.
142 - The AUTO_INCREMENT column now returns false for types: hugeint, decimal,
143 oid and wrd.
144
145 * Thu Sep 10 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
146 - Removed support for deprecated MD5 encryption algorithm in MapiSocket.
147
148 * Wed Sep 9 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
149 - Corrected Statement.executeBatch() method. It now implicitly clears the
150 batch buffer, ready to accept new addBatch() calls without the need for
151 an explicit clearBatch() call.
152 See also https://www.monetdb.org/bugzilla/show_bug.cgi?id=6953
153
154 * Wed Feb 19 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
155 - Corrected the return value of getCatalogTerm() to "cat".
156
157 * Wed Feb 12 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
158 - As Java 7 is no longer supported we now compile for Java 8 as the
159 minimum required JVM version (profile compact2).
4 160
5 * Thu Sep 26 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> 161 * Thu Sep 26 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
6 - Compiled and released new jar files: monetdb-jdbc-2.29.jre7.jar, 162 - Compiled and released new jar files: monetdb-jdbc-2.29.jre7.jar,
7 monetdb-mcl-1.18.jre7.jar and jdbcclient.jre7.jar 163 monetdb-mcl-1.18.jre7.jar and jdbcclient.jre7.jar
8 - Following issues are resolved with this new MonetDB JDBC driver release: 164 - Following issues are resolved with this new MonetDB JDBC driver release: