Mercurial > hg > monetdb-java

annotate ChangeLog-Archive @ 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 52a23aaa8580
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
337
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
1 # ChangeLog-Archive file for monetdb-java
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
2 # This file contains all past monetdb-java ChangeLog entries
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
3 # For every new release the ChangeLog is prepended to this file.
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
4
957
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
5 * Thu Jan 16 2025 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
6 - The release version number has been bumped to 12.0 to avoid confusion
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
7 with historic 11.x versions.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
8 - Compiled and released new jar files: monetdb-jdbc-12.0.jre8.jar and
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
9 jdbcclient.jre8.jar
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
10
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
11 * Wed Jan 8 2025 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
12 - The JDBC jar now includes JdbcClient. For backward compatibility the jar
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
13 is still also available as jdbcclient.jreX.jar.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
14
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
15 * Thu Nov 7 2024 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
16 - In JdbcClient when running the \vsci or \vdbi or \vsi commands, we now
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
17 suppress "42000 SELECT: insufficient privileges for ..." and
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
18 "42000 SELECT: access denied for ..." error messages when the connected user
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
19 does not have 'monetdb' or 'sysadmin' privileges, needed for some validations.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
20
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
21 * Wed Jun 19 2024 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
22 - Implemented Connection#set/getClientInfo, and send sensible default info
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
23 at connect time. This can be controlled with the properties 'client_info=on/off',
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
24 'client_application=ApplicationName' and 'client_remark=Other Useful Info'.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
25 Note setting client info requires MonetDB server 11.51 (Aug2024) or higher.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
26
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
27 * Thu Apr 4 2024 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
28 - Corrected ResultSetMetaData methods getColumnTypeName(), getPrecision(),
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
29 getColumnDisplaySize() and ParameterMetaData methods getParameterTypeName()
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
30 and getPrecision() for the interval data types. They now return
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
31 more precise information for the 13 possible interval data types.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
32
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
33 * Thu Mar 7 2024 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
34 - Improved DatabaseMetaData.getTypeInfo(). It now also returns the serial
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
35 and bigserial data types and all 13 possible interval data types.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
36
958
52a23aaa8580 Add ChangeLog entry for TLS and new URL syntax
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 957
diff changeset
37 * 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: 957
diff changeset
38 - 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: 957
diff changeset
39 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: 957
diff changeset
40 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: 957
diff changeset
41 - 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: 957
diff changeset
42 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: 957
diff changeset
43 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: 957
diff changeset
44 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: 957
diff changeset
45 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: 957
diff changeset
46 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: 957
diff changeset
47 password=100%25milk%26cookies.
52a23aaa8580 Add ChangeLog entry for TLS and new URL syntax
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 957
diff changeset
48
957
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
49 * Thu Dec 28 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
50 - In ResultSet.getObject(column, Class<T> type) and
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
51 ResultSet.getObject(column, Map<String,Class<?>>) methods added support
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
52 to return objects for classes: java.time.LocalDate, java.time.LocalDateTime
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
53 and java.time.LocalTime.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
54
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
55 * Wed Dec 20 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
56 - Enhanced DatabaseMetaData.getTables() method by adding support for SQL
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
57 table type names: 'BASE TABLE', 'GLOBAL TEMPORARY' and 'LOCAL TEMPORARY'
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
58 in parameter types[]. These are SQL synonyms of MonetDB table type names:
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
59 'TABLE', 'GLOBAL TEMPORARY TABLE' and 'LOCAL TEMPORARY TABLE'.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
60
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
61 * Thu Dec 14 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
62 - In ResultSet.getObject() method added support for retrieving
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
63 TIMESTAMP WITH TIME ZONE data as java.time.OffsetDateTime object
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
64 and TIME WITH TIME ZONE as java.time.OffsetTime object.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
65 Also methods ResultSetMetaData.getColumnClassName() and
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
66 ParameterMetaData.getParameterClassName() now return
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
67 java.time.OffsetDateTime.class for columns of type TIMESTAMP WITH TIME ZONE
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
68 and java.time.OffsetTime.class for columns of type TIME WITH TIME ZONE.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
69
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
70 * Thu Oct 12 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
71 - Improved DatabaseMetaData.getSystemFunctions(). It now also returns
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
72 functions: current_sessionid, greatest, ifnull, least, sql_max, sql_min.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
73 Function ifnull will only be returned for servers Jun2023 (11.47 or higher).
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
74
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
75 * Wed Aug 9 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
76 - Implemented ResultSet methods:
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
77 <T> T getObject(int columnIndex, Class<T> type)
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
78 <T> T getObject(String columnLabel, Class<T> type)
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
79 They used to throw an SQLFeatureNotSupportedException.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
80
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
81 * Thu Jul 6 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
82 - Removed deprecated nl.cwi.monetdb.*.* classes and package.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
83 Those classes were marked deprecated on 12 Nov 2020 from
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
84 release 3.0 (released on 17 Feb 2021) onwards. It includes:
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
85 nl.cwi.monetdb.client.JdbcClient.class
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
86 nl.cwi.monetdb.jdbc.MonetDriver.class
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
87 nl.cwi.monetdb.jdbc.types.INET.class
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
88 nl.cwi.monetdb.jdbc.types.URL.class
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
89 nl.cwi.monetdb.mcl.net.MapiSocket.class
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
90 These classes are now removed permanently.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
91 Use the org.monetdb.* equivalents instead.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
92
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
93 * Thu Jul 6 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
94 - Removed code to support old MonetDB servers Oct2014 or older. Those
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
95 old servers did not yet have the system tables: sys.keywords and
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
96 sys.table_types which are introduced in Jul2015 release. Those system
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
97 tables are used by MonetDatabaseMetaData methods: getSQLKeywords(),
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
98 getTableTypes() and getTables(). These 3 methods will now fail when
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
99 used with those very old MonetDB servers.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
100
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
101 * Wed Jul 5 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
102 - Corrected implementation of Connection methods getClientInfo() and
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
103 setClientInfo(). They used to get/set Connection properties instead of
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
104 Client Info properties, which was incorrect.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
105
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
106 * Thu Jun 22 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
107 - Corrected DatabaseMetaData method getClientProperties().
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
108 It used to return connection properties instead of client info properties.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
109
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
110 * Thu May 4 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
111 - Corrected DatabaseMetaData method getStringFunctions() when connected
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
112 to Jun2023 server. It now includes the string functions from the new
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
113 txtsim module.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 943
diff changeset
114
739
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
115 * 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: 636
diff changeset
116 - 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: 636
diff changeset
117 jdbcclient.jre8.jar
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
118
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
119 * Thu Feb 9 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: 636
diff changeset
120 - Corrected DatabaseMetaData.getSQLKeywords() output. It used to return
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
121 all MonetDB SQL keywords, but now it excludes the SQL:2003 keywords
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
122 as defined by the Java JDBC API specification.
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
123
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
124 * Thu Jan 19 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: 636
diff changeset
125 - Corrected DatabaseMetaData.getUDTs() output. It used to return rows
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
126 for system types: inet, json, url and uuid. However those are not User
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
127 Defined Types. Now they are no longer returned by this method.
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
128
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
129 * Thu Dec 8 2022 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
130 - Internal method waitForPrompt() of class BufferedMCLReader has been
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
131 renamed to discardRemainder(). The example program SQLcopyinto.java
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
132 which uses this method, has been updated.
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
133
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
134 * Thu Nov 17 2022 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: 636
diff changeset
135 - Fixed an invalid error issue when a PreparedStatement had more than 250
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
136 parameters. See also https://github.com/MonetDB/MonetDB/issues/7337
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
137
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
138 * Thu Nov 3 2022 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: 636
diff changeset
139 - Corrected returned SQL TypeName values for the MonetDB interval types:
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
140 'day_interval', 'month_interval' and 'sec_interval'. Those MonetDB
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
141 type names can not be used in CREATE TABLE statements. Instead
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
142 one has to use SQL type names: 'interval day', 'interval month' or
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
143 'interval second'. The JDBC driver now returns those SQL type names.
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
144 This applies to methods: DatabaseMetaData.getTypeInfo() for the output
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
145 column TYPE_NAME (the output column LOCAL_TYPE_NAME now returns
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
146 the original type name), ResultSetMetaData.getColumnTypeName() and
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
147 ParameterMetaData.getParameterTypeName().
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
148
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
149 * Thu Oct 27 2022 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: 636
diff changeset
150 - Corrected PreparedStatement methods getMetaData().getColumnDisplaySize(),
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
151 getMetaData().getPrecision() and getParameterMetaData().getPrecision().
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
152
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
153 * Thu Oct 20 2022 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: 636
diff changeset
154 - Improved implementation of method ResultSetMetaData.getPrecision(). It
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
155 now returns more accurate values for columns of type DECIMAL, NUMERIC,
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
156 CHAR, VARCHAR, CLOB, JSON, URL and BLOB.
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
157 - Improved implementation of method ResultSetMetaData.getScale(). It now
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
158 returns more accurate values for columns of type DECIMAL and NUMERIC.
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
159
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
160 * Thu Sep 29 2022 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: 636
diff changeset
161 - Removed creation and distribution of monetdb-mcl-1.##.jre8.jar file.
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
162 Programmers who used this jar file should use monetdb-jdbc-3.#.jre8.jar file.
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
163
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
164 * Fri Sep 09 2022 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
165 - Add autocommit=true/false option to the JDBC URL. The default remains 'true'.
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
166
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
167 * Wed Aug 24 2022 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: 636
diff changeset
168 - Improved DatabaseMetaData.getBestRowIdentifier(). When there are multiple
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
169 unique constraints and no pkey for a table it used to return the columns
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
170 of all the table unique constraints. Now it only returns the columns of
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
171 the first table unique constraint.
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
172 Also optimized the performance of getBestRowIdentifier(). It used to
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
173 send a separate query first to find out if the table had a pkey or not.
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
174 This extra query is now integrated so less queries are send to the server.
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
175
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
176 * Wed Mar 30 2022 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: 636
diff changeset
177 - Corrected DatabaseMetaData methods getPrimaryKeys(), getBestRowIdentifier()
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
178 and getIndexInfo() for local temporary tables located in schema tmp. They
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
179 did not return any rows when the temp table had a primary or unique key or
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
180 index. Now they do return rows as expected.
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
181
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
182 * Thu Feb 10 2022 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: 636
diff changeset
183 - Added recognition of 'xml' type. Use default mapping to Types.VARCHAR for
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
184 easy and fast (as java.lang.String) retrieval, display and setting data of
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
185 columns of type 'xml'.
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
186
636
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
187 * Thu Jan 27 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
188 - Compiled and released new jar files: monetdb-jdbc-3.2.jre8.jar,
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
189 monetdb-mcl-1.21.jre8.jar and jdbcclient.jre8.jar
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
190
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
191 * Wed Jan 19 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
192 - Fixed an SQL query problem in DatabaseMetaData.getBestRowIdentifier()
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
193 method when used with MonetDB Jan2022 (or newer) releases. It
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
194 returned java.sql.SQLException:
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
195 SELECT: with DISTINCT ORDER BY expressions must appear in select list
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
196 As of MonetDB Jan2022 (11.43.5) such queries are no longer allowed.
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
197 The internally used SQL query has been improved.
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
198
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
199 * Thu Jan 13 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
200 - Extended JdbcClient application with support for following \d commands:
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
201 \dt \dv \dSt \dSv \df \dp \dSf \dSp \dn \dSn and \ds
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
202 for showing list of: user tables, user views, system tables, system views,
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
203 user functions, user procedures, system functions, system procedures,
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
204 user schemas, system schemas and user sequences.
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
205 For more information, see the built-in help (\?) on available commands.
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
206
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
207 * Thu Nov 25 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
208 - Extended FileTransferHandler utility class by adding support for reading from
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
209 and writing to gzip compressed files when using file name extension .gz
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
210 Also improve error handling by testing on empty file name and provide more
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
211 information when invalid file name is given or other compression formats are
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
212 requested. As the FileTransferHandler utility class is used by JdbcClient
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
213 application, it will now also support this functionality.
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
214
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
215 * Fri Nov 05 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
216 - The JdbcClient application has been extended to support the new
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
217 COPY ... ON CLIENT functionality.
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
218 However for security reasons you must provide an explicit new startup argument
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
219 --csvdir "/absolute/path/to/csvdatafiles"
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
220 or on MS Windows
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
221 --csvdir "C:\\path\\to\\csvdatafiles"
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
222 in order to activate the JdbcClient application to down/up load data to/from
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
223 the local file system.
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
224
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
225 * Fri Nov 05 2021 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
226 - Extended the MonetDB JDBC driver with support for the ON CLIENT clause of
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
227 the COPY statements. To make use of this functionality you must first
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
228 register handlers for upload and download of data.
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
229 The MonetConnection class has been extended with 2 methods:
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
230 public void setUploadHandler(UploadHandler uploadHandler)
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
231 public void setDownloadHandler(DownloadHandler downloadHandler)
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
232 The MonetDB JDBC driver API has been extended with interfaces:
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
233 public interface org.monetdb.jdbc.MonetConnection.UploadHandler
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
234 public interface org.monetdb.jdbc.MonetConnection.DownloadHandler
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
235 See onclient.txt for more information on how to use these from Java.
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
236 We also provide a utility class:
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
237 public class org.monetdb.util.FileTransferHandler
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
238 which provides an example implementation of the MonetConnection.UploadHandler
943
ff075ed5ce81 Spell check.
Sjoerd Mullender <sjoerd@acm.org>
parents: 927
diff changeset
239 and MonetConnection.DownloadHandler interfaces usable for reading files
636
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
240 from or writing files to a local file system.
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
241
482
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
242 * Mon Jun 14 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
243 - Compiled and released new jar files: monetdb-jdbc-3.1.jre8.jar,
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
244 monetdb-mcl-1.20.jre8.jar and jdbcclient.jre8.jar
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
245
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
246 * Thu Apr 29 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
247 - Improved performance of ResultSetMetaData methods getPrecision(),
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
248 getScale(), isNullable() and isAutoIncrement(). The data is fetched
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
249 from the server by sending a query. This used to be one query for
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
250 each column of the ResultSet. Now these metadata queries are combined
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
251 into one query fetching this meta data for up to 50 columns in one query.
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
252 This reduces the number of queries sent to the server significantly.
943
ff075ed5ce81 Spell check.
Sjoerd Mullender <sjoerd@acm.org>
parents: 927
diff changeset
253 This is noticeable for instance when using generic JDBC query tools
482
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
254 such as SQuirreL, DBeaver, which now respond much faster.
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
255
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
256 * Wed Mar 3 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
257 - Implemented PreparedStatement.toString() as requested by
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
258 https://github.com/MonetDB/monetdb-java/issues/8
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
259
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
260 * Wed Mar 3 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
261 - Implemented fix for released monetdb-jdbc-3.0.jre8.jar and
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
262 monetdb-mcl-1.19.jre8.jar when it is was run using java build 1.8.0_###.
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
263 It would throw:
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
264 java.lang.NoSuchMethodError: java.nio.CharBuffer.mark()Ljava/nio/CharBuffer;
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
265 at org.monetdb.mcl.parser.StartOfHeaderParser.getNextAsString(Unknown Source)
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
266 at org.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(Unknown Source)
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
267 at org.monetdb.jdbc.MonetConnection$ResponseList.processQuery(Unknown Source)
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
268 at org.monetdb.jdbc.MonetStatement.internalExecute(Unknown Source)
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
269 at org.monetdb.jdbc.MonetStatement.execute(Unknown Source)
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
270 The problem is caused by a change in java.nio.CharBuffer API (return
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
271 types of methods mark() and reset() have changed from Buffer to
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
272 CharBuffer) from Java 8 to Java 9+.
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 445
diff changeset
273
445
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
274 * Wed Feb 17 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
275 - Compiled and released new jar files: monetdb-jdbc-3.0.jre8.jar,
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
276 monetdb-mcl-1.19.jre8.jar and jdbcclient.jre8.jar
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
277
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
278 monetdb-jdbc-3.0.jre8.jar is a new major release of the MonetDB JDBC driver.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
279 The MonetDB JDBC Driver is now compliant with the Java??? Database
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
280 Connectivity (JDBC) 4.2 specification as defined in Java 8 and requires
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
281 Java 8 runtime (profile compact2) as minimum version.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
282
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
283 Important: the MonetDB JDBC driver class name has also been changed in
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
284 this release to: org.monetdb.jdbc.MonetDriver. The old driver class
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
285 (nl.cwi.monetdb.jdbc.MonetDriver) is also included in the jar file, but
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
286 only to ease the transition for existing deployments. It will be removed
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
287 in a future release of this JDBC driver. Please use the new driver
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
288 class name if this is used in your configuration files or Java code.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
289
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
290 The JdbcClient program (jdbcclient.jre8.jar) has been extended with
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
291 functionality to validate the integrity of the system tables (\vsci) or
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
292 to validate the integrity of data in tables of a specific schema (\vsi xyz)
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
293 based on defined declarative constraints (pkey, fkey, not null, etc.).
943
ff075ed5ce81 Spell check.
Sjoerd Mullender <sjoerd@acm.org>
parents: 927
diff changeset
294 This will be useful to find and report inconsistencies in your database.
445
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
295 This functionality is a beta release. Please let us know if you
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
296 encounter any issues running it. See below for more information.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
297
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
298 Besides a few bug fixes also performance has been improved in multiple areas.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
299
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
300 * Wed Feb 3 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
301 - Added support for escaped wildcards (\% en \_) in String arguments of
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
302 DatabaseMetaData methods which return a ResultSet, such as getTables(),
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
303 getColumns(), etc. When you do not want the characters % or _ to be
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
304 interpreted as wildcards but as normal characters you can prefix them
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
305 with a backslash (so \% and \_). Note: be sure all wildcards characters
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
306 in the String argument are escaped else the search must still use a
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
307 LIKE operator instead of an = comparison operator.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
308 This fixes: https://github.com/MonetDB/monetdb-java/issues/3
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
309
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
310 * Thu Jan 28 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
311 - Corrected the ordering of the output of DatabaseMetaData methods
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
312 getImportedKeys(), getExportedKeys() and getCrossReference(). In cases
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
313 where a table would have multiple fks to the same external table,
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
314 the output was not as expected. This has been corrected, so the columns
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
315 now appear in the order as defined in the creation of the fks.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
316
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
317 * Thu Jan 28 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
318 - The dumping of table definitions from JdbcClient program has been
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
319 improved. It now includes the ON UPDATE and ON DELETE rules for foreign
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
320 key constraints. Also it no longer generates CREATE INDEX statements
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
321 for foreign key constraints whose name is not system generated but
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
322 user specified.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
323
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
324 * Thu Jan 14 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
325 - Improved DatabaseMetaData.getTypeInfo() output for temporal data
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
326 types: sec_interval, day_interval, month_interval, date, time, timetz,
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
327 timestamp and timestamptz.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
328
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
329 * Wed Jan 6 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
330 - Corrected output of resultset columns UPDATE_RULE and DELETE_RULE
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
331 when calling DatabaseMetaData API methods getImportedKeys() or
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
332 getExportedKeys() or getCrossReference(). These columns used to
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
333 always return DatabaseMetaData.importedKeyNoAction but now they
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
334 can also report the other values when set:
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
335 DatabaseMetaData.importedKeyCascade
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
336 or DatabaseMetaData.importedKeyRestrict
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
337 or DatabaseMetaData.importedKeySetNull
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
338 or DatabaseMetaData.importedKeySetDefault.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
339
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
340 * Thu Nov 12 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
341 - Moved Java classes from packages starting with nl.cwi.monetdb.*
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
342 to package org.monetdb.* This naming complies to the Java Package
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
343 Naming convention as MonetDB's main website is www.monetdb.org.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
344 To prevent problems with existing Java programs and JDBC driver
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
345 configurations we still support usage of the following classes:
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
346 nl.cwi.monetdb.jdbc.MonetDriver
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
347 nl.cwi.monetdb.jdbc.types.INET
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
348 nl.cwi.monetdb.jdbc.types.URL
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
349 nl.cwi.monetdb.mcl.net.MapiSocket
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
350 nl.cwi.monetdb.client.JdbcClient
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
351 They are implemented as simple wrappers of their org.monetdb.* equivalents.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
352 Note: These nl.cwi.monetdb.* classes are now marked as deprecated and may
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
353 be removed in a future release. If you still use them in your Java code or
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
354 configuration files, update them to use the new package names.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
355
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
356 * Thu Oct 29 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
357 - Extended JdbcClient program with 3 new commands to quickly validate
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
358 data integrity:
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
359 \vsci validate sql system catalog integrity
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
360 \vsi <schema> validate integrity of data in the given schema
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
361 \vdbi validate integrity of data in all user schemas in the database
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
362 The current validations include:
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
363 - Primary Key uniqueness
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
364 - Primary Key column(s) being NOT NULL (currently only for \vsci)
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
365 - Unique constraint uniqueness
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
366 - Foreign Key referential integrity
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
367 - Column NOT NULL constraint
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
368 - Varchar(n) max length constraint
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
369 - Idem for char(n), clob(n), blob(n), json(n) and url(n).
943
ff075ed5ce81 Spell check.
Sjoerd Mullender <sjoerd@acm.org>
parents: 927
diff changeset
370 It can be useful to run \vsci before and after an upgrade of MonetDB server.
445
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
371 Use \vsi my_schema to validate data in all tables of a specific schema.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
372 Use \vdbi to validate integrity of data in all user schemas in
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
373 the database. Note: this can take a while, depending on your number
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
374 of user schemas, tables, columns and rows. Despite being tested on several
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
375 internal dbs the functionality is still beta, so you can get false
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
376 errors reported. If you encounter any let us know asap.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
377
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
378 * Thu Oct 8 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
379 - Improved performance of ResultSetMetaData methods isAutoIncrement(),
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
380 getPrecision() and getScale() significantly for columns of specific data
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
381 types as in some cases no costly meta data query is executed anymore.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
382
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
383 * Thu Oct 8 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
384 - The connection properties treat_clob_as_varchar and treat_blob_as_binary
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
385 are now set to true by default within the JDBC driver. This is done
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
386 as it results by default in less memory usage, (much) faster response
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
387 and better user experience for many generic JDBC applications (like
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
388 SQuirreL SQL, DBeaver, etc) when fetching data from CLOB or BLOB result
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
389 columns. See release.txt for more information and how you can turn
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
390 it off to get the old JDBC driver behavior if you require it.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
391
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
392 * Wed Oct 7 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
393 - Added support for new Java 8 java.sql.Types: Types.TIME_WITH_TIMEZONE and
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
394 Types.TIMESTAMP_WITH_TIMEZONE.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
395
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
396 * Wed Sep 23 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
397 - Updated JDBC driver to comply with JDBC 4.2 interface now we compile
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
398 for Java 8. This includes:
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
399 - adding 8 methods to MonetCallableStatement
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
400 - adding 2 methods to MonetDatabaseMetaData
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
401 - adding 3 methods to MonetPreparedStatement
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
402 - adding 4 methods to MonetResultSet
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
403 - adding 8 methods to MonetStatement
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
404
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
405 * Wed Sep 23 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
406 - Corrected MonetDatabaseMetaData.getTypeInfo()
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
407 - The LITERAL_PREFIX column now includes the required casting name for
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
408 types: clob, inet, json, url, uuid and blob.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
409 - The SEARCHABLE column now returns typePredBasic instead of typeSearchable
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
410 for type: blob.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
411 - The AUTO_INCREMENT column now returns false for types: hugeint, decimal,
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
412 oid and wrd.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
413
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
414 * Thu Sep 10 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
415 - Removed support for deprecated MD5 encryption algorithm in MapiSocket.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
416
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
417 * Wed Sep 9 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
418 - Corrected Statement.executeBatch() method. It now implicitly clears the
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
419 batch buffer, ready to accept new addBatch() calls without the need for
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
420 an explicit clearBatch() call.
927
d311affc65f0 Stop referring to monetdb.org/bugzilla, point straight to github.
Sjoerd Mullender <sjoerd@acm.org>
parents: 739
diff changeset
421 See also https://github.com/MonetDB/MonetDB/issues/6953
445
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
422
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
423 * Wed Feb 19 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
424 - Corrected the return value of getCatalogTerm() to "cat".
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
425
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
426 * Wed Feb 12 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
427 - As Java 7 is no longer supported we now compile for Java 8 as the
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
428 minimum required JVM version (profile compact2).
8867403ec322 Add content of ChangeLog to ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 339
diff changeset
429
339
71a79126a390 Added general release notes on the new release in the ChangeLog
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 338
diff changeset
430 * Thu Sep 26 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
337
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
431 - Compiled and released new jar files: monetdb-jdbc-2.29.jre7.jar,
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
432 monetdb-mcl-1.18.jre7.jar and jdbcclient.jre7.jar
339
71a79126a390 Added general release notes on the new release in the ChangeLog
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 338
diff changeset
433 - Following issues are resolved with this new MonetDB JDBC driver release:
71a79126a390 Added general release notes on the new release in the ChangeLog
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 338
diff changeset
434 - JDBC: Support for Connection.prepareCall()
927
d311affc65f0 Stop referring to monetdb.org/bugzilla, point straight to github.
Sjoerd Mullender <sjoerd@acm.org>
parents: 739
diff changeset
435 See https://github.com/MonetDB/MonetDB/issues/6402
339
71a79126a390 Added general release notes on the new release in the ChangeLog
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 338
diff changeset
436 We implemented the java.sql.CallableStatement interface.
71a79126a390 Added general release notes on the new release in the ChangeLog
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 338
diff changeset
437 - Jdbc connection hangs
927
d311affc65f0 Stop referring to monetdb.org/bugzilla, point straight to github.
Sjoerd Mullender <sjoerd@acm.org>
parents: 739
diff changeset
438 See https://github.com/MonetDB/MonetDB/issues/6571
339
71a79126a390 Added general release notes on the new release in the ChangeLog
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 338
diff changeset
439 - Mix of long and short queries make JDBC-driver hang
927
d311affc65f0 Stop referring to monetdb.org/bugzilla, point straight to github.
Sjoerd Mullender <sjoerd@acm.org>
parents: 739
diff changeset
440 See https://github.com/MonetDB/MonetDB/issues/6693
339
71a79126a390 Added general release notes on the new release in the ChangeLog
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 338
diff changeset
441 - Example SQLcopyinto.java does not work
927
d311affc65f0 Stop referring to monetdb.org/bugzilla, point straight to github.
Sjoerd Mullender <sjoerd@acm.org>
parents: 739
diff changeset
442 See https://github.com/MonetDB/MonetDB/issues/6646
339
71a79126a390 Added general release notes on the new release in the ChangeLog
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 338
diff changeset
443 Also improvements are made in:
71a79126a390 Added general release notes on the new release in the ChangeLog
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 338
diff changeset
444 - reducing the number of objects created (and thereby heap memory size)
71a79126a390 Added general release notes on the new release in the ChangeLog
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 338
diff changeset
445 - reducing number of methods called
71a79126a390 Added general release notes on the new release in the ChangeLog
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 338
diff changeset
446 - robustness, more checks on invalid parameter values
71a79126a390 Added general release notes on the new release in the ChangeLog
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 338
diff changeset
447 - performance
337
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
448
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
449 * Wed Sep 25 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
450 - The jar files are now named according to Java version compatibility.
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
451 For example, the monetdb-jdbc-2.29.jre7.jar file should be used with
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
452 Java 7 or higher.
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
453
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
454 * Wed Sep 18 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
455 - Corrected method DatabaseMetaData.getBestRowIdentifier(). It used to
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
456 return columns of both primary key and unique constraints. Now it only
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
457 returns the columns of the primary key if it has one, else columns of
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
458 a unique constraint.
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
459
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
460 * Wed Sep 11 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
461 - Optimized parse() method of TupleLineParser by creating less helper objects
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
462 and replacing method calls by direct operations on variables.
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
463
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
464 * Wed Sep 4 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
465 - Corrected JdbcClient program: the dumping of a view DDL was incorrect when
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
466 the view creation statement was not starting with "create view ", such as
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
467 when it was created using "create or replace view". It now shows the
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
468 value as stored in sys.tables.query field, similar to mclient program.
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
469
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
470 * Thu Aug 22 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
471 - Improved JdbcClient program by including the schema prefix when dumping
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
472 schema objects. It now behaves more similar to: mclient -D -N.
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
473 - Improved JdbcClient program. It now also dumps definitions of MERGE TABLE,
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
474 REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping (all) tables.
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
475
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
476 * Wed Aug 14 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
477 - Improved MonetDatabaseMetaData methods:
338
98018e38994b Correct getNumericFunctions() which incorrectly returned functions 'code' and 'space' as numeric functions.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 337
diff changeset
478 - getNumericFunctions(): it now includes function: sys.alpha
337
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
479 - getNumericFunctions(): it no longer lists functions: not_uniques and rotate_xor_hash
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
480 - getStringFunctions(): it now includes functions: json.isarray, json.isobject,
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
481 json.isvalid, sys.reverse which accept a string value as argument
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
482 - getStringFunctions(): it no longer lists functions: copyfrom, get_value_for, next_value_for, restart.
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
483 - getSystemFunctions(): it now includes system functions: get_value_for, hash,
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
484 next_value_for, sys.columnsize, sys.debug, sys.hashsize, sys.heapsize,
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
485 sys.imprintsize, sys.isauuid, sys.md5, sys.newurl, sys.password_hash, isaurl
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
486 - getSystemFunctions(): it no longer lists function: getlimit.
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
487 Also some functions require the prefix "sys." or "json." when used
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
488 from another schema. This is now included in the names returned by
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
489 methods getNumericFunctions(), getStringFunctions(), getSystemFunctions()
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
490 and getTimeDateFunctions().
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
491
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
492 * Wed Jul 31 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
493 - Corrected MonetDatabaseMetaData methods:
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
494 - getNumericFunctions(): it now includes function: pi.
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
495 - getSystemFunctions(): it no longer lists numeric functions: pi and rand.
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
496 - supportsSchemasInIndexDefinitions(): changed from true to false
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
497 - Optimised MonetStatement memory resource usage by only creating an ArrayList
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
498 and ReentrantLock object when the batch methods addBatch() or executeBatch()
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
499 are called. In most Statement usages those methods are never called.
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
500 - Implemented method MonetClob.getAsciiStream().
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
501
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
502 * Thu Mar 21 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
503 - Added implementation of java.sql.CallableStatement interface. Some standard
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
504 Java applications require this JDBC interface for executing SQL stored procedures.
927
d311affc65f0 Stop referring to monetdb.org/bugzilla, point straight to github.
Sjoerd Mullender <sjoerd@acm.org>
parents: 739
diff changeset
505 This implementation resolves request: https://github.com/MonetDB/MonetDB/issues/6402
337
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
506
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
507 * Thu Mar 7 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
508 - Improved MonetDatabaseMetaData methods:
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
509 - getNumericFunctions(): it now includes functions: degrees, fuse, ms_round, ms_str, ms_trunc and radians.
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
510 - getStringFunctions(): it now includes function: position.
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
511 - supportsIntegrityEnhancementFacility() now returns false, as we do not enforce CHECK constraints yet.
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
512
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
513 * Thu Feb 7 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
514 - Improved MonetDatabaseMetaData methods:
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
515 - getNumericFunctions(): it no longer lists aggregate functions: avg, prod and sum
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
516 - getSystemFunctions(): it no longer lists timedate function: extract
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
517 - getTimeDateFunctions(): it now also lists functions: date_trunc, epoch
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
518 - Corrected MonetDatabaseMetaData method getTypeInfo() for result column
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
519 SEARCHABLE. It now returns DatabaseMetaData.typeSearchable for all
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
520 string data types including 'inet','json','url','uuid' and 'blob'.
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
521
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
522 * Thu Sep 20 2018 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
523 - Improved example program SQLcopyinto.java and moved it to tests directory
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
524 for automatic testing.
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
525
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
526 * Thu Jun 28 2018 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
527 - Corrected return values of DatabaseMetaData methods
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
528 allTablesAreSelectable() and allProceduresAreCallable().
55735963f605 Prepare for new release of monetdb-java jar files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
529 They used to return true but now return false.
89
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
530
230
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
531 * Wed May 23 2018 Sjoerd Mullender <sjoerd@acm.org>
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
532 - Compiled and released new jars: monetdb-jdbc-2.28.jar, monetdb-mcl-1.17.jar
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
533 and updated jdbcclient.jar
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
534
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
535 * Thu Apr 26 2018 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
536 - Corrected and extended output of DatabaseMetaData methods
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
537 getTimeDateFunctions() and getSystemFunctions(). The Date/Time functions
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
538 (curdate, current_date, current_time, current_timestamp, curtime,
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
539 local_timezone, localtime, localtimestamp) were returned by
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
540 getSystemFunctions() but are now returned by getTimeDateFunctions().
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
541 getTimeDateFunctions() now also lists functions: date_to_str, extract, now,
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
542 str_to_date, str_to_time, str_to_timestamp, time_to_str and timestamp_to_str.
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
543 - Improved DatabaseMetaData methods getTablePrivileges() and
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
544 getColumnPrivileges() by returning also any combination of privileges
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
545 for the table or column in the PRIVILEGE result column. Previously only
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
546 single privileges (SELECT or UPDATE or INSERT or DELETE or EXECUTE or
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
547 GRANT) would be returned.
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
548
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
549 * Thu Apr 19 2018 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
550 - Corrected method DatabaseMetaData.getFunctions() for result column
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
551 FUNCTION_TYPE. It used to return DatabaseMetaData.functionResultUnknown
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
552 value for Analytic (functions.type 6) and Loader function (functions type 7).
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
553 It now returns DatabaseMetaData.functionNoTable for Analytic functions and
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
554 DatabaseMetaData.functionReturnsTable for Loader functions.
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
555 - DatabaseMetaData methods getTables(), getColumns(), getProcedures() and
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
556 getFunctions() now return the comment in the REMARKS result column when a
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
557 comment has been set for the table / view / column / procedure / function
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
558 via the SQL command COMMENT ON <db-object type> <qname> IS 'comment-text'.
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
559
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
560 * Thu Dec 14 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
561 - Fixed a problem with retrieving Dates and Timestamps which contained a
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
562 year value less than 1000. It would throw an SQLDataException with message:
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
563 Could not convert value to a Date. Expected JDBC date escape format
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
564 yyyy-[m]m-[d]d.
927
d311affc65f0 Stop referring to monetdb.org/bugzilla, point straight to github.
Sjoerd Mullender <sjoerd@acm.org>
parents: 739
diff changeset
565 See also: https://github.com/MonetDB/MonetDB/issues/6468
230
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
566
189
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
567 * Mon Oct 23 2017 Sjoerd Mullender <sjoerd@acm.org>
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
568 - Compiled and released new jars: monetdb-jdbc-2.27.jar, monetdb-mcl-1.16.jar
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
569 and updated jdbcclient.jar
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
570
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
571 * Thu Oct 5 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
572 - Corrected method Connection.prepareCall(). It used to return null.
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
573 Now it throws an SQLFeatureNotSupportedException to comply with the
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
574 JDBC specification.
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
575
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
576 * Thu Sep 28 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
577 - Added possibility to let the JDBC driver return columnType value
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
578 Types.VARCHAR instead of Types.CLOB in case the result column of a
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
579 ResultSet or parameter in a PreparedStatement is of data type 'clob'.
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
580 To enable this behavior provide it as JDBC connection URL property:
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
581 treat_clob_as_varchar=true
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
582 For example: jdbc:monetdb://localhost:50000/demo?treat_clob_as_varchar=true
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
583 See also:
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
584 https://www.monetdb.org/Documentation/Manuals/SQLreference/Programming/JDBC
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
585 This custom clob mapping informs generic JDBC programs to fetch clob
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
586 column values via method ResultSet.getString() instead of getClob()
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
587 and Clob.getCharacterStream() and next fetching from the stream.
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
588 As MonetDB server MAPI communication protocol does not support
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
589 streaming of parts of a CLOB value, the current implementation is to
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
590 send over the whole CLOB value as a string. Therefore there is no
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
591 performance gain when fetching those Clob values via getClob() and
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
592 getCharacterStream(). In fact it creates a lot of overhead (additional
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
593 objects and method calls) and triples the amount of needed Java Heap memory
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
594 for each Clob value!
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
595 With this connection property set, you can reduce this overhead when
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
596 working with clob column data from generic JDBC programs.
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
597
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
598 * Thu Sep 7 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
599 - Implemented PreparedStatement methods setNCharacterStream(int, Reader)
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
600 and setNCharacterStream(int, Reader, long).
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
601
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
602 * Thu Aug 31 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
603 - Corrected PreparedStatement methods setString(int, String)
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
604 and setObject(int, Object, ...) in case the target parameter
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
605 data type was json or inet or url or uuid. See also
927
d311affc65f0 Stop referring to monetdb.org/bugzilla, point straight to github.
Sjoerd Mullender <sjoerd@acm.org>
parents: 739
diff changeset
606 https://github.com/MonetDB/MonetDB/issues/6382
189
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
607
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
608 * Thu Aug 24 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
609 - Implemented PreparedStatement method setURL(int, URL).
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
610 - Implemented PreparedStatement method setNString(int, String).
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
611 - The MonetDB JDBC driver code and jdbcclient program are now compiled
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
612 without debug info and with optimise flag enabled.
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
613 The new jar files are now some 20% smaller in size.
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
614
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
615 * Thu Aug 17 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
616 - Implemented ResultSet method getNCharacterStream().
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
617 - In class MonetClob implemented methods getCharacterStream()
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
618 and getCharacterStream(long pos, long length). Method
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
619 getCharacterStream() is called by DBeaver to fetch the Clob value.
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
620 It used to throw a SQLFeatureNotSupportedException with message:
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
621 "Operation getCharacterStream() currently not supported". This caused
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
622 DBeaver to log the exception and show NULL as the value on screen,
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
623 which is incorrect. This has been fixed.
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
624
138
f97c111db06f Updated ChangeLog in preparation of new release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 127
diff changeset
625 * Fri Jul 28 2017 Sjoerd Mullender <sjoerd@acm.org>
f97c111db06f Updated ChangeLog in preparation of new release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 127
diff changeset
626 - Compiled and released new jars: monetdb-jdbc-2.26.jar and updated jdbcclient.jar
f97c111db06f Updated ChangeLog in preparation of new release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 127
diff changeset
627
f97c111db06f Updated ChangeLog in preparation of new release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 127
diff changeset
628 * Thu Jul 13 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
f97c111db06f Updated ChangeLog in preparation of new release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 127
diff changeset
629 - Corrected implementation of PreparedStatement method
f97c111db06f Updated ChangeLog in preparation of new release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 127
diff changeset
630 setObject(int parameterIndex, Object x, int targetSqlType, int scaleOrLength)
f97c111db06f Updated ChangeLog in preparation of new release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 127
diff changeset
631 for the case the targetSqlType is Types.CLOB.
927
d311affc65f0 Stop referring to monetdb.org/bugzilla, point straight to github.
Sjoerd Mullender <sjoerd@acm.org>
parents: 739
diff changeset
632 See also: https://github.com/MonetDB/MonetDB/issues/6349
138
f97c111db06f Updated ChangeLog in preparation of new release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 127
diff changeset
633
127
384d7035f317 Adding ChangeLog info to the ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 89
diff changeset
634 * Thu Mar 30 2017 Sjoerd Mullender <sjoerd@acm.org>
384d7035f317 Adding ChangeLog info to the ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 89
diff changeset
635 - Compiled and released new jars: monetdb-jdbc-2.25.jar, monetdb-mcl-1.15.jar
384d7035f317 Adding ChangeLog info to the ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 89
diff changeset
636 and updated jdbcclient.jar
384d7035f317 Adding ChangeLog info to the ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 89
diff changeset
637
384d7035f317 Adding ChangeLog info to the ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 89
diff changeset
638 * Thu Mar 9 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
384d7035f317 Adding ChangeLog info to the ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 89
diff changeset
639 - Corrected ResultSetMetaData methods getColumnLabel(int), getColomnName(int),
384d7035f317 Adding ChangeLog info to the ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 89
diff changeset
640 getTableName(int) and getSchemaName(int) for names which contain special
384d7035f317 Adding ChangeLog info to the ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 89
diff changeset
641 characters such as a space, a tab, a comma, a double quote, etc.
927
d311affc65f0 Stop referring to monetdb.org/bugzilla, point straight to github.
Sjoerd Mullender <sjoerd@acm.org>
parents: 739
diff changeset
642 See also: https://github.com/MonetDB/MonetDB/issues/6183
127
384d7035f317 Adding ChangeLog info to the ChangeLog-Archive
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 89
diff changeset
643
89
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
644 * Wed Dec 21 2016 Sjoerd Mullender <sjoerd@acm.org>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
645 - Compiled and released new jars: monetdb-jdbc-2.24.jar, monetdb-mcl-1.14.jar
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
646 and updated jdbcclient.jar
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
647
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
648 * Thu Nov 17 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
649 - The MapiSocket object now supports getting and setting the
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
650 socket timeout, even before the TCP socket is created. To set
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
651 the socket timeout specify it in the JDBC URL, for example:
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
652 jdbc:monetdb://localhost:50000/demo?so_timeout=8000
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
653 This enables the timeout and sets it to 8000 milliseconds (= 8 seconds).
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
654 By default the timeout is not set, so wait infinitely.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
655
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
656 * Thu Nov 10 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
657 - Implemented Connection methods: getClientInfo(name) and getClientInfo().
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
658 They used to return null and empty Properties object.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
659 Corrected implementation of Connection methods: setClientInfo(name, value)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
660 and setClientInfo(properties). They are now processed as expected.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
661 Corrected implementation of Connection.setHoldability(holdability). It now
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
662 throws an SQLFeatureNotSupportedException when holdability is not
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
663 ResultSet.HOLD_CURSORS_OVER_COMMIT (which is the only supported holdability).
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
664
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
665 * Thu Oct 13 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
666 - Corrected implementation of java.sql.Wrapper methods isWrapperFor()
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
667 and unwrap(). They now properly return expected results instead of
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
668 always return false or throw an SQLException.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
669
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
670 * Thu Oct 6 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
671 - Corrected return values of DatabaseMetaData methods nullsAreSortedHigh(),
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
672 nullsAreSortedLow(), getMaxCursorNameLength(), getMaxProcedureNameLength(),
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
673 getMaxStatementLength() and getMaxUserNameLength().
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
674 Improved return values of DatabaseMetaData methods getMaxBinaryLiteralLength(),
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
675 getMaxCharLiteralLength() and getMaxColumnsInTable().
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
676 - Implemented Statement methods: getQueryTimeout() and setQueryTimeout(int
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
677 seconds). getQueryTimeout() used to always return 0, now it returns the
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
678 query timeout retrieved from the server. setQueryTimeout(int seconds)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
679 used to always throw SQLException: query time outs not supported.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
680 Now it sets the query timeout for the current connection/session on
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
681 the server.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
682
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
683 * Thu Sep 29 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
684 - Corrected ResultSet methods: getByte(), getBigDecimal(), getShort(),
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
685 getInt(), getLong(), getFloat() and getDouble() in case the conversion
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
686 to the native type failed due to a Number Format conversion error.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
687 It used to silently ignore the conversion error and return 0 instead,
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
688 which is not correct. Now it throws an SQLException with message
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
689 "Could not convert value to a number." and SQLstate "22003" meaning:
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
690 Numeric value out of range.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
691
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
692 * Thu Sep 22 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
693 - Improved JdbcClient program when doing dump of table definition. It now
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
694 outputs CREATE TABLE definition more similar to mclient program.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
695
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
696 * Thu Sep 15 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
697 - Improved performance of following JDBC ResultSet and ResultSetMetaData
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
698 methods:
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
699 - ResultSet.getBoolean(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
700 - ResultSet.getBinaryStream(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
701 - ResultSet.getBytes(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
702 - ResultSet.getObject(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
703 - ResultSet.getObject(column, map)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
704 - ResultSet.getDate(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
705 - ResultSet.getTime(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
706 - ResultSet.getTimestamp(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
707 - ResultSet.getDate(column, calendar)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
708 - ResultSet.getTime(column, calendar)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
709 - ResultSet.getTimestamp(column, calendar)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
710 - ResultSetMetaData.getColumnClassName(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
711 - ResultSetMetaData.getColumnType(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
712 - ResultSetMetaData.isCaseSensitive(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
713 - ResultSetMetaData.isSigned(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
714 - ResultSetMetaData.getPrecision(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
715
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
716 * Thu Sep 8 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
717 - Improved JdbcClient program by fixing some resource leaks.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
718 - Extended JdbcClient program by showing elapsed time information for each
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
719 query or command when started in interactive mode (no -f was used at startup).
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
720
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
721 * Thu Sep 1 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
722 - Improved fetching and output speed of JdbcClient program for query results.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
723
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
724 * Thu Aug 11 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
725 - Improved performance of method ResultSet.getObject(column_ID) significantly.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
726
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
727 * Wed Jul 13 2016 Sjoerd Mullender <sjoerd@acm.org>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
728 - Compiled and released new JDBC driver jar: monetdb-jdbc-2.23.jar
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
729
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
730 * Thu Jul 7 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.7-20160713
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
731 - Corrected PROCEDURE_TYPE output value of method DatabaseMetaData.getProcedures().
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
732 It used to return procedureReturnsResult. Now it returns procedureNoResult.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
733 Corrected ORDINAL_POSITION output value of method DatabaseMetaData.getProcedureColumns().
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
734 It used to start with 0, but as procedures do not return a result value it now
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
735 starts with 1 for all the procedure arguments, as defined by the JDBC API.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
736 - Improved output of method DatabaseMetaData.getProcedures(). The REMARKS
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
737 column now contains the procedure definition as stored in sys.functions.func.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
738 The SPECIFIC_NAME column now contains the procedure unique identifier as
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
739 stored in sys.functions.id. This allows the caller to retrieve the specific
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
740 overloaded procedure which has the same name, but different arguments.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
741 Also improved output of method DatabaseMetaData.getProcedureColumns().
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
742 The SPECIFIC_NAME column now contains the procedure unique identifier as
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
743 stored in sys.functions.id. This allows the caller to retrieve the proper
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
744 arguments of the specific overloaded procedure by matching the SPECIFIC_NAME
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
745 value.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
746 - Improved output of method DatabaseMetaData.getFunctions(). The REMARKS
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
747 column now contains the function definition as stored in sys.functions.func.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
748 The SPECIFIC_NAME column now contains the function unique identifier as
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
749 stored in sys.functions.id. This allows the caller to retrieve the specific
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
750 overloaded function which has the same name, but different arguments.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
751 Also improved output of method DatabaseMetaData.getFunctionColumns().
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
752 The SPECIFIC_NAME column now contains the function unique identifier as
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
753 stored in sys.functions.id. This allows the caller to retrieve the proper
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
754 arguments of the specific overloaded function by matching the SPECIFIC_NAME
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
755 value.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
756
89
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
757 * Fri Jun 10 2016 Sjoerd Mullender <sjoerd@acm.org>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
758 - Compiled and released new JDBC driver jar: monetdb-jdbc-2.21.jar
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
759
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
760 * Thu May 26 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
761 - Fixed problem in DatabaseMetaData.getUDTs() when it was called with
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
762 types parameter filled. It used to throw SQException with message:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
763 SELECT: identifier 'DATA_TYPE' unknown. Now it returns the UDTs which
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
764 match the provided array of data types.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
765
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
766 * Thu May 19 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
767 - Implemented MonetDatabaseMetaData.supportsConvert() and
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
768 MonetDatabaseMetaData.supportsConvert(int fromType, int toType) methods.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
769 It used to always return false. Now it returns true for the supported conversions.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
770 This fixes Bug 3460.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
771
89
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
772 * Thu May 12 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
773 - Improved JdbcClient program when presenting query data to console.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
774 It used to send an SQL catalog query for each query result column
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
775 which slowed down the interactive response considerably.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
776 These additional SQL catalog queries have been eliminated.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
777
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
778 * Thu May 12 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
779 - Corrected MonetResultSet.getObject(String columnName). It no longer
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
780 throws a NullPointerException in cases where internally a
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
781 MonetVirtualResultSet is used.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
782
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
783 * Sun May 8 2016 Jennie Zhang <y.zhang@cwi.nl> - 11.23.1-20160601
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
784 - Fixed Connection.isValid(): this method should never attempt to
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
785 close the connection, even if an error has occurred.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
786
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
787 * Sun May 8 2016 Jennie Zhang <y.zhang@cwi.nl> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
788 - ResultSet.setFetchSize(): added a dummy implementation to get rid
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
789 of the SQLFeatureNotSupportedException. In MonetDB, it does not
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
790 make sense to set the fetch size of a result set. If one really
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
791 wants to set the fetch size, one should use Statement.setFetchSize()
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
792 instead.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
793
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
794 * Thu Apr 21 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
795 - Fixed resource leak in ResultSetMetaData. It created and cached a ResultSet
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
796 object for each column but never closed the ResultSet objects.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
797
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
798 * Thu Mar 31 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
799 - Corrected DatabaseMetaData methods which accept a catalog filter argument.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
800 Those methods will now filter the results on the specified catalog name,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
801 whereas previously the catalog filter argument was ignored.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
802 - Corrected output of column KEY_SEQ of DatabaseMetaData methods:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
803 getPrimaryKeys(), getImportedKeys(), getExportedKeys() and
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
804 getCrossReference(). It now starts at 1 instead of 0 previously.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
805
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
806 * Thu Mar 24 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
807 - Corrected DatabaseMetaData.getSchemas() by returning 2 instead of 3 columns.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
808 - Improved DatabaseMetaData.getColumns() by returning two additional
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
809 columns: IS_AUTOINCREMENT and IS_GENERATEDCOLUMN.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
810
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
811 * Thu Mar 17 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
812 - Improved DatabaseMetaData.getTypeInfo(). It now returns better information
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
813 on LITERAL_PREFIX, LITERAL_SUFFIX, CREATE_PARAMS, CASE_SENSITIVE,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
814 FIXED_PREC_SCALE and MAXIMUM_SCALE for some data types. Also the returned rows
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
815 are now ordered by DATA_TYPE, TYPE_NAME, PRECISION as required by the specs.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
816 Also corrected output column names "searchable" into "SEARCHABLE" and
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
817 "MAXIMUM SCALE" into "MAXIMUM_SCALE" to match the JDBC specification.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
818 - Corrected DatabaseMetaData.getPseudoColumns(). It used to return 12 empty rows.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
819 Now it returns no rows as MonetDB does not have pseudo columns.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
820
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
821 * Thu Mar 3 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
822 - Implemented method DatabaseMetaData.getClientProperties(). It used to always
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
823 return a resultset with 4 completely empty rows. It now returns a
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
824 resultset with the possible connection properties.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
825 - Implemented method DatabaseMetaData.getUDTs(). It used to return an empty
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
826 resultset. Now it returns the User Defined Types such as inet, json, url and uuid.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
827
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
828 * Thu Feb 18 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
829 - Corrected the returned table types in DatabaseMetaData.getTableTypes().
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
830 It now returns all 10 table types (as stored in sys.table_types) instead
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
831 of the previously 8 hardcoded table types.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
832 For old MonetDB servers which do not have the sys.table_types table,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
833 the old behavior is retained.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
834
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
835 * Thu Feb 11 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
836 - Implemented methods DatabaseMetadata.getProcedures() and
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
837 DatabaseMetadata.getProcedureColumns(). They used to return an empty resultset.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
838 Now they return the expected Procedures and ProcedureColumns.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
839 Also getProcedureColumns() now returns a resultset with all 20 columns
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
840 instead of 13 columns previously.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
841
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
842 * Thu Feb 4 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
843 - Method getFunctionColumns() in DatabaseMetadata used to throw an
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
844 SQLException: getFunctionColumns(String, String, String, String) is
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
845 not implemented.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
846 This method is now implemented and returns a resultset.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
847
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
848 * Thu Jan 28 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
849 - Method getFunctions() in DatabaseMetadata used to throw an SQLException:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
850 SELECT: no such column 'functions.sql'
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
851 This has been corrected. It now returns a resultset as requested.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
852 - The resultsets of DatabaseMetadata methods now no longer return a
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
853 value for the *_CAT columns as MonetDB does not support Catalogs.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
854
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
855 * Thu Jan 7 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
856 - Fixed a memory leak in MonetDatabaseMetaData.java for a static cache
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
857 which kept references to closed Connection objects.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
858
89
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
859 * Tue Jan 5 2016 Sjoerd Mullender <sjoerd@acm.org>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
860 - Compiled and released new JDBC driver jar: monetdb-jdbc-2.19.jar
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
861
89
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
862 * Fri Oct 30 2015 Sjoerd Mullender <sjoerd@acm.org>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
863 - Compiled and released new jars: monetdb-jdbc-2.18.jar, monetdb-mcl-1.13.jar
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
864 and updated jdbcclient.jar
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
865
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
866 * Thu Aug 6 2015 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.21.1-20150807
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
867 - Improved JDBC driver to not throw NullPointerException anymore
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
868 when calling isNullable() or getPrecision() or getScale() or
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
869 getColumnDisplaySize() or getSchemaName() or getTableName() or
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
870 getColumnClassName() on a ResultSetMetaData object.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
871
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
872 * Thu Jul 16 2015 Sjoerd Mullender <sjoerd@acm.org> - 11.21.1-20150807
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
873 - We now compile the Java classes using the latest Java 1.8 version, and
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
874 we tell it to compile for Java 1.7.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
875
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
876 * Mon Oct 7 2013 Sjoerd Mullender <sjoerd@acm.org> - 11.15.17-20131008
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
877 - Rearranged order of returned columns of certain metadata functions to
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
878 comply with the JDBC documentation. See bug 3356.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
879
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
880 * Sun Jun 9 2013 Fabian Groffen <fabian@monetdb.org> - 11.15.9-20130619
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
881 - Further improved setBigDecimal() method, based on patch by Ben Reilly
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
882 in bug #3290
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
883
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
884 * Thu May 23 2013 Fabian Groffen <fabian@monetdb.org> - 11.15.9-20130619
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
885 - Fixed bug where PreparedStatement.setBigDecimal() wouldn't format its
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
886 input well enough for the server causing odd errors.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
887 - Allow PreparedStatement.setXXX() methods to be called with null
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
888 arguments, bug #3288
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
889
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
890 * Thu Apr 11 2013 Sjoerd Mullender <sjoerd@acm.org> - 11.15.5-20130412
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
891 - The pre-compiled .jar files are now created using Java 7 instead of
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
892 Java 6.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
893
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
894 * Sat Dec 1 2012 Fabian Groffen <fabian@monetdb.org> - 11.15.1-20130212
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
895 - merocontrol was changed to return server URIs, and lastStop time.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
896 Connections and dbpath were removed.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
897 - Mapi protocol v8 support was removed from MapiSocket. Protocol
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
898 v8 has not been used by the servers any more since Apr2012 release
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
899
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
900 * Fri Nov 23 2012 Fabian Groffen <fabian@monetdb.org> - 11.13.7-20121212
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
901 - Implemented type map support of Connection to allow custom mapping
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
902 of UDTs to Java classes. By default the INET and URL UDTs are
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
903 now mapped to nl.cwi.monetdb.jdbc.types.{INET,URL}. Most notably,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
904 ResultSet.getObject() and PreparedStatement.setObject() deal with the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
905 type map.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
906
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
907 * Thu Nov 22 2012 Fabian Groffen <fabian@monetdb.org> - 11.13.7-20121212
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
908 - Fixed a problem in PreparedStatement where the prepared statement's
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
909 ResultSetMetaData (on its columns to be produced) incorrectly threw
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
910 exceptions about non existing columns. Bug #3192
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
911
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
912 * Wed Oct 10 2012 Fabian Groffen <fabian@cwi.nl> - 11.13.3-20121016
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
913 - Fixed problem with PreparedStatements and setXXX() methods using column
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
914 numbers instead of names, bug #3158
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
915
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
916 * Tue Aug 14 2012 Fabian Groffen <fabian@cwi.nl> - 11.11.9-20120911
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
917 - Fixed a bug where DatabaseMetaData.getURL() did return null:0 for
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
918 hostname:port.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
919
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
920 * Fri Jul 20 2012 Fabian Groffen <fabian@cwi.nl> - 11.11.7-20120813
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
921 - Fixed adaptive cache size used when retrieving results, not to cause
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
922 divide by zero errors when memory gets short, bug #3119.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
923
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
924 * Fri Mar 2 2012 Wouter Alink <wouter@spinque.com> - 11.9.1-20120418
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
925 - Password reading by JdbcClient no longer results in strange artifacts
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
926 - JdbcClient now returns exit code 1 in case of failures
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
927
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
928 * Tue Feb 28 2012 Fabian Groffen <fabian@cwi.nl> - 11.7.9-20120312
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
929 - Implemented missing Number types support in
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
930 PreparedStatement.setObject()
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
931
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
932 * Mon Feb 20 2012 Fabian Groffen <fabian@cwi.nl> - 11.7.7-20120224
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
933 - Fixed bug in DatabaseMetaData.getSchemas() method that caused an SQL
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
934 error when called with catalog and schema argument.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
935
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
936 * Tue Feb 14 2012 Fabian Groffen <fabian@cwi.nl> - 11.7.7-20120224
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
937 - Resolved a bug where JDBC and Control connections could terminate
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
938 abruptly with 'Connection closed' messages
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
939
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
940 * Mon Jan 2 2012 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
941 - Implemented getMetaData() method of PreparedStatement.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
942
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
943 * Tue Dec 27 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
944 - Fixed an AssertionError for special results from e.g. EXPLAIN queries.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
945
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
946 * Wed Dec 21 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
947 - Fixed overflow error when batching large statements, bug #2952
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
948
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
949 * Tue Dec 20 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
950 - Resolved a concurrency problem where ResultSet's date-related getters
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
951 could cause odd stack traces when used by multiple threads at the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
952 same time, bug #2950.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
953
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
954 * Mon Dec 19 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
955 - JDBC now implements JDBCv4.1 which makes it possible to be built with
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
956 Java 7 and up. JDBCv4.1 is a maintenance release of JDBCv4, and hence
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
957 can be compiled with Java 6, although the added methods obviously are
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
958 not part of the java.sql interfaces.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
959
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
960 * Sun Dec 11 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
961 - SQLExceptions thrown now carry a SQLSTATE. Until the server starts
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
962 sending correct SQLSTATEs for all errors, server originated errors
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
963 without SQLSTATE are considered generic data exceptions (22000).
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
964
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
965 * Sat Dec 10 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
966 - Fixed a bug where closing ResultSets and PreparedStatements could lead
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
967 to errors on concurrent running queries using the same Connection due
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
968 to a race condition.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
969
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
970 * Thu Dec 8 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
971 - Changed version scheme of JDBC driver and MCL jar to be more standard,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
972 from monetdb-X.Y-<thing>.jar to monetdb-<thing>-X.Y.jar, bug #2943
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
973
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
974 * Fri Oct 14 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
975 - The embedded monet instance capability of MonetConnection was removed.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
976 - Bump JDBC version to 2.0 (Liberica). JDBC now implements JDBCv4 which
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
977 makes it possible to be built with Java 6 and up. Java 5 and before
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
978 are no longer supported, and can use the 1.x releases of the driver.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
979
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
980 * Thu Sep 1 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
981 - INTERVAL columns are now treated as decimals, since they can have
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
982 sub-second precision.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
983
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
984 * Thu Jun 30 2011 Fabian Groffen <fabian@cwi.nl> - 11.5.1-20110907
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
985 - Add so_timeout Driver property to specify a SO_TIMEOUT value for the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
986 socket in use to the database. Setting this property to a value in
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
987 milliseconds defines the timeout for read calls, which may 'unlock'
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
988 the driver if the server hangs, bug #2828
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
989
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
990 * Wed May 25 2011 Fabian Groffen <fabian@cwi.nl> - 11.5.1-20110907
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
991 - Added a naive implementation for PreparedStatement.setCharacterStream
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
992
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
993 * Mon Apr 11 2011 Fabian Groffen <fabian@cwi.nl> - 11.5.1-20110907
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
994 - The obsolete Java-based implementation for PreparedStatements (formerly
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
995 activated using the java_prepared_statements property) has been dropped
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
996
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
997 * Fri Jul 8 2011 Fabian Groffen <fabian@cwi.nl> - 11.3.5-20110720
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
998 - Return false from Statement.getMoreResults() instead of a
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
999 NullPointerException when no query has been performed on the Statement
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1000 yet, bug #2833
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1001
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1002 * Mon Jun 6 2011 Fabian Groffen <fabian@cwi.nl> - 11.3.5-20110720
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1003 - Fixed read-only interpretation. Connection.isReadOnly now always
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1004 returns false, setReadOnly now generates a warning when called with
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1005 true. Partly from bug #2818
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1006 - Allow readonly to be set when autocommit is disabled as well. Bug #2818
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1007
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1008 * Wed May 11 2011 Fabian Groffen <fabian@cwi.nl> - 11.3.3-20110517
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1009 - Insertion via PreparedStatement and retrieval via ResultSet of timestamp
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1010 and time fields with and without timezones was improved to better
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1011 respect timezones, as partly indicated in bug #2781.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1012
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1013 * Tue Apr 5 2011 Fabian Groffen <fabian@cwi.nl> - 11.3.1-20110414
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1014 - clarify exception messages for unsupported methods
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1015
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1016 * Mon Feb 7 2011 Fabian Groffen <fabian@cwi.nl> - 11.3.1-20110414
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1017 - Removed XQuery related XRPC wrapper and XML:DB code, removed support
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1018 for language=xquery and language=mil from JDBC.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1019
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1020 * Wed Dec 15 2010 Fabian Groffen <fabian@cwi.nl> - 11.1.1-20110317
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1021 - PreparedStatements now free the server-side resources attached to them
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1022 when closed. This implements bug #2720
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1023
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1024 * Tue Nov 9 2010 Fabian Groffen <fabian@cwi.nl> - 1.40.1-20101110
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1025 - Fix SQL syntax of inserting BLOB code, using setBytes()
943
ff075ed5ce81 Spell check.
Sjoerd Mullender <sjoerd@acm.org>
parents: 927
diff changeset
1026 - Added property 'treat_blob_as_binary' to simulate BINARY types based on
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1027 BLOBs for applications, (e.g. Hibernate-based) that rely on BINARY's
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1028 byte array mapping
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1029 - Added code to handle BINARY types
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1030 - Fixed implementation of getBytes to match the specifications
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1031 - Implemented getBinaryStream according to the specifications
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1032
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1033 * Mon Nov 8 2010 Fabian Groffen <fabian@cwi.nl> - 1.40.1-20101109
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1034 - Java 1.6's subSequence() bug has changed into a slice() bug since
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1035 1.6.0_22. Revert workaround for subSequence breakage, since it breaks
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1036 operating with the latest Java 1.6.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1037
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1038 * Fri Oct 22 2010 Fabian Groffen <fabian@cwi.nl> - 1.40.1-20101029
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1039 - Fix for bug #2703, allow to have multiple metadata ResultSets open at
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1040 the same time
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1041
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1042 * Wed Aug 11 2010 Fabian Groffen <fabian@cwi.nl> - 1.38.5-20100823
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1043 - Implemented ResultSet's getCharacterStream methods, since Hibernate seems to
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1044 call this method for retrieving CLOB columns that we now do support.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1045
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1046 * Fri Aug 06 2010 Fabian Groffen <fabian@cwi.nl> - 1.38.5-20100823
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1047 - Fix implementation of setBytes method of PreparedStatement, such that bytes
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1048 are converted to MonetDB/SQL's BLOB notation.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1049
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1050 * Wed Jul 21 2010 Fabian Groffen <fabian@cwi.nl> - 1.38.5-20100823
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1051 - merocontrol Java library requires Java 2 Platform 1.5 and up, due to enum
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1052 and boxing/unboxing. Bug #2627
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1053
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1054 * Tue Jul 20 2010 Fabian Groffen <fabian@cwi.nl> - 1.38.5-20100823
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1055 - Implement missing Blob support (readonly), since getObject will blindly
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1056 return a BLOB instance as String, which is causing applications to wrongly
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1057 believe a BLOB instance is a string.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1058
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1059 * Fri Jul 16 2010 Fabian Groffen <fabian@cwi.nl> - 1.38.5-20100823
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1060 - Fix problem when using the MAL language. Any statement would return
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1061 an error with a typo that was not typed in by the user, such as
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1062 ioo.printf when io.printf was typed.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1063
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1064 * Fri Apr 16 2010 Fabian Groffen <fabian@cwi.nl> - Jun2010-SP1
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1065 - Enable the merovingian control library for default distribution as it
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1066 has been in use for some time without problems now.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1067
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1068 * Wed Mar 31 2010 Stefan Manegold <manegold@cwi.nl> - Jun2010-SP1
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1069 - Made compilation of "testing" (and "java") independent of MonetDB.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1070 This is mainly for Windows, but also on other systems, "testing" can now be
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1071 built independently of (and hence before) "MonetDB".
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1072 Files that mimic configure functionality on Windows were moved from
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1073 "MonetDB" to "buildtools"; hence, this affects all packages on Windows,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1074 requiring a complete rebuild from scratch on Windows.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1075 getopt() support in testing has changed; hence, (most probably) requiring a
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1076 rebuild from scratch of testing on other systems.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1077
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1078 * Wed Mar 31 2010 Fabian Groffen <fabian@cwi.nl> - Feb2010-SP2
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1079 - Do not to throw an SQLException, but generate a warning and try to
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1080 perform as much as requested in an optimistic manner, as not to break
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1081 clients that rely on the called method, but don't really use its
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1082 functionality (such as high-level generic programs that call any
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1083 driver and try to put it in a mode that it does what they expect).
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1084 The following functions no longer throw an SQLException but now
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1085 generate a warning and perform actions as far as possible:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1086 - Statement.execute(sql, columnIndexes/columnNames)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1087 - Statement.executeUpdate(sql, columnIndexes/columnNames)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1088 - Statement.getMaxFieldSize()
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1089 - Statement.setCursorName(name)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1090 - Statement.setEscapeProcessing(enable)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1091 - Statement.setMaxFieldSize(max)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1092 - Statement.setQueryTimeout(seconds)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1093 - PreparedStatement.getMetaData()
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1094 - PreparedStatement.setNull(paramIndex, sqlType, typeName)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1095
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1096 * Wed Mar 24 2010 Stefan Manegold <manegold@cwi.nl> - Jun2010-SP1
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1097 - Implemented build directory support for Windows,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1098 i.e., like on Unix/Linux also on Windows we can now build in a separate
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1099 build directory as alternative to ...\<package>\NT, and thus keep the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1100 latter clean from files generated during the build.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1101 On Windows, the build directory must be a sibling of ...\<package>\NT .
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1102
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1103 * Tue Mar 09 2010 Fabian Groffen <fabian@cwi.nl> - Feb2010-SP1
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1104 - Set JAVA_HOME to the configure derived value, such that ant will use
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1105 the javac compiler as found by configure, and not the one it was built
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1106 with itself. This solves the problem that the JDBC driver still fails
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1107 to compile on e.g. Fedora systems even though configure
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1108 --with-java=/path/to/sun/jdk-5 was given, because ant still uses
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1109 gjc/icedtea by itself.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1110
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1111 * Mon Oct 12 2009 Wouter Alink <w.alink@cwi.nl> - Aug2009-SP2
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1112 - Bump MCL version to 1.6 for fix.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1113
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1114 * Fri Oct 09 2009 Fabian Groffen <fabian@cwi.nl> - Feb2010
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1115 - Bump Java source version to 1.5. Java 1.5 is the current J2EE, and code
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1116 from nl.cwi.monetdb.merovingian relies on Java 1.5 features. It seems
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1117 like a good time to deprecate 1.4 now 1.6 is about to become the new
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1118 J2EE version.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1119
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1120 * Fri Oct 09 2009 Wouter Alink <w.alink@cwi.nl> - Aug2009-SP2
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1121 - applied workaround for bug in Sun JRE 1.6.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1122
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1123 * Thu Oct 01 2009 Fabian Groffen <fabian@cwi.nl> - Aug2009-SP2
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1124 - Bump JDBC version to 1.14 for fix.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1125
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1126 * Thu Oct 01 2009 Fabian Groffen <fabian@cwi.nl> - Aug2009-SP2
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1127 - Fix warning messages to disappear when a connection to merovingian is
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1128 made.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1129
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1130 * Sun Aug 23 2009 Fabian Groffen <fabian@cwi.nl> - Aug2009-SP1
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1131 - Bump JDBC version to 1.13 for fix.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1132
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1133 * Sun Aug 23 2009 Fabian Groffen <fabian@cwi.nl> - Aug2009-SP1
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1134 - Avoid "ResultSet is closed" messages by disabling the use of
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1135 finalizers, bug #2844202
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1136
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1137 * Thu Mar 26 2009 Fabian Groffen <fabian@cwi.nl> - Feb2010
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1138 - Fix configure handling for --enable-{jdbc,xrpc}, by Yue Sheng on
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1139 Monetdb-developers ML
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1140