+
−# ChangeLog file for monetdb-java
+
−# This file is updated with Maddlog
+
−
+
−* Thu Nov 17 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Fixed an invalid error issue when a PreparedStatement had more than 250
+
−  parameters. See also  https://github.com/MonetDB/MonetDB/issues/7337
+
−
+
−* Thu Nov  3 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Corrected returned SQL TypeName values for the MonetDB interval types:
+
−  'day_interval', 'month_interval' and 'sec_interval'.  Those MonetDB
+
−  type names can not be used in CREATE TABLE statements. Instead
+
−  one has to use SQL type names: 'interval day', 'interval month' or
+
−  'interval second'. The JDBC driver now returns those SQL type names.
+
−  This applies to methods: DatabaseMetaData.getTypeInfo() for the output
+
−  column TYPE_NAME (the output column LOCAL_TYPE_NAME now returns
+
−  the original type name), ResultSetMetaData.getColumnTypeName() and
+
−  ParameterMetaData.getParameterTypeName().
+
−
+
−* Thu Oct 27 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Corrected PreparedStatement methods getMetaData().getColumnDisplaySize(),
+
−  getMetaData().getPrecision() and getParameterMetaData().getPrecision().
+
−
+
−* Thu Oct 20 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Improved implementation of method ResultSetMetaData.getPrecision(). It
+
−  now returns more accurate values for columns of type DECIMAL, NUMERIC,
+
−  CHAR, VARCHAR, CLOB, JSON, URL and BLOB.
+
−- Improved implementation of method ResultSetMetaData.getScale(). It now
+
−  returns more accurate values for columns of type DECIMAL and NUMERIC.
+
−
+
−* Thu Sep 29 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Removed creation and distribution of monetdb-mcl-1.##.jre8.jar file.
+
−  Programmers who used this jar file should use monetdb-jdbc-3.#.jre8.jar file.
+
−
+
−* Fri Sep 09 2022 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
+
−- Add autocommit=true/false option to the JDBC URL. The default remains 'true'.
+
−
+
−* Wed Aug 24 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Improved DatabaseMetaData.getBestRowIdentifier(). When there are multiple
+
−  unique constraints and no pkey for a table it used to return the columns
+
−  of all the table unique constraints. Now it only returns the columns of
+
−  the first table unique constraint.
+
−  Also optimized the performance of getBestRowIdentifier(). It used to
+
−  send a separate query first to find out if the table had a pkey or not.
+
−  This extra query is now integrated so less queries are send to the server.
+
−
+
−* Wed Mar 30 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Corrected DatabaseMetaData methods getPrimaryKeys(), getBestRowIdentifier()
+
−  and getIndexInfo() for local temporary tables located in schema tmp. They
+
−  did not return any rows when the temp table had a primary or unique key or
+
−  index. Now they do return rows as expected.
+
−
+
−* Thu Feb 10 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- 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'.
+
−
+
−* Thu Jan 27 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Compiled and released new jar files: monetdb-jdbc-3.2.jre8.jar,
+
−  monetdb-mcl-1.21.jre8.jar and jdbcclient.jre8.jar
+
−
+
−* Wed Jan 19 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Fixed an SQL query problem in DatabaseMetaData.getBestRowIdentifier()
+
−  method when used with MonetDB Jan2022 (or newer) releases. It
+
−  returned java.sql.SQLException:
+
−   SELECT: with DISTINCT ORDER BY expressions must appear in select list
+
−  As of MonetDB Jan2022 (11.43.5) such queries are no longer allowed.
+
−  The internally used SQL query has been improved.
+
−
+
−* Thu Jan 13 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Extended JdbcClient application with support for following \d commands:
+
−    \dt  \dv  \dSt  \dSv  \df  \dp  \dSf  \dSp  \dn  \dSn  and  \ds
+
−  for showing list of: user tables, user views, system tables, system views,
+
−  user functions, user procedures, system functions, system procedures,
+
−  user schemas, system schemas and user sequences.
+
−  For more information, see the built-in help (\?) on available commands.
+
−
+
−* Thu Nov 25 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Extended FileTransferHandler utility class by adding support for reading from
+
−  and writing to gzip compressed files when using file name extension .gz
+
−  Also improve error handling by testing on empty file name and provide more
+
−  information when invalid file name is given or other compression formats are
+
−  requested. As the FileTransferHandler utility class is used by JdbcClient
+
−  application, it will now also support this functionality.
+
−
+
−* Fri Nov 05 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- The JdbcClient application has been extended to support the new
+
−    COPY ... ON CLIENT functionality.
+
−  However for security reasons you must provide an explicit new startup argument
+
−    --csvdir "/absolute/path/to/csvdatafiles"
+
−  or on MS Windows
+
−    --csvdir "C:\\path\\to\\csvdatafiles"
+
−  in order to activate the JdbcClient application to down/up load data to/from
+
−  the local file system.
+
−
+
−* Fri Nov 05 2021 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
+
−- Extended the MonetDB JDBC driver with support for the ON CLIENT clause of
+
−  the COPY statements. To make use of this functionality you must first
+
−  register handlers for upload and download of data.
+
−  The MonetConnection class has been extended with 2 methods:
+
−    public void setUploadHandler(UploadHandler uploadHandler)
+
−    public void setDownloadHandler(DownloadHandler downloadHandler)
+
−  The MonetDB JDBC driver API has been extended with interfaces:
+
−    public interface org.monetdb.jdbc.MonetConnection.UploadHandler
+
−    public interface org.monetdb.jdbc.MonetConnection.DownloadHandler
+
−  See onclient.txt for more information on how to use these from Java.
+
−  We also provide a utility class:
+
−    public class org.monetdb.util.FileTransferHandler
+
−  which provides an example implementation of the MonetConnection.UploadHandler
+
−  and MonetConnection.DownloadHandler interfaces useable for reading files
+
−  from or writing files to a local file system.
+
−
+
−For a complete list of changes in previous monetdb-java releases see:
+
−  https://www.monetdb.org/downloads/Java/archive/ChangeLog-Archive
+
−