view ChangeLog @ 932:f16966084980

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.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 07 Nov 2024 18:02:34 +0100 (5 months ago)
parents 0ce63f3686fe
children 45c26b1a0677
line wrap: on
line source
# ChangeLog file for monetdb-java
# This file is updated with Maddlog

* 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'.

* 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.

* 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. 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.

For a complete list of changes in previous monetdb-java releases see:
  https://www.monetdb.org/downloads/Java/archive/ChangeLog-Archive