Mercurial > hg > monetdb-java

annotate ChangeLog @ 832:7eb05cbf67dc

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 28 Dec 2023 17:12:56 +0100 (15 months ago)
parents b2cbe866d020
children c6946ee9f5ce
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
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
4 * 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
5 - 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
6 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
7 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
8 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
9
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
10 * 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
11 - 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
12 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
13 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
14 '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
15
820
4c35009cd59c In ResultSet.getObject() method added support for retrieving
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 781
diff changeset
16 * 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
17 - 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
18 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
19 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
20 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
21 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
22 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
23 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
24
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
25 * 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
26 - 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
27 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
28 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
29
774
e029af7551b7 Implemented ResultSet methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 768
diff changeset
30 * 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
31 - Implemented ResultSet methods:
e029af7551b7 Implemented ResultSet methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 768
diff changeset
32 <T> T getObject(int columnIndex, Class<T> type)
e029af7551b7 Implemented ResultSet methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 768
diff changeset
33 <T> T getObject(String columnLabel, Class<T> type)
e029af7551b7 Implemented ResultSet methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 768
diff changeset
34 They used to throw an SQLFeatureNotSupportedException.
e029af7551b7 Implemented ResultSet methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 768
diff changeset
35
767
1547843b3a9b Removed code to support old MonetDB servers Oct2014 or older.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 764
diff changeset
36 * 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
37 - 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
38 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
39 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
40 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
41 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
42 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
43 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
44 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
45 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
46 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
47
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
48 * 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
49 - 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
50 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
51 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
52 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
53 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
54 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
55
764
052c23fbfab2 Corrected implementation of Connection methods getClientInfo() and setClientInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 757
diff changeset
56 * 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
57 - Corrected implementation of Connection methods getClientInfo() and
823
d3f92fcd047c correct English
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 820
diff changeset
58 setClientInfo(). They used to get/set Connection properties instead of
d3f92fcd047c correct English
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 820
diff changeset
59 Client Info properties, which was incorrect. MonetDB does not support
d3f92fcd047c correct English
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 820
diff changeset
60 Client Info properties.
764
052c23fbfab2 Corrected implementation of Connection methods getClientInfo() and setClientInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 757
diff changeset
61
757
7f68120de37c Corrected DatabaseMetaData method getClientProperties().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 755
diff changeset
62 * 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
63 - Corrected DatabaseMetaData method getClientProperties().
7f68120de37c Corrected DatabaseMetaData method getClientProperties().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 755
diff changeset
64 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
65
755
99ff3cd9f4f0 Corrected DatabaseMetaData method getStringFunctions() when connected to a Jun2023 server.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 739
diff changeset
66 * 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
67 - 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
68 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
69 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
70
739
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 732
diff changeset
71 * Thu Feb 23 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 732
diff changeset
72 - Compiled and released new jar files: monetdb-jdbc-3.3.jre8.jar and
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 732
diff changeset
73 jdbcclient.jre8.jar
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 732
diff changeset
74
730
ee061ab9ee32 Corrected DatabaseMetaData.getSQLKeywords() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 724
diff changeset
75 * Thu Feb 9 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
ee061ab9ee32 Corrected DatabaseMetaData.getSQLKeywords() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 724
diff changeset
76 - Corrected DatabaseMetaData.getSQLKeywords() output. It used to return
ee061ab9ee32 Corrected DatabaseMetaData.getSQLKeywords() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 724
diff changeset
77 all MonetDB SQL keywords, but now it excludes the SQL:2003 keywords
ee061ab9ee32 Corrected DatabaseMetaData.getSQLKeywords() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 724
diff changeset
78 as defined by the Java JDBC API specification.
ee061ab9ee32 Corrected DatabaseMetaData.getSQLKeywords() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 724
diff changeset
79
724
2b763b189452 Corrected DatabaseMetaData.getUDTs() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 704
diff changeset
80 * Thu Jan 19 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
2b763b189452 Corrected DatabaseMetaData.getUDTs() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 704
diff changeset
81 - Corrected DatabaseMetaData.getUDTs() output. It used to return rows
2b763b189452 Corrected DatabaseMetaData.getUDTs() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 704
diff changeset
82 for system types: inet, json, url and uuid. However those are not User
2b763b189452 Corrected DatabaseMetaData.getUDTs() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 704
diff changeset
83 Defined Types. Now they are no longer returned by this method.
2b763b189452 Corrected DatabaseMetaData.getUDTs() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 704
diff changeset
84
704
5d6c577e2f74 Add a ChangeLog entry for change of method name in a MonetDB specific class.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 691
diff changeset
85 * Thu Dec 8 2022 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
5d6c577e2f74 Add a ChangeLog entry for change of method name in a MonetDB specific class.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 691
diff changeset
86 - Internal method waitForPrompt() of class BufferedMCLReader has been
5d6c577e2f74 Add a ChangeLog entry for change of method name in a MonetDB specific class.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 691
diff changeset
87 renamed to discardRemainder(). The example program SQLcopyinto.java
5d6c577e2f74 Add a ChangeLog entry for change of method name in a MonetDB specific class.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 691
diff changeset
88 which uses this method, has been updated.
5d6c577e2f74 Add a ChangeLog entry for change of method name in a MonetDB specific class.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 691
diff changeset
89
691
fb55e62c50f3 Fixed an invalid error issue when a PreparedStatement had more than 250 parameters.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 682
diff changeset
90 * Thu Nov 17 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
fb55e62c50f3 Fixed an invalid error issue when a PreparedStatement had more than 250 parameters.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 682
diff changeset
91 - Fixed an invalid error issue when a PreparedStatement had more than 250
fb55e62c50f3 Fixed an invalid error issue when a PreparedStatement had more than 250 parameters.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 682
diff changeset
92 parameters. See also https://github.com/MonetDB/MonetDB/issues/7337
fb55e62c50f3 Fixed an invalid error issue when a PreparedStatement had more than 250 parameters.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 682
diff changeset
93
682
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
94 * Thu Nov 3 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
95 - Corrected returned SQL TypeName values for the MonetDB interval types:
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
96 'day_interval', 'month_interval' and 'sec_interval'. Those MonetDB
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
97 type names can not be used in CREATE TABLE statements. Instead
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
98 one has to use SQL type names: 'interval day', 'interval month' or
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
99 'interval second'. The JDBC driver now returns those SQL type names.
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
100 This applies to methods: DatabaseMetaData.getTypeInfo() for the output
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
101 column TYPE_NAME (the output column LOCAL_TYPE_NAME now returns
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
102 the original type name), ResultSetMetaData.getColumnTypeName() and
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
103 ParameterMetaData.getParameterTypeName().
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
104
667
ed3d0c1a60cf Corrected PreparedStatement methods getMetaData().getColumnDisplaySize(), getMetaData().getPrecision() and getParameterMetaData().getPrecision().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 665
diff changeset
105 * Thu Oct 27 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
ed3d0c1a60cf Corrected PreparedStatement methods getMetaData().getColumnDisplaySize(), getMetaData().getPrecision() and getParameterMetaData().getPrecision().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 665
diff changeset
106 - Corrected PreparedStatement methods getMetaData().getColumnDisplaySize(),
ed3d0c1a60cf Corrected PreparedStatement methods getMetaData().getColumnDisplaySize(), getMetaData().getPrecision() and getParameterMetaData().getPrecision().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 665
diff changeset
107 getMetaData().getPrecision() and getParameterMetaData().getPrecision().
ed3d0c1a60cf Corrected PreparedStatement methods getMetaData().getColumnDisplaySize(), getMetaData().getPrecision() and getParameterMetaData().getPrecision().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 665
diff changeset
108
665
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
109 * Thu Oct 20 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
110 - Improved implementation of method ResultSetMetaData.getPrecision(). It
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
111 now returns more accurate values for columns of type DECIMAL, NUMERIC,
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
112 CHAR, VARCHAR, CLOB, JSON, URL and BLOB.
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
113 - Improved implementation of method ResultSetMetaData.getScale(). It now
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
114 returns more accurate values for columns of type DECIMAL and NUMERIC.
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
115
659
0b564ae68ac1 Removed creation and distribution of monetdb-mcl-1.##.jre8.jar file.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 652
diff changeset
116 * Thu Sep 29 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
0b564ae68ac1 Removed creation and distribution of monetdb-mcl-1.##.jre8.jar file.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 652
diff changeset
117 - Removed creation and distribution of monetdb-mcl-1.##.jre8.jar file.
0b564ae68ac1 Removed creation and distribution of monetdb-mcl-1.##.jre8.jar file.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 652
diff changeset
118 Programmers who used this jar file should use monetdb-jdbc-3.#.jre8.jar file.
0b564ae68ac1 Removed creation and distribution of monetdb-mcl-1.##.jre8.jar file.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 652
diff changeset
119
672
cd6193bc5956 Update ChangeLog
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 667
diff changeset
120 * Fri Sep 09 2022 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
cd6193bc5956 Update ChangeLog
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 667
diff changeset
121 - Add autocommit=true/false option to the JDBC URL. The default remains 'true'.
cd6193bc5956 Update ChangeLog
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 667
diff changeset
122
652
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
123 * Wed Aug 24 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
124 - Improved DatabaseMetaData.getBestRowIdentifier(). When there are multiple
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
125 unique constraints and no pkey for a table it used to return the columns
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
126 of all the table unique constraints. Now it only returns the columns of
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
127 the first table unique constraint.
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
128 Also optimized the performance of getBestRowIdentifier(). It used to
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
129 send a separate query first to find out if the table had a pkey or not.
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
130 This extra query is now integrated so less queries are send to the server.
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
131
645
fbed03097738 Corrected DatabaseMetaData methods getPrimaryKeys(), getBestRowIdentifier() and getIndexInfo() for temporary tables in schema tmp.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 642
diff changeset
132 * Wed Mar 30 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
fbed03097738 Corrected DatabaseMetaData methods getPrimaryKeys(), getBestRowIdentifier() and getIndexInfo() for temporary tables in schema tmp.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 642
diff changeset
133 - Corrected DatabaseMetaData methods getPrimaryKeys(), getBestRowIdentifier()
648
03e0f577db00 Improve ChangeLog text.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 645
diff changeset
134 and getIndexInfo() for local temporary tables located in schema tmp. They
03e0f577db00 Improve ChangeLog text.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 645
diff changeset
135 did not return any rows when the temp table had a primary or unique key or
03e0f577db00 Improve ChangeLog text.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 645
diff changeset
136 index. Now they do return rows as expected.
645
fbed03097738 Corrected DatabaseMetaData methods getPrimaryKeys(), getBestRowIdentifier() and getIndexInfo() for temporary tables in schema tmp.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 642
diff changeset
137
642
dd9b4fb14256 Added recognition of 'xml' type.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
138 * Thu Feb 10 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
dd9b4fb14256 Added recognition of 'xml' type.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
139 - Added recognition of 'xml' type. Use default mapping to Types.VARCHAR for
dd9b4fb14256 Added recognition of 'xml' type.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
140 easy and fast (as java.lang.String) retrieval, display and setting data of
dd9b4fb14256 Added recognition of 'xml' type.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
141 columns of type 'xml'.
dd9b4fb14256 Added recognition of 'xml' type.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
142
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
143 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
144 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
145