+
−# ChangeLog file for monetdb-java
+
−# This file is updated with Maddlog
+
−
+
−* Thu Oct 12 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Improved DatabaseMetaData.getSystemFunctions(). It now also returns
+
−  functions: current_sessionid, greatest, ifnull, least, sql_max, sql_min.
+
−  Function ifnull will only be returned for servers Jun2023 (11.47 or higher).
+
−
+
−* Wed Aug  9 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Implemented ResultSet methods:
+
−   <T> T getObject(int columnIndex, Class<T> type)
+
−   <T> T getObject(String columnLabel, Class<T> type)
+
−  They used to throw an SQLFeatureNotSupportedException.
+
−
+
−* Thu Jul  6 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Removed deprecated nl.cwi.monetdb.*.* classes and package.
+
−  Those classes were marked deprecated on 12 Nov 2020 from
+
−  release 3.0 (released on 17 Feb 2021) onwards. It includes:
+
−   nl.cwi.monetdb.client.JdbcClient.class
+
−   nl.cwi.monetdb.jdbc.MonetDriver.class
+
−   nl.cwi.monetdb.jdbc.types.INET.class
+
−   nl.cwi.monetdb.jdbc.types.URL.class
+
−   nl.cwi.monetdb.mcl.net.MapiSocket.class
+
−  These classes are now removed permanently.
+
−  Use the  org.monetdb.*  equivalents instead.
+
−
+
−* Thu Jul  6 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Removed code to support old MonetDB servers Oct2014 or older. Those
+
−  old servers did not yet have the system tables: sys.keywords and
+
−  sys.table_types which are introduced in Jul2015 release. Those system
+
−  tables are used by MonetDatabaseMetaData methods: getSQLKeywords(),
+
−  getTableTypes() and getTables(). These 3 methods will now fail when
+
−  used with those very old MonetDB servers.
+
−
+
−* Wed Jul  5 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Corrected implementation of Connection methods getClientInfo() and
+
−  setClientInfo(). They used to get/set Connection properties instead
+
−  of Client Info properties which was a incorrect. MonetDB does not
+
−  support Client Info properties.
+
−
+
−* Thu Jun 22 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Corrected DatabaseMetaData method getClientProperties().
+
−  It used to return connection properties instead of client info properties.
+
−
+
−* Thu May  4 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Corrected DatabaseMetaData method getStringFunctions() when connected
+
−  to Jun2023 server. It now includes the string functions from the new
+
−  txtsim module.
+
−
+
−* Thu Feb 23 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Compiled and released new jar files: monetdb-jdbc-3.3.jre8.jar and
+
−  jdbcclient.jre8.jar
+
−
+
−* Thu Feb  9 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Corrected DatabaseMetaData.getSQLKeywords() output. It used to return
+
−  all MonetDB SQL keywords, but now it excludes the SQL:2003 keywords
+
−  as defined by the Java JDBC API specification.
+
−
+
−* Thu Jan 19 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Corrected DatabaseMetaData.getUDTs() output. It used to return rows
+
−  for system types: inet, json, url and uuid. However those are not User
+
−  Defined Types. Now they are no longer returned by this method.
+
−
+
−* Thu Dec  8 2022 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
+
−- Internal method waitForPrompt() of class BufferedMCLReader has been
+
−  renamed to discardRemainder(). The example program SQLcopyinto.java
+
−  which uses this method, has been updated.
+
−
+
−* 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'.
+
−
+
−For a complete list of changes in previous monetdb-java releases see:
+
−  https://www.monetdb.org/downloads/Java/archive/ChangeLog-Archive
+
−