annotate ChangeLog @ 218:5cc7101c5c8d

Corrected method DatabaseMetaData.getFunctions().
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 19 Apr 2018 19:03:40 +0200 (2018-04-19)
parents 71b039bc2d99
children 4572f0694fde
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
215
71b039bc2d99 Added support for querying the sys.comments table for some meta data methods
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
4 * Thu Apr 19 2018 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
218
5cc7101c5c8d Corrected method DatabaseMetaData.getFunctions().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 215
diff changeset
5 - Corrected method DatabaseMetaData.getFunctions() for result column
5cc7101c5c8d Corrected method DatabaseMetaData.getFunctions().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 215
diff changeset
6 FUNCTION_TYPE. It used to return DatabaseMetaData.functionResultUnknown
5cc7101c5c8d Corrected method DatabaseMetaData.getFunctions().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 215
diff changeset
7 value for when the internal function type was 6 (Analytic function) or 7
5cc7101c5c8d Corrected method DatabaseMetaData.getFunctions().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 215
diff changeset
8 (Loader function). It now returns DatabaseMetaData.functionNoTable value
5cc7101c5c8d Corrected method DatabaseMetaData.getFunctions().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 215
diff changeset
9 for those functions.
215
71b039bc2d99 Added support for querying the sys.comments table for some meta data methods
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
10 - DatabaseMetaData methods getTables(), getColumns(), getProcedures() and
71b039bc2d99 Added support for querying the sys.comments table for some meta data methods
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
11 getFunctions() now return the comment in the REMARKS result column when a
71b039bc2d99 Added support for querying the sys.comments table for some meta data methods
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
12 comment has been set for the table / view / column / procedure / function
71b039bc2d99 Added support for querying the sys.comments table for some meta data methods
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
13 via the SQL command COMMENT ON <db-object> IS 'comment-text'.
71b039bc2d99 Added support for querying the sys.comments table for some meta data methods
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 189
diff changeset
14
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
15 * 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
16 - 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
17 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
18
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
19 * 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
20 - 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
21 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
22 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
23
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
24 * 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
25 - 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
26 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
27 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
28 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
29 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
30 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
31 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
32 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
33 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
34 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
35 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
36 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
37 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
38 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
39 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
40 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
41 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
42 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
43 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
44 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
45
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
46 * 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
47 - 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
48 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
49
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
50 * 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
51 - 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
52 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
53 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
54 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
55
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
56 * 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
57 - 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
58 - 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
59 - 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
60 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
61 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
62
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
63 * 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
64 - 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
65 - 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
66 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
67 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
68 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
69 "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
70 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
71 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
72