Mercurial > hg > monetdb-java

annotate ChangeLog @ 724:2b763b189452

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Corrected DatabaseMetaData.getUDTs() output. It used to return rows for system types: inet, json, url and uuid. However those are not User Defined Types. Now they are no longer returned by this method.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 19 Jan 2023 20:50:52 +0100 (2023-01-19)
parents 5d6c577e2f74
children ee061ab9ee32
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
724
2b763b189452 Corrected DatabaseMetaData.getUDTs() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 704
diff changeset
4 * Thu Jan 19 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
2b763b189452 Corrected DatabaseMetaData.getUDTs() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 704
diff changeset
5 - Corrected DatabaseMetaData.getUDTs() output. It used to return rows
2b763b189452 Corrected DatabaseMetaData.getUDTs() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 704
diff changeset
6 for system types: inet, json, url and uuid. However those are not User
2b763b189452 Corrected DatabaseMetaData.getUDTs() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 704
diff changeset
7 Defined Types. Now they are no longer returned by this method.
2b763b189452 Corrected DatabaseMetaData.getUDTs() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 704
diff changeset
8
704
5d6c577e2f74 Add a ChangeLog entry for change of method name in a MonetDB specific class.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 691
diff changeset
9 * Thu Dec 8 2022 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
5d6c577e2f74 Add a ChangeLog entry for change of method name in a MonetDB specific class.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 691
diff changeset
10 - Internal method waitForPrompt() of class BufferedMCLReader has been
5d6c577e2f74 Add a ChangeLog entry for change of method name in a MonetDB specific class.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 691
diff changeset
11 renamed to discardRemainder(). The example program SQLcopyinto.java
5d6c577e2f74 Add a ChangeLog entry for change of method name in a MonetDB specific class.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 691
diff changeset
12 which uses this method, has been updated.
5d6c577e2f74 Add a ChangeLog entry for change of method name in a MonetDB specific class.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 691
diff changeset
13
691
fb55e62c50f3 Fixed an invalid error issue when a PreparedStatement had more than 250 parameters.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 682
diff changeset
14 * Thu Nov 17 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
fb55e62c50f3 Fixed an invalid error issue when a PreparedStatement had more than 250 parameters.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 682
diff changeset
15 - Fixed an invalid error issue when a PreparedStatement had more than 250
fb55e62c50f3 Fixed an invalid error issue when a PreparedStatement had more than 250 parameters.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 682
diff changeset
16 parameters. See also https://github.com/MonetDB/MonetDB/issues/7337
fb55e62c50f3 Fixed an invalid error issue when a PreparedStatement had more than 250 parameters.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 682
diff changeset
17
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
18 * 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
19 - 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
20 '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
21 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
22 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
23 '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
24 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
25 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
26 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
27 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
28
667
ed3d0c1a60cf Corrected PreparedStatement methods getMetaData().getColumnDisplaySize(), getMetaData().getPrecision() and getParameterMetaData().getPrecision().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 665
diff changeset
29 * 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
30 - 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
31 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
32
665
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
33 * 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
34 - 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
35 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
36 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
37 - 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
38 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
39
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
40 * 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
41 - 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
42 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
43
672
cd6193bc5956 Update ChangeLog
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 667
diff changeset
44 * 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
45 - 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
46
652
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
47 * 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
48 - 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
49 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
50 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
51 the first table unique constraint.
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
52 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
53 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
54 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
55
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
56 * 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
57 - Corrected DatabaseMetaData methods getPrimaryKeys(), getBestRowIdentifier()
648
03e0f577db00 Improve ChangeLog text.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 645
diff changeset
58 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
59 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
60 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
61
642
dd9b4fb14256 Added recognition of 'xml' type.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
62 * 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
63 - 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
64 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
65 columns of type 'xml'.
dd9b4fb14256 Added recognition of 'xml' type.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
66
636
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 619
diff changeset
67 * 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
68 - 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
69 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
70
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
71 * 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
72 - 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
73 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
74 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
75 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
76 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
77 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
78
611
d2a141446e22 Extended JdbcClient application with support for more \d commands:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 606
diff changeset
79 * 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
80 - 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
81 \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
82 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
83 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
84 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
85 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
86
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
87 * 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
88 - 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
89 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
90 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
91 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
92 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
93 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
94
611
d2a141446e22 Extended JdbcClient application with support for more \d commands:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 606
diff changeset
95 * 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
96 - 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
97 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
98 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
99 --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
100 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
101 --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
102 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
103 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
104
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
105 * 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
106 - 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
107 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
108 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
109 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
110 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
111 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
112 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
113 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
114 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
115 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
116 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
117 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
118 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
119 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
120 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
121
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
122 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
123 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
124