Mercurial > hg > monetdb-java

comparison ChangeLog-Archive @ 0:a5a898f6886c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Copy of MonetDB java directory changeset e6e32756ad31.
author Sjoerd Mullender <sjoerd@acm.org>
date Wed, 21 Sep 2016 09:34:48 +0200 (2016-09-21)
parents
children a6608e9581c1
comparison
equal deleted inserted replaced
-1:000000000000 0:a5a898f6886c
1 # DO NOT EDIT THIS FILE -- MAINTAINED AUTOMATICALLY
2 # This file contains past ChangeLog entries
3
4 * Thu Jul 7 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.7-20160713
5 - Corrected PROCEDURE_TYPE output value of method DatabaseMetaData.getProcedures().
6 It used to return procedureReturnsResult. Now it returns procedureNoResult.
7 Corrected ORDINAL_POSITION output value of method DatabaseMetaData.getProcedureColumns().
8 It used to start with 0, but as procedures do not return a result value it now
9 starts with 1 for all the procedure arguments, as defined by the JDBC API.
10 - Improved output of method DatabaseMetaData.getProcedures(). The REMARKS
11 column now contains the procedure definition as stored in sys.functions.func.
12 The SPECIFIC_NAME column now contains the procedure unique identifier as
13 stored in sys.functions.id. This allows the caller to retrieve the specific
14 overloaded procedure which has the same name, but different arguments.
15 Also improved output of method DatabaseMetaData.getProcedureColumns().
16 The SPECIFIC_NAME column now contains the procedure unique identifier as
17 stored in sys.functions.id. This allows the caller to retrieve the proper
18 arguments of the specific overloaded procedure by matching the SPECIFIC_NAME
19 value.
20 - Improved output of method DatabaseMetaData.getFunctions(). The REMARKS
21 column now contains the function definition as stored in sys.functions.func.
22 The SPECIFIC_NAME column now contains the function unique identifier as
23 stored in sys.functions.id. This allows the caller to retrieve the specific
24 overloaded function which has the same name, but different arguments.
25 Also improved output of method DatabaseMetaData.getFunctionColumns().
26 The SPECIFIC_NAME column now contains the function unique identifier as
27 stored in sys.functions.id. This allows the caller to retrieve the proper
28 arguments of the specific overloaded function by matching the SPECIFIC_NAME
29 value.
30
31 * Thu May 26 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
32 - Fixed problem in DatabaseMetaData.getUDTs() when it was called with
33 types parameter filled. It used to throw SQException with message:
34 SELECT: identifier 'DATA_TYPE' unknown. Now it returns the UDTs which
35 match the provided array of data types.
36
37 * Thu May 19 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
38 - Implemented MonetDatabaseMetaData.supportsConvert() and
39 MonetDatabaseMetaData.supportsConvert(int fromType, int toType) methods.
40 It used to always return false. Now it returns true for the supported conversions.
41 This fixes Bug 3460.
42
43 * Sun May 8 2016 Jennie Zhang <y.zhang@cwi.nl> - 11.23.1-20160601
44 - ResultSet.setFetchSize(): added a dummy implementation to get rid
45 of the SQLFeatureNotSupportedException. In MonetDB, it does not
46 make sense to set the fetch size of a result set. If one really
47 wants to set the fetch size, one should use Statement.setFetchSize()
48 instead.
49
50 * Thu Apr 21 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
51 - Fixed resource leak in ResultSetMetaData. It created and cached a ResultSet
52 object for each column but never closed the ResultSet objects.
53
54 * Thu Mar 31 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
55 - Corrected DatabaseMetaData methods which accept a catalog filter argument.
56 Those methods will now filter the results on the specified catalog name,
57 whereas previously the catalog filter argument was ignored.
58 - Corrected output of column KEY_SEQ of DatabaseMetaData methods:
59 getPrimaryKeys(), getImportedKeys(), getExportedKeys() and
60 getCrossReference(). It now starts at 1 instead of 0 previously.
61
62 * Thu Mar 24 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
63 - Corrected DatabaseMetaData.getSchemas() by returning 2 instead of 3 columns.
64 - Improved DatabaseMetaData.getColumns() by returning two additional
65 columns: IS_AUTOINCREMENT and IS_GENERATEDCOLUMN.
66
67 * Thu Mar 17 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
68 - Improved DatabaseMetaData.getTypeInfo(). It now returns better information
69 on LITERAL_PREFIX, LITERAL_SUFFIX, CREATE_PARAMS, CASE_SENSITIVE,
70 FIXED_PREC_SCALE and MAXIMUM_SCALE for some data types. Also the returned rows
71 are now ordered by DATA_TYPE, TYPE_NAME, PRECISION as required by the specs.
72 Also corrected output column names "searchable" into "SEARCHABLE" and
73 "MAXIMUM SCALE" into "MAXIMUM_SCALE" to match the JDBC specification.
74 - Corrected DatabaseMetaData.getPseudoColumns(). It used to return 12 empty rows.
75 Now it returns no rows as MonetDB does not have pseudo columns.
76
77 * Thu Mar 3 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
78 - Implemented method DatabaseMetaData.getClientProperties(). It used to always
79 return a resultset with 4 completely empty rows. It now returns a
80 resultset with the possible connection properties.
81 - Implemented method DatabaseMetaData.getUDTs(). It used to return an empty
82 resultset. Now it returns the User Defined Types such as inet, json, url and uuid.
83
84 * Thu Feb 18 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
85 - Corrected the returned table types in DatabaseMetaData.getTableTypes().
86 It now returns all 10 table types (as stored in sys.table_types) instead
87 of the previously 8 hardcoded table types.
88 For old MonetDB servers which do not have the sys.table_types table,
89 the old behavior is retained.
90
91 * Thu Feb 11 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
92 - Implemented methods DatabaseMetadata.getProcedures() and
93 DatabaseMetadata.getProcedureColumns(). They used to return an empty resultset.
94 Now they return the expected Procedures and ProcedureColumns.
95 Also getProcedureColumns() now returns a resultset with all 20 columns
96 instead of 13 columns previously.
97
98 * Thu Feb 4 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
99 - Method getFunctionColumns() in DatabaseMetadata used to throw an
100 SQLException: getFunctionColumns(String, String, String, String) is
101 not implemented.
102 This method is now implemented and returns a resultset.
103
104 * Thu Jan 28 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
105 - Method getFunctions() in DatabaseMetadata used to throw an SQLException:
106 SELECT: no such column 'functions.sql'
107 This has been corrected. It now returns a resultset as requested.
108 - The resultsets of DatabaseMetadata methods now no longer return a
109 value for the *_CAT columns as MonetDB does not support Catalogs.
110
111 * Thu Jan 7 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
112 - Fixed a memory leak in MonetDatabaseMetaData.java for a static cache
113 which kept references to closed Connection objects.
114
115 * Thu May 12 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
116 - Improved JdbcClient program when presenting query data to console.
117 It used to send an SQL catalog query for each query result column
118 which slowed down the interactive response considerably.
119 These additional SQL catalog queries have been eliminated.
120
121 * Thu May 12 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
122 - Corrected MonetResultSet.getObject(String columnName). It no longer
123 throws a NullPointerException in cases where internally a
124 MonetVirtualResultSet is used.
125
126 * Sun May 8 2016 Jennie Zhang <y.zhang@cwi.nl> - 11.23.1-20160601
127 - Fixed Connection.isValid(): this method should never attempt to
128 close the connection, even if an error has occurred.
129
130 * Thu Aug 6 2015 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.21.1-20150807
131 - Improved JDBC driver to not throw NullPointerException anymore
132 when calling isNullable() or getPrecision() or getScale() or
133 getColumnDisplaySize() or getSchemaName() or getTableName() or
134 getColumnClassName() on a ResultSetMetaData object.
135
136 * Thu Jul 16 2015 Sjoerd Mullender <sjoerd@acm.org> - 11.21.1-20150807
137 - We now compile the Java classes using the latest Java 1.8 version, and
138 we tell it to compile for Java 1.7.
139
140 * Mon Oct 7 2013 Sjoerd Mullender <sjoerd@acm.org> - 11.15.17-20131008
141 - Rearranged order of returned columns of certain metadata functions to
142 comply with the JDBC documentation. See bug 3356.
143
144 * Sun Jun 9 2013 Fabian Groffen <fabian@monetdb.org> - 11.15.9-20130619
145 - Further improved setBigDecimal() method, based on patch by Ben Reilly
146 in bug #3290
147
148 * Thu May 23 2013 Fabian Groffen <fabian@monetdb.org> - 11.15.9-20130619
149 - Fixed bug where PreparedStatement.setBigDecimal() wouldn't format its
150 input well enough for the server causing odd errors.
151 - Allow PreparedStatement.setXXX() methods to be called with null
152 arguments, bug #3288
153
154 * Thu Apr 11 2013 Sjoerd Mullender <sjoerd@acm.org> - 11.15.5-20130412
155 - The pre-compiled .jar files are now created using Java 7 instead of
156 Java 6.
157
158 * Sat Dec 1 2012 Fabian Groffen <fabian@monetdb.org> - 11.15.1-20130212
159 - merocontrol was changed to return server URIs, and lastStop time.
160 Connections and dbpath were removed.
161 - Mapi protocol v8 support was removed from MapiSocket. Protocol
162 v8 has not been used by the servers any more since Apr2012 release
163
164 * Fri Nov 23 2012 Fabian Groffen <fabian@monetdb.org> - 11.13.7-20121212
165 - Implemented type map support of Connection to allow custom mapping
166 of UDTs to Java classes. By default the INET and URL UDTs are
167 now mapped to nl.cwi.monetdb.jdbc.types.{INET,URL}. Most notably,
168 ResultSet.getObject() and PreparedStatement.setObject() deal with the
169 type map.
170
171 * Thu Nov 22 2012 Fabian Groffen <fabian@monetdb.org> - 11.13.7-20121212
172 - Fixed a problem in PreparedStatement where the prepared statement's
173 ResultSetMetaData (on its columns to be produced) incorrectly threw
174 exceptions about non existing columns. Bug #3192
175
176 * Wed Oct 10 2012 Fabian Groffen <fabian@cwi.nl> - 11.13.3-20121016
177 - Fixed problem with PreparedStatements and setXXX() methods using column
178 numbers instead of names, bug #3158
179
180 * Tue Aug 14 2012 Fabian Groffen <fabian@cwi.nl> - 11.11.9-20120911
181 - Fixed a bug where DatabaseMetaData.getURL() did return null:0 for
182 hostname:port.
183
184 * Fri Jul 20 2012 Fabian Groffen <fabian@cwi.nl> - 11.11.7-20120813
185 - Fixed adaptive cache size used when retrieving results, not to cause
186 divide by zero errors when memory gets short, bug #3119.
187
188 * Fri Mar 2 2012 Wouter Alink <wouter@spinque.com> - 11.9.1-20120418
189 - Password reading by JdbcClient no longer results in strange artifacts
190 - JdbcClient now returns exit code 1 in case of failures
191
192 * Tue Feb 28 2012 Fabian Groffen <fabian@cwi.nl> - 11.7.9-20120312
193 - Implemented missing Number types support in
194 PreparedStatement.setObject()
195
196 * Mon Feb 20 2012 Fabian Groffen <fabian@cwi.nl> - 11.7.7-20120224
197 - Fixed bug in DatabaseMetaData.getSchemas() method that caused an SQL
198 error when called with catalog and schema argument.
199
200 * Tue Feb 14 2012 Fabian Groffen <fabian@cwi.nl> - 11.7.7-20120224
201 - Resolved a bug where JDBC and Control connections could terminate
202 abruptly with 'Connection closed' messages
203
204 * Mon Jan 2 2012 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
205 - Implemented getMetaData() method of PreparedStatement.
206
207 * Tue Dec 27 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
208 - Fixed an AssertionError for special results from e.g. EXPLAIN queries.
209
210 * Wed Dec 21 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
211 - Fixed overflow error when batching large statements, bug #2952
212
213 * Tue Dec 20 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
214 - Resolved a concurrency problem where ResultSet's date-related getters
215 could cause odd stack traces when used by multiple threads at the
216 same time, bug #2950.
217
218 * Mon Dec 19 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
219 - JDBC now implements JDBCv4.1 which makes it possible to be built with
220 Java 7 and up. JDBCv4.1 is a maintenance release of JDBCv4, and hence
221 can be compiled with Java 6, although the added methods obviously are
222 not part of the java.sql interfaces.
223
224 * Sun Dec 11 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
225 - SQLExceptions thrown now carry a SQLSTATE. Until the server starts
226 sending correct SQLSTATEs for all errors, server originated errors
227 without SQLSTATE are considered generic data exceptions (22000).
228
229 * Sat Dec 10 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
230 - Fixed a bug where closing ResultSets and PreparedStatements could lead
231 to errors on concurrent running queries using the same Connection due
232 to a race condition.
233
234 * Thu Dec 8 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
235 - Changed version scheme of JDBC driver and MCL jar to be more standard,
236 from monetdb-X.Y-<thing>.jar to monetdb-<thing>-X.Y.jar, bug #2943
237
238 * Fri Oct 14 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
239 - The embedded monet instance capability of MonetConnection was removed.
240 - Bump JDBC version to 2.0 (Liberica). JDBC now implements JDBCv4 which
241 makes it possible to be built with Java 6 and up. Java 5 and before
242 are no longer supported, and can use the 1.x releases of the driver.
243
244 * Thu Sep 1 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
245 - INTERVAL columns are now treated as decimals, since they can have
246 sub-second precision.
247
248 * Thu Jun 30 2011 Fabian Groffen <fabian@cwi.nl> - 11.5.1-20110907
249 - Add so_timeout Driver property to specify a SO_TIMEOUT value for the
250 socket in use to the database. Setting this property to a value in
251 milliseconds defines the timeout for read calls, which may 'unlock'
252 the driver if the server hangs, bug #2828
253
254 * Wed May 25 2011 Fabian Groffen <fabian@cwi.nl> - 11.5.1-20110907
255 - Added a naive implementation for PreparedStatement.setCharacterStream
256
257 * Mon Apr 11 2011 Fabian Groffen <fabian@cwi.nl> - 11.5.1-20110907
258 - The obsolete Java-based implementation for PreparedStatements (formerly
259 activated using the java_prepared_statements property) has been dropped
260
261 * Fri Jul 8 2011 Fabian Groffen <fabian@cwi.nl> - 11.3.5-20110720
262 - Return false from Statement.getMoreResults() instead of a
263 NullPointerException when no query has been performed on the Statement
264 yet, bug #2833
265
266 * Mon Jun 6 2011 Fabian Groffen <fabian@cwi.nl> - 11.3.5-20110720
267 - Fixed read-only interpretation. Connection.isReadOnly now always
268 returns false, setReadOnly now generates a warning when called with
269 true. Partly from bug #2818
270 - Allow readonly to be set when autocommit is disabled as well. Bug #2818
271
272 * Wed May 11 2011 Fabian Groffen <fabian@cwi.nl> - 11.3.3-20110517
273 - Insertion via PreparedStatement and retrieval via ResultSet of timestamp
274 and time fields with and without timezones was improved to better
275 respect timezones, as partly indicated in bug #2781.
276
277 * Tue Apr 5 2011 Fabian Groffen <fabian@cwi.nl> - 11.3.1-20110414
278 - clarify exception messages for unsupported methods
279
280 * Mon Feb 7 2011 Fabian Groffen <fabian@cwi.nl> - 11.3.1-20110414
281 - Removed XQuery related XRPC wrapper and XML:DB code, removed support
282 for language=xquery and language=mil from JDBC.
283
284 * Wed Dec 15 2010 Fabian Groffen <fabian@cwi.nl> - 11.1.1-20110317
285 - PreparedStatements now free the server-side resources attached to them
286 when closed. This implements bug #2720
287
288 * Tue Nov 9 2010 Fabian Groffen <fabian@cwi.nl> - 1.40.1-20101110
289 - Fix SQL syntax of inserting BLOB code, using setBytes()
290 - Added propery 'treat_blob_as_binary' to simulate BINARY types based on
291 BLOBs for applications, (e.g. Hibernate-based) that rely on BINARY's
292 byte array mapping
293 - Added code to handle BINARY types
294 - Fixed implementation of getBytes to match the specifications
295 - Implemented getBinaryStream according to the specifications
296
297 * Mon Nov 8 2010 Fabian Groffen <fabian@cwi.nl> - 1.40.1-20101109
298 - Java 1.6's subSequence() bug has changed into a slice() bug since
299 1.6.0_22. Revert workaround for subSequence breakage, since it breaks
300 operating with the latest Java 1.6.
301
302 * Fri Oct 22 2010 Fabian Groffen <fabian@cwi.nl> - 1.40.1-20101029
303 - Fix for bug #2703, allow to have multiple metadata ResultSets open at
304 the same time
305
306 * Wed Aug 11 2010 Fabian Groffen <fabian@cwi.nl> - 1.38.5-20100823
307 - Implemented ResultSet's getCharacterStream methods, since Hibernate seems to
308 call this method for retrieving CLOB columns that we now do support.
309
310 * Fri Aug 06 2010 Fabian Groffen <fabian@cwi.nl> - 1.38.5-20100823
311 - Fix implementation of setBytes method of PreparedStatement, such that bytes
312 are converted to MonetDB/SQL's BLOB notation.
313
314 * Wed Jul 21 2010 Fabian Groffen <fabian@cwi.nl> - 1.38.5-20100823
315 - merocontrol Java library requires Java 2 Platform 1.5 and up, due to enum
316 and boxing/unboxing. Bug #2627
317
318 * Tue Jul 20 2010 Fabian Groffen <fabian@cwi.nl> - 1.38.5-20100823
319 - Implement missing Blob support (readonly), since getObject will blindly
320 return a BLOB instance as String, which is causing applications to wrongly
321 believe a BLOB instance is a string.
322
323 * Fri Jul 16 2010 Fabian Groffen <fabian@cwi.nl> - 1.38.5-20100823
324 - Fix problem when using the MAL language. Any statement would return
325 an error with a typo that was not typed in by the user, such as
326 ioo.printf when io.printf was typed.
327
328 * Fri Apr 16 2010 Fabian Groffen <fabian@cwi.nl> - Jun2010-SP1
329 - Enable the merovingian control library for default distribution as it
330 has been in use for some time without problems now.
331
332 * Wed Mar 31 2010 Stefan Manegold <manegold@cwi.nl> - Jun2010-SP1
333 - Made compilation of "testing" (and "java") independent of MonetDB.
334 This is mainly for Windows, but also on other systems, "testing" can now be
335 built independently of (and hence before) "MonetDB".
336 Files that mimic configure functionality on Windows were moved from
337 "MonetDB" to "buildtools"; hence, this affects all packages on Windows,
338 requiring a complete rebuild from scratch on Windows.
339 getopt() support in testing has changed; hence, (most probably) requiring a
340 rebuild from scratch of testing on other systems.
341
342 * Wed Mar 31 2010 Fabian Groffen <fabian@cwi.nl> - Feb2010-SP2
343 - Do not to throw an SQLException, but generate a warning and try to
344 perform as much as requested in an optimistic manner, as not to break
345 clients that rely on the called method, but don't really use its
346 functionality (such as high-level generic programs that call any
347 driver and try to put it in a mode that it does what they expect).
348 The following functions no longer throw an SQLException but now
349 generate a warning and perform actions as far as possible:
350 - Statement.execute(sql, columnIndexes/columnNames)
351 - Statement.executeUpdate(sql, columnIndexes/columnNames)
352 - Statement.getMaxFieldSize()
353 - Statement.setCursorName(name)
354 - Statement.setEscapeProcessing(enable)
355 - Statement.setMaxFieldSize(max)
356 - Statement.setQueryTimeout(seconds)
357 - PreparedStatement.getMetaData()
358 - PreparedStatement.setNull(paramIndex, sqlType, typeName)
359
360 * Wed Mar 24 2010 Stefan Manegold <manegold@cwi.nl> - Jun2010-SP1
361 - Implemented build directory support for Windows,
362 i.e., like on Unix/Linux also on Windows we can now build in a separate
363 build directory as alternative to ...\<package>\NT, and thus keep the
364 latter clean from files generated during the build.
365 On Windows, the build directory must be a sibling of ...\<package>\NT .
366
367 * Tue Mar 09 2010 Fabian Groffen <fabian@cwi.nl> - Feb2010-SP1
368 - Set JAVA_HOME to the configure derived value, such that ant will use
369 the javac compiler as found by configure, and not the one it was built
370 with itself. This solves the problem that the JDBC driver still fails
371 to compile on e.g. Fedora systems even though configure
372 --with-java=/path/to/sun/jdk-5 was given, because ant still uses
373 gjc/icedtea by itself.
374
375 * Mon Oct 12 2009 Wouter Alink <w.alink@cwi.nl> - Aug2009-SP2
376 - Bump MCL version to 1.6 for fix.
377
378 * Fri Oct 09 2009 Fabian Groffen <fabian@cwi.nl> - Feb2010
379 - Bump Java source version to 1.5. Java 1.5 is the current J2EE, and code
380 from nl.cwi.monetdb.merovingian relies on Java 1.5 features. It seems
381 like a good time to deprecate 1.4 now 1.6 is about to become the new
382 J2EE version.
383
384 * Fri Oct 09 2009 Wouter Alink <w.alink@cwi.nl> - Aug2009-SP2
385 - applied workaround for bug in Sun JRE 1.6.
386
387 * Thu Oct 01 2009 Fabian Groffen <fabian@cwi.nl> - Aug2009-SP2
388 - Bump JDBC version to 1.14 for fix.
389
390 * Thu Oct 01 2009 Fabian Groffen <fabian@cwi.nl> - Aug2009-SP2
391 - Fix warning messages to disappear when a connection to merovingian is
392 made.
393
394 * Sun Aug 23 2009 Fabian Groffen <fabian@cwi.nl> - Aug2009-SP1
395 - Bump JDBC version to 1.13 for fix.
396
397 * Sun Aug 23 2009 Fabian Groffen <fabian@cwi.nl> - Aug2009-SP1
398 - Avoid "ResultSet is closed" messages by disabling the use of
399 finalizers, bug #2844202
400
401 * Thu Mar 26 2009 Fabian Groffen <fabian@cwi.nl> - Feb2010
402 - Fix configure handling for --enable-{jdbc,xrpc}, by Yue Sheng on
403 Monetdb-developers ML
404