annotate ChangeLog @ 53:6cc63d6cb224

Implemented fix as suggested in Bug 3973 The MapiSocket object now supports getting and setting the socket timeout, even before the TCP socket is created. Also improved the close() method to continue closing all opened resources, even if one of them failed to close. To set the socket timeout specify it in the JDBC URL, for example: jdbc:monetdb://localhost:50000/demo?so_timeout=8000 This enables the timeout and sets it to 8000 milliseconds (= 8 seconds). By default the timeout is not set, so wait infinitely.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 17 Nov 2016 17:42:41 +0100 (2016-11-17)
parents 562dbfb2fee8
children a6608e9581c1
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1 # ChangeLog file for java
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
53
6cc63d6cb224 Implemented fix as suggested in Bug 3973
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 47
diff changeset
4 * Thu Nov 17 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
6cc63d6cb224 Implemented fix as suggested in Bug 3973
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 47
diff changeset
5 - The MapiSocket object now supports getting and setting the
6cc63d6cb224 Implemented fix as suggested in Bug 3973
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 47
diff changeset
6 socket timeout, even before the TCP socket is created. To set
6cc63d6cb224 Implemented fix as suggested in Bug 3973
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 47
diff changeset
7 the socket timeout specify it in the JDBC URL, for example:
6cc63d6cb224 Implemented fix as suggested in Bug 3973
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 47
diff changeset
8 jdbc:monetdb://localhost:50000/demo?so_timeout=8000
6cc63d6cb224 Implemented fix as suggested in Bug 3973
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 47
diff changeset
9 This enables the timeout and sets it to 8000 milliseconds (= 8 seconds).
6cc63d6cb224 Implemented fix as suggested in Bug 3973
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 47
diff changeset
10 By default the timeout is not set, so wait infinitely.
6cc63d6cb224 Implemented fix as suggested in Bug 3973
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 47
diff changeset
11
45
c2bf983dc79b Implemented Connection methods: getClientInfo(name) and getClientInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 18
diff changeset
12 * Thu Nov 10 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
c2bf983dc79b Implemented Connection methods: getClientInfo(name) and getClientInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 18
diff changeset
13 - Implemented Connection methods: getClientInfo(name) and getClientInfo().
c2bf983dc79b Implemented Connection methods: getClientInfo(name) and getClientInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 18
diff changeset
14 They used to return null and empty Properties object.
47
562dbfb2fee8 Prevent null pointer exception by checking props argument
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 45
diff changeset
15 Corrected implementation of Connection methods: setClientInfo(name, value)
562dbfb2fee8 Prevent null pointer exception by checking props argument
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 45
diff changeset
16 and setClientInfo(properties). They are now processed as expected.
562dbfb2fee8 Prevent null pointer exception by checking props argument
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 45
diff changeset
17 Corrected implementation of Connection.setHoldability(holdability). It now
562dbfb2fee8 Prevent null pointer exception by checking props argument
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 45
diff changeset
18 throws an SQLFeatureNotSupportedException when holdability is not
562dbfb2fee8 Prevent null pointer exception by checking props argument
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 45
diff changeset
19 ResultSet.HOLD_CURSORS_OVER_COMMIT (which is the only supported holdability).
45
c2bf983dc79b Implemented Connection methods: getClientInfo(name) and getClientInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 18
diff changeset
20
18
8e57d20b5e80 Corrected implementation of java.sql.Wrapper methods isWrapperFor() and unwrap().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 15
diff changeset
21 * Thu Oct 13 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8e57d20b5e80 Corrected implementation of java.sql.Wrapper methods isWrapperFor() and unwrap().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 15
diff changeset
22 - Corrected implementation of java.sql.Wrapper methods isWrapperFor()
8e57d20b5e80 Corrected implementation of java.sql.Wrapper methods isWrapperFor() and unwrap().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 15
diff changeset
23 and unwrap(). They now properly return expected results instead of
8e57d20b5e80 Corrected implementation of java.sql.Wrapper methods isWrapperFor() and unwrap().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 15
diff changeset
24 always return false or throw an SQLException.
8e57d20b5e80 Corrected implementation of java.sql.Wrapper methods isWrapperFor() and unwrap().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 15
diff changeset
25
14
3fa949cbc783 Implemented Statement methods: getQueryTimeout() and setQueryTimeout(int seconds).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 9
diff changeset
26 * Thu Oct 6 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
15
6e48d0fae766 Corrected return values of DatabaseMetaData methods nullsAreSortedHigh(), nullsAreSortedLow(),
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 14
diff changeset
27 - Corrected return values of DatabaseMetaData methods nullsAreSortedHigh(),
6e48d0fae766 Corrected return values of DatabaseMetaData methods nullsAreSortedHigh(), nullsAreSortedLow(),
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 14
diff changeset
28 nullsAreSortedLow(), getMaxCursorNameLength(), getMaxProcedureNameLength(),
6e48d0fae766 Corrected return values of DatabaseMetaData methods nullsAreSortedHigh(), nullsAreSortedLow(),
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 14
diff changeset
29 getMaxStatementLength() and getMaxUserNameLength().
6e48d0fae766 Corrected return values of DatabaseMetaData methods nullsAreSortedHigh(), nullsAreSortedLow(),
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 14
diff changeset
30 Improved return values of DatabaseMetaData methods getMaxBinaryLiteralLength(),
6e48d0fae766 Corrected return values of DatabaseMetaData methods nullsAreSortedHigh(), nullsAreSortedLow(),
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 14
diff changeset
31 getMaxCharLiteralLength() and getMaxColumnsInTable().
14
3fa949cbc783 Implemented Statement methods: getQueryTimeout() and setQueryTimeout(int seconds).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 9
diff changeset
32 - Implemented Statement methods: getQueryTimeout() and setQueryTimeout(int
3fa949cbc783 Implemented Statement methods: getQueryTimeout() and setQueryTimeout(int seconds).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 9
diff changeset
33 seconds). getQueryTimeout() used to always return 0, now it returns the
3fa949cbc783 Implemented Statement methods: getQueryTimeout() and setQueryTimeout(int seconds).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 9
diff changeset
34 query timeout retrieved from the server. setQueryTimeout(int seconds)
3fa949cbc783 Implemented Statement methods: getQueryTimeout() and setQueryTimeout(int seconds).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 9
diff changeset
35 used to always throw SQLException: query time outs not supported.
3fa949cbc783 Implemented Statement methods: getQueryTimeout() and setQueryTimeout(int seconds).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 9
diff changeset
36 Now it sets the query timeout for the current connection/session on
3fa949cbc783 Implemented Statement methods: getQueryTimeout() and setQueryTimeout(int seconds).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 9
diff changeset
37 the server.
3fa949cbc783 Implemented Statement methods: getQueryTimeout() and setQueryTimeout(int seconds).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 9
diff changeset
38
9
c37a76cc1e6e Corrected ResultSet methods: getByte(), getBigDecimal(), getShort(), getInt(), getLong(), getFloat() and getDouble()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 6
diff changeset
39 * Thu Sep 29 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
c37a76cc1e6e Corrected ResultSet methods: getByte(), getBigDecimal(), getShort(), getInt(), getLong(), getFloat() and getDouble()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 6
diff changeset
40 - Corrected ResultSet methods: getByte(), getBigDecimal(), getShort(),
c37a76cc1e6e Corrected ResultSet methods: getByte(), getBigDecimal(), getShort(), getInt(), getLong(), getFloat() and getDouble()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 6
diff changeset
41 getInt(), getLong(), getFloat() and getDouble() in case the conversion
c37a76cc1e6e Corrected ResultSet methods: getByte(), getBigDecimal(), getShort(), getInt(), getLong(), getFloat() and getDouble()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 6
diff changeset
42 to the native type failed due to a Number Format conversion error.
c37a76cc1e6e Corrected ResultSet methods: getByte(), getBigDecimal(), getShort(), getInt(), getLong(), getFloat() and getDouble()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 6
diff changeset
43 It used to silently ignore the conversion error and return 0 instead,
c37a76cc1e6e Corrected ResultSet methods: getByte(), getBigDecimal(), getShort(), getInt(), getLong(), getFloat() and getDouble()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 6
diff changeset
44 which is not correct. Now it throws an SQLException with message
c37a76cc1e6e Corrected ResultSet methods: getByte(), getBigDecimal(), getShort(), getInt(), getLong(), getFloat() and getDouble()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 6
diff changeset
45 "Could not convert value to a number." and SQLstate "22003" meaning:
c37a76cc1e6e Corrected ResultSet methods: getByte(), getBigDecimal(), getShort(), getInt(), getLong(), getFloat() and getDouble()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 6
diff changeset
46 Numeric value out of range.
c37a76cc1e6e Corrected ResultSet methods: getByte(), getBigDecimal(), getShort(), getInt(), getLong(), getFloat() and getDouble()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 6
diff changeset
47
6
2165c6f838fe Add info to Changelog regarding changeset b07b4940c3ed
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 4
diff changeset
48 * Thu Sep 22 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
2165c6f838fe Add info to Changelog regarding changeset b07b4940c3ed
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 4
diff changeset
49 - Improved JdbcClient program when doing dump of table definition. It now
2165c6f838fe Add info to Changelog regarding changeset b07b4940c3ed
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 4
diff changeset
50 outputs CREATE TABLE definition more similar to mclient program.
2165c6f838fe Add info to Changelog regarding changeset b07b4940c3ed
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 4
diff changeset
51
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
52 * Thu Sep 15 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
53 - Improved performance of following JDBC ResultSet and ResultSetMetaData
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
54 methods:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
55 - ResultSet.getBoolean(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
56 - ResultSet.getBinaryStream(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
57 - ResultSet.getBytes(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
58 - ResultSet.getObject(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
59 - ResultSet.getObject(column, map)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
60 - ResultSet.getDate(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
61 - ResultSet.getTime(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
62 - ResultSet.getTimestamp(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
63 - ResultSet.getDate(column, calendar)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
64 - ResultSet.getTime(column, calendar)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
65 - ResultSet.getTimestamp(column, calendar)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
66 - ResultSetMetaData.getColumnClassName(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
67 - ResultSetMetaData.getColumnType(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
68 - ResultSetMetaData.isCaseSensitive(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
69 - ResultSetMetaData.isSigned(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
70 - ResultSetMetaData.getPrecision(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
71
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
72 * Thu Sep 8 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
73 - Improved JdbcClient program by fixing some resource leaks.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
74 - Extended JdbcClient program by showing elapsed time information for each
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
75 query or command when started in interactive mode (no -f was used at startup).
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
76
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
77 * Thu Sep 1 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
78 - Improved fetching and output speed of JdbcClient program for query results.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
79
4
29b8dc4473b5 Updated changelog regarding changes made in https://dev.monetdb.org/hg/MonetDB/rev/1f2731776e1b
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
80 * Thu Aug 11 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
29b8dc4473b5 Updated changelog regarding changes made in https://dev.monetdb.org/hg/MonetDB/rev/1f2731776e1b
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
81 - Improved performance of method ResultSet.getObject(column_ID) significantly.
29b8dc4473b5 Updated changelog regarding changes made in https://dev.monetdb.org/hg/MonetDB/rev/1f2731776e1b
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
82