Mercurial > hg > monetdb-java
annotate ChangeLog @ 471:e14e81b8044e
Improved performance of ResultSetMetaData methods getPrecision(), getScale(), isNullable() and isAutoIncrement().
The data is fetched from the server by sending a query. This used to be one query for each column of the ResultSet.
Now these queries are combined into one query fetching this meta data for up to 50 columns in one query.
This reduces the number of queries sent to the server significantly.
This is noticable for instance when using generic JDBC query tools such as SQuirreL, which now respond much faster.
author | Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
---|---|
date | Thu, 29 Apr 2021 22:56:37 +0200 (2021-04-29) |
parents | b9f82064fe0c |
children | 5b99ca67825a |
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 |
471
e14e81b8044e
Improved performance of ResultSetMetaData methods getPrecision(), getScale(), isNullable() and isAutoIncrement().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
450
diff
changeset
|
4 * Thu Apr 29 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
e14e81b8044e
Improved performance of ResultSetMetaData methods getPrecision(), getScale(), isNullable() and isAutoIncrement().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
450
diff
changeset
|
5 - Improved performance of ResultSetMetaData methods getPrecision(), |
e14e81b8044e
Improved performance of ResultSetMetaData methods getPrecision(), getScale(), isNullable() and isAutoIncrement().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
450
diff
changeset
|
6 getScale(), isNullable() and isAutoIncrement(). The data is fetched |
e14e81b8044e
Improved performance of ResultSetMetaData methods getPrecision(), getScale(), isNullable() and isAutoIncrement().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
450
diff
changeset
|
7 from the server by sending a query. This used to be one query for |
e14e81b8044e
Improved performance of ResultSetMetaData methods getPrecision(), getScale(), isNullable() and isAutoIncrement().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
450
diff
changeset
|
8 each column of the ResultSet. Now these queries are combined into |
e14e81b8044e
Improved performance of ResultSetMetaData methods getPrecision(), getScale(), isNullable() and isAutoIncrement().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
450
diff
changeset
|
9 one query fetching this meta data for up to 50 columns in one query. |
e14e81b8044e
Improved performance of ResultSetMetaData methods getPrecision(), getScale(), isNullable() and isAutoIncrement().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
450
diff
changeset
|
10 This reduces the number of queries sent to the server significantly. |
e14e81b8044e
Improved performance of ResultSetMetaData methods getPrecision(), getScale(), isNullable() and isAutoIncrement().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
450
diff
changeset
|
11 This is noticable for instance when using generic JDBC query tools |
e14e81b8044e
Improved performance of ResultSetMetaData methods getPrecision(), getScale(), isNullable() and isAutoIncrement().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
450
diff
changeset
|
12 such as SQuirreL, which now respond much faster. |
e14e81b8044e
Improved performance of ResultSetMetaData methods getPrecision(), getScale(), isNullable() and isAutoIncrement().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
450
diff
changeset
|
13 |
449
5ddfc0aa7f0e
Implemented fix for released monetdb-jdbc-3.0.jre8.jar and monetdb-mcl-1.19.jre8.jar when it is was run using java build 1.8.0_###.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
444
diff
changeset
|
14 * Wed Mar 3 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
450
b9f82064fe0c
Implemented PreparedStatement.toString() as requested by https://github.com/MonetDB/monetdb-java/issues/8
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
449
diff
changeset
|
15 - Implemented PreparedStatement.toString() as requested by |
b9f82064fe0c
Implemented PreparedStatement.toString() as requested by https://github.com/MonetDB/monetdb-java/issues/8
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
449
diff
changeset
|
16 https://github.com/MonetDB/monetdb-java/issues/8 |
b9f82064fe0c
Implemented PreparedStatement.toString() as requested by https://github.com/MonetDB/monetdb-java/issues/8
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
449
diff
changeset
|
17 |
b9f82064fe0c
Implemented PreparedStatement.toString() as requested by https://github.com/MonetDB/monetdb-java/issues/8
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
449
diff
changeset
|
18 * Wed Mar 3 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
449
5ddfc0aa7f0e
Implemented fix for released monetdb-jdbc-3.0.jre8.jar and monetdb-mcl-1.19.jre8.jar when it is was run using java build 1.8.0_###.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
444
diff
changeset
|
19 - Implemented fix for released monetdb-jdbc-3.0.jre8.jar and |
5ddfc0aa7f0e
Implemented fix for released monetdb-jdbc-3.0.jre8.jar and monetdb-mcl-1.19.jre8.jar when it is was run using java build 1.8.0_###.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
444
diff
changeset
|
20 monetdb-mcl-1.19.jre8.jar when it is was run using java build |
5ddfc0aa7f0e
Implemented fix for released monetdb-jdbc-3.0.jre8.jar and monetdb-mcl-1.19.jre8.jar when it is was run using java build 1.8.0_###.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
444
diff
changeset
|
21 1.8.0_###. It would throw: java.lang.NoSuchMethodError: |
5ddfc0aa7f0e
Implemented fix for released monetdb-jdbc-3.0.jre8.jar and monetdb-mcl-1.19.jre8.jar when it is was run using java build 1.8.0_###.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
444
diff
changeset
|
22 java.nio.CharBuffer.mark()Ljava/nio/CharBuffer; at |
5ddfc0aa7f0e
Implemented fix for released monetdb-jdbc-3.0.jre8.jar and monetdb-mcl-1.19.jre8.jar when it is was run using java build 1.8.0_###.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
444
diff
changeset
|
23 org.monetdb.mcl.parser.StartOfHeaderParser.getNextAsString(Unknown |
5ddfc0aa7f0e
Implemented fix for released monetdb-jdbc-3.0.jre8.jar and monetdb-mcl-1.19.jre8.jar when it is was run using java build 1.8.0_###.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
444
diff
changeset
|
24 Source) at |
5ddfc0aa7f0e
Implemented fix for released monetdb-jdbc-3.0.jre8.jar and monetdb-mcl-1.19.jre8.jar when it is was run using java build 1.8.0_###.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
444
diff
changeset
|
25 org.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(Unknown |
5ddfc0aa7f0e
Implemented fix for released monetdb-jdbc-3.0.jre8.jar and monetdb-mcl-1.19.jre8.jar when it is was run using java build 1.8.0_###.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
444
diff
changeset
|
26 Source) at |
5ddfc0aa7f0e
Implemented fix for released monetdb-jdbc-3.0.jre8.jar and monetdb-mcl-1.19.jre8.jar when it is was run using java build 1.8.0_###.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
444
diff
changeset
|
27 org.monetdb.jdbc.MonetConnection$ResponseList.processQuery(Unknown |
5ddfc0aa7f0e
Implemented fix for released monetdb-jdbc-3.0.jre8.jar and monetdb-mcl-1.19.jre8.jar when it is was run using java build 1.8.0_###.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
444
diff
changeset
|
28 Source) at org.monetdb.jdbc.MonetStatement.internalExecute(Unknown |
5ddfc0aa7f0e
Implemented fix for released monetdb-jdbc-3.0.jre8.jar and monetdb-mcl-1.19.jre8.jar when it is was run using java build 1.8.0_###.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
444
diff
changeset
|
29 Source) at org.monetdb.jdbc.MonetStatement.execute(Unknown Source) |
5ddfc0aa7f0e
Implemented fix for released monetdb-jdbc-3.0.jre8.jar and monetdb-mcl-1.19.jre8.jar when it is was run using java build 1.8.0_###.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
444
diff
changeset
|
30 The problem is caused by a change in java.nio.CharBuffer API (return |
5ddfc0aa7f0e
Implemented fix for released monetdb-jdbc-3.0.jre8.jar and monetdb-mcl-1.19.jre8.jar when it is was run using java build 1.8.0_###.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
444
diff
changeset
|
31 types of methods mark() and reset() have changed from Buffer to |
5ddfc0aa7f0e
Implemented fix for released monetdb-jdbc-3.0.jre8.jar and monetdb-mcl-1.19.jre8.jar when it is was run using java build 1.8.0_###.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
444
diff
changeset
|
32 CharBuffer) from Java 8 to Java 9+. |
5ddfc0aa7f0e
Implemented fix for released monetdb-jdbc-3.0.jre8.jar and monetdb-mcl-1.19.jre8.jar when it is was run using java build 1.8.0_###.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
444
diff
changeset
|
33 |
444
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
34 * Wed Feb 17 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
35 - Compiled and released new jar files: monetdb-jdbc-3.0.jre8.jar, |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
36 monetdb-mcl-1.19.jre8.jar and jdbcclient.jre8.jar |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
37 |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
38 monetdb-jdbc-3.0.jre8.jar is a new major release of the MonetDB JDBC driver. |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
39 The MonetDB JDBC Driver is now compliant with the Java??? Database |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
40 Connectivity (JDBC) 4.2 specification as defined in Java 8 and requires |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
41 Java 8 runtime (profile compact2) as minimum version. |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
42 |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
43 Important: the MonetDB JDBC driver class name has also been changed in |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
44 this release to: org.monetdb.jdbc.MonetDriver. The old driver class |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
45 (nl.cwi.monetdb.jdbc.MonetDriver) is also included in the jar file, but |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
46 only to ease the transition for existing deployments. It will be removed |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
47 in a future release of this JDBC driver. Please use the new driver |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
48 class name if this is used in your configuration files or Java code. |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
49 |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
50 The JdbcClient program (jdbcclient.jre8.jar) has been extended with |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
51 functionality to validate the integrity of the system tables (\vsci) or |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
52 to validate the integrity of data in tables of a specific schema (\vsi xyz) |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
53 based on defined declarative constraints (pkey, fkey, not null, etc.). |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
54 This will be usefull to find and report inconsistencies in your database. |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
55 This functionality is a beta release. Please let us know if you |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
56 encounter any issues running it. See below for more information. |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
57 |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
58 Besides a few bug fixes also performance has been improved in multiple areas. |
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
59 |
427
e79bfbd0553e
Added support for escaped wildcards (\% en \_) in String arguments of
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
421
diff
changeset
|
60 * Wed Feb 3 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
e79bfbd0553e
Added support for escaped wildcards (\% en \_) in String arguments of
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
421
diff
changeset
|
61 - Added support for escaped wildcards (\% en \_) in String arguments of |
e79bfbd0553e
Added support for escaped wildcards (\% en \_) in String arguments of
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
421
diff
changeset
|
62 DatabaseMetaData methods which return a ResultSet, such as getTables(), |
e79bfbd0553e
Added support for escaped wildcards (\% en \_) in String arguments of
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
421
diff
changeset
|
63 getColumns(), etc. When you do not want the characters % or _ to be |
e79bfbd0553e
Added support for escaped wildcards (\% en \_) in String arguments of
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
421
diff
changeset
|
64 interpreted as wildcards but as normal characters you can prefix them |
e79bfbd0553e
Added support for escaped wildcards (\% en \_) in String arguments of
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
421
diff
changeset
|
65 with a backslash (so \% and \_). Note: be sure all wildcards characters |
e79bfbd0553e
Added support for escaped wildcards (\% en \_) in String arguments of
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
421
diff
changeset
|
66 in the String argument are escaped else the search must still use a |
e79bfbd0553e
Added support for escaped wildcards (\% en \_) in String arguments of
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
421
diff
changeset
|
67 LIKE operator instead of an = comparison operator. |
e79bfbd0553e
Added support for escaped wildcards (\% en \_) in String arguments of
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
421
diff
changeset
|
68 This fixes: https://github.com/MonetDB/monetdb-java/issues/3 |
e79bfbd0553e
Added support for escaped wildcards (\% en \_) in String arguments of
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
421
diff
changeset
|
69 |
420
a0f99a81ce8e
Extend the generation of FOREIGN KEY CONSTRAINTS with ON UPDATE and ON DELETE rules.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
419
diff
changeset
|
70 * Thu Jan 28 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
421
163b784aa93b
Added full ordering to correct issues when retrieving columns from fks where a table has multiple fks to the same table.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
420
diff
changeset
|
71 - Corrected the ordering of the output of DatabaseMetaData methods |
163b784aa93b
Added full ordering to correct issues when retrieving columns from fks where a table has multiple fks to the same table.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
420
diff
changeset
|
72 getImportedKeys(), getExportedKeys() and getCrossReference(). In cases |
163b784aa93b
Added full ordering to correct issues when retrieving columns from fks where a table has multiple fks to the same table.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
420
diff
changeset
|
73 where a table would have multiple fks to the same external table, |
163b784aa93b
Added full ordering to correct issues when retrieving columns from fks where a table has multiple fks to the same table.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
420
diff
changeset
|
74 the output was not as expected. This has been corrected, so the columns |
163b784aa93b
Added full ordering to correct issues when retrieving columns from fks where a table has multiple fks to the same table.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
420
diff
changeset
|
75 now appear in the order as defined in the creation of the fks. |
163b784aa93b
Added full ordering to correct issues when retrieving columns from fks where a table has multiple fks to the same table.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
420
diff
changeset
|
76 |
163b784aa93b
Added full ordering to correct issues when retrieving columns from fks where a table has multiple fks to the same table.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
420
diff
changeset
|
77 * Thu Jan 28 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
420
a0f99a81ce8e
Extend the generation of FOREIGN KEY CONSTRAINTS with ON UPDATE and ON DELETE rules.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
419
diff
changeset
|
78 - The dumping of table definitions from JdbcClient program has been |
a0f99a81ce8e
Extend the generation of FOREIGN KEY CONSTRAINTS with ON UPDATE and ON DELETE rules.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
419
diff
changeset
|
79 improved. It now includes the ON UPDATE and ON DELETE rules for foreign |
a0f99a81ce8e
Extend the generation of FOREIGN KEY CONSTRAINTS with ON UPDATE and ON DELETE rules.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
419
diff
changeset
|
80 key constraints. Also it no longer generates CREATE INDEX statements |
a0f99a81ce8e
Extend the generation of FOREIGN KEY CONSTRAINTS with ON UPDATE and ON DELETE rules.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
419
diff
changeset
|
81 for foreign key constraints whose name is not system generated but |
a0f99a81ce8e
Extend the generation of FOREIGN KEY CONSTRAINTS with ON UPDATE and ON DELETE rules.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
419
diff
changeset
|
82 user specified. |
a0f99a81ce8e
Extend the generation of FOREIGN KEY CONSTRAINTS with ON UPDATE and ON DELETE rules.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
419
diff
changeset
|
83 |
415
50e43af49d47
Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
405
diff
changeset
|
84 * Thu Jan 14 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
50e43af49d47
Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
405
diff
changeset
|
85 - Improved DatabaseMetaData.getTypeInfo() output for temporal data |
50e43af49d47
Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
405
diff
changeset
|
86 types: sec_interval, day_interval, month_interval, date, time, timetz, |
50e43af49d47
Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
405
diff
changeset
|
87 timestamp and timestamptz. |
50e43af49d47
Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
405
diff
changeset
|
88 |
405
6242351e8802
Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
391
diff
changeset
|
89 * Wed Jan 6 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
6242351e8802
Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
391
diff
changeset
|
90 - Corrected output of resultset columns UPDATE_RULE and DELETE_RULE |
6242351e8802
Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
391
diff
changeset
|
91 when calling DatabaseMetaData API methods getImportedKeys() or |
6242351e8802
Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
391
diff
changeset
|
92 getExportedKeys() or getCrossReference(). These columns used to |
6242351e8802
Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
391
diff
changeset
|
93 always return DatabaseMetaData.importedKeyNoAction but now they |
6242351e8802
Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
391
diff
changeset
|
94 can also report the other values when set: |
6242351e8802
Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
391
diff
changeset
|
95 DatabaseMetaData.importedKeyCascade |
6242351e8802
Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
391
diff
changeset
|
96 or DatabaseMetaData.importedKeyRestrict |
6242351e8802
Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
391
diff
changeset
|
97 or DatabaseMetaData.importedKeySetNull |
6242351e8802
Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
391
diff
changeset
|
98 or DatabaseMetaData.importedKeySetDefault. |
6242351e8802
Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
391
diff
changeset
|
99 |
391
f523727db392
Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.*
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
386
diff
changeset
|
100 * Thu Nov 12 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
f523727db392
Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.*
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
386
diff
changeset
|
101 - Moved Java classes from packages starting with nl.cwi.monetdb.* |
f523727db392
Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.*
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
386
diff
changeset
|
102 to package org.monetdb.* This naming complies to the Java Package |
f523727db392
Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.*
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
386
diff
changeset
|
103 Naming convention as MonetDB's main website is www.monetdb.org. |
f523727db392
Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.*
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
386
diff
changeset
|
104 To prevent problems with existing Java programs and JDBC driver |
f523727db392
Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.*
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
386
diff
changeset
|
105 configurations we still support usage of the following classes: |
f523727db392
Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.*
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
386
diff
changeset
|
106 nl.cwi.monetdb.jdbc.MonetDriver |
f523727db392
Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.*
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
386
diff
changeset
|
107 nl.cwi.monetdb.jdbc.types.INET |
f523727db392
Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.*
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
386
diff
changeset
|
108 nl.cwi.monetdb.jdbc.types.URL |
f523727db392
Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.*
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
386
diff
changeset
|
109 nl.cwi.monetdb.mcl.net.MapiSocket |
f523727db392
Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.*
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
386
diff
changeset
|
110 nl.cwi.monetdb.client.JdbcClient |
f523727db392
Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.*
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
386
diff
changeset
|
111 They are implemented as simple wrappers of their org.monetdb.* equivalents. |
415
50e43af49d47
Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
405
diff
changeset
|
112 Note: These nl.cwi.monetdb.* classes are now marked as deprecated and may |
50e43af49d47
Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
405
diff
changeset
|
113 be removed in a future release. If you still use them in your Java code or |
50e43af49d47
Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
405
diff
changeset
|
114 configuration files, update them to use the new package names. |
391
f523727db392
Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.*
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
386
diff
changeset
|
115 |
386
15b87fd68052
Extended JdbcClient program with 3 new commands to quickly validate data integrity:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
383
diff
changeset
|
116 * Thu Oct 29 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
15b87fd68052
Extended JdbcClient program with 3 new commands to quickly validate data integrity:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
383
diff
changeset
|
117 - Extended JdbcClient program with 3 new commands to quickly validate |
15b87fd68052
Extended JdbcClient program with 3 new commands to quickly validate data integrity:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
383
diff
changeset
|
118 data integrity: |
15b87fd68052
Extended JdbcClient program with 3 new commands to quickly validate data integrity:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
383
diff
changeset
|
119 \vsci validate sql system catalog integrity |
15b87fd68052
Extended JdbcClient program with 3 new commands to quickly validate data integrity:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
383
diff
changeset
|
120 \vsi <schema> validate integrity of data in the given schema |
15b87fd68052
Extended JdbcClient program with 3 new commands to quickly validate data integrity:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
383
diff
changeset
|
121 \vdbi validate integrity of data in all user schemas in the database |
15b87fd68052
Extended JdbcClient program with 3 new commands to quickly validate data integrity:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
383
diff
changeset
|
122 The current validations include: |
15b87fd68052
Extended JdbcClient program with 3 new commands to quickly validate data integrity:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
383
diff
changeset
|
123 - Primary Key uniqueness |
15b87fd68052
Extended JdbcClient program with 3 new commands to quickly validate data integrity:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
383
diff
changeset
|
124 - Primary Key column(s) being NOT NULL (currently only for \vsci) |
15b87fd68052
Extended JdbcClient program with 3 new commands to quickly validate data integrity:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
383
diff
changeset
|
125 - Unique constraint uniqueness |
419
d9f9e077cd03
Finish implementation of foreign key referential integrity checks for user tables.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
415
diff
changeset
|
126 - Foreign Key referential integrity |
386
15b87fd68052
Extended JdbcClient program with 3 new commands to quickly validate data integrity:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
383
diff
changeset
|
127 - Column NOT NULL constraint |
15b87fd68052
Extended JdbcClient program with 3 new commands to quickly validate data integrity:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
383
diff
changeset
|
128 - Varchar(n) max length constraint |
15b87fd68052
Extended JdbcClient program with 3 new commands to quickly validate data integrity:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
383
diff
changeset
|
129 - Idem for char(n), clob(n), blob(n), json(n) and url(n). |
415
50e43af49d47
Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
405
diff
changeset
|
130 It can be usefull to run \vsci before and after an upgrade of MonetDB server. |
386
15b87fd68052
Extended JdbcClient program with 3 new commands to quickly validate data integrity:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
383
diff
changeset
|
131 Use \vsi my_schema to validate data in all tables of a specific schema. |
15b87fd68052
Extended JdbcClient program with 3 new commands to quickly validate data integrity:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
383
diff
changeset
|
132 Use \vdbi to validate integrity of data in all user schemas in |
415
50e43af49d47
Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
405
diff
changeset
|
133 the database. Note: this can take a while, depending on your number |
444
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
134 of user schemas, tables, columns and rows. Despite being tested on several |
386
15b87fd68052
Extended JdbcClient program with 3 new commands to quickly validate data integrity:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
383
diff
changeset
|
135 internal dbs the functionality is still beta, so you can get false |
444
bc39810b3faa
Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
427
diff
changeset
|
136 errors reported. If you encounter any let us know asap. |
386
15b87fd68052
Extended JdbcClient program with 3 new commands to quickly validate data integrity:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
383
diff
changeset
|
137 |
381
11c30e3b7966
Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
380
diff
changeset
|
138 * Thu Oct 8 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
383
19a5583a7b5f
Improved performance of ResultSetMetaData methods isAutoIncrement(), getPrecision() and getScale() significant for columns of specific data types as in some cases no costly meta data query is executed anymore.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
381
diff
changeset
|
139 - Improved performance of ResultSetMetaData methods isAutoIncrement(), |
405
6242351e8802
Corrected output of resultset columns UPDATE_RULE and DELETE_RULE when calling DatabaseMetaData API methods getImportedKeys() or getExportedKeys() or getCrossReference().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
391
diff
changeset
|
140 getPrecision() and getScale() significantly for columns of specific data |
383
19a5583a7b5f
Improved performance of ResultSetMetaData methods isAutoIncrement(), getPrecision() and getScale() significant for columns of specific data types as in some cases no costly meta data query is executed anymore.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
381
diff
changeset
|
141 types as in some cases no costly meta data query is executed anymore. |
415
50e43af49d47
Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
405
diff
changeset
|
142 |
50e43af49d47
Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
405
diff
changeset
|
143 * Thu Oct 8 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
381
11c30e3b7966
Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
380
diff
changeset
|
144 - The connection properties treat_clob_as_varchar and treat_blob_as_binary |
11c30e3b7966
Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
380
diff
changeset
|
145 are now set to true by default within the JDBC driver. This is done |
11c30e3b7966
Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
380
diff
changeset
|
146 as it results by default in less memory usage, (much) faster response |
11c30e3b7966
Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
380
diff
changeset
|
147 and better user experience for many generic JDBC applications (like |
11c30e3b7966
Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
380
diff
changeset
|
148 SQuirreL SQL, DBeaver, etc) when fetching data from CLOB or BLOB result |
11c30e3b7966
Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
380
diff
changeset
|
149 columns. See release.txt for more information and how you can turn |
11c30e3b7966
Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
380
diff
changeset
|
150 it off to get the old JDBC driver behavior if you require it. |
11c30e3b7966
Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
380
diff
changeset
|
151 |
380
bf521f343172
Added support for new Java 8 java.sql.Types: Types.TIME_WITH_TIMEZONE and Types.TIMESTAMP_WITH_TIMEZONE.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
376
diff
changeset
|
152 * Wed Oct 7 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
bf521f343172
Added support for new Java 8 java.sql.Types: Types.TIME_WITH_TIMEZONE and Types.TIMESTAMP_WITH_TIMEZONE.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
376
diff
changeset
|
153 - Added support for new Java 8 java.sql.Types: Types.TIME_WITH_TIMEZONE and |
bf521f343172
Added support for new Java 8 java.sql.Types: Types.TIME_WITH_TIMEZONE and Types.TIMESTAMP_WITH_TIMEZONE.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
376
diff
changeset
|
154 Types.TIMESTAMP_WITH_TIMEZONE. |
bf521f343172
Added support for new Java 8 java.sql.Types: Types.TIME_WITH_TIMEZONE and Types.TIMESTAMP_WITH_TIMEZONE.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
376
diff
changeset
|
155 |
375
a229ac4e275c
Corrected MonetDatabaseMetaData.getTypeInfo()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
369
diff
changeset
|
156 * Wed Sep 23 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
376
ffdc7b0e102d
Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
375
diff
changeset
|
157 - Updated JDBC driver to comply with JDBC 4.2 interface now we compile |
ffdc7b0e102d
Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
375
diff
changeset
|
158 for Java 8. This includes: |
ffdc7b0e102d
Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
375
diff
changeset
|
159 - adding 8 methods to MonetCallableStatement |
ffdc7b0e102d
Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
375
diff
changeset
|
160 - adding 2 methods to MonetDatabaseMetaData |
ffdc7b0e102d
Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
375
diff
changeset
|
161 - adding 3 methods to MonetPreparedStatement |
ffdc7b0e102d
Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
375
diff
changeset
|
162 - adding 4 methods to MonetResultSet |
ffdc7b0e102d
Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
375
diff
changeset
|
163 - adding 8 methods to MonetStatement |
415
50e43af49d47
Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
405
diff
changeset
|
164 |
50e43af49d47
Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
405
diff
changeset
|
165 * Wed Sep 23 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
375
a229ac4e275c
Corrected MonetDatabaseMetaData.getTypeInfo()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
369
diff
changeset
|
166 - Corrected MonetDatabaseMetaData.getTypeInfo() |
376
ffdc7b0e102d
Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
375
diff
changeset
|
167 - The LITERAL_PREFIX column now includes the required casting name for |
ffdc7b0e102d
Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
375
diff
changeset
|
168 types: clob, inet, json, url, uuid and blob. |
ffdc7b0e102d
Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
375
diff
changeset
|
169 - The SEARCHABLE column now returns typePredBasic instead of typeSearchable |
ffdc7b0e102d
Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
375
diff
changeset
|
170 for type: blob. |
ffdc7b0e102d
Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
375
diff
changeset
|
171 - The AUTO_INCREMENT column now returns false for types: hugeint, decimal, |
ffdc7b0e102d
Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
375
diff
changeset
|
172 oid and wrd. |
375
a229ac4e275c
Corrected MonetDatabaseMetaData.getTypeInfo()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
369
diff
changeset
|
173 |
363
34ce6e1b1be8
Remove support for deprecated MD5 encryption algorithm in MapiSocket.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
356
diff
changeset
|
174 * Thu Sep 10 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
34ce6e1b1be8
Remove support for deprecated MD5 encryption algorithm in MapiSocket.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
356
diff
changeset
|
175 - Removed support for deprecated MD5 encryption algorithm in MapiSocket. |
34ce6e1b1be8
Remove support for deprecated MD5 encryption algorithm in MapiSocket.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
356
diff
changeset
|
176 |
34ce6e1b1be8
Remove support for deprecated MD5 encryption algorithm in MapiSocket.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
356
diff
changeset
|
177 * Wed Sep 9 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
34ce6e1b1be8
Remove support for deprecated MD5 encryption algorithm in MapiSocket.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
356
diff
changeset
|
178 - Corrected Statement.executeBatch() method. It now implicitly clears the |
34ce6e1b1be8
Remove support for deprecated MD5 encryption algorithm in MapiSocket.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
356
diff
changeset
|
179 batch buffer, ready to accept new addBatch() calls without the need for |
34ce6e1b1be8
Remove support for deprecated MD5 encryption algorithm in MapiSocket.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
356
diff
changeset
|
180 an explicit clearBatch() call. |
34ce6e1b1be8
Remove support for deprecated MD5 encryption algorithm in MapiSocket.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
356
diff
changeset
|
181 See also https://www.monetdb.org/bugzilla/show_bug.cgi?id=6953 |
34ce6e1b1be8
Remove support for deprecated MD5 encryption algorithm in MapiSocket.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
356
diff
changeset
|
182 |
356
eabbc5bf7cdb
Corrected the return value of getCatalogTerm();
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
354
diff
changeset
|
183 * Wed Feb 19 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
eabbc5bf7cdb
Corrected the return value of getCatalogTerm();
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
354
diff
changeset
|
184 - Corrected the return value of getCatalogTerm() to "cat". |
eabbc5bf7cdb
Corrected the return value of getCatalogTerm();
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
354
diff
changeset
|
185 |
354
b1f8750e6cde
Switch to Java 8 compilation and distribution as Java 7 is no longer supported.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
339
diff
changeset
|
186 * Wed Feb 12 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
b1f8750e6cde
Switch to Java 8 compilation and distribution as Java 7 is no longer supported.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
339
diff
changeset
|
187 - As Java 7 is no longer supported we now compile for Java 8 as the |
b1f8750e6cde
Switch to Java 8 compilation and distribution as Java 7 is no longer supported.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
339
diff
changeset
|
188 minimum required JVM version (profile compact2). |
b1f8750e6cde
Switch to Java 8 compilation and distribution as Java 7 is no longer supported.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents:
339
diff
changeset
|
189 |