Mercurial > hg > monetdb-java

annotate ChangeLog @ 970:f90d811e97eb default tip

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Adjust getTableTypes() test for new table type: LOCAL TEMPORARY VIEW, added in 11.53.4 (Mar2025-SP1)
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 03 Apr 2025 15:01:33 +0200 (35 hours ago)
parents 5cc071c5c170
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
89
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 53
diff changeset
1 # ChangeLog file for monetdb-java
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
2 # This file is updated with Maddlog
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
3
967
5cc071c5c170 Corrected the returned integer values of Statement methods executeUpdate(...), executeLargeUpdate(...), getUpdateCount() and getLargeUpdateCount() and PreparedStatement methods executeUpdate() and executeLargeUpdate(). They returned -2 for DDL statements, which was not in compliance with the JDBC API documentation.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 966
diff changeset
4 * Thu Feb 13 2025 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
5cc071c5c170 Corrected the returned integer values of Statement methods executeUpdate(...), executeLargeUpdate(...), getUpdateCount() and getLargeUpdateCount() and PreparedStatement methods executeUpdate() and executeLargeUpdate(). They returned -2 for DDL statements, which was not in compliance with the JDBC API documentation.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 966
diff changeset
5 - Corrected the returned integer values of Statement methods
5cc071c5c170 Corrected the returned integer values of Statement methods executeUpdate(...), executeLargeUpdate(...), getUpdateCount() and getLargeUpdateCount() and PreparedStatement methods executeUpdate() and executeLargeUpdate(). They returned -2 for DDL statements, which was not in compliance with the JDBC API documentation.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 966
diff changeset
6 getUpdateCount() and getLargeUpdateCount(). They returned -2 for
5cc071c5c170 Corrected the returned integer values of Statement methods executeUpdate(...), executeLargeUpdate(...), getUpdateCount() and getLargeUpdateCount() and PreparedStatement methods executeUpdate() and executeLargeUpdate(). They returned -2 for DDL statements, which was not in compliance with the JDBC API documentation.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 966
diff changeset
7 DDL statements, which was not in compliance with the JDBC API
5cc071c5c170 Corrected the returned integer values of Statement methods executeUpdate(...), executeLargeUpdate(...), getUpdateCount() and getLargeUpdateCount() and PreparedStatement methods executeUpdate() and executeLargeUpdate(). They returned -2 for DDL statements, which was not in compliance with the JDBC API documentation.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 966
diff changeset
8 documentation. Now they no longer return numbers smaller than -1.
5cc071c5c170 Corrected the returned integer values of Statement methods executeUpdate(...), executeLargeUpdate(...), getUpdateCount() and getLargeUpdateCount() and PreparedStatement methods executeUpdate() and executeLargeUpdate(). They returned -2 for DDL statements, which was not in compliance with the JDBC API documentation.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 966
diff changeset
9 - Corrected the returned integer values of Statement methods
5cc071c5c170 Corrected the returned integer values of Statement methods executeUpdate(...), executeLargeUpdate(...), getUpdateCount() and getLargeUpdateCount() and PreparedStatement methods executeUpdate() and executeLargeUpdate(). They returned -2 for DDL statements, which was not in compliance with the JDBC API documentation.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 966
diff changeset
10 executeUpdate(...) and executeLargeUpdate(...) and PreparedStatement
5cc071c5c170 Corrected the returned integer values of Statement methods executeUpdate(...), executeLargeUpdate(...), getUpdateCount() and getLargeUpdateCount() and PreparedStatement methods executeUpdate() and executeLargeUpdate(). They returned -2 for DDL statements, which was not in compliance with the JDBC API documentation.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 966
diff changeset
11 methods executeUpdate() and executeLargeUpdate(). They returned -2 for
5cc071c5c170 Corrected the returned integer values of Statement methods executeUpdate(...), executeLargeUpdate(...), getUpdateCount() and getLargeUpdateCount() and PreparedStatement methods executeUpdate() and executeLargeUpdate(). They returned -2 for DDL statements, which was not in compliance with the JDBC API documentation.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 966
diff changeset
12 DDL statements, which was not in compliance with the JDBC API
5cc071c5c170 Corrected the returned integer values of Statement methods executeUpdate(...), executeLargeUpdate(...), getUpdateCount() and getLargeUpdateCount() and PreparedStatement methods executeUpdate() and executeLargeUpdate(). They returned -2 for DDL statements, which was not in compliance with the JDBC API documentation.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 966
diff changeset
13 documentation. Now they no longer return negative numbers.
5cc071c5c170 Corrected the returned integer values of Statement methods executeUpdate(...), executeLargeUpdate(...), getUpdateCount() and getLargeUpdateCount() and PreparedStatement methods executeUpdate() and executeLargeUpdate(). They returned -2 for DDL statements, which was not in compliance with the JDBC API documentation.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 966
diff changeset
14
965
8aaa9964359a Fix missing escaping of single back slashes in string data provided to
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 958
diff changeset
15 * Wed Feb 12 2025 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
966
39b74cc688d2 Fix a bug in DatabaseMetaData.getTables() where a provided string in the
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 965
diff changeset
16 - Fix a bug in DatabaseMetaData.getTables() where a provided string in the
39b74cc688d2 Fix a bug in DatabaseMetaData.getTables() where a provided string in the
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 965
diff changeset
17 array of table types argument would contain a single quote or back slash.
39b74cc688d2 Fix a bug in DatabaseMetaData.getTables() where a provided string in the
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 965
diff changeset
18 It was not escaped properly, resulting in an SQL syntax error.
965
8aaa9964359a Fix missing escaping of single back slashes in string data provided to
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 958
diff changeset
19 - Fix missing escaping of single back slashes in string data provided to
8aaa9964359a Fix missing escaping of single back slashes in string data provided to
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 958
diff changeset
20 PreparedStatement methods setString(), setClob(), setObject() and setURL().
8aaa9964359a Fix missing escaping of single back slashes in string data provided to
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 958
diff changeset
21
954
87f0184a79b7 Add info on new release to ChangeLog.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 942
diff changeset
22 * Thu Jan 16 2025 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
955
4b5ed1419a98 Add info on why we changed to version 12.0 (instead of 3.4)
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 954
diff changeset
23 - The release version number has been bumped to 12.0 to avoid confusion
4b5ed1419a98 Add info on why we changed to version 12.0 (instead of 3.4)
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 954
diff changeset
24 with historic 11.x versions.
954
87f0184a79b7 Add info on new release to ChangeLog.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 942
diff changeset
25 - Compiled and released new jar files: monetdb-jdbc-12.0.jre8.jar and
87f0184a79b7 Add info on new release to ChangeLog.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 942
diff changeset
26 jdbcclient.jre8.jar
87f0184a79b7 Add info on new release to ChangeLog.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 942
diff changeset
27
942
45c26b1a0677 Include all of JdbcClient in the jdbc jar
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 932
diff changeset
28 * Wed Jan 8 2025 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
45c26b1a0677 Include all of JdbcClient in the jdbc jar
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 932
diff changeset
29 - The JDBC jar now includes JdbcClient. For backward compatibility the jar
45c26b1a0677 Include all of JdbcClient in the jdbc jar
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 932
diff changeset
30 is still also available as jdbcclient.jreX.jar.
45c26b1a0677 Include all of JdbcClient in the jdbc jar
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 932
diff changeset
31
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.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 926
diff changeset
32 * Thu Nov 7 2024 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
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.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 926
diff changeset
33 - In JdbcClient when running the \vsci or \vdbi or \vsi commands, we now
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.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 926
diff changeset
34 suppress "42000 SELECT: insufficient privileges for ..." and
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.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 926
diff changeset
35 "42000 SELECT: access denied for ..." error messages when the connected user
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.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 926
diff changeset
36 does not have 'monetdb' or 'sysadmin' privileges, needed for some validations.
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.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 926
diff changeset
37
926
0ce63f3686fe ChangeLog
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 888
diff changeset
38 * Wed Jun 19 2024 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
0ce63f3686fe ChangeLog
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 888
diff changeset
39 - Implemented Connection#set/getClientInfo, and send sensible default info
0ce63f3686fe ChangeLog
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 888
diff changeset
40 at connect time. This can be controlled with the properties 'client_info=on/off',
0ce63f3686fe ChangeLog
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 888
diff changeset
41 'client_application=ApplicationName' and 'client_remark=Other Useful Info'.
954
87f0184a79b7 Add info on new release to ChangeLog.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 942
diff changeset
42 Note setting client info requires MonetDB server 11.51 (Aug2024) or higher.
926
0ce63f3686fe ChangeLog
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 888
diff changeset
43
887
674f9ed21308 Improved ResultSetMetaData.getColumnTypeName() and ParameterMetaData.getParameterTypeName() for interval types. It now returns more precise information for the 13 possible interval data types.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 882
diff changeset
44 * Thu Apr 4 2024 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
888
549225b7be85 Corrected ResultSetMetaData methods getPrecision(), getColumnDisplaySize() and ParameterMetaData method getPrecision() for the interval data types. They now return more precise information for the 13 possible interval data types.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 887
diff changeset
45 - Corrected ResultSetMetaData methods getColumnTypeName(), getPrecision(),
549225b7be85 Corrected ResultSetMetaData methods getPrecision(), getColumnDisplaySize() and ParameterMetaData method getPrecision() for the interval data types. They now return more precise information for the 13 possible interval data types.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 887
diff changeset
46 getColumnDisplaySize() and ParameterMetaData methods getParameterTypeName()
549225b7be85 Corrected ResultSetMetaData methods getPrecision(), getColumnDisplaySize() and ParameterMetaData method getPrecision() for the interval data types. They now return more precise information for the 13 possible interval data types.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 887
diff changeset
47 and getPrecision() for the interval data types. They now return
549225b7be85 Corrected ResultSetMetaData methods getPrecision(), getColumnDisplaySize() and ParameterMetaData method getPrecision() for the interval data types. They now return more precise information for the 13 possible interval data types.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 887
diff changeset
48 more precise information for the 13 possible interval data types.
887
674f9ed21308 Improved ResultSetMetaData.getColumnTypeName() and ParameterMetaData.getParameterTypeName() for interval types. It now returns more precise information for the 13 possible interval data types.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 882
diff changeset
49
882
cd6e5449fb1a Improved DatabaseMetaData.getTypeInfo(). It now also returns the serial and bigserial data types and all 13 possible interval data types.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 856
diff changeset
50 * Thu Mar 7 2024 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
cd6e5449fb1a Improved DatabaseMetaData.getTypeInfo(). It now also returns the serial and bigserial data types and all 13 possible interval data types.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 856
diff changeset
51 - Improved DatabaseMetaData.getTypeInfo(). It now also returns the serial
cd6e5449fb1a Improved DatabaseMetaData.getTypeInfo(). It now also returns the serial and bigserial data types and all 13 possible interval data types.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 856
diff changeset
52 and bigserial data types and all 13 possible interval data types.
cd6e5449fb1a Improved DatabaseMetaData.getTypeInfo(). It now also returns the serial and bigserial data types and all 13 possible interval data types.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 856
diff changeset
53
958
52a23aaa8580 Add ChangeLog entry for TLS and new URL syntax
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 955
diff changeset
54 * Fri Jan 5 2024 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
52a23aaa8580 Add ChangeLog entry for TLS and new URL syntax
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 955
diff changeset
55 - Network connections can now be encrypted with TLS by using jdbc:monetdbs://..
52a23aaa8580 Add ChangeLog entry for TLS and new URL syntax
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 955
diff changeset
56 instead of jdbc:monetdb://. The server is authenticated using the JVM's root
52a23aaa8580 Add ChangeLog entry for TLS and new URL syntax
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 955
diff changeset
57 certificate pool unless cert= or certhash= properties are given.
52a23aaa8580 Add ChangeLog entry for TLS and new URL syntax
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 955
diff changeset
58 - The syntax of the JDBC URL's has been updated to match the monetdb:// and
52a23aaa8580 Add ChangeLog entry for TLS and new URL syntax
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 955
diff changeset
59 monetdbs:// URL syntax introduced in MonetDB 11.51 (Aug2024), see
52a23aaa8580 Add ChangeLog entry for TLS and new URL syntax
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 955
diff changeset
60 https://www.monetdb.org/documentation/user-guide/client-interfaces/monetdb-urls/.
52a23aaa8580 Add ChangeLog entry for TLS and new URL syntax
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 955
diff changeset
61 This adds a number of properties that can be set in the URL but is otherwise
52a23aaa8580 Add ChangeLog entry for TLS and new URL syntax
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 955
diff changeset
62 backward compatible except that percent sign are now used to escape other characters.
52a23aaa8580 Add ChangeLog entry for TLS and new URL syntax
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 955
diff changeset
63 For example, the password '100%milk&cookies' can be passed as
52a23aaa8580 Add ChangeLog entry for TLS and new URL syntax
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 955
diff changeset
64 password=100%25milk%26cookies.
52a23aaa8580 Add ChangeLog entry for TLS and new URL syntax
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 955
diff changeset
65
832
7eb05cbf67dc 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.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 827
diff changeset
66 * Thu Dec 28 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
7eb05cbf67dc 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.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 827
diff changeset
67 - In ResultSet.getObject(column, Class<T> type) and
7eb05cbf67dc 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.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 827
diff changeset
68 ResultSet.getObject(column, Map<String,Class<?>>) methods added support
7eb05cbf67dc 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.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 827
diff changeset
69 to return objects for classes: java.time.LocalDate, java.time.LocalDateTime
7eb05cbf67dc 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.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 827
diff changeset
70 and java.time.LocalTime.
7eb05cbf67dc 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.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 827
diff changeset
71
827
b2cbe866d020 Enhanced DatabaseMetaData.getTables() method by adding support for SQL table type names: 'BASE TABLE', 'GLOBAL TEMPORARY' and 'LOCAL TEMPORARY' in parameter types[].
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 823
diff changeset
72 * Wed Dec 20 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
b2cbe866d020 Enhanced DatabaseMetaData.getTables() method by adding support for SQL table type names: 'BASE TABLE', 'GLOBAL TEMPORARY' and 'LOCAL TEMPORARY' in parameter types[].
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 823
diff changeset
73 - Enhanced DatabaseMetaData.getTables() method by adding support for SQL
b2cbe866d020 Enhanced DatabaseMetaData.getTables() method by adding support for SQL table type names: 'BASE TABLE', 'GLOBAL TEMPORARY' and 'LOCAL TEMPORARY' in parameter types[].
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 823
diff changeset
74 table type names: 'BASE TABLE', 'GLOBAL TEMPORARY' and 'LOCAL TEMPORARY'
b2cbe866d020 Enhanced DatabaseMetaData.getTables() method by adding support for SQL table type names: 'BASE TABLE', 'GLOBAL TEMPORARY' and 'LOCAL TEMPORARY' in parameter types[].
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 823
diff changeset
75 in parameter types[]. These are SQL synonyms of MonetDB table type names:
b2cbe866d020 Enhanced DatabaseMetaData.getTables() method by adding support for SQL table type names: 'BASE TABLE', 'GLOBAL TEMPORARY' and 'LOCAL TEMPORARY' in parameter types[].
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 823
diff changeset
76 'TABLE', 'GLOBAL TEMPORARY TABLE' and 'LOCAL TEMPORARY TABLE'.
b2cbe866d020 Enhanced DatabaseMetaData.getTables() method by adding support for SQL table type names: 'BASE TABLE', 'GLOBAL TEMPORARY' and 'LOCAL TEMPORARY' in parameter types[].
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 823
diff changeset
77
820
4c35009cd59c In ResultSet.getObject() method added support for retrieving
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 781
diff changeset
78 * Thu Dec 14 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
4c35009cd59c In ResultSet.getObject() method added support for retrieving
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 781
diff changeset
79 - In ResultSet.getObject() method added support for retrieving
4c35009cd59c In ResultSet.getObject() method added support for retrieving
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 781
diff changeset
80 TIMESTAMP WITH TIME ZONE data as java.time.OffsetDateTime object
4c35009cd59c In ResultSet.getObject() method added support for retrieving
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 781
diff changeset
81 and TIME WITH TIME ZONE as java.time.OffsetTime object.
4c35009cd59c In ResultSet.getObject() method added support for retrieving
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 781
diff changeset
82 Also methods ResultSetMetaData.getColumnClassName() and
4c35009cd59c In ResultSet.getObject() method added support for retrieving
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 781
diff changeset
83 ParameterMetaData.getParameterClassName() now return
4c35009cd59c In ResultSet.getObject() method added support for retrieving
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 781
diff changeset
84 java.time.OffsetDateTime.class for columns of type TIMESTAMP WITH TIME ZONE
4c35009cd59c In ResultSet.getObject() method added support for retrieving
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 781
diff changeset
85 and java.time.OffsetTime.class for columns of type TIME WITH TIME ZONE.
4c35009cd59c In ResultSet.getObject() method added support for retrieving
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 781
diff changeset
86
781
71d32f1a4d60 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).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 774
diff changeset
87 * Thu Oct 12 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
71d32f1a4d60 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).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 774
diff changeset
88 - Improved DatabaseMetaData.getSystemFunctions(). It now also returns
71d32f1a4d60 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).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 774
diff changeset
89 functions: current_sessionid, greatest, ifnull, least, sql_max, sql_min.
71d32f1a4d60 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).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 774
diff changeset
90 Function ifnull will only be returned for servers Jun2023 (11.47 or higher).
71d32f1a4d60 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).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 774
diff changeset
91
774
e029af7551b7 Implemented ResultSet methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 768
diff changeset
92 * Wed Aug 9 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
e029af7551b7 Implemented ResultSet methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 768
diff changeset
93 - Implemented ResultSet methods:
e029af7551b7 Implemented ResultSet methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 768
diff changeset
94 <T> T getObject(int columnIndex, Class<T> type)
e029af7551b7 Implemented ResultSet methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 768
diff changeset
95 <T> T getObject(String columnLabel, Class<T> type)
e029af7551b7 Implemented ResultSet methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 768
diff changeset
96 They used to throw an SQLFeatureNotSupportedException.
e029af7551b7 Implemented ResultSet methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 768
diff changeset
97
767
1547843b3a9b Removed code to support old MonetDB servers Oct2014 or older.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 764
diff changeset
98 * Thu Jul 6 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
768
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
99 - Removed deprecated nl.cwi.monetdb.*.* classes and package.
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
100 Those classes were marked deprecated on 12 Nov 2020 from
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
101 release 3.0 (released on 17 Feb 2021) onwards. It includes:
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
102 nl.cwi.monetdb.client.JdbcClient.class
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
103 nl.cwi.monetdb.jdbc.MonetDriver.class
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
104 nl.cwi.monetdb.jdbc.types.INET.class
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
105 nl.cwi.monetdb.jdbc.types.URL.class
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
106 nl.cwi.monetdb.mcl.net.MapiSocket.class
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
107 These classes are now removed permanently.
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
108 Use the org.monetdb.* equivalents instead.
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
109
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
110 * Thu Jul 6 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
767
1547843b3a9b Removed code to support old MonetDB servers Oct2014 or older.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 764
diff changeset
111 - Removed code to support old MonetDB servers Oct2014 or older. Those
1547843b3a9b Removed code to support old MonetDB servers Oct2014 or older.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 764
diff changeset
112 old servers did not yet have the system tables: sys.keywords and
1547843b3a9b Removed code to support old MonetDB servers Oct2014 or older.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 764
diff changeset
113 sys.table_types which are introduced in Jul2015 release. Those system
1547843b3a9b Removed code to support old MonetDB servers Oct2014 or older.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 764
diff changeset
114 tables are used by MonetDatabaseMetaData methods: getSQLKeywords(),
1547843b3a9b Removed code to support old MonetDB servers Oct2014 or older.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 764
diff changeset
115 getTableTypes() and getTables(). These 3 methods will now fail when
1547843b3a9b Removed code to support old MonetDB servers Oct2014 or older.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 764
diff changeset
116 used with those very old MonetDB servers.
1547843b3a9b Removed code to support old MonetDB servers Oct2014 or older.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 764
diff changeset
117
764
052c23fbfab2 Corrected implementation of Connection methods getClientInfo() and setClientInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 757
diff changeset
118 * Wed Jul 5 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
052c23fbfab2 Corrected implementation of Connection methods getClientInfo() and setClientInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 757
diff changeset
119 - Corrected implementation of Connection methods getClientInfo() and
823
d3f92fcd047c correct English
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 820
diff changeset
120 setClientInfo(). They used to get/set Connection properties instead of
954
87f0184a79b7 Add info on new release to ChangeLog.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 942
diff changeset
121 Client Info properties, which was incorrect.
764
052c23fbfab2 Corrected implementation of Connection methods getClientInfo() and setClientInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 757
diff changeset
122
757
7f68120de37c Corrected DatabaseMetaData method getClientProperties().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 755
diff changeset
123 * Thu Jun 22 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
7f68120de37c Corrected DatabaseMetaData method getClientProperties().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 755
diff changeset
124 - Corrected DatabaseMetaData method getClientProperties().
7f68120de37c Corrected DatabaseMetaData method getClientProperties().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 755
diff changeset
125 It used to return connection properties instead of client info properties.
7f68120de37c Corrected DatabaseMetaData method getClientProperties().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 755
diff changeset
126
755
99ff3cd9f4f0 Corrected DatabaseMetaData method getStringFunctions() when connected to a Jun2023 server.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 739
diff changeset
127 * Thu May 4 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
99ff3cd9f4f0 Corrected DatabaseMetaData method getStringFunctions() when connected to a Jun2023 server.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 739
diff changeset
128 - Corrected DatabaseMetaData method getStringFunctions() when connected
99ff3cd9f4f0 Corrected DatabaseMetaData method getStringFunctions() when connected to a Jun2023 server.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 739
diff changeset
129 to Jun2023 server. It now includes the string functions from the new
99ff3cd9f4f0 Corrected DatabaseMetaData method getStringFunctions() when connected to a Jun2023 server.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 739
diff changeset
130 txtsim module.
99ff3cd9f4f0 Corrected DatabaseMetaData method getStringFunctions() when connected to a Jun2023 server.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 739
diff changeset
131
476
5b99ca67825a Improve text in ChangeLog. Also remove old release 3.0 changes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 471
diff changeset
132 For a complete list of changes in previous monetdb-java releases see:
5b99ca67825a Improve text in ChangeLog. Also remove old release 3.0 changes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 471
diff changeset
133 https://www.monetdb.org/downloads/Java/archive/ChangeLog-Archive
606
f15df1ae41bc Remove old changes already from the ChangeLog.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 595
diff changeset
134