Mercurial > hg > monetdb-java
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 |
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 |