-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathChangeLog
134 lines (113 loc) · 7.31 KB
/
ChangeLog
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
# ChangeLog file for monetdb-java
# This file is updated with Maddlog
* Thu Feb 13 2025 Martin van Dinther <[email protected]>
- Corrected the returned integer values of Statement methods
getUpdateCount() and getLargeUpdateCount(). They returned -2 for
DDL statements, which was not in compliance with the JDBC API
documentation. Now they no longer return numbers smaller than -1.
- Corrected the returned integer values of Statement methods
executeUpdate(...) and executeLargeUpdate(...) and PreparedStatement
methods executeUpdate() and executeLargeUpdate(). They returned -2 for
DDL statements, which was not in compliance with the JDBC API
documentation. Now they no longer return negative numbers.
* Wed Feb 12 2025 Martin van Dinther <[email protected]>
- Fix a bug in DatabaseMetaData.getTables() where a provided string in the
array of table types argument would contain a single quote or back slash.
It was not escaped properly, resulting in an SQL syntax error.
- Fix missing escaping of single back slashes in string data provided to
PreparedStatement methods setString(), setClob(), setObject() and setURL().
* Thu Jan 16 2025 Martin van Dinther <[email protected]>
- The release version number has been bumped to 12.0 to avoid confusion
with historic 11.x versions.
- Compiled and released new jar files: monetdb-jdbc-12.0.jre8.jar and
jdbcclient.jre8.jar
* Wed Jan 8 2025 Joeri van Ruth <[email protected]>
- The JDBC jar now includes JdbcClient. For backward compatibility the jar
is still also available as jdbcclient.jreX.jar.
* Thu Nov 7 2024 Martin van Dinther <[email protected]>
- In JdbcClient when running the \vsci or \vdbi or \vsi commands, we now
suppress "42000 SELECT: insufficient privileges for ..." and
"42000 SELECT: access denied for ..." error messages when the connected user
does not have 'monetdb' or 'sysadmin' privileges, needed for some validations.
* Wed Jun 19 2024 Joeri van Ruth <[email protected]>
- Implemented Connection#set/getClientInfo, and send sensible default info
at connect time. This can be controlled with the properties 'client_info=on/off',
'client_application=ApplicationName' and 'client_remark=Other Useful Info'.
Note setting client info requires MonetDB server 11.51 (Aug2024) or higher.
* Thu Apr 4 2024 Martin van Dinther <[email protected]>
- Corrected ResultSetMetaData methods getColumnTypeName(), getPrecision(),
getColumnDisplaySize() and ParameterMetaData methods getParameterTypeName()
and getPrecision() for the interval data types. They now return
more precise information for the 13 possible interval data types.
* Thu Mar 7 2024 Martin van Dinther <[email protected]>
- Improved DatabaseMetaData.getTypeInfo(). It now also returns the serial
and bigserial data types and all 13 possible interval data types.
* Fri Jan 5 2024 Joeri van Ruth <[email protected]>
- Network connections can now be encrypted with TLS by using jdbc:monetdbs://..
instead of jdbc:monetdb://. The server is authenticated using the JVM's root
certificate pool unless cert= or certhash= properties are given.
- The syntax of the JDBC URL's has been updated to match the monetdb:// and
monetdbs:// URL syntax introduced in MonetDB 11.51 (Aug2024), see
https://www.monetdb.org/documentation/user-guide/client-interfaces/monetdb-urls/.
This adds a number of properties that can be set in the URL but is otherwise
backward compatible except that percent sign are now used to escape other characters.
For example, the password '100%milk&cookies' can be passed as
password=100%25milk%26cookies.
* Thu Dec 28 2023 Martin van Dinther <[email protected]>
- In ResultSet.getObject(column, Class<T> type) and
ResultSet.getObject(column, Map<String,Class<?>>) methods added support
to return objects for classes: java.time.LocalDate, java.time.LocalDateTime
and java.time.LocalTime.
* Wed Dec 20 2023 Martin van Dinther <[email protected]>
- Enhanced DatabaseMetaData.getTables() method by adding support for SQL
table type names: 'BASE TABLE', 'GLOBAL TEMPORARY' and 'LOCAL TEMPORARY'
in parameter types[]. These are SQL synonyms of MonetDB table type names:
'TABLE', 'GLOBAL TEMPORARY TABLE' and 'LOCAL TEMPORARY TABLE'.
* Thu Dec 14 2023 Martin van Dinther <[email protected]>
- In ResultSet.getObject() method added support for retrieving
TIMESTAMP WITH TIME ZONE data as java.time.OffsetDateTime object
and TIME WITH TIME ZONE as java.time.OffsetTime object.
Also methods ResultSetMetaData.getColumnClassName() and
ParameterMetaData.getParameterClassName() now return
java.time.OffsetDateTime.class for columns of type TIMESTAMP WITH TIME ZONE
and java.time.OffsetTime.class for columns of type TIME WITH TIME ZONE.
* Thu Oct 12 2023 Martin van Dinther <[email protected]>
- Improved DatabaseMetaData.getSystemFunctions(). It now also returns
functions: current_sessionid, greatest, ifnull, least, sql_max, sql_min.
Function ifnull will only be returned for servers Jun2023 (11.47 or higher).
* Wed Aug 9 2023 Martin van Dinther <[email protected]>
- Implemented ResultSet methods:
<T> T getObject(int columnIndex, Class<T> type)
<T> T getObject(String columnLabel, Class<T> type)
They used to throw an SQLFeatureNotSupportedException.
* Thu Jul 6 2023 Martin van Dinther <[email protected]>
- Removed deprecated nl.cwi.monetdb.*.* classes and package.
Those classes were marked deprecated on 12 Nov 2020 from
release 3.0 (released on 17 Feb 2021) onwards. It includes:
nl.cwi.monetdb.client.JdbcClient.class
nl.cwi.monetdb.jdbc.MonetDriver.class
nl.cwi.monetdb.jdbc.types.INET.class
nl.cwi.monetdb.jdbc.types.URL.class
nl.cwi.monetdb.mcl.net.MapiSocket.class
These classes are now removed permanently.
Use the org.monetdb.* equivalents instead.
* Thu Jul 6 2023 Martin van Dinther <[email protected]>
- Removed code to support old MonetDB servers Oct2014 or older. Those
old servers did not yet have the system tables: sys.keywords and
sys.table_types which are introduced in Jul2015 release. Those system
tables are used by MonetDatabaseMetaData methods: getSQLKeywords(),
getTableTypes() and getTables(). These 3 methods will now fail when
used with those very old MonetDB servers.
* Wed Jul 5 2023 Martin van Dinther <[email protected]>
- Corrected implementation of Connection methods getClientInfo() and
setClientInfo(). They used to get/set Connection properties instead of
Client Info properties, which was incorrect.
* Thu Jun 22 2023 Martin van Dinther <[email protected]>
- Corrected DatabaseMetaData method getClientProperties().
It used to return connection properties instead of client info properties.
* Thu May 4 2023 Martin van Dinther <[email protected]>
- Corrected DatabaseMetaData method getStringFunctions() when connected
to Jun2023 server. It now includes the string functions from the new
txtsim module.
For a complete list of changes in previous monetdb-java releases see:
https://www.monetdb.org/downloads/Java/archive/ChangeLog-Archive