Mercurial > hg > monetdb-java

comparison ChangeLog-Archive @ 943:ff075ed5ce81

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Spell check.
author Sjoerd Mullender <sjoerd@acm.org>
date Thu, 09 Jan 2025 10:56:14 +0100 (3 months ago)
parents d311affc65f0
children 683eec730d81
comparison
equal deleted inserted replaced
942:45c26b1a0677 943:ff075ed5ce81
124 public interface org.monetdb.jdbc.MonetConnection.DownloadHandler 124 public interface org.monetdb.jdbc.MonetConnection.DownloadHandler
125 See onclient.txt for more information on how to use these from Java. 125 See onclient.txt for more information on how to use these from Java.
126 We also provide a utility class: 126 We also provide a utility class:
127 public class org.monetdb.util.FileTransferHandler 127 public class org.monetdb.util.FileTransferHandler
128 which provides an example implementation of the MonetConnection.UploadHandler 128 which provides an example implementation of the MonetConnection.UploadHandler
129 and MonetConnection.DownloadHandler interfaces useable for reading files 129 and MonetConnection.DownloadHandler interfaces usable for reading files
130 from or writing files to a local file system. 130 from or writing files to a local file system.
131 131
132 * Mon Jun 14 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> 132 * Mon Jun 14 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
133 - Compiled and released new jar files: monetdb-jdbc-3.1.jre8.jar, 133 - Compiled and released new jar files: monetdb-jdbc-3.1.jre8.jar,
134 monetdb-mcl-1.20.jre8.jar and jdbcclient.jre8.jar 134 monetdb-mcl-1.20.jre8.jar and jdbcclient.jre8.jar
138 getScale(), isNullable() and isAutoIncrement(). The data is fetched 138 getScale(), isNullable() and isAutoIncrement(). The data is fetched
139 from the server by sending a query. This used to be one query for 139 from the server by sending a query. This used to be one query for
140 each column of the ResultSet. Now these metadata queries are combined 140 each column of the ResultSet. Now these metadata queries are combined
141 into one query fetching this meta data for up to 50 columns in one query. 141 into one query fetching this meta data for up to 50 columns in one query.
142 This reduces the number of queries sent to the server significantly. 142 This reduces the number of queries sent to the server significantly.
143 This is noticable for instance when using generic JDBC query tools 143 This is noticeable for instance when using generic JDBC query tools
144 such as SQuirreL, DBeaver, which now respond much faster. 144 such as SQuirreL, DBeaver, which now respond much faster.
145 145
146 * Wed Mar 3 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> 146 * Wed Mar 3 2021 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
147 - Implemented PreparedStatement.toString() as requested by 147 - Implemented PreparedStatement.toString() as requested by
148 https://github.com/MonetDB/monetdb-java/issues/8 148 https://github.com/MonetDB/monetdb-java/issues/8
179 179
180 The JdbcClient program (jdbcclient.jre8.jar) has been extended with 180 The JdbcClient program (jdbcclient.jre8.jar) has been extended with
181 functionality to validate the integrity of the system tables (\vsci) or 181 functionality to validate the integrity of the system tables (\vsci) or
182 to validate the integrity of data in tables of a specific schema (\vsi xyz) 182 to validate the integrity of data in tables of a specific schema (\vsi xyz)
183 based on defined declarative constraints (pkey, fkey, not null, etc.). 183 based on defined declarative constraints (pkey, fkey, not null, etc.).
184 This will be usefull to find and report inconsistencies in your database. 184 This will be useful to find and report inconsistencies in your database.
185 This functionality is a beta release. Please let us know if you 185 This functionality is a beta release. Please let us know if you
186 encounter any issues running it. See below for more information. 186 encounter any issues running it. See below for more information.
187 187
188 Besides a few bug fixes also performance has been improved in multiple areas. 188 Besides a few bug fixes also performance has been improved in multiple areas.
189 189
255 - Unique constraint uniqueness 255 - Unique constraint uniqueness
256 - Foreign Key referential integrity 256 - Foreign Key referential integrity
257 - Column NOT NULL constraint 257 - Column NOT NULL constraint
258 - Varchar(n) max length constraint 258 - Varchar(n) max length constraint
259 - Idem for char(n), clob(n), blob(n), json(n) and url(n). 259 - Idem for char(n), clob(n), blob(n), json(n) and url(n).
260 It can be usefull to run \vsci before and after an upgrade of MonetDB server. 260 It can be useful to run \vsci before and after an upgrade of MonetDB server.
261 Use \vsi my_schema to validate data in all tables of a specific schema. 261 Use \vsi my_schema to validate data in all tables of a specific schema.
262 Use \vdbi to validate integrity of data in all user schemas in 262 Use \vdbi to validate integrity of data in all user schemas in
263 the database. Note: this can take a while, depending on your number 263 the database. Note: this can take a while, depending on your number
264 of user schemas, tables, columns and rows. Despite being tested on several 264 of user schemas, tables, columns and rows. Despite being tested on several
265 internal dbs the functionality is still beta, so you can get false 265 internal dbs the functionality is still beta, so you can get false
911 - PreparedStatements now free the server-side resources attached to them 911 - PreparedStatements now free the server-side resources attached to them
912 when closed. This implements bug #2720 912 when closed. This implements bug #2720
913 913
914 * Tue Nov 9 2010 Fabian Groffen <fabian@cwi.nl> - 1.40.1-20101110 914 * Tue Nov 9 2010 Fabian Groffen <fabian@cwi.nl> - 1.40.1-20101110
915 - Fix SQL syntax of inserting BLOB code, using setBytes() 915 - Fix SQL syntax of inserting BLOB code, using setBytes()
916 - Added propery 'treat_blob_as_binary' to simulate BINARY types based on 916 - Added property 'treat_blob_as_binary' to simulate BINARY types based on
917 BLOBs for applications, (e.g. Hibernate-based) that rely on BINARY's 917 BLOBs for applications, (e.g. Hibernate-based) that rely on BINARY's
918 byte array mapping 918 byte array mapping
919 - Added code to handle BINARY types 919 - Added code to handle BINARY types
920 - Fixed implementation of getBytes to match the specifications 920 - Fixed implementation of getBytes to match the specifications
921 - Implemented getBinaryStream according to the specifications 921 - Implemented getBinaryStream according to the specifications