monetdb-java: ChangeLog-Archive annotate

annotate ChangeLog-Archive @ 925:4dfdb62e3e9d

Extend JDBC_API_Tester program with optional second startup argument '-skipMALoutput'. This allows the JDBC_API_Tester program to be called to skip the comparing the MAL output of tests which return MAL output such as PLAN, EXPLAIN and TRACE statements. It is intended for internal development use only.

author	Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date	Thu, 08 Aug 2024 15:26:28 +0200 (9 months ago)
parents	01da1ea91c3f
children	d311affc65f0

rev	line source
337 55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	1 # ChangeLog-Archive file for monetdb-java
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	2 # This file contains all past monetdb-java ChangeLog entries
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	3 # For every new release the ChangeLog is prepended to this file.
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	4
739 01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	5 * Thu Feb 23 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	6 - Compiled and released new jar files: monetdb-jdbc-3.3.jre8.jar and
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	7 jdbcclient.jre8.jar
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	8
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	9 * Thu Feb 9 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	10 - Corrected DatabaseMetaData.getSQLKeywords() output. It used to return
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	11 all MonetDB SQL keywords, but now it excludes the SQL:2003 keywords
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	12 as defined by the Java JDBC API specification.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	13
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	14 * Thu Jan 19 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	15 - Corrected DatabaseMetaData.getUDTs() output. It used to return rows
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	16 for system types: inet, json, url and uuid. However those are not User
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	17 Defined Types. Now they are no longer returned by this method.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	18
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	19 * Thu Dec 8 2022 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	20 - Internal method waitForPrompt() of class BufferedMCLReader has been
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	21 renamed to discardRemainder(). The example program SQLcopyinto.java
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	22 which uses this method, has been updated.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	23
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	24 * Thu Nov 17 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	25 - Fixed an invalid error issue when a PreparedStatement had more than 250
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	26 parameters. See also https://github.com/MonetDB/MonetDB/issues/7337
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	27
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	28 * Thu Nov 3 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	29 - Corrected returned SQL TypeName values for the MonetDB interval types:
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	30 'day_interval', 'month_interval' and 'sec_interval'. Those MonetDB
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	31 type names can not be used in CREATE TABLE statements. Instead
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	32 one has to use SQL type names: 'interval day', 'interval month' or
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	33 'interval second'. The JDBC driver now returns those SQL type names.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	34 This applies to methods: DatabaseMetaData.getTypeInfo() for the output
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	35 column TYPE_NAME (the output column LOCAL_TYPE_NAME now returns
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	36 the original type name), ResultSetMetaData.getColumnTypeName() and
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	37 ParameterMetaData.getParameterTypeName().
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	38
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	39 * Thu Oct 27 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	40 - Corrected PreparedStatement methods getMetaData().getColumnDisplaySize(),
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	41 getMetaData().getPrecision() and getParameterMetaData().getPrecision().
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	42
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	43 * Thu Oct 20 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	44 - Improved implementation of method ResultSetMetaData.getPrecision(). It
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	45 now returns more accurate values for columns of type DECIMAL, NUMERIC,
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	46 CHAR, VARCHAR, CLOB, JSON, URL and BLOB.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	47 - Improved implementation of method ResultSetMetaData.getScale(). It now
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	48 returns more accurate values for columns of type DECIMAL and NUMERIC.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	49
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	50 * Thu Sep 29 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	51 - Removed creation and distribution of monetdb-mcl-1.##.jre8.jar file.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	52 Programmers who used this jar file should use monetdb-jdbc-3.#.jre8.jar file.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	53
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	54 * Fri Sep 09 2022 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	55 - Add autocommit=true/false option to the JDBC URL. The default remains 'true'.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	56
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	57 * Wed Aug 24 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	58 - Improved DatabaseMetaData.getBestRowIdentifier(). When there are multiple
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	59 unique constraints and no pkey for a table it used to return the columns
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	60 of all the table unique constraints. Now it only returns the columns of
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	61 the first table unique constraint.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	62 Also optimized the performance of getBestRowIdentifier(). It used to
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	63 send a separate query first to find out if the table had a pkey or not.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	64 This extra query is now integrated so less queries are send to the server.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	65
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	66 * Wed Mar 30 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	67 - Corrected DatabaseMetaData methods getPrimaryKeys(), getBestRowIdentifier()
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	68 and getIndexInfo() for local temporary tables located in schema tmp. They
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	69 did not return any rows when the temp table had a primary or unique key or
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	70 index. Now they do return rows as expected.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	71
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	72 * Thu Feb 10 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	73 - Added recognition of 'xml' type. Use default mapping to Types.VARCHAR for
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	74 easy and fast (as java.lang.String) retrieval, display and setting data of
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	75 columns of type 'xml'.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	76
636 fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	77 * Thu Jan 27 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	78 - Compiled and released new jar files: monetdb-jdbc-3.2.jre8.jar,
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	79 monetdb-mcl-1.21.jre8.jar and jdbcclient.jre8.jar
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	80
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	81 * Wed Jan 19 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	82 - Fixed an SQL query problem in DatabaseMetaData.getBestRowIdentifier()
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	83 method when used with MonetDB Jan2022 (or newer) releases. It
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	84 returned java.sql.SQLException:
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	85 SELECT: with DISTINCT ORDER BY expressions must appear in select list
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	86 As of MonetDB Jan2022 (11.43.5) such queries are no longer allowed.
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	87 The internally used SQL query has been improved.
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	88
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	89 * Thu Jan 13 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	90 - Extended JdbcClient application with support for following \d commands:
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	91 \dt \dv \dSt \dSv \df \dp \dSf \dSp \dn \dSn and \ds
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	92 for showing list of: user tables, user views, system tables, system views,
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	93 user functions, user procedures, system functions, system procedures,
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	94 user schemas, system schemas and user sequences.
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	95 For more information, see the built-in help (\?) on available commands.
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	96
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	97 * Thu Nov 25 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	98 - Extended FileTransferHandler utility class by adding support for reading from
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	99 and writing to gzip compressed files when using file name extension .gz
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	100 Also improve error handling by testing on empty file name and provide more
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	101 information when invalid file name is given or other compression formats are
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	102 requested. As the FileTransferHandler utility class is used by JdbcClient
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	103 application, it will now also support this functionality.
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	104
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	105 * Fri Nov 05 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	106 - The JdbcClient application has been extended to support the new
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	107 COPY ... ON CLIENT functionality.
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	108 However for security reasons you must provide an explicit new startup argument
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	109 --csvdir "/absolute/path/to/csvdatafiles"
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	110 or on MS Windows
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	111 --csvdir "C:\\path\\to\\csvdatafiles"
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	112 in order to activate the JdbcClient application to down/up load data to/from
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	113 the local file system.
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	114
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	115 * Fri Nov 05 2021 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	116 - Extended the MonetDB JDBC driver with support for the ON CLIENT clause of
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	117 the COPY statements. To make use of this functionality you must first
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	118 register handlers for upload and download of data.
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	119 The MonetConnection class has been extended with 2 methods:
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	120 public void setUploadHandler(UploadHandler uploadHandler)
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	121 public void setDownloadHandler(DownloadHandler downloadHandler)
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	122 The MonetDB JDBC driver API has been extended with interfaces:
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	123 public interface org.monetdb.jdbc.MonetConnection.UploadHandler
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	124 public interface org.monetdb.jdbc.MonetConnection.DownloadHandler
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	125 See onclient.txt for more information on how to use these from Java.
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	126 We also provide a utility class:
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	127 public class org.monetdb.util.FileTransferHandler
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	128 which provides an example implementation of the MonetConnection.UploadHandler
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	129 and MonetConnection.DownloadHandler interfaces useable for reading files
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	130 from or writing files to a local file system.
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	131
482 73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	132 * Mon Jun 14 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	133 - Compiled and released new jar files: monetdb-jdbc-3.1.jre8.jar,
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	134 monetdb-mcl-1.20.jre8.jar and jdbcclient.jre8.jar
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	135
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	136 * Thu Apr 29 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	137 - Improved performance of ResultSetMetaData methods getPrecision(),
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	138 getScale(), isNullable() and isAutoIncrement(). The data is fetched
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	139 from the server by sending a query. This used to be one query for
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	140 each column of the ResultSet. Now these metadata queries are combined
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	141 into one query fetching this meta data for up to 50 columns in one query.
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	142 This reduces the number of queries sent to the server significantly.
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	143 This is noticable for instance when using generic JDBC query tools
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	144 such as SQuirreL, DBeaver, which now respond much faster.
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	145
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	146 * Wed Mar 3 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	147 - Implemented PreparedStatement.toString() as requested by
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	148 https://github.com/MonetDB/monetdb-java/issues/8
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	149
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	150 * Wed Mar 3 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	151 - Implemented fix for released monetdb-jdbc-3.0.jre8.jar and
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	152 monetdb-mcl-1.19.jre8.jar when it is was run using java build 1.8.0_###.
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	153 It would throw:
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	154 java.lang.NoSuchMethodError: java.nio.CharBuffer.mark()Ljava/nio/CharBuffer;
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	155 at org.monetdb.mcl.parser.StartOfHeaderParser.getNextAsString(Unknown Source)
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	156 at org.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(Unknown Source)
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	157 at org.monetdb.jdbc.MonetConnection$ResponseList.processQuery(Unknown Source)
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	158 at org.monetdb.jdbc.MonetStatement.internalExecute(Unknown Source)
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	159 at org.monetdb.jdbc.MonetStatement.execute(Unknown Source)
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	160 The problem is caused by a change in java.nio.CharBuffer API (return
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	161 types of methods mark() and reset() have changed from Buffer to
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	162 CharBuffer) from Java 8 to Java 9+.
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	163
445 8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	164 * Wed Feb 17 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	165 - Compiled and released new jar files: monetdb-jdbc-3.0.jre8.jar,
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	166 monetdb-mcl-1.19.jre8.jar and jdbcclient.jre8.jar
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	167
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	168 monetdb-jdbc-3.0.jre8.jar is a new major release of the MonetDB JDBC driver.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	169 The MonetDB JDBC Driver is now compliant with the Java??? Database
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	170 Connectivity (JDBC) 4.2 specification as defined in Java 8 and requires
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	171 Java 8 runtime (profile compact2) as minimum version.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	172
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	173 Important: the MonetDB JDBC driver class name has also been changed in
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	174 this release to: org.monetdb.jdbc.MonetDriver. The old driver class
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	175 (nl.cwi.monetdb.jdbc.MonetDriver) is also included in the jar file, but
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	176 only to ease the transition for existing deployments. It will be removed
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	177 in a future release of this JDBC driver. Please use the new driver
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	178 class name if this is used in your configuration files or Java code.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	179
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	180 The JdbcClient program (jdbcclient.jre8.jar) has been extended with
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	181 functionality to validate the integrity of the system tables (\vsci) or
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	182 to validate the integrity of data in tables of a specific schema (\vsi xyz)
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	183 based on defined declarative constraints (pkey, fkey, not null, etc.).
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	184 This will be usefull to find and report inconsistencies in your database.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	185 This functionality is a beta release. Please let us know if you
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	186 encounter any issues running it. See below for more information.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	187
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	188 Besides a few bug fixes also performance has been improved in multiple areas.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	189
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	190 * Wed Feb 3 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	191 - Added support for escaped wildcards (\% en \_) in String arguments of
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	192 DatabaseMetaData methods which return a ResultSet, such as getTables(),
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	193 getColumns(), etc. When you do not want the characters % or _ to be
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	194 interpreted as wildcards but as normal characters you can prefix them
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	195 with a backslash (so \% and \_). Note: be sure all wildcards characters
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	196 in the String argument are escaped else the search must still use a
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	197 LIKE operator instead of an = comparison operator.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	198 This fixes: https://github.com/MonetDB/monetdb-java/issues/3
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	199
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	200 * Thu Jan 28 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	201 - Corrected the ordering of the output of DatabaseMetaData methods
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	202 getImportedKeys(), getExportedKeys() and getCrossReference(). In cases
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	203 where a table would have multiple fks to the same external table,
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	204 the output was not as expected. This has been corrected, so the columns
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	205 now appear in the order as defined in the creation of the fks.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	206
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	207 * Thu Jan 28 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	208 - The dumping of table definitions from JdbcClient program has been
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	209 improved. It now includes the ON UPDATE and ON DELETE rules for foreign
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	210 key constraints. Also it no longer generates CREATE INDEX statements
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	211 for foreign key constraints whose name is not system generated but
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	212 user specified.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	213
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	214 * Thu Jan 14 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	215 - Improved DatabaseMetaData.getTypeInfo() output for temporal data
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	216 types: sec_interval, day_interval, month_interval, date, time, timetz,
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	217 timestamp and timestamptz.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	218
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	219 * Wed Jan 6 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	220 - Corrected output of resultset columns UPDATE_RULE and DELETE_RULE
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	221 when calling DatabaseMetaData API methods getImportedKeys() or
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	222 getExportedKeys() or getCrossReference(). These columns used to
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	223 always return DatabaseMetaData.importedKeyNoAction but now they
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	224 can also report the other values when set:
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	225 DatabaseMetaData.importedKeyCascade
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	226 or DatabaseMetaData.importedKeyRestrict
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	227 or DatabaseMetaData.importedKeySetNull
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	228 or DatabaseMetaData.importedKeySetDefault.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	229
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	230 * Thu Nov 12 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	231 - Moved Java classes from packages starting with nl.cwi.monetdb.*
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	232 to package org.monetdb.* This naming complies to the Java Package
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	233 Naming convention as MonetDB's main website is www.monetdb.org.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	234 To prevent problems with existing Java programs and JDBC driver
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	235 configurations we still support usage of the following classes:
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	236 nl.cwi.monetdb.jdbc.MonetDriver
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	237 nl.cwi.monetdb.jdbc.types.INET
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	238 nl.cwi.monetdb.jdbc.types.URL
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	239 nl.cwi.monetdb.mcl.net.MapiSocket
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	240 nl.cwi.monetdb.client.JdbcClient
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	241 They are implemented as simple wrappers of their org.monetdb.* equivalents.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	242 Note: These nl.cwi.monetdb.* classes are now marked as deprecated and may
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	243 be removed in a future release. If you still use them in your Java code or
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	244 configuration files, update them to use the new package names.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	245
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	246 * Thu Oct 29 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	247 - Extended JdbcClient program with 3 new commands to quickly validate
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	248 data integrity:
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	249 \vsci validate sql system catalog integrity
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	250 \vsi <schema> validate integrity of data in the given schema
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	251 \vdbi validate integrity of data in all user schemas in the database
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	252 The current validations include:
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	253 - Primary Key uniqueness
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	254 - Primary Key column(s) being NOT NULL (currently only for \vsci)
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	255 - Unique constraint uniqueness
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	256 - Foreign Key referential integrity
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	257 - Column NOT NULL constraint
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	258 - Varchar(n) max length constraint
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	259 - Idem for char(n), clob(n), blob(n), json(n) and url(n).
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	260 It can be usefull to run \vsci before and after an upgrade of MonetDB server.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	261 Use \vsi my_schema to validate data in all tables of a specific schema.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	262 Use \vdbi to validate integrity of data in all user schemas in
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	263 the database. Note: this can take a while, depending on your number
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	264 of user schemas, tables, columns and rows. Despite being tested on several
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	265 internal dbs the functionality is still beta, so you can get false
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	266 errors reported. If you encounter any let us know asap.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	267
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	268 * Thu Oct 8 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	269 - Improved performance of ResultSetMetaData methods isAutoIncrement(),
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	270 getPrecision() and getScale() significantly for columns of specific data
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	271 types as in some cases no costly meta data query is executed anymore.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	272
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	273 * Thu Oct 8 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	274 - The connection properties treat_clob_as_varchar and treat_blob_as_binary
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	275 are now set to true by default within the JDBC driver. This is done
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	276 as it results by default in less memory usage, (much) faster response
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	277 and better user experience for many generic JDBC applications (like
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	278 SQuirreL SQL, DBeaver, etc) when fetching data from CLOB or BLOB result
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	279 columns. See release.txt for more information and how you can turn
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	280 it off to get the old JDBC driver behavior if you require it.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	281
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	282 * Wed Oct 7 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	283 - Added support for new Java 8 java.sql.Types: Types.TIME_WITH_TIMEZONE and
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	284 Types.TIMESTAMP_WITH_TIMEZONE.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	285
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	286 * Wed Sep 23 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	287 - Updated JDBC driver to comply with JDBC 4.2 interface now we compile
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	288 for Java 8. This includes:
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	289 - adding 8 methods to MonetCallableStatement
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	290 - adding 2 methods to MonetDatabaseMetaData
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	291 - adding 3 methods to MonetPreparedStatement
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	292 - adding 4 methods to MonetResultSet
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	293 - adding 8 methods to MonetStatement
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	294
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	295 * Wed Sep 23 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	296 - Corrected MonetDatabaseMetaData.getTypeInfo()
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	297 - The LITERAL_PREFIX column now includes the required casting name for
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	298 types: clob, inet, json, url, uuid and blob.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	299 - The SEARCHABLE column now returns typePredBasic instead of typeSearchable
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	300 for type: blob.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	301 - The AUTO_INCREMENT column now returns false for types: hugeint, decimal,
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	302 oid and wrd.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	303
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	304 * Thu Sep 10 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	305 - Removed support for deprecated MD5 encryption algorithm in MapiSocket.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	306
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	307 * Wed Sep 9 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	308 - Corrected Statement.executeBatch() method. It now implicitly clears the
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	309 batch buffer, ready to accept new addBatch() calls without the need for
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	310 an explicit clearBatch() call.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	311 See also https://www.monetdb.org/bugzilla/show_bug.cgi?id=6953
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	312
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	313 * Wed Feb 19 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	314 - Corrected the return value of getCatalogTerm() to "cat".
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	315
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	316 * Wed Feb 12 2020 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	317 - As Java 7 is no longer supported we now compile for Java 8 as the
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	318 minimum required JVM version (profile compact2).
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	319
339 71a79126a390 Added general release notes on the new release in the ChangeLog Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 338 diff changeset	320 * Thu Sep 26 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
337 55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	321 - Compiled and released new jar files: monetdb-jdbc-2.29.jre7.jar,
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	322 monetdb-mcl-1.18.jre7.jar and jdbcclient.jre7.jar
339 71a79126a390 Added general release notes on the new release in the ChangeLog Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 338 diff changeset	323 - Following issues are resolved with this new MonetDB JDBC driver release:
71a79126a390 Added general release notes on the new release in the ChangeLog Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 338 diff changeset	324 - JDBC: Support for Connection.prepareCall()
71a79126a390 Added general release notes on the new release in the ChangeLog Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 338 diff changeset	325 See https://www.monetdb.org/bugzilla/show_bug.cgi?id=6402
71a79126a390 Added general release notes on the new release in the ChangeLog Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 338 diff changeset	326 We implemented the java.sql.CallableStatement interface.
71a79126a390 Added general release notes on the new release in the ChangeLog Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 338 diff changeset	327 - Jdbc connection hangs
71a79126a390 Added general release notes on the new release in the ChangeLog Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 338 diff changeset	328 See https://www.monetdb.org/bugzilla/show_bug.cgi?id=6571
71a79126a390 Added general release notes on the new release in the ChangeLog Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 338 diff changeset	329 - Mix of long and short queries make JDBC-driver hang
71a79126a390 Added general release notes on the new release in the ChangeLog Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 338 diff changeset	330 See https://www.monetdb.org/bugzilla/show_bug.cgi?id=6693
71a79126a390 Added general release notes on the new release in the ChangeLog Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 338 diff changeset	331 - Example SQLcopyinto.java does not work
71a79126a390 Added general release notes on the new release in the ChangeLog Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 338 diff changeset	332 See https://www.monetdb.org/bugzilla/show_bug.cgi?id=6646
71a79126a390 Added general release notes on the new release in the ChangeLog Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 338 diff changeset	333 Also improvements are made in:
71a79126a390 Added general release notes on the new release in the ChangeLog Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 338 diff changeset	334 - reducing the number of objects created (and thereby heap memory size)
71a79126a390 Added general release notes on the new release in the ChangeLog Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 338 diff changeset	335 - reducing number of methods called
71a79126a390 Added general release notes on the new release in the ChangeLog Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 338 diff changeset	336 - robustness, more checks on invalid parameter values
71a79126a390 Added general release notes on the new release in the ChangeLog Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 338 diff changeset	337 - performance
337 55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	338
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	339 * Wed Sep 25 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	340 - The jar files are now named according to Java version compatibility.
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	341 For example, the monetdb-jdbc-2.29.jre7.jar file should be used with
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	342 Java 7 or higher.
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	343
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	344 * Wed Sep 18 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	345 - Corrected method DatabaseMetaData.getBestRowIdentifier(). It used to
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	346 return columns of both primary key and unique constraints. Now it only
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	347 returns the columns of the primary key if it has one, else columns of
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	348 a unique constraint.
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	349
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	350 * Wed Sep 11 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	351 - Optimized parse() method of TupleLineParser by creating less helper objects
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	352 and replacing method calls by direct operations on variables.
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	353
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	354 * Wed Sep 4 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	355 - Corrected JdbcClient program: the dumping of a view DDL was incorrect when
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	356 the view creation statement was not starting with "create view ", such as
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	357 when it was created using "create or replace view". It now shows the
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	358 value as stored in sys.tables.query field, similar to mclient program.
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	359
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	360 * Thu Aug 22 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	361 - Improved JdbcClient program by including the schema prefix when dumping
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	362 schema objects. It now behaves more similar to: mclient -D -N.
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	363 - Improved JdbcClient program. It now also dumps definitions of MERGE TABLE,
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	364 REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping (all) tables.
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	365
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	366 * Wed Aug 14 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	367 - Improved MonetDatabaseMetaData methods:
338 98018e38994b Correct getNumericFunctions() which incorrectly returned functions 'code' and 'space' as numeric functions. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 337 diff changeset	368 - getNumericFunctions(): it now includes function: sys.alpha
337 55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	369 - getNumericFunctions(): it no longer lists functions: not_uniques and rotate_xor_hash
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	370 - getStringFunctions(): it now includes functions: json.isarray, json.isobject,
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	371 json.isvalid, sys.reverse which accept a string value as argument
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	372 - getStringFunctions(): it no longer lists functions: copyfrom, get_value_for, next_value_for, restart.
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	373 - getSystemFunctions(): it now includes system functions: get_value_for, hash,
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	374 next_value_for, sys.columnsize, sys.debug, sys.hashsize, sys.heapsize,
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	375 sys.imprintsize, sys.isauuid, sys.md5, sys.newurl, sys.password_hash, isaurl
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	376 - getSystemFunctions(): it no longer lists function: getlimit.
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	377 Also some functions require the prefix "sys." or "json." when used
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	378 from another schema. This is now included in the names returned by
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	379 methods getNumericFunctions(), getStringFunctions(), getSystemFunctions()
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	380 and getTimeDateFunctions().
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	381
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	382 * Wed Jul 31 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	383 - Corrected MonetDatabaseMetaData methods:
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	384 - getNumericFunctions(): it now includes function: pi.
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	385 - getSystemFunctions(): it no longer lists numeric functions: pi and rand.
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	386 - supportsSchemasInIndexDefinitions(): changed from true to false
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	387 - Optimised MonetStatement memory resource usage by only creating an ArrayList
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	388 and ReentrantLock object when the batch methods addBatch() or executeBatch()
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	389 are called. In most Statement usages those methods are never called.
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	390 - Implemented method MonetClob.getAsciiStream().
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	391
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	392 * Thu Mar 21 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	393 - Added implementation of java.sql.CallableStatement interface. Some standard
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	394 Java applications require this JDBC interface for executing SQL stored procedures.
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	395 This implementation resolves request: https://www.monetdb.org/bugzilla/show_bug.cgi?id=6402
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	396
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	397 * Thu Mar 7 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	398 - Improved MonetDatabaseMetaData methods:
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	399 - getNumericFunctions(): it now includes functions: degrees, fuse, ms_round, ms_str, ms_trunc and radians.
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	400 - getStringFunctions(): it now includes function: position.
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	401 - supportsIntegrityEnhancementFacility() now returns false, as we do not enforce CHECK constraints yet.
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	402
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	403 * Thu Feb 7 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	404 - Improved MonetDatabaseMetaData methods:
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	405 - getNumericFunctions(): it no longer lists aggregate functions: avg, prod and sum
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	406 - getSystemFunctions(): it no longer lists timedate function: extract
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	407 - getTimeDateFunctions(): it now also lists functions: date_trunc, epoch
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	408 - Corrected MonetDatabaseMetaData method getTypeInfo() for result column
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	409 SEARCHABLE. It now returns DatabaseMetaData.typeSearchable for all
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	410 string data types including 'inet','json','url','uuid' and 'blob'.
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	411
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	412 * Thu Sep 20 2018 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	413 - Improved example program SQLcopyinto.java and moved it to tests directory
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	414 for automatic testing.
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	415
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	416 * Thu Jun 28 2018 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	417 - Corrected return values of DatabaseMetaData methods
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	418 allTablesAreSelectable() and allProceduresAreCallable().
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	419 They used to return true but now return false.
89 a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	420
230 60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	421 * Wed May 23 2018 Sjoerd Mullender <sjoerd@acm.org>
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	422 - Compiled and released new jars: monetdb-jdbc-2.28.jar, monetdb-mcl-1.17.jar
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	423 and updated jdbcclient.jar
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	424
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	425 * Thu Apr 26 2018 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	426 - Corrected and extended output of DatabaseMetaData methods
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	427 getTimeDateFunctions() and getSystemFunctions(). The Date/Time functions
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	428 (curdate, current_date, current_time, current_timestamp, curtime,
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	429 local_timezone, localtime, localtimestamp) were returned by
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	430 getSystemFunctions() but are now returned by getTimeDateFunctions().
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	431 getTimeDateFunctions() now also lists functions: date_to_str, extract, now,
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	432 str_to_date, str_to_time, str_to_timestamp, time_to_str and timestamp_to_str.
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	433 - Improved DatabaseMetaData methods getTablePrivileges() and
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	434 getColumnPrivileges() by returning also any combination of privileges
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	435 for the table or column in the PRIVILEGE result column. Previously only
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	436 single privileges (SELECT or UPDATE or INSERT or DELETE or EXECUTE or
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	437 GRANT) would be returned.
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	438
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	439 * Thu Apr 19 2018 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	440 - Corrected method DatabaseMetaData.getFunctions() for result column
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	441 FUNCTION_TYPE. It used to return DatabaseMetaData.functionResultUnknown
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	442 value for Analytic (functions.type 6) and Loader function (functions type 7).
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	443 It now returns DatabaseMetaData.functionNoTable for Analytic functions and
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	444 DatabaseMetaData.functionReturnsTable for Loader functions.
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	445 - DatabaseMetaData methods getTables(), getColumns(), getProcedures() and
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	446 getFunctions() now return the comment in the REMARKS result column when a
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	447 comment has been set for the table / view / column / procedure / function
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	448 via the SQL command COMMENT ON <db-object type> <qname> IS 'comment-text'.
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	449
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	450 * Thu Dec 14 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	451 - Fixed a problem with retrieving Dates and Timestamps which contained a
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	452 year value less than 1000. It would throw an SQLDataException with message:
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	453 Could not convert value to a Date. Expected JDBC date escape format
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	454 yyyy-[m]m-[d]d.
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	455 See also: https://www.monetdb.org/bugzilla/show_bug.cgi?id=6468
60334b96df18 Updated ChangeLog and ChangeLog-Archive in preparation for new release of JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 189 diff changeset	456
189 1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	457 * Mon Oct 23 2017 Sjoerd Mullender <sjoerd@acm.org>
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	458 - Compiled and released new jars: monetdb-jdbc-2.27.jar, monetdb-mcl-1.16.jar
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	459 and updated jdbcclient.jar
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	460
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	461 * Thu Oct 5 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	462 - Corrected method Connection.prepareCall(). It used to return null.
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	463 Now it throws an SQLFeatureNotSupportedException to comply with the
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	464 JDBC specification.
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	465
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	466 * Thu Sep 28 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	467 - Added possibility to let the JDBC driver return columnType value
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	468 Types.VARCHAR instead of Types.CLOB in case the result column of a
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	469 ResultSet or parameter in a PreparedStatement is of data type 'clob'.
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	470 To enable this behavior provide it as JDBC connection URL property:
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	471 treat_clob_as_varchar=true
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	472 For example: jdbc:monetdb://localhost:50000/demo?treat_clob_as_varchar=true
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	473 See also:
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	474 https://www.monetdb.org/Documentation/Manuals/SQLreference/Programming/JDBC
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	475 This custom clob mapping informs generic JDBC programs to fetch clob
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	476 column values via method ResultSet.getString() instead of getClob()
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	477 and Clob.getCharacterStream() and next fetching from the stream.
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	478 As MonetDB server MAPI communication protocol does not support
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	479 streaming of parts of a CLOB value, the current implementation is to
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	480 send over the whole CLOB value as a string. Therefore there is no
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	481 performance gain when fetching those Clob values via getClob() and
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	482 getCharacterStream(). In fact it creates a lot of overhead (additional
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	483 objects and method calls) and triples the amount of needed Java Heap memory
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	484 for each Clob value!
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	485 With this connection property set, you can reduce this overhead when
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	486 working with clob column data from generic JDBC programs.
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	487
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	488 * Thu Sep 7 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	489 - Implemented PreparedStatement methods setNCharacterStream(int, Reader)
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	490 and setNCharacterStream(int, Reader, long).
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	491
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	492 * Thu Aug 31 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	493 - Corrected PreparedStatement methods setString(int, String)
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	494 and setObject(int, Object, ...) in case the target parameter
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	495 data type was json or inet or url or uuid. See also
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	496 https://www.monetdb.org/bugzilla/show_bug.cgi?id=6382
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	497
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	498 * Thu Aug 24 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	499 - Implemented PreparedStatement method setURL(int, URL).
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	500 - Implemented PreparedStatement method setNString(int, String).
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	501 - The MonetDB JDBC driver code and jdbcclient program are now compiled
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	502 without debug info and with optimise flag enabled.
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	503 The new jar files are now some 20% smaller in size.
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	504
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	505 * Thu Aug 17 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	506 - Implemented ResultSet method getNCharacterStream().
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	507 - In class MonetClob implemented methods getCharacterStream()
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	508 and getCharacterStream(long pos, long length). Method
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	509 getCharacterStream() is called by DBeaver to fetch the Clob value.
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	510 It used to throw a SQLFeatureNotSupportedException with message:
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	511 "Operation getCharacterStream() currently not supported". This caused
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	512 DBeaver to log the exception and show NULL as the value on screen,
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	513 which is incorrect. This has been fixed.
1834e6339279 Updated ChangeLogs and minor release numbers for both MCL and JDBC driver in preparation for new releases. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 138 diff changeset	514
138 f97c111db06f Updated ChangeLog in preparation of new release Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 127 diff changeset	515 * Fri Jul 28 2017 Sjoerd Mullender <sjoerd@acm.org>
f97c111db06f Updated ChangeLog in preparation of new release Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 127 diff changeset	516 - Compiled and released new jars: monetdb-jdbc-2.26.jar and updated jdbcclient.jar
f97c111db06f Updated ChangeLog in preparation of new release Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 127 diff changeset	517
f97c111db06f Updated ChangeLog in preparation of new release Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 127 diff changeset	518 * Thu Jul 13 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
f97c111db06f Updated ChangeLog in preparation of new release Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 127 diff changeset	519 - Corrected implementation of PreparedStatement method
f97c111db06f Updated ChangeLog in preparation of new release Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 127 diff changeset	520 setObject(int parameterIndex, Object x, int targetSqlType, int scaleOrLength)
f97c111db06f Updated ChangeLog in preparation of new release Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 127 diff changeset	521 for the case the targetSqlType is Types.CLOB.
f97c111db06f Updated ChangeLog in preparation of new release Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 127 diff changeset	522 See also: https://www.monetdb.org/bugzilla/show_bug.cgi?id=6349
f97c111db06f Updated ChangeLog in preparation of new release Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 127 diff changeset	523
127 384d7035f317 Adding ChangeLog info to the ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 89 diff changeset	524 * Thu Mar 30 2017 Sjoerd Mullender <sjoerd@acm.org>
384d7035f317 Adding ChangeLog info to the ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 89 diff changeset	525 - Compiled and released new jars: monetdb-jdbc-2.25.jar, monetdb-mcl-1.15.jar
384d7035f317 Adding ChangeLog info to the ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 89 diff changeset	526 and updated jdbcclient.jar
384d7035f317 Adding ChangeLog info to the ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 89 diff changeset	527
384d7035f317 Adding ChangeLog info to the ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 89 diff changeset	528 * Thu Mar 9 2017 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
384d7035f317 Adding ChangeLog info to the ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 89 diff changeset	529 - Corrected ResultSetMetaData methods getColumnLabel(int), getColomnName(int),
384d7035f317 Adding ChangeLog info to the ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 89 diff changeset	530 getTableName(int) and getSchemaName(int) for names which contain special
384d7035f317 Adding ChangeLog info to the ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 89 diff changeset	531 characters such as a space, a tab, a comma, a double quote, etc.
384d7035f317 Adding ChangeLog info to the ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 89 diff changeset	532 See also: https://www.monetdb.org/bugzilla/show_bug.cgi?id=6183
384d7035f317 Adding ChangeLog info to the ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 89 diff changeset	533
89 a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	534 * Wed Dec 21 2016 Sjoerd Mullender <sjoerd@acm.org>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	535 - Compiled and released new jars: monetdb-jdbc-2.24.jar, monetdb-mcl-1.14.jar
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	536 and updated jdbcclient.jar
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	537
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	538 * Thu Nov 17 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	539 - The MapiSocket object now supports getting and setting the
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	540 socket timeout, even before the TCP socket is created. To set
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	541 the socket timeout specify it in the JDBC URL, for example:
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	542 jdbc:monetdb://localhost:50000/demo?so_timeout=8000
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	543 This enables the timeout and sets it to 8000 milliseconds (= 8 seconds).
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	544 By default the timeout is not set, so wait infinitely.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	545
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	546 * Thu Nov 10 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	547 - Implemented Connection methods: getClientInfo(name) and getClientInfo().
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	548 They used to return null and empty Properties object.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	549 Corrected implementation of Connection methods: setClientInfo(name, value)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	550 and setClientInfo(properties). They are now processed as expected.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	551 Corrected implementation of Connection.setHoldability(holdability). It now
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	552 throws an SQLFeatureNotSupportedException when holdability is not
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	553 ResultSet.HOLD_CURSORS_OVER_COMMIT (which is the only supported holdability).
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	554
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	555 * Thu Oct 13 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	556 - Corrected implementation of java.sql.Wrapper methods isWrapperFor()
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	557 and unwrap(). They now properly return expected results instead of
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	558 always return false or throw an SQLException.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	559
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	560 * Thu Oct 6 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	561 - Corrected return values of DatabaseMetaData methods nullsAreSortedHigh(),
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	562 nullsAreSortedLow(), getMaxCursorNameLength(), getMaxProcedureNameLength(),
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	563 getMaxStatementLength() and getMaxUserNameLength().
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	564 Improved return values of DatabaseMetaData methods getMaxBinaryLiteralLength(),
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	565 getMaxCharLiteralLength() and getMaxColumnsInTable().
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	566 - Implemented Statement methods: getQueryTimeout() and setQueryTimeout(int
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	567 seconds). getQueryTimeout() used to always return 0, now it returns the
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	568 query timeout retrieved from the server. setQueryTimeout(int seconds)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	569 used to always throw SQLException: query time outs not supported.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	570 Now it sets the query timeout for the current connection/session on
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	571 the server.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	572
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	573 * Thu Sep 29 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	574 - Corrected ResultSet methods: getByte(), getBigDecimal(), getShort(),
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	575 getInt(), getLong(), getFloat() and getDouble() in case the conversion
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	576 to the native type failed due to a Number Format conversion error.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	577 It used to silently ignore the conversion error and return 0 instead,
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	578 which is not correct. Now it throws an SQLException with message
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	579 "Could not convert value to a number." and SQLstate "22003" meaning:
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	580 Numeric value out of range.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	581
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	582 * Thu Sep 22 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	583 - Improved JdbcClient program when doing dump of table definition. It now
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	584 outputs CREATE TABLE definition more similar to mclient program.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	585
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	586 * Thu Sep 15 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	587 - Improved performance of following JDBC ResultSet and ResultSetMetaData
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	588 methods:
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	589 - ResultSet.getBoolean(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	590 - ResultSet.getBinaryStream(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	591 - ResultSet.getBytes(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	592 - ResultSet.getObject(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	593 - ResultSet.getObject(column, map)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	594 - ResultSet.getDate(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	595 - ResultSet.getTime(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	596 - ResultSet.getTimestamp(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	597 - ResultSet.getDate(column, calendar)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	598 - ResultSet.getTime(column, calendar)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	599 - ResultSet.getTimestamp(column, calendar)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	600 - ResultSetMetaData.getColumnClassName(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	601 - ResultSetMetaData.getColumnType(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	602 - ResultSetMetaData.isCaseSensitive(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	603 - ResultSetMetaData.isSigned(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	604 - ResultSetMetaData.getPrecision(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	605
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	606 * Thu Sep 8 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	607 - Improved JdbcClient program by fixing some resource leaks.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	608 - Extended JdbcClient program by showing elapsed time information for each
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	609 query or command when started in interactive mode (no -f was used at startup).
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	610
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	611 * Thu Sep 1 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	612 - Improved fetching and output speed of JdbcClient program for query results.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	613
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	614 * Thu Aug 11 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	615 - Improved performance of method ResultSet.getObject(column_ID) significantly.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	616
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	617 * Wed Jul 13 2016 Sjoerd Mullender <sjoerd@acm.org>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	618 - Compiled and released new JDBC driver jar: monetdb-jdbc-2.23.jar
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	619
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	620 * Thu Jul 7 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.7-20160713
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	621 - Corrected PROCEDURE_TYPE output value of method DatabaseMetaData.getProcedures().
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	622 It used to return procedureReturnsResult. Now it returns procedureNoResult.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	623 Corrected ORDINAL_POSITION output value of method DatabaseMetaData.getProcedureColumns().
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	624 It used to start with 0, but as procedures do not return a result value it now
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	625 starts with 1 for all the procedure arguments, as defined by the JDBC API.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	626 - Improved output of method DatabaseMetaData.getProcedures(). The REMARKS
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	627 column now contains the procedure definition as stored in sys.functions.func.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	628 The SPECIFIC_NAME column now contains the procedure unique identifier as
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	629 stored in sys.functions.id. This allows the caller to retrieve the specific
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	630 overloaded procedure which has the same name, but different arguments.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	631 Also improved output of method DatabaseMetaData.getProcedureColumns().
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	632 The SPECIFIC_NAME column now contains the procedure unique identifier as
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	633 stored in sys.functions.id. This allows the caller to retrieve the proper
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	634 arguments of the specific overloaded procedure by matching the SPECIFIC_NAME
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	635 value.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	636 - Improved output of method DatabaseMetaData.getFunctions(). The REMARKS
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	637 column now contains the function definition as stored in sys.functions.func.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	638 The SPECIFIC_NAME column now contains the function unique identifier as
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	639 stored in sys.functions.id. This allows the caller to retrieve the specific
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	640 overloaded function which has the same name, but different arguments.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	641 Also improved output of method DatabaseMetaData.getFunctionColumns().
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	642 The SPECIFIC_NAME column now contains the function unique identifier as
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	643 stored in sys.functions.id. This allows the caller to retrieve the proper
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	644 arguments of the specific overloaded function by matching the SPECIFIC_NAME
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	645 value.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	646
89 a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	647 * Fri Jun 10 2016 Sjoerd Mullender <sjoerd@acm.org>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	648 - Compiled and released new JDBC driver jar: monetdb-jdbc-2.21.jar
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	649
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	650 * Thu May 26 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	651 - Fixed problem in DatabaseMetaData.getUDTs() when it was called with
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	652 types parameter filled. It used to throw SQException with message:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	653 SELECT: identifier 'DATA_TYPE' unknown. Now it returns the UDTs which
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	654 match the provided array of data types.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	655
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	656 * Thu May 19 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	657 - Implemented MonetDatabaseMetaData.supportsConvert() and
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	658 MonetDatabaseMetaData.supportsConvert(int fromType, int toType) methods.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	659 It used to always return false. Now it returns true for the supported conversions.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	660 This fixes Bug 3460.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	661
89 a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	662 * Thu May 12 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	663 - Improved JdbcClient program when presenting query data to console.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	664 It used to send an SQL catalog query for each query result column
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	665 which slowed down the interactive response considerably.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	666 These additional SQL catalog queries have been eliminated.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	667
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	668 * Thu May 12 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	669 - Corrected MonetResultSet.getObject(String columnName). It no longer
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	670 throws a NullPointerException in cases where internally a
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	671 MonetVirtualResultSet is used.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	672
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	673 * Sun May 8 2016 Jennie Zhang <y.zhang@cwi.nl> - 11.23.1-20160601
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	674 - Fixed Connection.isValid(): this method should never attempt to
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	675 close the connection, even if an error has occurred.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	676
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	677 * Sun May 8 2016 Jennie Zhang <y.zhang@cwi.nl> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	678 - ResultSet.setFetchSize(): added a dummy implementation to get rid
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	679 of the SQLFeatureNotSupportedException. In MonetDB, it does not
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	680 make sense to set the fetch size of a result set. If one really
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	681 wants to set the fetch size, one should use Statement.setFetchSize()
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	682 instead.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	683
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	684 * Thu Apr 21 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	685 - Fixed resource leak in ResultSetMetaData. It created and cached a ResultSet
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	686 object for each column but never closed the ResultSet objects.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	687
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	688 * Thu Mar 31 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	689 - Corrected DatabaseMetaData methods which accept a catalog filter argument.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	690 Those methods will now filter the results on the specified catalog name,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	691 whereas previously the catalog filter argument was ignored.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	692 - Corrected output of column KEY_SEQ of DatabaseMetaData methods:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	693 getPrimaryKeys(), getImportedKeys(), getExportedKeys() and
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	694 getCrossReference(). It now starts at 1 instead of 0 previously.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	695
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	696 * Thu Mar 24 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	697 - Corrected DatabaseMetaData.getSchemas() by returning 2 instead of 3 columns.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	698 - Improved DatabaseMetaData.getColumns() by returning two additional
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	699 columns: IS_AUTOINCREMENT and IS_GENERATEDCOLUMN.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	700
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	701 * Thu Mar 17 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	702 - Improved DatabaseMetaData.getTypeInfo(). It now returns better information
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	703 on LITERAL_PREFIX, LITERAL_SUFFIX, CREATE_PARAMS, CASE_SENSITIVE,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	704 FIXED_PREC_SCALE and MAXIMUM_SCALE for some data types. Also the returned rows
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	705 are now ordered by DATA_TYPE, TYPE_NAME, PRECISION as required by the specs.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	706 Also corrected output column names "searchable" into "SEARCHABLE" and
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	707 "MAXIMUM SCALE" into "MAXIMUM_SCALE" to match the JDBC specification.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	708 - Corrected DatabaseMetaData.getPseudoColumns(). It used to return 12 empty rows.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	709 Now it returns no rows as MonetDB does not have pseudo columns.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	710
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	711 * Thu Mar 3 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	712 - Implemented method DatabaseMetaData.getClientProperties(). It used to always
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	713 return a resultset with 4 completely empty rows. It now returns a
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	714 resultset with the possible connection properties.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	715 - Implemented method DatabaseMetaData.getUDTs(). It used to return an empty
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	716 resultset. Now it returns the User Defined Types such as inet, json, url and uuid.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	717
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	718 * Thu Feb 18 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	719 - Corrected the returned table types in DatabaseMetaData.getTableTypes().
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	720 It now returns all 10 table types (as stored in sys.table_types) instead
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	721 of the previously 8 hardcoded table types.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	722 For old MonetDB servers which do not have the sys.table_types table,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	723 the old behavior is retained.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	724
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	725 * Thu Feb 11 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	726 - Implemented methods DatabaseMetadata.getProcedures() and
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	727 DatabaseMetadata.getProcedureColumns(). They used to return an empty resultset.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	728 Now they return the expected Procedures and ProcedureColumns.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	729 Also getProcedureColumns() now returns a resultset with all 20 columns
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	730 instead of 13 columns previously.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	731
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	732 * Thu Feb 4 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	733 - Method getFunctionColumns() in DatabaseMetadata used to throw an
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	734 SQLException: getFunctionColumns(String, String, String, String) is
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	735 not implemented.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	736 This method is now implemented and returns a resultset.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	737
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	738 * Thu Jan 28 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	739 - Method getFunctions() in DatabaseMetadata used to throw an SQLException:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	740 SELECT: no such column 'functions.sql'
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	741 This has been corrected. It now returns a resultset as requested.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	742 - The resultsets of DatabaseMetadata methods now no longer return a
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	743 value for the *_CAT columns as MonetDB does not support Catalogs.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	744
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	745 * Thu Jan 7 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	746 - Fixed a memory leak in MonetDatabaseMetaData.java for a static cache
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	747 which kept references to closed Connection objects.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	748
89 a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	749 * Tue Jan 5 2016 Sjoerd Mullender <sjoerd@acm.org>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	750 - Compiled and released new JDBC driver jar: monetdb-jdbc-2.19.jar
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	751
89 a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	752 * Fri Oct 30 2015 Sjoerd Mullender <sjoerd@acm.org>
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	753 - Compiled and released new jars: monetdb-jdbc-2.18.jar, monetdb-mcl-1.13.jar
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	754 and updated jdbcclient.jar
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	755
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	756 * Thu Aug 6 2015 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.21.1-20150807
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	757 - Improved JDBC driver to not throw NullPointerException anymore
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	758 when calling isNullable() or getPrecision() or getScale() or
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	759 getColumnDisplaySize() or getSchemaName() or getTableName() or
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	760 getColumnClassName() on a ResultSetMetaData object.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	761
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	762 * Thu Jul 16 2015 Sjoerd Mullender <sjoerd@acm.org> - 11.21.1-20150807
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	763 - We now compile the Java classes using the latest Java 1.8 version, and
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	764 we tell it to compile for Java 1.7.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	765
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	766 * Mon Oct 7 2013 Sjoerd Mullender <sjoerd@acm.org> - 11.15.17-20131008
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	767 - Rearranged order of returned columns of certain metadata functions to
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	768 comply with the JDBC documentation. See bug 3356.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	769
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	770 * Sun Jun 9 2013 Fabian Groffen <fabian@monetdb.org> - 11.15.9-20130619
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	771 - Further improved setBigDecimal() method, based on patch by Ben Reilly
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	772 in bug #3290
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	773
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	774 * Thu May 23 2013 Fabian Groffen <fabian@monetdb.org> - 11.15.9-20130619
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	775 - Fixed bug where PreparedStatement.setBigDecimal() wouldn't format its
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	776 input well enough for the server causing odd errors.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	777 - Allow PreparedStatement.setXXX() methods to be called with null
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	778 arguments, bug #3288
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	779
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	780 * Thu Apr 11 2013 Sjoerd Mullender <sjoerd@acm.org> - 11.15.5-20130412
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	781 - The pre-compiled .jar files are now created using Java 7 instead of
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	782 Java 6.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	783
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	784 * Sat Dec 1 2012 Fabian Groffen <fabian@monetdb.org> - 11.15.1-20130212
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	785 - merocontrol was changed to return server URIs, and lastStop time.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	786 Connections and dbpath were removed.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	787 - Mapi protocol v8 support was removed from MapiSocket. Protocol
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	788 v8 has not been used by the servers any more since Apr2012 release
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	789
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	790 * Fri Nov 23 2012 Fabian Groffen <fabian@monetdb.org> - 11.13.7-20121212
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	791 - Implemented type map support of Connection to allow custom mapping
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	792 of UDTs to Java classes. By default the INET and URL UDTs are
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	793 now mapped to nl.cwi.monetdb.jdbc.types.{INET,URL}. Most notably,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	794 ResultSet.getObject() and PreparedStatement.setObject() deal with the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	795 type map.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	796
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	797 * Thu Nov 22 2012 Fabian Groffen <fabian@monetdb.org> - 11.13.7-20121212
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	798 - Fixed a problem in PreparedStatement where the prepared statement's
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	799 ResultSetMetaData (on its columns to be produced) incorrectly threw
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	800 exceptions about non existing columns. Bug #3192
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	801
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	802 * Wed Oct 10 2012 Fabian Groffen <fabian@cwi.nl> - 11.13.3-20121016
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	803 - Fixed problem with PreparedStatements and setXXX() methods using column
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	804 numbers instead of names, bug #3158
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	805
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	806 * Tue Aug 14 2012 Fabian Groffen <fabian@cwi.nl> - 11.11.9-20120911
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	807 - Fixed a bug where DatabaseMetaData.getURL() did return null:0 for
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	808 hostname:port.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	809
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	810 * Fri Jul 20 2012 Fabian Groffen <fabian@cwi.nl> - 11.11.7-20120813
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	811 - Fixed adaptive cache size used when retrieving results, not to cause
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	812 divide by zero errors when memory gets short, bug #3119.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	813
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	814 * Fri Mar 2 2012 Wouter Alink <wouter@spinque.com> - 11.9.1-20120418
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	815 - Password reading by JdbcClient no longer results in strange artifacts
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	816 - JdbcClient now returns exit code 1 in case of failures
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	817
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	818 * Tue Feb 28 2012 Fabian Groffen <fabian@cwi.nl> - 11.7.9-20120312
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	819 - Implemented missing Number types support in
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	820 PreparedStatement.setObject()
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	821
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	822 * Mon Feb 20 2012 Fabian Groffen <fabian@cwi.nl> - 11.7.7-20120224
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	823 - Fixed bug in DatabaseMetaData.getSchemas() method that caused an SQL
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	824 error when called with catalog and schema argument.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	825
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	826 * Tue Feb 14 2012 Fabian Groffen <fabian@cwi.nl> - 11.7.7-20120224
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	827 - Resolved a bug where JDBC and Control connections could terminate
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	828 abruptly with 'Connection closed' messages
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	829
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	830 * Mon Jan 2 2012 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	831 - Implemented getMetaData() method of PreparedStatement.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	832
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	833 * Tue Dec 27 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	834 - Fixed an AssertionError for special results from e.g. EXPLAIN queries.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	835
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	836 * Wed Dec 21 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	837 - Fixed overflow error when batching large statements, bug #2952
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	838
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	839 * Tue Dec 20 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	840 - Resolved a concurrency problem where ResultSet's date-related getters
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	841 could cause odd stack traces when used by multiple threads at the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	842 same time, bug #2950.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	843
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	844 * Mon Dec 19 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	845 - JDBC now implements JDBCv4.1 which makes it possible to be built with
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	846 Java 7 and up. JDBCv4.1 is a maintenance release of JDBCv4, and hence
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	847 can be compiled with Java 6, although the added methods obviously are
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	848 not part of the java.sql interfaces.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	849
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	850 * Sun Dec 11 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	851 - SQLExceptions thrown now carry a SQLSTATE. Until the server starts
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	852 sending correct SQLSTATEs for all errors, server originated errors
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	853 without SQLSTATE are considered generic data exceptions (22000).
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	854
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	855 * Sat Dec 10 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	856 - Fixed a bug where closing ResultSets and PreparedStatements could lead
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	857 to errors on concurrent running queries using the same Connection due
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	858 to a race condition.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	859
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	860 * Thu Dec 8 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	861 - Changed version scheme of JDBC driver and MCL jar to be more standard,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	862 from monetdb-X.Y-<thing>.jar to monetdb-<thing>-X.Y.jar, bug #2943
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	863
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	864 * Fri Oct 14 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	865 - The embedded monet instance capability of MonetConnection was removed.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	866 - Bump JDBC version to 2.0 (Liberica). JDBC now implements JDBCv4 which
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	867 makes it possible to be built with Java 6 and up. Java 5 and before
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	868 are no longer supported, and can use the 1.x releases of the driver.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	869
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	870 * Thu Sep 1 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	871 - INTERVAL columns are now treated as decimals, since they can have
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	872 sub-second precision.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	873
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	874 * Thu Jun 30 2011 Fabian Groffen <fabian@cwi.nl> - 11.5.1-20110907
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	875 - Add so_timeout Driver property to specify a SO_TIMEOUT value for the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	876 socket in use to the database. Setting this property to a value in
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	877 milliseconds defines the timeout for read calls, which may 'unlock'
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	878 the driver if the server hangs, bug #2828
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	879
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	880 * Wed May 25 2011 Fabian Groffen <fabian@cwi.nl> - 11.5.1-20110907
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	881 - Added a naive implementation for PreparedStatement.setCharacterStream
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	882
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	883 * Mon Apr 11 2011 Fabian Groffen <fabian@cwi.nl> - 11.5.1-20110907
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	884 - The obsolete Java-based implementation for PreparedStatements (formerly
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	885 activated using the java_prepared_statements property) has been dropped
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	886
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	887 * Fri Jul 8 2011 Fabian Groffen <fabian@cwi.nl> - 11.3.5-20110720
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	888 - Return false from Statement.getMoreResults() instead of a
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	889 NullPointerException when no query has been performed on the Statement
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	890 yet, bug #2833
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	891
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	892 * Mon Jun 6 2011 Fabian Groffen <fabian@cwi.nl> - 11.3.5-20110720
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	893 - Fixed read-only interpretation. Connection.isReadOnly now always
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	894 returns false, setReadOnly now generates a warning when called with
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	895 true. Partly from bug #2818
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	896 - Allow readonly to be set when autocommit is disabled as well. Bug #2818
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	897
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	898 * Wed May 11 2011 Fabian Groffen <fabian@cwi.nl> - 11.3.3-20110517
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	899 - Insertion via PreparedStatement and retrieval via ResultSet of timestamp
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	900 and time fields with and without timezones was improved to better
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	901 respect timezones, as partly indicated in bug #2781.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	902
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	903 * Tue Apr 5 2011 Fabian Groffen <fabian@cwi.nl> - 11.3.1-20110414
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	904 - clarify exception messages for unsupported methods
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	905
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	906 * Mon Feb 7 2011 Fabian Groffen <fabian@cwi.nl> - 11.3.1-20110414
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	907 - Removed XQuery related XRPC wrapper and XML:DB code, removed support
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	908 for language=xquery and language=mil from JDBC.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	909
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	910 * Wed Dec 15 2010 Fabian Groffen <fabian@cwi.nl> - 11.1.1-20110317
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	911 - PreparedStatements now free the server-side resources attached to them
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	912 when closed. This implements bug #2720
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	913
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	914 * Tue Nov 9 2010 Fabian Groffen <fabian@cwi.nl> - 1.40.1-20101110
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	915 - Fix SQL syntax of inserting BLOB code, using setBytes()
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	916 - Added propery 'treat_blob_as_binary' to simulate BINARY types based on
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	917 BLOBs for applications, (e.g. Hibernate-based) that rely on BINARY's
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	918 byte array mapping
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	919 - Added code to handle BINARY types
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	920 - Fixed implementation of getBytes to match the specifications
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	921 - Implemented getBinaryStream according to the specifications
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	922
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	923 * Mon Nov 8 2010 Fabian Groffen <fabian@cwi.nl> - 1.40.1-20101109
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	924 - Java 1.6's subSequence() bug has changed into a slice() bug since
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	925 1.6.0_22. Revert workaround for subSequence breakage, since it breaks
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	926 operating with the latest Java 1.6.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	927
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	928 * Fri Oct 22 2010 Fabian Groffen <fabian@cwi.nl> - 1.40.1-20101029
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	929 - Fix for bug #2703, allow to have multiple metadata ResultSets open at
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	930 the same time
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	931
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	932 * Wed Aug 11 2010 Fabian Groffen <fabian@cwi.nl> - 1.38.5-20100823
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	933 - Implemented ResultSet's getCharacterStream methods, since Hibernate seems to
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	934 call this method for retrieving CLOB columns that we now do support.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	935
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	936 * Fri Aug 06 2010 Fabian Groffen <fabian@cwi.nl> - 1.38.5-20100823
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	937 - Fix implementation of setBytes method of PreparedStatement, such that bytes
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	938 are converted to MonetDB/SQL's BLOB notation.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	939
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	940 * Wed Jul 21 2010 Fabian Groffen <fabian@cwi.nl> - 1.38.5-20100823
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	941 - merocontrol Java library requires Java 2 Platform 1.5 and up, due to enum
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	942 and boxing/unboxing. Bug #2627
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	943
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	944 * Tue Jul 20 2010 Fabian Groffen <fabian@cwi.nl> - 1.38.5-20100823
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	945 - Implement missing Blob support (readonly), since getObject will blindly
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	946 return a BLOB instance as String, which is causing applications to wrongly
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	947 believe a BLOB instance is a string.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	948
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	949 * Fri Jul 16 2010 Fabian Groffen <fabian@cwi.nl> - 1.38.5-20100823
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	950 - Fix problem when using the MAL language. Any statement would return
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	951 an error with a typo that was not typed in by the user, such as
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	952 ioo.printf when io.printf was typed.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	953
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	954 * Fri Apr 16 2010 Fabian Groffen <fabian@cwi.nl> - Jun2010-SP1
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	955 - Enable the merovingian control library for default distribution as it
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	956 has been in use for some time without problems now.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	957
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	958 * Wed Mar 31 2010 Stefan Manegold <manegold@cwi.nl> - Jun2010-SP1
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	959 - Made compilation of "testing" (and "java") independent of MonetDB.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	960 This is mainly for Windows, but also on other systems, "testing" can now be
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	961 built independently of (and hence before) "MonetDB".
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	962 Files that mimic configure functionality on Windows were moved from
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	963 "MonetDB" to "buildtools"; hence, this affects all packages on Windows,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	964 requiring a complete rebuild from scratch on Windows.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	965 getopt() support in testing has changed; hence, (most probably) requiring a
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	966 rebuild from scratch of testing on other systems.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	967
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	968 * Wed Mar 31 2010 Fabian Groffen <fabian@cwi.nl> - Feb2010-SP2
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	969 - Do not to throw an SQLException, but generate a warning and try to
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	970 perform as much as requested in an optimistic manner, as not to break
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	971 clients that rely on the called method, but don't really use its
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	972 functionality (such as high-level generic programs that call any
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	973 driver and try to put it in a mode that it does what they expect).
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	974 The following functions no longer throw an SQLException but now
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	975 generate a warning and perform actions as far as possible:
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	976 - Statement.execute(sql, columnIndexes/columnNames)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	977 - Statement.executeUpdate(sql, columnIndexes/columnNames)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	978 - Statement.getMaxFieldSize()
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	979 - Statement.setCursorName(name)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	980 - Statement.setEscapeProcessing(enable)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	981 - Statement.setMaxFieldSize(max)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	982 - Statement.setQueryTimeout(seconds)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	983 - PreparedStatement.getMetaData()
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	984 - PreparedStatement.setNull(paramIndex, sqlType, typeName)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	985
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	986 * Wed Mar 24 2010 Stefan Manegold <manegold@cwi.nl> - Jun2010-SP1
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	987 - Implemented build directory support for Windows,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	988 i.e., like on Unix/Linux also on Windows we can now build in a separate
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	989 build directory as alternative to ...\<package>\NT, and thus keep the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	990 latter clean from files generated during the build.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	991 On Windows, the build directory must be a sibling of ...\<package>\NT .
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	992
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	993 * Tue Mar 09 2010 Fabian Groffen <fabian@cwi.nl> - Feb2010-SP1
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	994 - Set JAVA_HOME to the configure derived value, such that ant will use
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	995 the javac compiler as found by configure, and not the one it was built
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	996 with itself. This solves the problem that the JDBC driver still fails
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	997 to compile on e.g. Fedora systems even though configure
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	998 --with-java=/path/to/sun/jdk-5 was given, because ant still uses
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	999 gjc/icedtea by itself.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1000
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1001 * Mon Oct 12 2009 Wouter Alink <w.alink@cwi.nl> - Aug2009-SP2
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1002 - Bump MCL version to 1.6 for fix.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1003
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1004 * Fri Oct 09 2009 Fabian Groffen <fabian@cwi.nl> - Feb2010
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1005 - Bump Java source version to 1.5. Java 1.5 is the current J2EE, and code
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1006 from nl.cwi.monetdb.merovingian relies on Java 1.5 features. It seems
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1007 like a good time to deprecate 1.4 now 1.6 is about to become the new
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1008 J2EE version.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1009
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1010 * Fri Oct 09 2009 Wouter Alink <w.alink@cwi.nl> - Aug2009-SP2
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1011 - applied workaround for bug in Sun JRE 1.6.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1012
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1013 * Thu Oct 01 2009 Fabian Groffen <fabian@cwi.nl> - Aug2009-SP2
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1014 - Bump JDBC version to 1.14 for fix.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1015
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1016 * Thu Oct 01 2009 Fabian Groffen <fabian@cwi.nl> - Aug2009-SP2
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1017 - Fix warning messages to disappear when a connection to merovingian is
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1018 made.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1019
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1020 * Sun Aug 23 2009 Fabian Groffen <fabian@cwi.nl> - Aug2009-SP1
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1021 - Bump JDBC version to 1.13 for fix.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1022
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1023 * Sun Aug 23 2009 Fabian Groffen <fabian@cwi.nl> - Aug2009-SP1
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1024 - Avoid "ResultSet is closed" messages by disabling the use of
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1025 finalizers, bug #2844202
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1026
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1027 * Thu Mar 26 2009 Fabian Groffen <fabian@cwi.nl> - Feb2010
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1028 - Fix configure handling for --enable-{jdbc,xrpc}, by Yue Sheng on
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1029 Monetdb-developers ML
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1030

Mercurial > hg > monetdb-java

annotate ChangeLog-Archive @ 925:4dfdb62e3e9d