Mercurial > hg > monetdb-java

annotate release.md @ 922:e54a9fc65e0c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Correct expected output of getClientInfoProperties() for Dec2023 and older releases.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Wed, 31 Jul 2024 20:41:13 +0200 (8 months ago)
parents f31366ece930
children d311affc65f0
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
1 RELEASE NOTES
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
2 =============
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
3
741
843f7d03540a Updated release numbers in preparation for a release.
Sjoerd Mullender <sjoerd@acm.org>
parents: 740
diff changeset
4 MonetDB JDBC driver version 3.3 (Liberica)
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
5 <br>
741
843f7d03540a Updated release numbers in preparation for a release.
Sjoerd Mullender <sjoerd@acm.org>
parents: 740
diff changeset
6 Release date: 2023-02-23
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
7
355
69803e5a5a49 Extend text in JDBC release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 354
diff changeset
8 The Java Database Connectivity (JDBC) API provides universal data access from
69803e5a5a49 Extend text in JDBC release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 354
diff changeset
9 the Java programming language.
69803e5a5a49 Extend text in JDBC release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 354
diff changeset
10
69803e5a5a49 Extend text in JDBC release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 354
diff changeset
11 The MonetDB JDBC driver is designed for use with MonetDB, an Open-Source column-store RDBMS.
177
4959b85b981c Extend DatabaseMetaData.getClientInfoProperties() with new property: treat_clob_as_varchar
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 176
diff changeset
12 For more information see https://www.monetdb.org/
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
13
355
69803e5a5a49 Extend text in JDBC release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 354
diff changeset
14 The latest MonetDB JDBC driver can be downloaded from
69803e5a5a49 Extend text in JDBC release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 354
diff changeset
15 https://www.monetdb.org/downloads/Java/
69803e5a5a49 Extend text in JDBC release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 354
diff changeset
16
477
0e30bc245838 Update the release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 444
diff changeset
17 The sources for this JDBC driver and related Java programs can be found at:
0e30bc245838 Update the release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 444
diff changeset
18 https://dev.monetdb.org/hg/monetdb-java/file/tip
0e30bc245838 Update the release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 444
diff changeset
19
0e30bc245838 Update the release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 444
diff changeset
20
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
21 URL Format
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
22 ----------
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
23
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
24 The MonetDB JDBC connection URL format is:
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
25
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
26 <pre>
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
27 jdbc:<b>monetdb</b>://[&lt;host>[:&lt;port>]]/&lt;databasename>[?&lt;properties>] (not encrypted)
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
28 OR
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
29 jdbc:<b>monetdbs</b>://[&lt;host>[:&lt;port>]]/&lt;databasename>[?&lt;properties>] (encrypted)
176
e701b51b3552 Extend release.txt with information on MonetDB JDBC connection URL format
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
30
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
31 where &lt;properties> are &-separated: prop1=value1[&prop2=value2[&prop3=value3...]]
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
32 </pre>
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
33
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
34 The second form (monetdbs) is for creating a TLS-protected connection. TLS (Transport Layer Security)
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
35 is the mechanism that is also used for HTTPS.
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
36
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
37 Property keys and values support percent-escaped bytes. For example, the
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
38 password 'chocolate&cookies' can be passed as follows: `jdbc:monetdb:///demo?user=me&password=chocolate%26cookies`.
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
39
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
40 Note: MonetDB-Java version 3.3 and earlier did not support percent-escapes.
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
41 If your password contains percent-characters, these must now be encoded as `%25`.
176
e701b51b3552 Extend release.txt with information on MonetDB JDBC connection URL format
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
42
177
4959b85b981c Extend DatabaseMetaData.getClientInfoProperties() with new property: treat_clob_as_varchar
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 176
diff changeset
43 Supported connection properties are:
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
44
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
45 | Property | Default | Notes |
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
46 | ----------------------------------------- | ------- | --------------------------------------------------- |
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
47 | user=&lt;login name> | - | required |
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
48 | password=&lt;secret value> | - | required |
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
49 | so_timeout=&lt;time in milliseconds> | - | |
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
50 | treat_clob_as_varchar=&lt;bool> | true | |
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
51 | treat_blob_as_binary=&lt;bool> | true | |
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
52 | language=&lt;sql or mal> | sql | |
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
53 | replysize=&lt;nr of rows> | 250 | -1 means fetch everything at once |
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
54 | autocommit=&lt;bool> | true | |
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
55 | schema=&lt;schema name> | - | initial schema to select |
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
56 | timezone=&lt;minutes east of UTC> | system | |
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
57 | debug=true | false | |
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
58 | logfile=&lt;name of logfile> | | |
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
59 | hash=&lt;SHA512, SHA384, SHA256 or SHA1> | | |
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
60 | cert=&lt;path to certificate> | - | TLS certificate must be in PEM format |
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
61 | certhash=sha256:&lt;hexdigits and colons> | - | required hash of server TLS certificate in DER form |
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
62
346
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
63
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
64 Booleans &lt;bool> can be written as 'true', 'false', 'yes', 'no', 'on' and 'off'. Property 'fetchsize' is accepted as an alias of 'replysize'.
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
65
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
66 Client authentication (Mutual TLS, or MTLS) is not yet supported.
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
67
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
68 When the properties 'treat_clob_as_varchar' and 'treat_blob_as_binary' are enabled,
381
11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 376
diff changeset
69
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
70 The properties 'treat_clob_as_varchar' and 'treat_blob_as_binary' control which
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
71 type is returned by ResultSetMetaData.getColumnType(int) for CLOB and BLOB columns.
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
72 When 'treat_clob_as_varchar' is enabled, Types.VARCHAR is returned instead of Types.CLOB
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
73 for CLOB columns. When 'treat_blob_as_binary' is enabled, Types.VARBINARY is returned instead
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
74 of Types.BLOB for BLOB columns.
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
75 This will cause generic JDBC applications such as SQuirrel SQL and DBeaver to use
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
76 the more efficient '#getString()' and '#getBytes()' API rather than '#getClob()' and
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
77 '#getClob()'.
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
78 These properties are enabled by default since MonetDB-Java version 3.0.
381
11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 376
diff changeset
79
176
e701b51b3552 Extend release.txt with information on MonetDB JDBC connection URL format
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
80
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
81 Use
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
82 ---
176
e701b51b3552 Extend release.txt with information on MonetDB JDBC connection URL format
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
83
364
37f54743b1fd Correcting invalid documentation URL refs.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 363
diff changeset
84 See also: https://www.monetdb.org/Documentation/SQLreference/Programming/JDBC
176
e701b51b3552 Extend release.txt with information on MonetDB JDBC connection URL format
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 163
diff changeset
85
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
86 The MonetDB JDBC driver class name is `org.monetdb.jdbc.MonetDriver`.
482
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 477
diff changeset
87 This has been changed as of release 3.0 (monetdb-jdbc-3.0.jre8.jar).
768
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 765
diff changeset
88 The old driver class (nl.cwi.monetdb.jdbc.MonetDriver) has been deprecated
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
89 since 12 Nov 2020 and has been removed in release 3.4 (monetdb-jdbc-3.4.jre8.jar).
482
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 477
diff changeset
90
73cfc519ec1e Updated ChangeLog, Archive and release.txt in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 477
diff changeset
91
190
d348d476153a Also update the release notes for the new release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 182
diff changeset
92 JDBC COMPLIANCE
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
93 ---------------
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
94
355
69803e5a5a49 Extend text in JDBC release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 354
diff changeset
95 The MonetDB JDBC driver is a type 4 driver (100% pure Java) and
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
96 complies to the JDBC 4.2 definition, see
376
ffdc7b0e102d Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 364
diff changeset
97 http://docs.oracle.com/javase/8/docs/technotes/guides/jdbc/index.html
355
69803e5a5a49 Extend text in JDBC release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 354
diff changeset
98 and
69803e5a5a49 Extend text in JDBC release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 354
diff changeset
99 https://en.wikipedia.org/wiki/Java_Database_Connectivity
28
9d4b1ef73a5f Updating release notes in preparation of Dec2016 release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
100
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
101 Within the current implementation not all functionalities of the JDBC
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
102 interface are available. It is believed however, that this
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
103 implementation is rich enough to be suitable for a majority of
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
104 application settings.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
105
28
9d4b1ef73a5f Updating release notes in preparation of Dec2016 release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
106 Below a list of (un)supported features can be found.
210
2dbfc65d8e03 Small update on the release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 202
diff changeset
107 Please read this list if you intend to use this JDBC driver.
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
108
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
109 If you feel some features are missing or have encountered an issue/bug,
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
110 please let us know at our bugtracker:
444
bc39810b3faa Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 435
diff changeset
111 https://github.com/MonetDB/monetdb-java/issues
28
9d4b1ef73a5f Updating release notes in preparation of Dec2016 release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
112
376
ffdc7b0e102d Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 364
diff changeset
113 Currently implemented JDBC 4.2 interfaces include:
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
114 * java.sql.Driver
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
115 The following method is NOT useable/supported:
477
0e30bc245838 Update the release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 444
diff changeset
116 - getParentLogger
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
117
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
118 * java.sql.Connection
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
119 The following features/methods are NOT useable/supported:
89
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 78
diff changeset
120 - createArrayOf, createNClob, createStruct, createSQLXML
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 78
diff changeset
121 - prepareStatement with array of column indices or column names
210
2dbfc65d8e03 Small update on the release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 202
diff changeset
122 - setHoldability (close/hold cursors over commit is not configurable)
2dbfc65d8e03 Small update on the release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 202
diff changeset
123
2dbfc65d8e03 Small update on the release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 202
diff changeset
124 NOTE: be sure to check for warnings after setting concurrencies or
2dbfc65d8e03 Small update on the release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 202
diff changeset
125 isolation levels; MonetDB currently does not support anything
2dbfc65d8e03 Small update on the release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 202
diff changeset
126 else but "fully serializable" transactions.
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
127
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
128 * java.sql.DatabaseMetaData
740
e1e9e0535e38 Add information on the column SPECIFIC_NAME as returned by getProcedures, getProcedureColumns, getFunctions and getFunctionColumns for overloaded procedure and function names.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 738
diff changeset
129 NOTE: the column SPECIFIC_NAME as returned by getProcedures,
e1e9e0535e38 Add information on the column SPECIFIC_NAME as returned by getProcedures, getProcedureColumns, getFunctions and getFunctionColumns for overloaded procedure and function names.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 738
diff changeset
130 getProcedureColumns, getFunctions and getFunctionColumns contains
e1e9e0535e38 Add information on the column SPECIFIC_NAME as returned by getProcedures, getProcedureColumns, getFunctions and getFunctionColumns for overloaded procedure and function names.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 738
diff changeset
131 the internal id of the procedure or function. Use it for overloaded
e1e9e0535e38 Add information on the column SPECIFIC_NAME as returned by getProcedures, getProcedureColumns, getFunctions and getFunctionColumns for overloaded procedure and function names.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 738
diff changeset
132 procedure and function names to match the proper columns info as
e1e9e0535e38 Add information on the column SPECIFIC_NAME as returned by getProcedures, getProcedureColumns, getFunctions and getFunctionColumns for overloaded procedure and function names.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 738
diff changeset
133 returned by getProcedureColumns or getFunctionColumns to a specifc
e1e9e0535e38 Add information on the column SPECIFIC_NAME as returned by getProcedures, getProcedureColumns, getFunctions and getFunctionColumns for overloaded procedure and function names.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 738
diff changeset
134 procedure or function name as returned by getProcedures or getFunctions.
e1e9e0535e38 Add information on the column SPECIFIC_NAME as returned by getProcedures, getProcedureColumns, getFunctions and getFunctionColumns for overloaded procedure and function names.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 738
diff changeset
135 For example, getProcedures(null, "sys", "analyze") will return 4 rows
e1e9e0535e38 Add information on the column SPECIFIC_NAME as returned by getProcedures, getProcedureColumns, getFunctions and getFunctionColumns for overloaded procedure and function names.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 738
diff changeset
136 as there exists 4 overloaded system procedures called analyze, with
e1e9e0535e38 Add information on the column SPECIFIC_NAME as returned by getProcedures, getProcedureColumns, getFunctions and getFunctionColumns for overloaded procedure and function names.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 738
diff changeset
137 different (from 0 to 3) parameters. When calling
e1e9e0535e38 Add information on the column SPECIFIC_NAME as returned by getProcedures, getProcedureColumns, getFunctions and getFunctionColumns for overloaded procedure and function names.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 738
diff changeset
138 getProcedureColumns(null, "sys", "analyze", "%") you will get all the
e1e9e0535e38 Add information on the column SPECIFIC_NAME as returned by getProcedures, getProcedureColumns, getFunctions and getFunctionColumns for overloaded procedure and function names.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 738
diff changeset
139 6 (0+1+2+3) parameters of the 4 system procedures combined. So you will
e1e9e0535e38 Add information on the column SPECIFIC_NAME as returned by getProcedures, getProcedureColumns, getFunctions and getFunctionColumns for overloaded procedure and function names.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 738
diff changeset
140 need to use the value of column SPECIFIC_NAME to properly match the right
e1e9e0535e38 Add information on the column SPECIFIC_NAME as returned by getProcedures, getProcedureColumns, getFunctions and getFunctionColumns for overloaded procedure and function names.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 738
diff changeset
141 parameters to a specific procedure.
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
142
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
143 * java.sql.Statement
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
144 The following methods/options are NOT useable/supported:
28
9d4b1ef73a5f Updating release notes in preparation of Dec2016 release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
145 - cancel (query execution cannot be terminated, once started)
610
6aa38e8c0f2d Updated Copyright year.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 584
diff changeset
146 see also: https://github.com/MonetDB/monetdb-java/issues/7
6aa38e8c0f2d Updated Copyright year.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 584
diff changeset
147 or https://www.monetdb.org/bugzilla/show_bug.cgi?id=6222
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
148 - execute with column indices or names
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
149 - executeUpdate with column indices or names
28
9d4b1ef73a5f Updating release notes in preparation of Dec2016 release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
150 - setMaxFieldSize
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
151 - setCursorName
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
152 The following methods will add an SQLWarning:
712
7cec464246f2 Correct and improve the information on Statement.setEscapeProcessing method.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 710
diff changeset
153 - setEscapeProcessing(true) for Sep2022 (11.45) and older servers
765
552c125e5cdc Update release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 741
diff changeset
154 - setEscapeProcessing(false) for Jun2023 (11.47) and newer servers
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
155
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
156 * java.sql.PreparedStatement
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
157 The following methods are NOT useable/supported:
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
158 - setArray
710
437e51b4c169 Future versions of MonetDB (post Sep2022) will have capability to parse and execute ODBC/JDBC escape sequence syntax.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 662
diff changeset
159 - setAsciiStream
437e51b4c169 Future versions of MonetDB (post Sep2022) will have capability to parse and execute ODBC/JDBC escape sequence syntax.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 662
diff changeset
160 - setBinaryStream
28
9d4b1ef73a5f Updating release notes in preparation of Dec2016 release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
161 - setBlob
163
e398c27acf7e Implemented PreparedStatement methods setNCharacterStream(int, Reader) and setNCharacterStream(int, Reader, long).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 158
diff changeset
162 - setNClob
710
437e51b4c169 Future versions of MonetDB (post Sep2022) will have capability to parse and execute ODBC/JDBC escape sequence syntax.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 662
diff changeset
163 - setRef
437e51b4c169 Future versions of MonetDB (post Sep2022) will have capability to parse and execute ODBC/JDBC escape sequence syntax.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 662
diff changeset
164 - setRowId
437e51b4c169 Future versions of MonetDB (post Sep2022) will have capability to parse and execute ODBC/JDBC escape sequence syntax.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 662
diff changeset
165 - setSQLXML
437e51b4c169 Future versions of MonetDB (post Sep2022) will have capability to parse and execute ODBC/JDBC escape sequence syntax.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 662
diff changeset
166 - setUnicodeStream (note: this method is Deprecated)
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
167
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
168 * java.sql.ParameterMetaData
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
169
271
4880267d0fe1 Added implementation of java.sql.CallableStatement interface, test program and updated the ChangeLog and release notes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 234
diff changeset
170 * java.sql.CallableStatement
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
171 The following methods are NOT useable/supported:
271
4880267d0fe1 Added implementation of java.sql.CallableStatement interface, test program and updated the ChangeLog and release notes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 234
diff changeset
172 - all getXyz(parameterIndex/parameterName, ...) methods because
4880267d0fe1 Added implementation of java.sql.CallableStatement interface, test program and updated the ChangeLog and release notes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 234
diff changeset
173 output parameters in stored procedures are not supported by MonetDB
4880267d0fe1 Added implementation of java.sql.CallableStatement interface, test program and updated the ChangeLog and release notes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 234
diff changeset
174 - all registerOutParameter(parameterIndex/parameterName, int sqlType, ...) methods
4880267d0fe1 Added implementation of java.sql.CallableStatement interface, test program and updated the ChangeLog and release notes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 234
diff changeset
175 because output parameters in stored procedures are not supported by MonetDB
4880267d0fe1 Added implementation of java.sql.CallableStatement interface, test program and updated the ChangeLog and release notes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 234
diff changeset
176 - wasNull() method because output parameters in stored procedures are
4880267d0fe1 Added implementation of java.sql.CallableStatement interface, test program and updated the ChangeLog and release notes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 234
diff changeset
177 not supported by MonetDB
710
437e51b4c169 Future versions of MonetDB (post Sep2022) will have capability to parse and execute ODBC/JDBC escape sequence syntax.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 662
diff changeset
178 - setArray
437e51b4c169 Future versions of MonetDB (post Sep2022) will have capability to parse and execute ODBC/JDBC escape sequence syntax.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 662
diff changeset
179 - setAsciiStream
437e51b4c169 Future versions of MonetDB (post Sep2022) will have capability to parse and execute ODBC/JDBC escape sequence syntax.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 662
diff changeset
180 - setBinaryStream
437e51b4c169 Future versions of MonetDB (post Sep2022) will have capability to parse and execute ODBC/JDBC escape sequence syntax.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 662
diff changeset
181 - setBlob
437e51b4c169 Future versions of MonetDB (post Sep2022) will have capability to parse and execute ODBC/JDBC escape sequence syntax.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 662
diff changeset
182 - setNClob
437e51b4c169 Future versions of MonetDB (post Sep2022) will have capability to parse and execute ODBC/JDBC escape sequence syntax.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 662
diff changeset
183 - setRef
437e51b4c169 Future versions of MonetDB (post Sep2022) will have capability to parse and execute ODBC/JDBC escape sequence syntax.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 662
diff changeset
184 - setRowId
437e51b4c169 Future versions of MonetDB (post Sep2022) will have capability to parse and execute ODBC/JDBC escape sequence syntax.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 662
diff changeset
185 - setSQLXML
437e51b4c169 Future versions of MonetDB (post Sep2022) will have capability to parse and execute ODBC/JDBC escape sequence syntax.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 662
diff changeset
186 - setUnicodeStream (note: this method is Deprecated)
271
4880267d0fe1 Added implementation of java.sql.CallableStatement interface, test program and updated the ChangeLog and release notes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 234
diff changeset
187
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
188 * java.sql.ResultSet
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
189 The following methods are NOT useable/supported:
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
190 - getArray
28
9d4b1ef73a5f Updating release notes in preparation of Dec2016 release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
191 - getAsciiStream, getUnicodeStream
152
352b54ff0436 Implemented ResultSet method getNCharacterStream()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 149
diff changeset
192 - getNClob
28
9d4b1ef73a5f Updating release notes in preparation of Dec2016 release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
193 - getRef, getRowId, getSQLXML
477
0e30bc245838 Update the release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 444
diff changeset
194 - moveToCurrentRow, moveToInsertRow,
0e30bc245838 Update the release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 444
diff changeset
195 - All methods related to updateable result sets such as:
0e30bc245838 Update the release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 444
diff changeset
196 updateArray ... updateTimestamp, cancelRowUpdates,
0e30bc245838 Update the release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 444
diff changeset
197 deleteRow, insertRow, refreshRow
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
198
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
199 * java.sql.ResultSetMetaData
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
200
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
201 * java.sql.SavePoint
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
202
28
9d4b1ef73a5f Updating release notes in preparation of Dec2016 release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
203 * java.sql.Wrapper
9d4b1ef73a5f Updating release notes in preparation of Dec2016 release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
204
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
205 * java.sql.Blob
346
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
206 A simple implementation using a byte[] to store the whole BLOB.
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
207 The following method is NOT useable/supported:
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
208 - setBinaryStream
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
209
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
210 * java.sql.Clob
346
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
211 A simple implementation using a StringBuilder to store the whole CLOB.
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
212 The following methods are NOT useable/supported:
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
213 - setAsciiStream
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
214 - setCharacterStream
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
215
158
b016c9e945a0 Update release.txt as we do have interface java.sql.SQLData implemented by two classes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 156
diff changeset
216 * java.sql.SQLData
391
f523727db392 Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.*
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 381
diff changeset
217 implemented by class: org.monetdb.jdbc.types.INET
f523727db392 Moved Java classes from packages starting with nl.cwi.monetdb.* to package org.monetdb.*
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 381
diff changeset
218 and by class: org.monetdb.jdbc.types.URL
158
b016c9e945a0 Update release.txt as we do have interface java.sql.SQLData implemented by two classes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 156
diff changeset
219
28
9d4b1ef73a5f Updating release notes in preparation of Dec2016 release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
220 * javax.sql.DataSource (not tested)
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
221 The following method is NOT useable/supported:
477
0e30bc245838 Update the release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 444
diff changeset
222 - getParentLogger
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
223
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
224
346
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
225 The following java.sql.* interfaces are NOT implemented:
28
9d4b1ef73a5f Updating release notes in preparation of Dec2016 release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
226 * java.sql.Array
376
ffdc7b0e102d Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 364
diff changeset
227 * java.sql.DriverAction
28
9d4b1ef73a5f Updating release notes in preparation of Dec2016 release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
228 * java.sql.NClob
9d4b1ef73a5f Updating release notes in preparation of Dec2016 release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
229 * java.sql.Ref
9d4b1ef73a5f Updating release notes in preparation of Dec2016 release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
230 * java.sql.Rowid
9d4b1ef73a5f Updating release notes in preparation of Dec2016 release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
231 * java.sql.SQLInput
9d4b1ef73a5f Updating release notes in preparation of Dec2016 release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
232 * java.sql.SQLOutput
376
ffdc7b0e102d Updated JDBC driver to comply with JDBC 4.2 interface now we compile for Java 8. This includes:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 364
diff changeset
233 * java.sql.SQLType
28
9d4b1ef73a5f Updating release notes in preparation of Dec2016 release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
234 * java.sql.SQLXML
9d4b1ef73a5f Updating release notes in preparation of Dec2016 release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
235 * java.sql.Struct
9d4b1ef73a5f Updating release notes in preparation of Dec2016 release
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 0
diff changeset
236
577
6ab9168ef8e1 Added startup argument --csvdir to JdbcClient program to allow explicit enabling and specification where csv data files are to be read from or written to when the COPY ... ON CLIENT command is executed.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 536
diff changeset
237
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
238 ON CLIENT support
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
239 -----------------
740
e1e9e0535e38 Add information on the column SPECIFIC_NAME as returned by getProcedures, getProcedureColumns, getFunctions and getFunctionColumns for overloaded procedure and function names.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 738
diff changeset
240
577
6ab9168ef8e1 Added startup argument --csvdir to JdbcClient program to allow explicit enabling and specification where csv data files are to be read from or written to when the COPY ... ON CLIENT command is executed.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 536
diff changeset
241 Since release 3.2 (monetdb-jdbc-3.2.jre8.jar), the MonetDB JDBC driver has
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
242 support for the ON CLIENT clause of the COPY statement. To use
577
6ab9168ef8e1 Added startup argument --csvdir to JdbcClient program to allow explicit enabling and specification where csv data files are to be read from or written to when the COPY ... ON CLIENT command is executed.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 536
diff changeset
243 this functionality you must register handlers for upload and download of data.
6ab9168ef8e1 Added startup argument --csvdir to JdbcClient program to allow explicit enabling and specification where csv data files are to be read from or written to when the COPY ... ON CLIENT command is executed.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 536
diff changeset
244 The MonetConnection class has been extended with 2 methods:
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
245
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
246 * public void setUploadHandler(UploadHandler uploadHandler)
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
247 * public void setDownloadHandler(DownloadHandler downloadHandler)
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
248
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
249 The API has been extended with some further interfaces and utility classes:
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
250 * public interface org.monetdb.jdbc.MonetConnection.UploadHandler
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
251 * public interface org.monetdb.jdbc.MonetConnection.DownloadHandler
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
252 * public static class org.monetdb.jdbc.MonetConnection.Upload
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
253 * public static class org.monetdb.jdbc.MonetConnection.Download
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
254 * public class org.monetdb.util.FileTransferHandler
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
255 which implements the UploadHandler and DownloadHandler interfaces.
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
256
738
19fba8e8ee17 Update JDBC documentation text.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 712
diff changeset
257 See file onclient.txt for more information on how to use these from Java.
577
6ab9168ef8e1 Added startup argument --csvdir to JdbcClient program to allow explicit enabling and specification where csv data files are to be read from or written to when the COPY ... ON CLIENT command is executed.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 536
diff changeset
258
6ab9168ef8e1 Added startup argument --csvdir to JdbcClient program to allow explicit enabling and specification where csv data files are to be read from or written to when the COPY ... ON CLIENT command is executed.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 536
diff changeset
259 The JdbcClient application has also been extended to support COPY ...
6ab9168ef8e1 Added startup argument --csvdir to JdbcClient program to allow explicit enabling and specification where csv data files are to be read from or written to when the COPY ... ON CLIENT command is executed.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 536
diff changeset
260 ON CLIENT functionality. However for security reasons you must provide an
6ab9168ef8e1 Added startup argument --csvdir to JdbcClient program to allow explicit enabling and specification where csv data files are to be read from or written to when the COPY ... ON CLIENT command is executed.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 536
diff changeset
261 explicit new startup argument
6ab9168ef8e1 Added startup argument --csvdir to JdbcClient program to allow explicit enabling and specification where csv data files are to be read from or written to when the COPY ... ON CLIENT command is executed.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 536
diff changeset
262 --csvdir "/path/to/csvdatafiles"
6ab9168ef8e1 Added startup argument --csvdir to JdbcClient program to allow explicit enabling and specification where csv data files are to be read from or written to when the COPY ... ON CLIENT command is executed.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 536
diff changeset
263 or on MS Windows
6ab9168ef8e1 Added startup argument --csvdir to JdbcClient program to allow explicit enabling and specification where csv data files are to be read from or written to when the COPY ... ON CLIENT command is executed.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 536
diff changeset
264 --csvdir "C:\\path\\to\\csvdatafiles"
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
265 in order to allow the JdbcClient to access local files.
577
6ab9168ef8e1 Added startup argument --csvdir to JdbcClient program to allow explicit enabling and specification where csv data files are to be read from or written to when the COPY ... ON CLIENT command is executed.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 536
diff changeset
266
346
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
267
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
268 Notes and tips
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
269 --------------
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
270
639
899f0c120256 Improve and extend information in .txt files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 637
diff changeset
271 - After creating a Connection object check for SQLWarnings via conn.getWarnings();
899f0c120256 Improve and extend information in .txt files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 637
diff changeset
272
346
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
273 - Close JDBC ResultSet, Statement, PreparedStatement, CallableStatement and
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
274 Connection objects immediately (via close()) when they are no longer needed,
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
275 in order to release resources and memory on the server and client side.
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
276 Especially ResultSets can occupy large amounts of memory on the server and
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
277 client side.
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
278
444
bc39810b3faa Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 435
diff changeset
279 - By default the ResultSets created by methods in DatabaseMetaData
bc39810b3faa Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 435
diff changeset
280 which return a ResultSet (such as dbmd.getColumns(...)) are
bc39810b3faa Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 435
diff changeset
281 TYPE_SCROLL_INSENSITIVE, so they cache their ResultSet data to
bc39810b3faa Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 435
diff changeset
282 allow absolute, relative and random access to data rows and fields.
639
899f0c120256 Improve and extend information in .txt files.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 637
diff changeset
283 To free heap memory and server resources, close those ResultSets
444
bc39810b3faa Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 435
diff changeset
284 immediately when no longer needed.
bc39810b3faa Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 435
diff changeset
285
bc39810b3faa Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 435
diff changeset
286 - By default the ResultSets created by stmt.executeQuery(...) or
bc39810b3faa Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 435
diff changeset
287 stmt.execute(...) are TYPE_FORWARD_ONLY, to reduce the potentially large
bc39810b3faa Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 435
diff changeset
288 amount of client memory needed to cache the whole ResultSet data.
bc39810b3faa Update ChangeLog release.txt for creating new MonetDB JDBC Driver release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 435
diff changeset
289
346
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
290 - When you need to execute many SQL queries sequentially reuse the Statement
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
291 object instead of creating a new Statement for each single SQL query.
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
292 Alternatively you can execute the SQL queries as one script (each SQL query
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
293 must be separated by a ; character) string via stmt.execute(script),
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
294 stmt.getResultSet() and stmt.getMoreResults().
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
295 Or you can use the batch execution functionality, see stmt.addBatch() and
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
296 stmt.executeBatch() methods.
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
297
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
298 - The fastest way to retrieve data from a MonetDB ResultSet is via the
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
299 getString(int columnIndex) method, because internally all data
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
300 values (of all types) are stored as Strings, so no conversions are needed.
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
301
381
11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 376
diff changeset
302 - Avoid using rs.getObject() as it will need to construct a new Object for
11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 376
diff changeset
303 each value, even for primitive types such as int, long, boolean.
11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 376
diff changeset
304
11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 376
diff changeset
305 - Avoid using rs.getClob(). Instead use getString() for all CLOB
11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 376
diff changeset
306 columns, which is much faster and uses much (3 times) less memory.
11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 376
diff changeset
307
11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 376
diff changeset
308 - Avoid using rs.getBlob(). Instead use getBytes() to get a byte array
11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 376
diff changeset
309 or use getString() to get a string containing hex pairs, for all BLOB
11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 376
diff changeset
310 columns. These methods are much faster and use much less memory.
11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 376
diff changeset
311 The getString() is the fastest way as no conversions are done at all.
11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 376
diff changeset
312 The getBytes() will need to convert the hex char string into a new bytes[].
11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 376
diff changeset
313
346
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
314 - Try to avoid calling "rs.get...(String columnLabel)" methods inside the
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
315 while(rs.next()) {...} loop. Instead resolve the columnLabels to column
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
316 numbers before the loop via method "int findColumn(String columnLabel)"
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
317 and use the int variables with the rs.get...(int columnIndex) methods.
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
318 This eliminates the call to findColumn(String columnLabel) for
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
319 each value of every column for every row in the ResultSet.
355
69803e5a5a49 Extend text in JDBC release.txt
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 354
diff changeset
320 See also the example Java JDBC program on:
364
37f54743b1fd Correcting invalid documentation URL refs.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 363
diff changeset
321 https://www.monetdb.org/Documentation/SQLreference/Programming/JDBC
346
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
322
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
323 **WARNING**:
662
ee1f3b3ff5fd Remove MCL_MAJOR and MCL_MINOR references now we no longer distribute monetdb-mcl-1.##.jre8.jar file.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 658
diff changeset
324 The current implementation of the MonetDB JDBC driver is *NOT*
346
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
325 multi-thread safe. If your program uses multiple threads concurrently on
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
326 the same Connection (so one MapiSocket), this may lead to incorrect behavior
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
327 and results (due to race conditions).
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
328 You will need to serialize the processing of the threads in your Java program.
381
11c30e3b7966 Set the connection properties treat_clob_as_varchar and treat_blob_as_binary to true by default for faster processing (less objects created, less memory needed) when querying CLOB or BLOB column data.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 376
diff changeset
329 Alternatively you can use a separate JDBC Connection for each thread.
346
5d108b9ffc64 Improved and extended the JDBC driver release information with notes and tips for programmers who want to use the MonetDB JDBC driver.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 340
diff changeset
330
877
f31366ece930 Convert release.txt to release.md and add TLS info
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 774
diff changeset
331 Note: as of version 3.0 (monetdb-jdbc-3.0.jre8.jar) we compile all
354
b1f8750e6cde Switch to Java 8 compilation and distribution as Java 7 is no longer supported.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 346
diff changeset
332 the java sources to target: Java SE 8 (profile compact2), so
b1f8750e6cde Switch to Java 8 compilation and distribution as Java 7 is no longer supported.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 346
diff changeset
333 you need a JRE/JDK JVM of version 8 or higher to use it.
662
ee1f3b3ff5fd Remove MCL_MAJOR and MCL_MINOR references now we no longer distribute monetdb-mcl-1.##.jre8.jar file.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 658
diff changeset
334