+
−# ChangeLog file for monetdb-java
+
−# This file is updated with Maddlog
+
−
+
−* Thu Feb 13 2025 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Corrected the returned integer values of Statement methods
+
−  getUpdateCount() and getLargeUpdateCount(). They returned -2 for
+
−  DDL statements, which was not in compliance with the JDBC API
+
−  documentation. Now they no longer return numbers smaller than -1.
+
−- Corrected the returned integer values of Statement methods
+
−  executeUpdate(...) and executeLargeUpdate(...) and PreparedStatement
+
−  methods executeUpdate() and executeLargeUpdate(). They returned -2 for
+
−  DDL statements, which was not in compliance with the JDBC API
+
−  documentation. Now they no longer return negative numbers.
+
−
+
−* Wed Feb 12 2025 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Fix a bug in DatabaseMetaData.getTables() where a provided string in the
+
−  array of table types argument would contain a single quote or back slash.
+
−  It was not escaped properly, resulting in an SQL syntax error.
+
−- Fix missing escaping of single back slashes in string data provided to
+
−  PreparedStatement methods setString(), setClob(), setObject() and setURL().
+
−
+
−* Thu Jan 16 2025 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- The release version number has been bumped to 12.0 to avoid confusion
+
−  with historic 11.x versions.
+
−- Compiled and released new jar files: monetdb-jdbc-12.0.jre8.jar and
+
−  jdbcclient.jre8.jar
+
−
+
−* Wed Jan  8 2025 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
+
−- The JDBC jar now includes JdbcClient. For backward compatibility the jar
+
−  is still also available as jdbcclient.jreX.jar.
+
−
+
−* Thu Nov  7 2024 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- In JdbcClient when running the \vsci or \vdbi or \vsi commands, we now
+
−  suppress "42000 SELECT: insufficient privileges for ..." and
+
−  "42000 SELECT: access denied for ..." error messages when the connected user
+
−  does not have 'monetdb' or 'sysadmin' privileges, needed for some validations.
+
−
+
−* Wed Jun 19 2024 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
+
−- Implemented Connection#set/getClientInfo, and send sensible default info
+
−  at connect time. This can be controlled with the properties 'client_info=on/off',
+
−  'client_application=ApplicationName' and 'client_remark=Other Useful Info'.
+
−  Note setting client info requires MonetDB server 11.51 (Aug2024) or higher.
+
−
+
−* Thu Apr  4 2024 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Corrected ResultSetMetaData methods getColumnTypeName(), getPrecision(),
+
−  getColumnDisplaySize() and ParameterMetaData methods getParameterTypeName()
+
−  and getPrecision() for the interval data types. They now return
+
−  more precise information for the 13 possible interval data types.
+
−
+
−* Thu Mar  7 2024 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Improved DatabaseMetaData.getTypeInfo(). It now also returns the serial
+
−  and bigserial data types and all 13 possible interval data types.
+
−
+
−* Fri Jan  5 2024 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
+
−- Network connections can now be encrypted with TLS by using jdbc:monetdbs://..
+
−  instead of jdbc:monetdb://. The server is authenticated using the JVM's root
+
−  certificate pool unless cert= or certhash= properties are given.
+
−- The syntax of the JDBC URL's has been updated to match the monetdb:// and
+
−  monetdbs:// URL syntax introduced in MonetDB 11.51 (Aug2024), see
+
−  https://www.monetdb.org/documentation/user-guide/client-interfaces/monetdb-urls/.
+
−  This adds a number of properties that can be set in the URL but is otherwise
+
−  backward compatible except that percent sign are now used to escape other characters.
+
−  For example, the password '100%milk&cookies' can be passed as
+
−  password=100%25milk%26cookies.
+
−
+
−* Thu Dec 28 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- In ResultSet.getObject(column, Class<T> type) and
+
−  ResultSet.getObject(column, Map<String,Class<?>>) methods added support
+
−  to return objects for classes: java.time.LocalDate, java.time.LocalDateTime
+
−  and java.time.LocalTime.
+
−
+
−* Wed Dec 20 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- Enhanced DatabaseMetaData.getTables() method by adding support for SQL
+
−  table type names: 'BASE TABLE', 'GLOBAL TEMPORARY' and 'LOCAL TEMPORARY'
+
−  in parameter types[].  These are SQL synonyms of MonetDB table type names:
+
−  'TABLE', 'GLOBAL TEMPORARY TABLE' and 'LOCAL TEMPORARY TABLE'.
+
−
+
−* Thu Dec 14 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
+
−- In ResultSet.getObject() method added support for retrieving
+
−  TIMESTAMP WITH TIME ZONE data as java.time.OffsetDateTime object
+
−  and TIME WITH TIME ZONE as java.time.OffsetTime object.
+
−  Also methods ResultSetMetaData.getColumnClassName() and
+
−  ParameterMetaData.getParameterClassName() now return
+
−  java.time.OffsetDateTime.class for columns of type TIMESTAMP WITH TIME ZONE
+
−  and java.time.OffsetTime.class for columns of type TIME WITH TIME ZONE.
+
−
+
−* 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 incorrect.
+
−
+
−* 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.
+
−
+
−For a complete list of changes in previous monetdb-java releases see:
+
−  https://www.monetdb.org/downloads/Java/archive/ChangeLog-Archive
+
−