annotate ChangeLog @ 9:c37a76cc1e6e

Corrected ResultSet methods: getByte(), getBigDecimal(), getShort(), getInt(), getLong(), getFloat() and getDouble() in case the conversion to the native type failed due to a Number Format conversion error. It used to silently ignore the conversion error and return 0 instead, which is not correct. Now it throws an SQLException with message "Could not convert value to a number." and SQLstate "22003" meaning: Numeric value out of range.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 29 Sep 2016 16:43:45 +0200 (2016-09-29)
parents 2165c6f838fe
children 3fa949cbc783
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
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
4 * 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
5 - 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
6 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
7 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
8 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
9 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
10 "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
11 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
12
6
2165c6f838fe Add info to Changelog regarding changeset b07b4940c3ed
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 4
diff changeset
13 * 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
14 - 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
15 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
16
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
17 * 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
18 - Improved performance of following JDBC ResultSet and ResultSetMetaData
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
19 methods:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
20 - ResultSet.getBoolean(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
21 - ResultSet.getBinaryStream(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
22 - ResultSet.getBytes(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
23 - ResultSet.getObject(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
24 - ResultSet.getObject(column, map)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
25 - ResultSet.getDate(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
26 - ResultSet.getTime(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
27 - ResultSet.getTimestamp(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
28 - ResultSet.getDate(column, calendar)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
29 - ResultSet.getTime(column, calendar)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
30 - ResultSet.getTimestamp(column, calendar)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
31 - ResultSetMetaData.getColumnClassName(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
32 - ResultSetMetaData.getColumnType(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
33 - ResultSetMetaData.isCaseSensitive(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
34 - ResultSetMetaData.isSigned(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
35 - ResultSetMetaData.getPrecision(column)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
36
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
37 * 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
38 - Improved JdbcClient program by fixing some resource leaks.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
39 - 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
40 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
41
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
42 * 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
43 - 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
44
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
45 * 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
46 - 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
47