Mercurial > hg > monetdb-java

annotate ChangeLog @ 682:78253fdb3c3f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'. Those MonetDB type names can not be used in CREATE TABLE statements. Instead one has to use SQL type names: 'interval day', 'interval month' or 'interval second'. The JDBC driver now returns those SQL type names. This applies to methods: DatabaseMetaData.getTypeInfo() for the output column TYPE_NAME (the output column LOCAL_TYPE_NAME now returns the original type name), ResultSetMetaData.getColumnTypeName() and ParameterMetaData.getParameterTypeName().
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Fri, 04 Nov 2022 00:04:42 +0100 (2022-11-03)
parents cd6193bc5956
children fb55e62c50f3
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
89
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 53
diff changeset
1 # ChangeLog file for monetdb-java
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
2 # This file is updated with Maddlog
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
3
682
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
4 * Thu Nov 3 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
5 - Corrected returned SQL TypeName values for the MonetDB interval types:
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
6 'day_interval', 'month_interval' and 'sec_interval'. Those MonetDB
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
7 type names can not be used in CREATE TABLE statements. Instead
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
8 one has to use SQL type names: 'interval day', 'interval month' or
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
9 'interval second'. The JDBC driver now returns those SQL type names.
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
10 This applies to methods: DatabaseMetaData.getTypeInfo() for the output
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
11 column TYPE_NAME (the output column LOCAL_TYPE_NAME now returns
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
12 the original type name), ResultSetMetaData.getColumnTypeName() and
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
13 ParameterMetaData.getParameterTypeName().
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
14
667
ed3d0c1a60cf Corrected PreparedStatement methods getMetaData().getColumnDisplaySize(), getMetaData().getPrecision() and getParameterMetaData().getPrecision().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 665
diff changeset
15 * Thu Oct 27 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
ed3d0c1a60cf Corrected PreparedStatement methods getMetaData().getColumnDisplaySize(), getMetaData().getPrecision() and getParameterMetaData().getPrecision().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 665
diff changeset
16 - Corrected PreparedStatement methods getMetaData().getColumnDisplaySize(),
ed3d0c1a60cf Corrected PreparedStatement methods getMetaData().getColumnDisplaySize(), getMetaData().getPrecision() and getParameterMetaData().getPrecision().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 665
diff changeset
17 getMetaData().getPrecision() and getParameterMetaData().getPrecision().
ed3d0c1a60cf Corrected PreparedStatement methods getMetaData().getColumnDisplaySize(), getMetaData().getPrecision() and getParameterMetaData().getPrecision().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 665
diff changeset
18
665
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
19 * Thu Oct 20 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
20 - Improved implementation of method ResultSetMetaData.getPrecision(). It
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
21 now returns more accurate values for columns of type DECIMAL, NUMERIC,
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
22 CHAR, VARCHAR, CLOB, JSON, URL and BLOB.
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
23 - Improved implementation of method ResultSetMetaData.getScale(). It now
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
24 returns more accurate values for columns of type DECIMAL and NUMERIC.
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
25
659
0b564ae68ac1 Removed creation and distribution of monetdb-mcl-1.##.jre8.jar file.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 652
diff changeset
26 * Thu Sep 29 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
0b564ae68ac1 Removed creation and distribution of monetdb-mcl-1.##.jre8.jar file.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 652
diff changeset
27 - Removed creation and distribution of monetdb-mcl-1.##.jre8.jar file.
0b564ae68ac1 Removed creation and distribution of monetdb-mcl-1.##.jre8.jar file.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 652
diff changeset
28 Programmers who used this jar file should use monetdb-jdbc-3.#.jre8.jar file.
0b564ae68ac1 Removed creation and distribution of monetdb-mcl-1.##.jre8.jar file.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 652
diff changeset
29
672
cd6193bc5956 Update ChangeLog
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 667
diff changeset
30 * Fri Sep 09 2022 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
cd6193bc5956 Update ChangeLog
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 667
diff changeset
31 - Add autocommit=true/false option to the JDBC URL. The default remains 'true'.
cd6193bc5956 Update ChangeLog
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 667
diff changeset
32
652
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
33 * Wed Aug 24 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
34 - Improved DatabaseMetaData.getBestRowIdentifier(). When there are multiple
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
35 unique constraints and no pkey for a table it used to return the columns
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
36 of all the table unique constraints. Now it only returns the columns of
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
37 the first table unique constraint.
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
38 Also optimized the performance of getBestRowIdentifier(). It used to
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
39 send a separate query first to find out if the table had a pkey or not.
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
40 This extra query is now integrated so less queries are send to the server.
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
41
645
fbed03097738 Corrected DatabaseMetaData methods getPrimaryKeys(), getBestRowIdentifier() and getIndexInfo() for temporary tables in schema tmp.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 642
diff changeset
42 * Wed Mar 30 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
fbed03097738 Corrected DatabaseMetaData methods getPrimaryKeys(), getBestRowIdentifier() and getIndexInfo() for temporary tables in schema tmp.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 642
diff changeset
43 - Corrected DatabaseMetaData methods getPrimaryKeys(), getBestRowIdentifier()
648
03e0f577db00 Improve ChangeLog text.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 645
diff changeset
44 and getIndexInfo() for local temporary tables located in schema tmp. They
03e0f577db00 Improve ChangeLog text.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 645
diff changeset
45 did not return any rows when the temp table had a primary or unique key or
03e0f577db00 Improve ChangeLog text.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 645
diff changeset
46 index. Now they do return rows as expected.
645
fbed03097738 Corrected DatabaseMetaData methods getPrimaryKeys(), getBestRowIdentifier() and getIndexInfo() for temporary tables in schema tmp.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 642
diff changeset
47
642
dd9b4fb14256 Added recognition of 'xml' type.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
48 * Thu Feb 10 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
dd9b4fb14256 Added recognition of 'xml' type.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
49 - Added recognition of 'xml' type. Use default mapping to Types.VARCHAR for
dd9b4fb14256 Added recognition of 'xml' type.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
50 easy and fast (as java.lang.String) retrieval, display and setting data of
dd9b4fb14256 Added recognition of 'xml' type.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
51 columns of type 'xml'.
dd9b4fb14256 Added recognition of 'xml' type.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
52
636
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 619
diff changeset
53 * Thu Jan 27 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
606
f15df1ae41bc Remove old changes already from the ChangeLog.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 595
diff changeset
54 - Compiled and released new jar files: monetdb-jdbc-3.2.jre8.jar,
f15df1ae41bc Remove old changes already from the ChangeLog.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 595
diff changeset
55 monetdb-mcl-1.21.jre8.jar and jdbcclient.jre8.jar
f15df1ae41bc Remove old changes already from the ChangeLog.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 595
diff changeset
56
619
ffc2fc8e82ec Fixed an SQL query problem in DatabaseMetaData.getBestRowIdentifier() method when used with MonetDB Jan2022 (or newer) releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 611
diff changeset
57 * Wed Jan 19 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
ffc2fc8e82ec Fixed an SQL query problem in DatabaseMetaData.getBestRowIdentifier() method when used with MonetDB Jan2022 (or newer) releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 611
diff changeset
58 - Fixed an SQL query problem in DatabaseMetaData.getBestRowIdentifier()
ffc2fc8e82ec Fixed an SQL query problem in DatabaseMetaData.getBestRowIdentifier() method when used with MonetDB Jan2022 (or newer) releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 611
diff changeset
59 method when used with MonetDB Jan2022 (or newer) releases. It
ffc2fc8e82ec Fixed an SQL query problem in DatabaseMetaData.getBestRowIdentifier() method when used with MonetDB Jan2022 (or newer) releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 611
diff changeset
60 returned java.sql.SQLException:
ffc2fc8e82ec Fixed an SQL query problem in DatabaseMetaData.getBestRowIdentifier() method when used with MonetDB Jan2022 (or newer) releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 611
diff changeset
61 SELECT: with DISTINCT ORDER BY expressions must appear in select list
636
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 619
diff changeset
62 As of MonetDB Jan2022 (11.43.5) such queries are no longer allowed.
619
ffc2fc8e82ec Fixed an SQL query problem in DatabaseMetaData.getBestRowIdentifier() method when used with MonetDB Jan2022 (or newer) releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 611
diff changeset
63 The internally used SQL query has been improved.
ffc2fc8e82ec Fixed an SQL query problem in DatabaseMetaData.getBestRowIdentifier() method when used with MonetDB Jan2022 (or newer) releases.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 611
diff changeset
64
611
d2a141446e22 Extended JdbcClient application with support for more \d commands:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 606
diff changeset
65 * Thu Jan 13 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
d2a141446e22 Extended JdbcClient application with support for more \d commands:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 606
diff changeset
66 - Extended JdbcClient application with support for following \d commands:
d2a141446e22 Extended JdbcClient application with support for more \d commands:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 606
diff changeset
67 \dt \dv \dSt \dSv \df \dp \dSf \dSp \dn \dSn and \ds
d2a141446e22 Extended JdbcClient application with support for more \d commands:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 606
diff changeset
68 for showing list of: user tables, user views, system tables, system views,
d2a141446e22 Extended JdbcClient application with support for more \d commands:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 606
diff changeset
69 user functions, user procedures, system functions, system procedures,
d2a141446e22 Extended JdbcClient application with support for more \d commands:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 606
diff changeset
70 user schemas, system schemas and user sequences.
d2a141446e22 Extended JdbcClient application with support for more \d commands:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 606
diff changeset
71 For more information, see the built-in help (\?) on available commands.
d2a141446e22 Extended JdbcClient application with support for more \d commands:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 606
diff changeset
72
595
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
73 * Thu Nov 25 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
74 - Extended FileTransferHandler utility class by adding support for reading from
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
75 and writing to gzip compressed files when using file name extension .gz
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
76 Also improve error handling by testing on empty file name and provide more
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
77 information when invalid file name is given or other compression formats are
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
78 requested. As the FileTransferHandler utility class is used by JdbcClient
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
79 application, it will now also support this functionality.
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
80
611
d2a141446e22 Extended JdbcClient application with support for more \d commands:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 606
diff changeset
81 * Fri Nov 05 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
d2a141446e22 Extended JdbcClient application with support for more \d commands:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 606
diff changeset
82 - The JdbcClient application has been extended to support the new
d2a141446e22 Extended JdbcClient application with support for more \d commands:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 606
diff changeset
83 COPY ... ON CLIENT functionality.
d2a141446e22 Extended JdbcClient application with support for more \d commands:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 606
diff changeset
84 However for security reasons you must provide an explicit new startup argument
d2a141446e22 Extended JdbcClient application with support for more \d commands:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 606
diff changeset
85 --csvdir "/absolute/path/to/csvdatafiles"
d2a141446e22 Extended JdbcClient application with support for more \d commands:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 606
diff changeset
86 or on MS Windows
d2a141446e22 Extended JdbcClient application with support for more \d commands:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 606
diff changeset
87 --csvdir "C:\\path\\to\\csvdatafiles"
d2a141446e22 Extended JdbcClient application with support for more \d commands:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 606
diff changeset
88 in order to activate the JdbcClient application to down/up load data to/from
d2a141446e22 Extended JdbcClient application with support for more \d commands:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 606
diff changeset
89 the local file system.
d2a141446e22 Extended JdbcClient application with support for more \d commands:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 606
diff changeset
90
595
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
91 * Fri Nov 05 2021 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
92 - Extended the MonetDB JDBC driver with support for the ON CLIENT clause of
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
93 the COPY statements. To make use of this functionality you must first
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
94 register handlers for upload and download of data.
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
95 The MonetConnection class has been extended with 2 methods:
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
96 public void setUploadHandler(UploadHandler uploadHandler)
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
97 public void setDownloadHandler(DownloadHandler downloadHandler)
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
98 The MonetDB JDBC driver API has been extended with interfaces:
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
99 public interface org.monetdb.jdbc.MonetConnection.UploadHandler
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
100 public interface org.monetdb.jdbc.MonetConnection.DownloadHandler
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
101 See onclient.txt for more information on how to use these from Java.
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
102 We also provide a utility class:
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
103 public class org.monetdb.util.FileTransferHandler
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
104 which provides an example implementation of the MonetConnection.UploadHandler
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
105 and MonetConnection.DownloadHandler interfaces useable for reading files
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
106 from or writing files to a local file system.
36df3c89845d Extended FileTransferHandler utility class by adding support for reading from and writing to gzip compressed files when using file name extension .gz
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 482
diff changeset
107
476
5b99ca67825a Improve text in ChangeLog. Also remove old release 3.0 changes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 471
diff changeset
108 For a complete list of changes in previous monetdb-java releases see:
5b99ca67825a Improve text in ChangeLog. Also remove old release 3.0 changes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 471
diff changeset
109 https://www.monetdb.org/downloads/Java/archive/ChangeLog-Archive
606
f15df1ae41bc Remove old changes already from the ChangeLog.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 595
diff changeset
110