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