Mercurial > hg > monetdb-java

annotate ChangeLog @ 191:fe8170e2b549 v2.27

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Corrected the hg URL to the new location: monetdb-java Updated the version number
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 19 Oct 2017 18:37:48 +0200 (2017-10-19)
parents 1834e6339279
children 71b039bc2d99
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
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: 184
diff changeset
4 * 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: 184
diff changeset
5 - 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: 184
diff changeset
6 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: 184
diff changeset
7
184
e0f76fedafc8 Corrected implementation of Connection.prepareCall() methods. They used to return null.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 177
diff changeset
8 * Thu Oct 5 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
e0f76fedafc8 Corrected implementation of Connection.prepareCall() methods. They used to return null.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 177
diff changeset
9 - Corrected method Connection.prepareCall(). It used to return null.
e0f76fedafc8 Corrected implementation of Connection.prepareCall() methods. They used to return null.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 177
diff changeset
10 Now it throws an SQLFeatureNotSupportedException to comply with the
e0f76fedafc8 Corrected implementation of Connection.prepareCall() methods. They used to return null.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 177
diff changeset
11 JDBC specification.
e0f76fedafc8 Corrected implementation of Connection.prepareCall() methods. They used to return null.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 177
diff changeset
12
175
8700d9ef2ace Added possibility via a connection property to let the JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
13 * Thu Sep 28 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8700d9ef2ace Added possibility via a connection property to let the JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
14 - Added possibility to let the JDBC driver return columnType value
8700d9ef2ace Added possibility via a connection property to let the JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
15 Types.VARCHAR instead of Types.CLOB in case the result column of a
8700d9ef2ace Added possibility via a connection property to let the JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
16 ResultSet or parameter in a PreparedStatement is of data type 'clob'.
8700d9ef2ace Added possibility via a connection property to let the JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
17 To enable this behavior provide it as JDBC connection URL property:
8700d9ef2ace Added possibility via a connection property to let the JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
18 treat_clob_as_varchar=true
8700d9ef2ace Added possibility via a connection property to let the JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
19 For example: jdbc:monetdb://localhost:50000/demo?treat_clob_as_varchar=true
8700d9ef2ace Added possibility via a connection property to let the JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
20 See also:
8700d9ef2ace Added possibility via a connection property to let the JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
21 https://www.monetdb.org/Documentation/Manuals/SQLreference/Programming/JDBC
8700d9ef2ace Added possibility via a connection property to let the JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
22 This custom clob mapping informs generic JDBC programs to fetch clob
8700d9ef2ace Added possibility via a connection property to let the JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
23 column values via method ResultSet.getString() instead of getClob()
8700d9ef2ace Added possibility via a connection property to let the JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
24 and Clob.getCharacterStream() and next fetching from the stream.
177
4959b85b981c Extend DatabaseMetaData.getClientInfoProperties() with new property: treat_clob_as_varchar
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 175
diff changeset
25 As MonetDB server MAPI communication protocol does not support
175
8700d9ef2ace Added possibility via a connection property to let the JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
26 streaming of parts of a CLOB value, the current implementation is to
8700d9ef2ace Added possibility via a connection property to let the JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
27 send over the whole CLOB value as a string. Therefore there is no
8700d9ef2ace Added possibility via a connection property to let the JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
28 performance gain when fetching those Clob values via getClob() and
8700d9ef2ace Added possibility via a connection property to let the JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
29 getCharacterStream(). In fact it creates a lot of overhead (additional
8700d9ef2ace Added possibility via a connection property to let the JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
30 objects and method calls) and triples the amount of needed Java Heap memory
8700d9ef2ace Added possibility via a connection property to let the JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
31 for each Clob value!
8700d9ef2ace Added possibility via a connection property to let the JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
32 With this connection property set, you can reduce this overhead when
8700d9ef2ace Added possibility via a connection property to let the JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
33 working with clob column data from generic JDBC programs.
8700d9ef2ace Added possibility via a connection property to let the JDBC driver
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
34
163
e398c27acf7e Implemented PreparedStatement methods setNCharacterStream(int, Reader) and setNCharacterStream(int, Reader, long).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 159
diff changeset
35 * Thu Sep 7 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
e398c27acf7e Implemented PreparedStatement methods setNCharacterStream(int, Reader) and setNCharacterStream(int, Reader, long).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 159
diff changeset
36 - Implemented PreparedStatement methods setNCharacterStream(int, Reader)
e398c27acf7e Implemented PreparedStatement methods setNCharacterStream(int, Reader) and setNCharacterStream(int, Reader, long).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 159
diff changeset
37 and setNCharacterStream(int, Reader, long).
e398c27acf7e Implemented PreparedStatement methods setNCharacterStream(int, Reader) and setNCharacterStream(int, Reader, long).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 159
diff changeset
38
159
8ea360b612de Corrected PreparedStatement methods setString(int, String) and setObject(int, Object, ...) in case the target parameter data type was json or inet or url or uuid.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 156
diff changeset
39 * Thu Aug 31 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8ea360b612de Corrected PreparedStatement methods setString(int, String) and setObject(int, Object, ...) in case the target parameter data type was json or inet or url or uuid.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 156
diff changeset
40 - Corrected PreparedStatement methods setString(int, String)
8ea360b612de Corrected PreparedStatement methods setString(int, String) and setObject(int, Object, ...) in case the target parameter data type was json or inet or url or uuid.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 156
diff changeset
41 and setObject(int, Object, ...) in case the target parameter
8ea360b612de Corrected PreparedStatement methods setString(int, String) and setObject(int, Object, ...) in case the target parameter data type was json or inet or url or uuid.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 156
diff changeset
42 data type was json or inet or url or uuid. See also
8ea360b612de Corrected PreparedStatement methods setString(int, String) and setObject(int, Object, ...) in case the target parameter data type was json or inet or url or uuid.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 156
diff changeset
43 https://www.monetdb.org/bugzilla/show_bug.cgi?id=6382
8ea360b612de Corrected PreparedStatement methods setString(int, String) and setObject(int, Object, ...) in case the target parameter data type was json or inet or url or uuid.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 156
diff changeset
44
153
836c49b890ec For public releases compile MonetDB JDBC driver code and jdbcclient program
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 152
diff changeset
45 * Thu Aug 24 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
156
2abd488159c4 Implemented PreparedStatement method setURL(int, URL).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 155
diff changeset
46 - Implemented PreparedStatement method setURL(int, URL).
2abd488159c4 Implemented PreparedStatement method setURL(int, URL).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 155
diff changeset
47 - Implemented PreparedStatement method setNString(int, String).
153
836c49b890ec For public releases compile MonetDB JDBC driver code and jdbcclient program
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 152
diff changeset
48 - The MonetDB JDBC driver code and jdbcclient program are now compiled
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: 184
diff changeset
49 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: 184
diff changeset
50 The new jar files are now some 20% smaller in size.
153
836c49b890ec For public releases compile MonetDB JDBC driver code and jdbcclient program
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 152
diff changeset
51
149
1e49fc74dba4 Implemented methods getCharacterStream() and getCharacterStream(long pos, long length) in class MonetClob.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
52 * Thu Aug 17 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
155
36f55bb8dd57 Implemented PreparedStatement method setNString().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 153
diff changeset
53 - Implemented ResultSet method getNCharacterStream().
149
1e49fc74dba4 Implemented methods getCharacterStream() and getCharacterStream(long pos, long length) in class MonetClob.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
54 - In class MonetClob implemented methods getCharacterStream()
1e49fc74dba4 Implemented methods getCharacterStream() and getCharacterStream(long pos, long length) in class MonetClob.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
55 and getCharacterStream(long pos, long length). Method
1e49fc74dba4 Implemented methods getCharacterStream() and getCharacterStream(long pos, long length) in class MonetClob.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
56 getCharacterStream() is called by DBeaver to fetch the Clob value.
1e49fc74dba4 Implemented methods getCharacterStream() and getCharacterStream(long pos, long length) in class MonetClob.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
57 It used to throw a SQLFeatureNotSupportedException with message:
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: 184
diff changeset
58 "Operation getCharacterStream() currently not supported". This caused
149
1e49fc74dba4 Implemented methods getCharacterStream() and getCharacterStream(long pos, long length) in class MonetClob.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
59 DBeaver to log the exception and show NULL as the value on screen,
1e49fc74dba4 Implemented methods getCharacterStream() and getCharacterStream(long pos, long length) in class MonetClob.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
60 which is incorrect. This has been fixed.
1e49fc74dba4 Implemented methods getCharacterStream() and getCharacterStream(long pos, long length) in class MonetClob.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 138
diff changeset
61