Mercurial > hg > monetdb-java

annotate ChangeLog @ 980:7f93f3dbdd78 default tip

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Adapt expected output for servers 11.54 or higher
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Wed, 09 Jul 2025 15:06:30 +0200 (2 weeks ago)
parents 4845c198f29f
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
979
4845c198f29f Corrected output of columns SEARCHABLE and AUTO_INCREMENT of method DatabaseMetaData.getTypeInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 967
diff changeset
4 * Thu Jul 3 2025 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
4845c198f29f Corrected output of columns SEARCHABLE and AUTO_INCREMENT of method DatabaseMetaData.getTypeInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 967
diff changeset
5 - Corrected output of columns SEARCHABLE and AUTO_INCREMENT of method
4845c198f29f Corrected output of columns SEARCHABLE and AUTO_INCREMENT of method DatabaseMetaData.getTypeInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 967
diff changeset
6 DatabaseMetaData.getTypeInfo(). Most types are searchable with LIKE
4845c198f29f Corrected output of columns SEARCHABLE and AUTO_INCREMENT of method DatabaseMetaData.getTypeInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 967
diff changeset
7 pattern matching. AUTO_INCREMENT is no longer true for base integer types.
4845c198f29f Corrected output of columns SEARCHABLE and AUTO_INCREMENT of method DatabaseMetaData.getTypeInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 967
diff changeset
8
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
9 * 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
10 - 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
11 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
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 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
14 - 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
15 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
16 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
17 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
18 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
19
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
20 * 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
21 - 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
22 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
23 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
24 - 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
25 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
26
954
87f0184a79b7 Add info on new release to ChangeLog.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 942
diff changeset
27 * 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
28 - 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
29 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
30 - 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
31 jdbcclient.jre8.jar
87f0184a79b7 Add info on new release to ChangeLog.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 942
diff changeset
32
942
45c26b1a0677 Include all of JdbcClient in the jdbc jar
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 932
diff changeset
33 * 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
34 - 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
35 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
36
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
37 * 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
38 - 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
39 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
40 "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
41 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
42
926
0ce63f3686fe ChangeLog
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 888
diff changeset
43 * 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
44 - Implemented Connection#set/getClientInfo, and send sensible default info
0ce63f3686fe ChangeLog
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 888
diff changeset
45 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
46 '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
47 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
48
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 * 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
50 - 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
51 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
52 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
53 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
54
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
55 * 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
56 - 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
57 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
58
958
52a23aaa8580 Add ChangeLog entry for TLS and new URL syntax
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 955
diff changeset
59 * 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
60 - 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
61 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
62 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
63 - 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
64 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
65 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
66 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
67 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
68 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
69 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
70
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
71 * 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
72 - 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
73 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
74 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
75 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
76
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
77 * 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
78 - 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
79 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
80 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
81 '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
82
820
4c35009cd59c In ResultSet.getObject() method added support for retrieving
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 781
diff changeset
83 * 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
84 - 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
85 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
86 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
87 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
88 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
89 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
90 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
91
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
92 * 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
93 - 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
94 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
95 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
96
774
e029af7551b7 Implemented ResultSet methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 768
diff changeset
97 * 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
98 - Implemented ResultSet methods:
e029af7551b7 Implemented ResultSet methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 768
diff changeset
99 <T> T getObject(int columnIndex, Class<T> type)
e029af7551b7 Implemented ResultSet methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 768
diff changeset
100 <T> T getObject(String columnLabel, Class<T> type)
e029af7551b7 Implemented ResultSet methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 768
diff changeset
101 They used to throw an SQLFeatureNotSupportedException.
e029af7551b7 Implemented ResultSet methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 768
diff changeset
102
767
1547843b3a9b Removed code to support old MonetDB servers Oct2014 or older.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 764
diff changeset
103 * 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
104 - 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
105 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
106 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
107 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
108 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
109 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
110 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
111 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
112 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
113 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
114
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
115 * 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
116 - 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
117 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
118 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
119 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
120 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
121 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
122
764
052c23fbfab2 Corrected implementation of Connection methods getClientInfo() and setClientInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 757
diff changeset
123 * 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
124 - Corrected implementation of Connection methods getClientInfo() and
823
d3f92fcd047c correct English
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 820
diff changeset
125 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
126 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
127
757
7f68120de37c Corrected DatabaseMetaData method getClientProperties().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 755
diff changeset
128 * 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
129 - Corrected DatabaseMetaData method getClientProperties().
7f68120de37c Corrected DatabaseMetaData method getClientProperties().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 755
diff changeset
130 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
131
755
99ff3cd9f4f0 Corrected DatabaseMetaData method getStringFunctions() when connected to a Jun2023 server.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 739
diff changeset
132 * 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
133 - 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
134 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
135 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
136
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
137 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
138 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
139