monetdb-java: ChangeLog-Archive annotate

annotate ChangeLog-Archive @ 957:683eec730d81

Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release.

author	Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date	Thu, 16 Jan 2025 14:31:36 +0100 (2 months ago)
parents	ff075ed5ce81
children	52a23aaa8580

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
957 683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	5 * Thu Jan 16 2025 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	6 - The release version number has been bumped to 12.0 to avoid confusion
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	7 with historic 11.x versions.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	8 - Compiled and released new jar files: monetdb-jdbc-12.0.jre8.jar and
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	9 jdbcclient.jre8.jar
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	10
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	11 * Wed Jan 8 2025 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	12 - The JDBC jar now includes JdbcClient. For backward compatibility the jar
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	13 is still also available as jdbcclient.jreX.jar.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	14
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	15 * Thu Nov 7 2024 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	16 - In JdbcClient when running the \vsci or \vdbi or \vsi commands, we now
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	17 suppress "42000 SELECT: insufficient privileges for ..." and
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	18 "42000 SELECT: access denied for ..." error messages when the connected user
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	19 does not have 'monetdb' or 'sysadmin' privileges, needed for some validations.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	20
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	21 * Wed Jun 19 2024 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	22 - Implemented Connection#set/getClientInfo, and send sensible default info
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	23 at connect time. This can be controlled with the properties 'client_info=on/off',
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	24 'client_application=ApplicationName' and 'client_remark=Other Useful Info'.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	25 Note setting client info requires MonetDB server 11.51 (Aug2024) or higher.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	26
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	27 * Thu Apr 4 2024 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	28 - Corrected ResultSetMetaData methods getColumnTypeName(), getPrecision(),
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	29 getColumnDisplaySize() and ParameterMetaData methods getParameterTypeName()
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	30 and getPrecision() for the interval data types. They now return
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	31 more precise information for the 13 possible interval data types.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	32
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	33 * Thu Mar 7 2024 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	34 - Improved DatabaseMetaData.getTypeInfo(). It now also returns the serial
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	35 and bigserial data types and all 13 possible interval data types.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	36
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	37 * Thu Dec 28 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	38 - In ResultSet.getObject(column, Class<T> type) and
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	39 ResultSet.getObject(column, Map<String,Class<?>>) methods added support
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	40 to return objects for classes: java.time.LocalDate, java.time.LocalDateTime
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	41 and java.time.LocalTime.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	42
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	43 * Wed Dec 20 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	44 - Enhanced DatabaseMetaData.getTables() method by adding support for SQL
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	45 table type names: 'BASE TABLE', 'GLOBAL TEMPORARY' and 'LOCAL TEMPORARY'
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	46 in parameter types[]. These are SQL synonyms of MonetDB table type names:
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	47 'TABLE', 'GLOBAL TEMPORARY TABLE' and 'LOCAL TEMPORARY TABLE'.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	48
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	49 * Thu Dec 14 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	50 - In ResultSet.getObject() method added support for retrieving
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	51 TIMESTAMP WITH TIME ZONE data as java.time.OffsetDateTime object
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	52 and TIME WITH TIME ZONE as java.time.OffsetTime object.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	53 Also methods ResultSetMetaData.getColumnClassName() and
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	54 ParameterMetaData.getParameterClassName() now return
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	55 java.time.OffsetDateTime.class for columns of type TIMESTAMP WITH TIME ZONE
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	56 and java.time.OffsetTime.class for columns of type TIME WITH TIME ZONE.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	57
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	58 * Thu Oct 12 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	59 - Improved DatabaseMetaData.getSystemFunctions(). It now also returns
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	60 functions: current_sessionid, greatest, ifnull, least, sql_max, sql_min.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	61 Function ifnull will only be returned for servers Jun2023 (11.47 or higher).
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	62
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	63 * Wed Aug 9 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	64 - Implemented ResultSet methods:
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	65 <T> T getObject(int columnIndex, Class<T> type)
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	66 <T> T getObject(String columnLabel, Class<T> type)
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	67 They used to throw an SQLFeatureNotSupportedException.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	68
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	69 * Thu Jul 6 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	70 - Removed deprecated nl.cwi.monetdb.. classes and package.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	71 Those classes were marked deprecated on 12 Nov 2020 from
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	72 release 3.0 (released on 17 Feb 2021) onwards. It includes:
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	73 nl.cwi.monetdb.client.JdbcClient.class
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	74 nl.cwi.monetdb.jdbc.MonetDriver.class
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	75 nl.cwi.monetdb.jdbc.types.INET.class
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	76 nl.cwi.monetdb.jdbc.types.URL.class
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	77 nl.cwi.monetdb.mcl.net.MapiSocket.class
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	78 These classes are now removed permanently.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	79 Use the org.monetdb.* equivalents instead.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	80
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	81 * Thu Jul 6 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	82 - Removed code to support old MonetDB servers Oct2014 or older. Those
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	83 old servers did not yet have the system tables: sys.keywords and
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	84 sys.table_types which are introduced in Jul2015 release. Those system
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	85 tables are used by MonetDatabaseMetaData methods: getSQLKeywords(),
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	86 getTableTypes() and getTables(). These 3 methods will now fail when
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	87 used with those very old MonetDB servers.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	88
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	89 * Wed Jul 5 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	90 - Corrected implementation of Connection methods getClientInfo() and
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	91 setClientInfo(). They used to get/set Connection properties instead of
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	92 Client Info properties, which was incorrect.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	93
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	94 * Thu Jun 22 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	95 - Corrected DatabaseMetaData method getClientProperties().
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	96 It used to return connection properties instead of client info properties.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	97
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	98 * Thu May 4 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	99 - Corrected DatabaseMetaData method getStringFunctions() when connected
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	100 to Jun2023 server. It now includes the string functions from the new
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	101 txtsim module.
683eec730d81 Copied contents of ChangeLog into ChangeLog-Archive in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 943 diff changeset	102
739 01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	103 * Thu Feb 23 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	104 - Compiled and released new jar files: monetdb-jdbc-3.3.jre8.jar and
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	105 jdbcclient.jre8.jar
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	106
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	107 * Thu Feb 9 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	108 - Corrected DatabaseMetaData.getSQLKeywords() output. It used to return
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	109 all MonetDB SQL keywords, but now it excludes the SQL:2003 keywords
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	110 as defined by the Java JDBC API specification.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	111
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	112 * Thu Jan 19 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	113 - Corrected DatabaseMetaData.getUDTs() output. It used to return rows
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	114 for system types: inet, json, url and uuid. However those are not User
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	115 Defined Types. Now they are no longer returned by this method.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	116
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	117 * Thu Dec 8 2022 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	118 - Internal method waitForPrompt() of class BufferedMCLReader has been
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	119 renamed to discardRemainder(). The example program SQLcopyinto.java
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	120 which uses this method, has been updated.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	121
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	122 * Thu Nov 17 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	123 - Fixed an invalid error issue when a PreparedStatement had more than 250
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	124 parameters. See also https://github.com/MonetDB/MonetDB/issues/7337
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	125
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	126 * Thu Nov 3 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	127 - Corrected returned SQL TypeName values for the MonetDB interval types:
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	128 'day_interval', 'month_interval' and 'sec_interval'. Those MonetDB
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	129 type names can not be used in CREATE TABLE statements. Instead
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	130 one has to use SQL type names: 'interval day', 'interval month' or
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	131 'interval second'. The JDBC driver now returns those SQL type names.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	132 This applies to methods: DatabaseMetaData.getTypeInfo() for the output
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	133 column TYPE_NAME (the output column LOCAL_TYPE_NAME now returns
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	134 the original type name), ResultSetMetaData.getColumnTypeName() and
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	135 ParameterMetaData.getParameterTypeName().
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	136
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	137 * Thu Oct 27 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	138 - Corrected PreparedStatement methods getMetaData().getColumnDisplaySize(),
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	139 getMetaData().getPrecision() and getParameterMetaData().getPrecision().
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	140
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	141 * Thu Oct 20 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	142 - Improved implementation of method ResultSetMetaData.getPrecision(). It
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	143 now returns more accurate values for columns of type DECIMAL, NUMERIC,
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	144 CHAR, VARCHAR, CLOB, JSON, URL and BLOB.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	145 - Improved implementation of method ResultSetMetaData.getScale(). It now
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	146 returns more accurate values for columns of type DECIMAL and NUMERIC.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	147
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	148 * Thu Sep 29 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	149 - Removed creation and distribution of monetdb-mcl-1.##.jre8.jar file.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	150 Programmers who used this jar file should use monetdb-jdbc-3.#.jre8.jar file.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	151
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	152 * Fri Sep 09 2022 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	153 - Add autocommit=true/false option to the JDBC URL. The default remains 'true'.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	154
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	155 * Wed Aug 24 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	156 - Improved DatabaseMetaData.getBestRowIdentifier(). When there are multiple
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	157 unique constraints and no pkey for a table it used to return the columns
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	158 of all the table unique constraints. Now it only returns the columns of
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	159 the first table unique constraint.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	160 Also optimized the performance of getBestRowIdentifier(). It used to
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	161 send a separate query first to find out if the table had a pkey or not.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	162 This extra query is now integrated so less queries are send to the server.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	163
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	164 * Wed Mar 30 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	165 - Corrected DatabaseMetaData methods getPrimaryKeys(), getBestRowIdentifier()
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	166 and getIndexInfo() for local temporary tables located in schema tmp. They
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	167 did not return any rows when the temp table had a primary or unique key or
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	168 index. Now they do return rows as expected.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	169
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	170 * Thu Feb 10 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	171 - Added recognition of 'xml' type. Use default mapping to Types.VARCHAR for
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	172 easy and fast (as java.lang.String) retrieval, display and setting data of
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	173 columns of type 'xml'.
01da1ea91c3f Update ChangeLog in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 636 diff changeset	174
636 fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	175 * 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	176 - 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	177 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	178
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	179 * 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	180 - 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	181 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	182 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	183 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	184 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	185 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	186
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	187 * 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	188 - 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	189 \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	190 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	191 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	192 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	193 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	194
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	195 * 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	196 - 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	197 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	198 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	199 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	200 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	201 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	202
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	203 * 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	204 - 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	205 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	206 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	207 --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	208 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	209 --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	210 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	211 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	212
fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	213 * 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	214 - 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	215 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	216 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	217 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	218 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	219 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	220 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	221 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	222 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	223 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	224 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	225 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	226 which provides an example implementation of the MonetConnection.UploadHandler
943 ff075ed5ce81 Spell check. Sjoerd Mullender <sjoerd@acm.org> parents: 927 diff changeset	227 and MonetConnection.DownloadHandler interfaces usable for reading files
636 fccc6c53f250 Update ChangeLog and ChangeLog-Archive in preparation for new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 482 diff changeset	228 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	229
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	230 * 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	231 - 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	232 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	233
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	234 * 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	235 - 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	236 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	237 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	238 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	239 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	240 This reduces the number of queries sent to the server significantly.
943 ff075ed5ce81 Spell check. Sjoerd Mullender <sjoerd@acm.org> parents: 927 diff changeset	241 This is noticeable for instance when using generic JDBC query tools
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	242 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	243
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	244 * 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	245 - 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	246 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	247
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 445 diff changeset	248 * 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	249 - 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	250 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	251 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	252 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	253 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	254 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	255 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	256 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	257 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	258 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	259 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	260 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	261
445 8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	262 * 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	263 - 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	264 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	265
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	266 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	267 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	268 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	269 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	270
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	271 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	272 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	273 (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	274 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	275 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	276 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	277
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	278 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	279 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	280 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	281 based on defined declarative constraints (pkey, fkey, not null, etc.).
943 ff075ed5ce81 Spell check. Sjoerd Mullender <sjoerd@acm.org> parents: 927 diff changeset	282 This will be useful to find and report inconsistencies in your database.
445 8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	283 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	284 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	285
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	286 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	287
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	288 * 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	289 - 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	290 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	291 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	292 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	293 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	294 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	295 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	296 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	297
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	298 * 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	299 - 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	300 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	301 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	302 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	303 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	304
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	305 * 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	306 - 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	307 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	308 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	309 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	310 user specified.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	311
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	312 * 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	313 - 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	314 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	315 timestamp and timestamptz.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	316
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	317 * 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	318 - 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	319 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	320 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	321 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	322 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	323 DatabaseMetaData.importedKeyCascade
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	324 or DatabaseMetaData.importedKeyRestrict
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	325 or DatabaseMetaData.importedKeySetNull
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	326 or DatabaseMetaData.importedKeySetDefault.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	327
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	328 * 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	329 - 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	330 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	331 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	332 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	333 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	334 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	335 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	336 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	337 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	338 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	339 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	340 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	341 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	342 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	343
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	344 * 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	345 - 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	346 data integrity:
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	347 \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	348 \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	349 \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	350 The current validations include:
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	351 - Primary Key uniqueness
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	352 - 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	353 - Unique constraint uniqueness
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	354 - Foreign Key referential integrity
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	355 - Column NOT NULL constraint
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	356 - 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	357 - Idem for char(n), clob(n), blob(n), json(n) and url(n).
943 ff075ed5ce81 Spell check. Sjoerd Mullender <sjoerd@acm.org> parents: 927 diff changeset	358 It can be useful to run \vsci before and after an upgrade of MonetDB server.
445 8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	359 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	360 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	361 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	362 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	363 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	364 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	365
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	366 * 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	367 - 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	368 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	369 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	370
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	371 * 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	372 - 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	373 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	374 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	375 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	376 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	377 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	378 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	379
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	380 * 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	381 - 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	382 Types.TIMESTAMP_WITH_TIMEZONE.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	383
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	384 * 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	385 - 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	386 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	387 - 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	388 - 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	389 - 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	390 - 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	391 - 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	392
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	393 * 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	394 - Corrected MonetDatabaseMetaData.getTypeInfo()
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	395 - 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	396 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	397 - 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	398 for type: blob.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	399 - 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	400 oid and wrd.
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	401
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	402 * 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	403 - 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	404
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	405 * 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	406 - 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	407 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	408 an explicit clearBatch() call.
927 d311affc65f0 Stop referring to monetdb.org/bugzilla, point straight to github. Sjoerd Mullender <sjoerd@acm.org> parents: 739 diff changeset	409 See also https://github.com/MonetDB/MonetDB/issues/6953
445 8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	410
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	411 * 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	412 - 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	413
8867403ec322 Add content of ChangeLog to ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 339 diff changeset	414 * 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	415 - 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	416 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	417
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	418 * 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	419 - 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	420 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	421 - 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	422 - JDBC: Support for Connection.prepareCall()
927 d311affc65f0 Stop referring to monetdb.org/bugzilla, point straight to github. Sjoerd Mullender <sjoerd@acm.org> parents: 739 diff changeset	423 See https://github.com/MonetDB/MonetDB/issues/6402
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	424 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	425 - Jdbc connection hangs
927 d311affc65f0 Stop referring to monetdb.org/bugzilla, point straight to github. Sjoerd Mullender <sjoerd@acm.org> parents: 739 diff changeset	426 See https://github.com/MonetDB/MonetDB/issues/6571
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	427 - Mix of long and short queries make JDBC-driver hang
927 d311affc65f0 Stop referring to monetdb.org/bugzilla, point straight to github. Sjoerd Mullender <sjoerd@acm.org> parents: 739 diff changeset	428 See https://github.com/MonetDB/MonetDB/issues/6693
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	429 - Example SQLcopyinto.java does not work
927 d311affc65f0 Stop referring to monetdb.org/bugzilla, point straight to github. Sjoerd Mullender <sjoerd@acm.org> parents: 739 diff changeset	430 See https://github.com/MonetDB/MonetDB/issues/6646
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	431 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	432 - 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	433 - 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	434 - 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	435 - performance
337 55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	436
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	437 * 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	438 - 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	439 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	440 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	441
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	442 * 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	443 - 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	444 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	445 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	446 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	447
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	448 * 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	449 - 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	450 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	451
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	452 * 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	453 - 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	454 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	455 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	456 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	457
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	458 * 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	459 - 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	460 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	461 - 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	462 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	463
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	464 * 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	465 - 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	466 - 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	467 - 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	468 - 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	469 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	470 - 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	471 - 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	472 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	473 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	474 - 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	475 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	476 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	477 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	478 and getTimeDateFunctions().
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	479
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	480 * 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	481 - 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	482 - 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	483 - 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	484 - 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	485 - 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	486 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	487 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	488 - 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	489
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	490 * 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	491 - 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	492 Java applications require this JDBC interface for executing SQL stored procedures.
927 d311affc65f0 Stop referring to monetdb.org/bugzilla, point straight to github. Sjoerd Mullender <sjoerd@acm.org> parents: 739 diff changeset	493 This implementation resolves request: https://github.com/MonetDB/MonetDB/issues/6402
337 55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	494
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	495 * 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	496 - 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	497 - 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	498 - 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	499 - 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	500
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	501 * 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	502 - 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	503 - 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	504 - 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	505 - 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	506 - 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	507 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	508 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	509
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	510 * 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	511 - 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	512 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	513
55735963f605 Prepare for new release of monetdb-java jar files. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 230 diff changeset	514 * 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	515 - 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	516 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	517 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	518
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	519 * 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	520 - 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	521 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	522
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	523 * 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	524 - 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	525 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	526 (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	527 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	528 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	529 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	530 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	531 - 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	532 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	533 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	534 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	535 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	536
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	537 * 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	538 - 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	539 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	540 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	541 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	542 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	543 - 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	544 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	545 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	546 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	547
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	548 * 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	549 - 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	550 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	551 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	552 yyyy-[m]m-[d]d.
927 d311affc65f0 Stop referring to monetdb.org/bugzilla, point straight to github. Sjoerd Mullender <sjoerd@acm.org> parents: 739 diff changeset	553 See also: https://github.com/MonetDB/MonetDB/issues/6468
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	554
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	555 * 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	556 - 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	557 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	558
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	559 * 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	560 - 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	561 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	562 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	563
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	564 * 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	565 - 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	566 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	567 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	568 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	569 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	570 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	571 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	572 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	573 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	574 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	575 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	576 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	577 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	578 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	579 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	580 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	581 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	582 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	583 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	584 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	585
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	586 * 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	587 - 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	588 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	589
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	590 * 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	591 - 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	592 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	593 data type was json or inet or url or uuid. See also
927 d311affc65f0 Stop referring to monetdb.org/bugzilla, point straight to github. Sjoerd Mullender <sjoerd@acm.org> parents: 739 diff changeset	594 https://github.com/MonetDB/MonetDB/issues/6382
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	595
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	596 * 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	597 - 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	598 - 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	599 - 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	600 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	601 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	602
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	603 * 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	604 - 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	605 - 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	606 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	607 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	608 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	609 "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	610 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	611 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	612
138 f97c111db06f Updated ChangeLog in preparation of new release Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 127 diff changeset	613 * 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	614 - 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	615
f97c111db06f Updated ChangeLog in preparation of new release Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 127 diff changeset	616 * 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	617 - 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	618 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	619 for the case the targetSqlType is Types.CLOB.
927 d311affc65f0 Stop referring to monetdb.org/bugzilla, point straight to github. Sjoerd Mullender <sjoerd@acm.org> parents: 739 diff changeset	620 See also: https://github.com/MonetDB/MonetDB/issues/6349
138 f97c111db06f Updated ChangeLog in preparation of new release Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 127 diff changeset	621
127 384d7035f317 Adding ChangeLog info to the ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 89 diff changeset	622 * 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	623 - 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	624 and updated jdbcclient.jar
384d7035f317 Adding ChangeLog info to the ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 89 diff changeset	625
384d7035f317 Adding ChangeLog info to the ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 89 diff changeset	626 * 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	627 - 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	628 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	629 characters such as a space, a tab, a comma, a double quote, etc.
927 d311affc65f0 Stop referring to monetdb.org/bugzilla, point straight to github. Sjoerd Mullender <sjoerd@acm.org> parents: 739 diff changeset	630 See also: https://github.com/MonetDB/MonetDB/issues/6183
127 384d7035f317 Adding ChangeLog info to the ChangeLog-Archive Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 89 diff changeset	631
89 a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	632 * 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	633 - 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	634 and updated jdbcclient.jar
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	635
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	636 * 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	637 - 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	638 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	639 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	640 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	641 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	642 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	643
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	644 * 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	645 - 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	646 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	647 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	648 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	649 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	650 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	651 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	652
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	653 * 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	654 - 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	655 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	656 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	657
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	658 * 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	659 - 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	660 nullsAreSortedLow(), getMaxCursorNameLength(), getMaxProcedureNameLength(),
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	661 getMaxStatementLength() and getMaxUserNameLength().
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	662 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	663 getMaxCharLiteralLength() and getMaxColumnsInTable().
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	664 - 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	665 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	666 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	667 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	668 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	669 the server.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	670
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	671 * 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	672 - 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	673 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	674 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	675 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	676 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	677 "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	678 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	679
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	680 * 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	681 - 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	682 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	683
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	684 * 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	685 - 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	686 methods:
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	687 - ResultSet.getBoolean(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	688 - ResultSet.getBinaryStream(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	689 - ResultSet.getBytes(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	690 - ResultSet.getObject(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	691 - ResultSet.getObject(column, map)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	692 - ResultSet.getDate(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	693 - ResultSet.getTime(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	694 - ResultSet.getTimestamp(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	695 - ResultSet.getDate(column, calendar)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	696 - ResultSet.getTime(column, calendar)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	697 - ResultSet.getTimestamp(column, calendar)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	698 - ResultSetMetaData.getColumnClassName(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	699 - ResultSetMetaData.getColumnType(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	700 - ResultSetMetaData.isCaseSensitive(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	701 - ResultSetMetaData.isSigned(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	702 - ResultSetMetaData.getPrecision(column)
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	703
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	704 * 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	705 - 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	706 - 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	707 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	708
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	709 * 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	710 - 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	711
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	712 * 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	713 - 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	714
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	715 * 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	716 - 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	717
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	718 * 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	719 - 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	720 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	721 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	722 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	723 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	724 - Improved output of method DatabaseMetaData.getProcedures(). The REMARKS
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	725 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	726 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	727 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	728 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	729 Also improved output of method DatabaseMetaData.getProcedureColumns().
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	730 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	731 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	732 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	733 value.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	734 - Improved output of method DatabaseMetaData.getFunctions(). The REMARKS
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	735 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	736 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	737 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	738 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	739 Also improved output of method DatabaseMetaData.getFunctionColumns().
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	740 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	741 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	742 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	743 value.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	744
89 a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	745 * 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	746 - 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	747
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	748 * 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	749 - 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	750 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	751 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	752 match the provided array of data types.
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 * 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	755 - Implemented MonetDatabaseMetaData.supportsConvert() and
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	756 MonetDatabaseMetaData.supportsConvert(int fromType, int toType) methods.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	757 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	758 This fixes Bug 3460.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	759
89 a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	760 * 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	761 - 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	762 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	763 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	764 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	765
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	766 * 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	767 - 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	768 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	769 MonetVirtualResultSet is used.
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	770
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	771 * 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	772 - 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	773 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	774
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	775 * 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	776 - 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	777 of the SQLFeatureNotSupportedException. In MonetDB, it does not
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	778 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	779 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	780 instead.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	781
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	782 * 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	783 - 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	784 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	785
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	786 * 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	787 - 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	788 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	789 whereas previously the catalog filter argument was ignored.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	790 - 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	791 getPrimaryKeys(), getImportedKeys(), getExportedKeys() and
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	792 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	793
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	794 * 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	795 - 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	796 - Improved DatabaseMetaData.getColumns() by returning two additional
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	797 columns: IS_AUTOINCREMENT and IS_GENERATEDCOLUMN.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	798
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	799 * 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	800 - Improved DatabaseMetaData.getTypeInfo(). It now returns better information
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	801 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	802 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	803 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	804 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	805 "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	806 - 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	807 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	808
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	809 * 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	810 - Implemented method DatabaseMetaData.getClientProperties(). It used to always
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	811 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	812 resultset with the possible connection properties.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	813 - 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	814 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	815
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	816 * 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	817 - Corrected the returned table types in DatabaseMetaData.getTableTypes().
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	818 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	819 of the previously 8 hardcoded table types.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	820 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	821 the old behavior is retained.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	822
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	823 * 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	824 - Implemented methods DatabaseMetadata.getProcedures() and
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	825 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	826 Now they return the expected Procedures and ProcedureColumns.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	827 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	828 instead of 13 columns previously.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	829
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	830 * 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	831 - Method getFunctionColumns() in DatabaseMetadata used to throw an
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	832 SQLException: getFunctionColumns(String, String, String, String) is
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	833 not implemented.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	834 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	835
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	836 * 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	837 - 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	838 SELECT: no such column 'functions.sql'
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	839 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	840 - 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	841 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	842
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	843 * 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	844 - 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	845 which kept references to closed Connection objects.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	846
89 a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	847 * 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	848 - 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	849
89 a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	850 * 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	851 - 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	852 and updated jdbcclient.jar
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	853
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	854 * 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	855 - Improved JDBC driver to not throw NullPointerException anymore
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	856 when calling isNullable() or getPrecision() or getScale() or
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	857 getColumnDisplaySize() or getSchemaName() or getTableName() or
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	858 getColumnClassName() on a ResultSetMetaData object.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	859
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	860 * Thu 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	861 - 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	862 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	863
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	864 * 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	865 - 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	866 comply with the JDBC documentation. See bug 3356.
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 * 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	869 - 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	870 in bug #3290
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 * 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	873 - 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	874 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	875 - 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	876 arguments, bug #3288
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	877
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	878 * 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	879 - 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	880 Java 6.
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 * 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	883 - 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	884 Connections and dbpath were removed.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	885 - 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	886 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	887
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	888 * 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	889 - 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	890 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	891 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	892 ResultSet.getObject() and PreparedStatement.setObject() deal with the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	893 type map.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	894
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	895 * 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	896 - 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	897 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	898 exceptions about non existing columns. Bug #3192
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	899
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	900 * 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	901 - 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	902 numbers instead of names, bug #3158
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	903
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	904 * 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	905 - 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	906 hostname:port.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	907
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	908 * 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	909 - 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	910 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	911
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	912 * 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	913 - 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	914 - 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	915
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	916 * 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	917 - Implemented missing Number types support in
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	918 PreparedStatement.setObject()
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	919
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	920 * 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	921 - 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	922 error when called with catalog and schema argument.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	923
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	924 * 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	925 - 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	926 abruptly with 'Connection closed' messages
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	927
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	928 * 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	929 - Implemented getMetaData() method of PreparedStatement.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	930
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	931 * 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	932 - 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	933
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	934 * 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	935 - 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	936
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	937 * 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	938 - 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	939 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	940 same time, bug #2950.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	941
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	942 * 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	943 - 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	944 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	945 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	946 not part of the java.sql interfaces.
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 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	949 - 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	950 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	951 without SQLSTATE are considered generic data exceptions (22000).
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	952
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	953 * 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	954 - 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	955 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	956 to a race condition.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	957
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	958 * 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	959 - 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	960 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	961
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	962 * 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	963 - 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	964 - 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	965 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	966 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	967
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	968 * 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	969 - 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	970 sub-second precision.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	971
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	972 * 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	973 - 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	974 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	975 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	976 the driver if the server hangs, bug #2828
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	977
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	978 * 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	979 - Added a naive implementation for PreparedStatement.setCharacterStream
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	980
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	981 * 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	982 - The obsolete Java-based implementation for PreparedStatements (formerly
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	983 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	984
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	985 * 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	986 - Return false from Statement.getMoreResults() instead of a
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	987 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	988 yet, bug #2833
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	989
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	990 * 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	991 - Fixed read-only interpretation. Connection.isReadOnly now always
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	992 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	993 true. Partly from bug #2818
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	994 - 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	995
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	996 * 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	997 - 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	998 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	999 respect timezones, as partly indicated in bug #2781.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1000
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1001 * 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	1002 - clarify exception messages for unsupported methods
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1003
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1004 * 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	1005 - 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	1006 for language=xquery and language=mil from JDBC.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1007
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1008 * 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	1009 - 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	1010 when closed. This implements bug #2720
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1011
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1012 * 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	1013 - Fix SQL syntax of inserting BLOB code, using setBytes()
943 ff075ed5ce81 Spell check. Sjoerd Mullender <sjoerd@acm.org> parents: 927 diff changeset	1014 - Added property 'treat_blob_as_binary' to simulate BINARY types based on
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1015 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	1016 byte array mapping
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1017 - Added code to handle BINARY types
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1018 - Fixed implementation of getBytes to match the specifications
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1019 - Implemented getBinaryStream according to the specifications
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1020
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1021 * 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	1022 - 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	1023 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	1024 operating with the latest Java 1.6.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1025
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1026 * 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	1027 - 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	1028 the same time
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1029
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1030 * 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	1031 - 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	1032 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	1033
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1034 * 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	1035 - 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	1036 are converted to MonetDB/SQL's BLOB notation.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1037
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1038 * 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	1039 - 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	1040 and boxing/unboxing. Bug #2627
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1041
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1042 * 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	1043 - 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	1044 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	1045 believe a BLOB instance is a string.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1046
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1047 * 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	1048 - 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	1049 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	1050 ioo.printf when io.printf was typed.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1051
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1052 * 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	1053 - 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	1054 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	1055
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1056 * 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	1057 - 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	1058 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	1059 built independently of (and hence before) "MonetDB".
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1060 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	1061 "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	1062 requiring a complete rebuild from scratch on Windows.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1063 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	1064 rebuild from scratch of testing on other systems.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1065
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1066 * 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	1067 - 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	1068 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	1069 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	1070 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	1071 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	1072 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	1073 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	1074 - Statement.execute(sql, columnIndexes/columnNames)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1075 - Statement.executeUpdate(sql, columnIndexes/columnNames)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1076 - Statement.getMaxFieldSize()
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1077 - Statement.setCursorName(name)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1078 - Statement.setEscapeProcessing(enable)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1079 - Statement.setMaxFieldSize(max)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1080 - Statement.setQueryTimeout(seconds)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1081 - PreparedStatement.getMetaData()
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1082 - PreparedStatement.setNull(paramIndex, sqlType, typeName)
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1083
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1084 * 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	1085 - Implemented build directory support for Windows,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1086 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	1087 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	1088 latter clean from files generated during the build.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1089 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	1090
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1091 * 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	1092 - 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	1093 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	1094 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	1095 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	1096 --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	1097 gjc/icedtea by itself.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1098
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1099 * 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	1100 - Bump MCL version to 1.6 for fix.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1101
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1102 * 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	1103 - 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	1104 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	1105 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	1106 J2EE version.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1107
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1108 * 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	1109 - 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	1110
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1111 * 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	1112 - Bump JDBC version to 1.14 for fix.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1113
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1114 * 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	1115 - 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	1116 made.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1117
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1118 * 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	1119 - Bump JDBC version to 1.13 for fix.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1120
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1121 * 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	1122 - 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	1123 finalizers, bug #2844202
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1124
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1125 * 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	1126 - 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	1127 Monetdb-developers ML
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1128

Mercurial > hg > monetdb-java

annotate ChangeLog-Archive @ 957:683eec730d81