Mercurial > hg > monetdb-java

changeset 740:e1e9e0535e38

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add information on the column SPECIFIC_NAME as returned by getProcedures, getProcedureColumns, getFunctions and getFunctionColumns for overloaded procedure and function names.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 23 Feb 2023 16:00:44 +0100 (2023-02-23)
parents 01da1ea91c3f
children 843f7d03540a
files release.txt
diffstat 1 files changed, 14 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/release.txt
+++ b/release.txt
@@ -107,6 +107,19 @@ Currently implemented JDBC 4.2 interface
           else but "fully serializable" transactions.
 
   * java.sql.DatabaseMetaData
+    NOTE: the column SPECIFIC_NAME as returned by getProcedures,
+    getProcedureColumns, getFunctions and getFunctionColumns contains
+    the internal id of the procedure or function. Use it for overloaded
+    procedure and function names to match the proper columns info as
+    returned by getProcedureColumns or getFunctionColumns to a specifc
+    procedure or function name as returned by getProcedures or getFunctions.
+    For example, getProcedures(null, "sys", "analyze") will return 4 rows
+    as there exists 4 overloaded system procedures called analyze, with
+    different (from 0 to 3) parameters. When calling
+    getProcedureColumns(null, "sys", "analyze", "%") you will get all the
+    6 (0+1+2+3) parameters of the 4 system procedures combined. So you will
+    need to use the value of column SPECIFIC_NAME to properly match the right
+    parameters to a specific procedure.
 
   * java.sql.Statement
     The next methods/options are NOT useable/supported:
@@ -204,6 +217,7 @@ The following java.sql.* interfaces are 
   * java.sql.Struct
 
 
+
 Since release 3.2 (monetdb-jdbc-3.2.jre8.jar), the MonetDB JDBC driver has
 support for the ON CLIENT clause of the COPY statement. To make use of
 this functionality you must register handlers for upload and download of data.