monetdb-java: ChangeLog-Archive annotate

annotate ChangeLog-Archive @ 636:fccc6c53f250

Update ChangeLog and ChangeLog-Archive in preparation for new release.

author	Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date	Thu, 27 Jan 2022 14:47:45 +0100 (2022-01-27)
parents	73cfc519ec1e
children	01da1ea91c3f

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
636 fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	5 * 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	6 - 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	7 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	8
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	9 * 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	10 - 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	11 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	12 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	13 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	14 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	15 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	16
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	17 * 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	18 - 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	19 \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	20 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	21 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	22 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	23 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	24
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	25 * 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	26 - 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	27 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	28 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	29 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	30 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	31 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	32
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	33 * 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	34 - 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	35 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	36 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	37 --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	38 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	39 --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	40 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	41 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	42
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	43 * 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	44 - 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	45 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	46 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	47 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	48 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	49 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	50 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	51 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	52 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	53 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	54 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	55 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	56 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	57 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	58 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	59
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	60 * 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	61 - 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	62 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	63
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	64 * 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	65 - 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	66 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	67 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	68 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	69 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	70 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	71 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	72 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	73
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	74 * 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	75 - 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	76 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	77
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	78 * 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	79 - 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	80 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	81 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	82 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	83 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	84 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	85 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	86 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	87 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	88 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	89 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	90 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	91
445 8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	92 * 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	93 - 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	94 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	95
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	96 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	97 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	98 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	99 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	100
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	101 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	102 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	103 (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	104 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	105 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	106 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	107
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	108 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	109 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	110 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	111 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	112 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	113 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	114 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	115
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	116 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	117
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	118 * 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	119 - 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	120 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	121 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	122 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	123 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	124 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	125 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	126 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	127
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	128 * 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	129 - 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	130 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	131 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	132 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	133 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	134
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	135 * 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	136 - 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	137 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	138 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	139 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	140 user specified.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	141
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	142 * 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	143 - 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	144 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	145 timestamp and timestamptz.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	146
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	147 * 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	148 - 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	149 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	150 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	151 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	152 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	153 DatabaseMetaData.importedKeyCascade
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	154 or DatabaseMetaData.importedKeyRestrict
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	155 or DatabaseMetaData.importedKeySetNull
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	156 or DatabaseMetaData.importedKeySetDefault.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	157
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	158 * 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	159 - 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	160 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	161 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	162 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	163 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	164 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	165 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	166 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	167 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	168 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	169 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	170 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	171 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	172 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	173
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	174 * 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	175 - 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	176 data integrity:
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	177 \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	178 \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	179 \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	180 The current validations include:
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	181 - Primary Key uniqueness
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	182 - 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	183 - Unique constraint uniqueness
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	184 - Foreign Key referential integrity
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	185 - Column NOT NULL constraint
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	186 - 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	187 - 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	188 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	189 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	190 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	191 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	192 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	193 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	194 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	195
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	196 * 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	197 - 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	198 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	199 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	200
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	201 * 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	202 - 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	203 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	204 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	205 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	206 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	207 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	208 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	209
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	210 * 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	211 - 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	212 Types.TIMESTAMP_WITH_TIMEZONE.
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 * 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	215 - 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	216 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	217 - 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	218 - 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	219 - 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	220 - 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	221 - 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	222
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	223 * 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	224 - Corrected MonetDatabaseMetaData.getTypeInfo()
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	225 - 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	226 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	227 - 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	228 for type: blob.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	229 - 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	230 oid and wrd.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	231
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	232 * 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	233 - 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	234
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	235 * 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	236 - 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	237 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	238 an explicit clearBatch() call.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	239 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	240
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	241 * 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	242 - 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	243
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	244 * 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	245 - 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	246 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	247
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	248 * 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	249 - 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	250 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	251 - 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	252 - 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	253 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	254 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	255 - 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	256 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	257 - 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	258 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	259 - 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	260 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	261 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	262 - 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	263 - 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	264 - 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	265 - performance
337 55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	266
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	267 * 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	268 - 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	269 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	270 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	271
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	272 * 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	273 - 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	274 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	275 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	276 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	277
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	278 * 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	279 - 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	280 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	281
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	282 * 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	283 - 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	284 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	285 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	286 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	287
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	288 * 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	289 - 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	290 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	291 - 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	292 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	293
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	294 * 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	295 - 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	296 - 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	297 - 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	298 - 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	299 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	300 - 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	301 - 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	302 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	303 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	304 - 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	305 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	306 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	307 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	308 and getTimeDateFunctions().
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	309
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	310 * 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	311 - 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	312 - 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	313 - 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	314 - 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	315 - 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	316 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	317 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	318 - 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	319
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	320 * 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	321 - 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	322 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	323 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	324
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	325 * 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	326 - 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	327 - 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	328 - 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	329 - 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	330
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	331 * 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	332 - 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	333 - 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	334 - 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	335 - 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	336 - 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	337 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	338 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	339
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	340 * 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	341 - 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	342 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	343
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	344 * 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	345 - 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	346 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	347 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	348
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	349 * 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	350 - 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	351 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	352
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	353 * 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	354 - 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	355 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	356 (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	357 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	358 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	359 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	360 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	361 - 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	362 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	363 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	364 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	365 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	366
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	367 * 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	368 - 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	369 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	370 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	371 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	372 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	373 - 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	374 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	375 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	376 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	377
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	378 * 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	379 - 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	380 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	381 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	382 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	383 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	384
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	385 * 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	386 - 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	387 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	388
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	389 * 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	390 - 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	391 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	392 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	393
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	394 * 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	395 - 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	396 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	397 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	398 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	399 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	400 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	401 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	402 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	403 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	404 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	405 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	406 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	407 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	408 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	409 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	410 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	411 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	412 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	413 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	414 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	415
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	416 * 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	417 - 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	418 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	419
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	420 * 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	421 - 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	422 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	423 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	424 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	425
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	426 * 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	427 - 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	428 - 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	429 - 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	430 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	431 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	432
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	433 * 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	434 - 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	435 - 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	436 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	437 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	438 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	439 "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	440 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	441 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	442
138 f97c111db06f Updated ChangeLog in preparation of new release Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 127 diff changeset	443 * 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	444 - 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	445
f97c111db06f Updated ChangeLog in preparation of new release Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 127 diff changeset	446 * 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	447 - 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	448 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	449 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	450 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	451
127 384d7035f317 Adding ChangeLog info to the ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 89 diff changeset	452 * 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	453 - 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	454 and updated jdbcclient.jar
384d7035f317 Adding ChangeLog info to the ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 89 diff changeset	455
384d7035f317 Adding ChangeLog info to the ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 89 diff changeset	456 * 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	457 - 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	458 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	459 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	460 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	461
89 a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	462 * 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	463 - 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	464 and updated jdbcclient.jar
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	465
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	466 * 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	467 - 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	468 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	469 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	470 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	471 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	472 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	473
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	474 * 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	475 - 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	476 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	477 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	478 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	479 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	480 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	481 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	482
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	483 * 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	484 - 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	485 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	486 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	487
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	488 * 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	489 - 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	490 nullsAreSortedLow(), getMaxCursorNameLength(), getMaxProcedureNameLength(),
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	491 getMaxStatementLength() and getMaxUserNameLength().
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	492 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	493 getMaxCharLiteralLength() and getMaxColumnsInTable().
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	494 - 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	495 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	496 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	497 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	498 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	499 the server.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	500
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	501 * 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	502 - 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	503 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	504 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	505 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	506 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	507 "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	508 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	509
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	510 * 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	511 - 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	512 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	513
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	514 * 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	515 - 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	516 methods:
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	517 - ResultSet.getBoolean(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	518 - ResultSet.getBinaryStream(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	519 - ResultSet.getBytes(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	520 - ResultSet.getObject(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	521 - ResultSet.getObject(column, map)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	522 - ResultSet.getDate(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	523 - ResultSet.getTime(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	524 - ResultSet.getTimestamp(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	525 - ResultSet.getDate(column, calendar)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	526 - ResultSet.getTime(column, calendar)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	527 - ResultSet.getTimestamp(column, calendar)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	528 - ResultSetMetaData.getColumnClassName(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	529 - ResultSetMetaData.getColumnType(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	530 - ResultSetMetaData.isCaseSensitive(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	531 - ResultSetMetaData.isSigned(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	532 - ResultSetMetaData.getPrecision(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	533
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	534 * 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	535 - 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	536 - 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	537 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	538
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	539 * 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	540 - 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	541
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	542 * 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	543 - 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	544
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	545 * 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	546 - 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	547
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	548 * 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	549 - 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	550 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	551 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	552 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	553 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	554 - Improved output of method DatabaseMetaData.getProcedures(). The REMARKS
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	555 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	556 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	557 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	558 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	559 Also improved output of method DatabaseMetaData.getProcedureColumns().
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	560 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	561 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	562 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	563 value.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	564 - Improved output of method DatabaseMetaData.getFunctions(). The REMARKS
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	565 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	566 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	567 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	568 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	569 Also improved output of method DatabaseMetaData.getFunctionColumns().
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	570 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	571 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	572 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	573 value.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	574
89 a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	575 * 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	576 - 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	577
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	578 * 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	579 - 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	580 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	581 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	582 match the provided array of data types.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	583
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	584 * 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	585 - Implemented MonetDatabaseMetaData.supportsConvert() and
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	586 MonetDatabaseMetaData.supportsConvert(int fromType, int toType) methods.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	587 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	588 This fixes Bug 3460.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	589
89 a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	590 * 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	591 - 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	592 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	593 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	594 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	595
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	596 * 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	597 - 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	598 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	599 MonetVirtualResultSet is used.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	600
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	601 * 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	602 - 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	603 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	604
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	605 * 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	606 - 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	607 of the SQLFeatureNotSupportedException. In MonetDB, it does not
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	608 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	609 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	610 instead.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	611
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	612 * 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	613 - 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	614 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	615
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	616 * 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	617 - 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	618 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	619 whereas previously the catalog filter argument was ignored.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	620 - 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	621 getPrimaryKeys(), getImportedKeys(), getExportedKeys() and
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	622 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	623
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	624 * 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	625 - 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	626 - Improved DatabaseMetaData.getColumns() by returning two additional
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	627 columns: IS_AUTOINCREMENT and IS_GENERATEDCOLUMN.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	628
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	629 * 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	630 - Improved DatabaseMetaData.getTypeInfo(). It now returns better information
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	631 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	632 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	633 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	634 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	635 "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	636 - 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	637 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	638
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	639 * 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	640 - Implemented method DatabaseMetaData.getClientProperties(). It used to always
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	641 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	642 resultset with the possible connection properties.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	643 - 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	644 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	645
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	646 * 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	647 - Corrected the returned table types in DatabaseMetaData.getTableTypes().
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	648 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	649 of the previously 8 hardcoded table types.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	650 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	651 the old behavior is retained.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	652
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	653 * 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	654 - Implemented methods DatabaseMetadata.getProcedures() and
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	655 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	656 Now they return the expected Procedures and ProcedureColumns.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	657 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	658 instead of 13 columns previously.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	659
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	660 * 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	661 - Method getFunctionColumns() in DatabaseMetadata used to throw an
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	662 SQLException: getFunctionColumns(String, String, String, String) is
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	663 not implemented.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	664 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	665
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	666 * 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	667 - 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	668 SELECT: no such column 'functions.sql'
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	669 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	670 - 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	671 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	672
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	673 * 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	674 - 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	675 which kept references to closed Connection objects.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	676
89 a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	677 * 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	678 - 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	679
89 a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	680 * 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	681 - 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	682 and updated jdbcclient.jar
0 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 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	685 - Improved JDBC driver to not throw NullPointerException anymore
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	686 when calling isNullable() or getPrecision() or getScale() or
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	687 getColumnDisplaySize() or getSchemaName() or getTableName() or
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	688 getColumnClassName() on a ResultSetMetaData object.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	689
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	690 * 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	691 - 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	692 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	693
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	694 * 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	695 - 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	696 comply with the JDBC documentation. See bug 3356.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	697
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	698 * 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	699 - 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	700 in bug #3290
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	701
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	702 * 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	703 - 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	704 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	705 - 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	706 arguments, bug #3288
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	707
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	708 * 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	709 - 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	710 Java 6.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	711
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	712 * 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	713 - 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	714 Connections and dbpath were removed.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	715 - 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	716 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	717
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	718 * 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	719 - 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	720 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	721 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	722 ResultSet.getObject() and PreparedStatement.setObject() deal with the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	723 type map.
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 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	726 - 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	727 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	728 exceptions about non existing columns. Bug #3192
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	729
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	730 * 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	731 - 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	732 numbers instead of names, bug #3158
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	733
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	734 * 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	735 - 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	736 hostname:port.
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 * 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	739 - 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	740 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	741
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	742 * 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	743 - 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	744 - 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	745
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	746 * 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	747 - Implemented missing Number types support in
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	748 PreparedStatement.setObject()
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	749
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	750 * 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	751 - 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	752 error when called with catalog and schema argument.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	753
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	754 * 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	755 - 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	756 abruptly with 'Connection closed' messages
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	757
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	758 * 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	759 - Implemented getMetaData() method of PreparedStatement.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	760
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	761 * 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	762 - 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	763
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	764 * 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	765 - 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	766
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	767 * 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	768 - 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	769 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	770 same time, bug #2950.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	771
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	772 * 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	773 - 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	774 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	775 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	776 not part of the java.sql interfaces.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	777
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	778 * 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	779 - 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	780 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	781 without SQLSTATE are considered generic data exceptions (22000).
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	782
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	783 * 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	784 - 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	785 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	786 to a race condition.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	787
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	788 * 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	789 - 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	790 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	791
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	792 * 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	793 - 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	794 - 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	795 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	796 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	797
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	798 * 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	799 - 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	800 sub-second precision.
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 * 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	803 - 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	804 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	805 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	806 the driver if the server hangs, bug #2828
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	807
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	808 * 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	809 - Added a naive implementation for PreparedStatement.setCharacterStream
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	810
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	811 * 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	812 - The obsolete Java-based implementation for PreparedStatements (formerly
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	813 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	814
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	815 * 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	816 - Return false from Statement.getMoreResults() instead of a
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	817 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	818 yet, bug #2833
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	819
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	820 * 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	821 - Fixed read-only interpretation. Connection.isReadOnly now always
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	822 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	823 true. Partly from bug #2818
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	824 - 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	825
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	826 * 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	827 - 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	828 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	829 respect timezones, as partly indicated in bug #2781.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	830
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	831 * 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	832 - clarify exception messages for unsupported methods
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	833
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	834 * 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	835 - 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	836 for language=xquery and language=mil from JDBC.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	837
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	838 * 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	839 - 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	840 when closed. This implements bug #2720
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	841
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	842 * 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	843 - 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	844 - 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	845 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	846 byte array mapping
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	847 - Added code to handle BINARY types
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	848 - Fixed implementation of getBytes to match the specifications
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	849 - Implemented getBinaryStream according to the specifications
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	850
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	851 * 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	852 - 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	853 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	854 operating with the latest Java 1.6.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	855
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	856 * 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	857 - 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	858 the same time
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 * 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	861 - 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	862 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	863
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	864 * 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	865 - 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	866 are converted to MonetDB/SQL's BLOB notation.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	867
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	868 * 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	869 - 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	870 and boxing/unboxing. Bug #2627
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	871
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	872 * 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	873 - 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	874 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	875 believe a BLOB instance is a string.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	876
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	877 * 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	878 - 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	879 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	880 ioo.printf when io.printf was typed.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	881
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	882 * 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	883 - 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	884 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	885
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	886 * 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	887 - 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	888 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	889 built independently of (and hence before) "MonetDB".
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	890 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	891 "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	892 requiring a complete rebuild from scratch on Windows.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	893 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	894 rebuild from scratch of testing on other systems.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	895
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	896 * 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	897 - 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	898 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	899 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	900 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	901 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	902 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	903 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	904 - Statement.execute(sql, columnIndexes/columnNames)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	905 - Statement.executeUpdate(sql, columnIndexes/columnNames)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	906 - Statement.getMaxFieldSize()
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	907 - Statement.setCursorName(name)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	908 - Statement.setEscapeProcessing(enable)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	909 - Statement.setMaxFieldSize(max)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	910 - Statement.setQueryTimeout(seconds)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	911 - PreparedStatement.getMetaData()
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	912 - PreparedStatement.setNull(paramIndex, sqlType, typeName)
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 * 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	915 - Implemented build directory support for Windows,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	916 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	917 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	918 latter clean from files generated during the build.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	919 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	920
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	921 * 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	922 - 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	923 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	924 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	925 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	926 --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	927 gjc/icedtea by itself.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	928
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	929 * 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	930 - Bump MCL version to 1.6 for fix.
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 * 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	933 - 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	934 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	935 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	936 J2EE version.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	937
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	938 * 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	939 - 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	940
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	941 * 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	942 - Bump JDBC version to 1.14 for fix.
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 * 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	945 - 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	946 made.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	947
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	948 * 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	949 - Bump JDBC version to 1.13 for fix.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	950
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	951 * 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	952 - 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	953 finalizers, bug #2844202
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	954
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	955 * 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	956 - 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	957 Monetdb-developers ML
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	958

Mercurial > hg > monetdb-java

annotate ChangeLog-Archive @ 636:fccc6c53f250