monetdb-java: src/main/java/org/monetdb/jdbc/MonetDriver.java annotate

annotate src/main/java/org/monetdb/jdbc/MonetDriver.java @ 788:2f36ac68ac35 monetdbs

Get rid of MONETURL constant it has two uses which are going to be changed in different ways

author	Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
date	Fri, 17 Nov 2023 14:45:40 +0100 (17 months ago)
parents	f7df78989ac5
children	5bfe3357fb1c

rev	line source
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	1 /*
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	2 * This Source Code Form is subject to the terms of the Mozilla Public
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	3 * License, v. 2.0. If a copy of the MPL was not distributed with this
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	4 * file, You can obtain one at http://mozilla.org/MPL/2.0/.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	5 *
716 aeb268156580 Updated Copyright year. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	6 * Copyright 1997 - July 2008 CWI, August 2008 - 2023 MonetDB B.V.
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	7 */
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	8
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	9 package org.monetdb.jdbc;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	10
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	11 import java.net.URI;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	12 import java.sql.Connection;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	13 import java.sql.Driver;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	14 import java.sql.DriverManager;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	15 import java.sql.DriverPropertyInfo;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	16 import java.sql.SQLException;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	17 import java.sql.SQLFeatureNotSupportedException;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	18 import java.sql.Types;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	19 import java.util.Map.Entry;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	20 import java.util.Properties;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	21
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	22 /**
451 3dfcd06fd8ba Correcting typos in documentation text. Also improved the readability of the generated javadoc documents. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 415 diff changeset	23 *<pre>
3dfcd06fd8ba Correcting typos in documentation text. Also improved the readability of the generated javadoc documents. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 415 diff changeset	24 * A JDBC {@link Driver} suitable for the MonetDB RDBMS.
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	25 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	26 * This driver will be used by the DriverManager to determine if an URL
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	27 * is to be handled by this driver, and if it does, then this driver
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	28 * will supply a Connection suitable for MonetDB.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	29 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	30 * This class has no explicit constructor, the default constructor
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	31 * generated by the Java compiler will be sufficient since nothing has
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	32 * to be set in order to use this driver.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	33 *
333 55330e40cbf1 Eliminate the need for private static final variables which are filled by preproccesor. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 295 diff changeset	34 * This Driver supports MonetDB database URLs. MonetDB URLs are defined as:
626 06d69b82d409 Resolve javadoc error and warnings : Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 610 diff changeset	35 * <code>jdbc:monetdb://<host>[:<port>]/<database></code>
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	36 * where [:<port>] denotes that a port is optional. If not
785 e00866975421 Get rid of JDBC_DEF_PORT Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 784 diff changeset	37 * given, port 50000 will be used.
451 3dfcd06fd8ba Correcting typos in documentation text. Also improved the readability of the generated javadoc documents. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 415 diff changeset	38 *</pre>
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	39 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	40 * @author Fabian Groffen
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	41 */
768 a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.. classes and package. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 761 diff changeset	42 public final class MonetDriver implements Driver {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	43 // the url kind will be jdbc:monetdb://<host>[:<port>]/<database>
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	44 // Chapter 9.2.1 from Sun JDBC 3.0 specification
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	45
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	46 // initialize this class: register it at the DriverManager
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	47 // Chapter 9.2 from Sun JDBC 3.0 specification
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	48 static {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	49 try {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	50 DriverManager.registerDriver(new MonetDriver());
8 a27ee2cb14a0 Replace String methods equals("") and "".equals( with isEmpty() Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	51 } catch (SQLException e) {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	52 e.printStackTrace();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	53 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	54 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	55
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	56 //== methods of interface Driver
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	57
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	58 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	59 * Retrieves whether the driver thinks that it can open a connection to the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	60 * given URL. Typically drivers will return true if they understand the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	61 * subprotocol specified in the URL and false if they do not.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	62 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	63 * @param url the URL of the database
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	64 * @return true if this driver understands the given URL; false otherwise
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	65 */
144 d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	66 @Override
295 003ae6d881db Add "final" keyword to method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 262 diff changeset	67 public boolean acceptsURL(final String url) {
788 2f36ac68ac35 Get rid of MONETURL constant Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 786 diff changeset	68 return url != null && url.startsWith("jdbc:monetdb://");
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	69 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	70
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	71 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	72 * Attempts to make a database connection to the given URL. The driver
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	73 * should return "null" if it realizes it is the wrong kind of driver to
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	74 * connect to the given URL. This will be common, as when the JDBC driver
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	75 * manager is asked to connect to a given URL it passes the URL to each
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	76 * loaded driver in turn.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	77 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	78 * The driver should throw an SQLException if it is the right driver to
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	79 * connect to the given URL but has trouble connecting to the database.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	80 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	81 * The java.util.Properties argument can be used to pass arbitrary string
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	82 * tag/value pairs as connection arguments. Normally at least "user" and
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	83 * "password" properties should be included in the Properties object.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	84 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	85 * @param url the URL of the database to which to connect
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	86 * @param info a list of arbitrary string tag/value pairs as connection
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	87 * arguments. Normally at least a "user" and "password" property
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	88 * should be included
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	89 * @return a Connection object that represents a connection to the URL
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	90 * @throws SQLException if a database access error occurs
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	91 */
144 d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	92 @Override
295 003ae6d881db Add "final" keyword to method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 262 diff changeset	93 public Connection connect(final String url, Properties info)
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	94 throws SQLException
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	95 {
199 e87d89d371f1 Make some public non-JDBC methods accessable only to classes of the same package. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 194 diff changeset	96 // url should be of style jdbc:monetdb://<host>/<database>
e87d89d371f1 Make some public non-JDBC methods accessable only to classes of the same package. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 194 diff changeset	97 if (!acceptsURL(url))
254 27b7166860c8 According to the JDBC specification if the JDBC URL is invalid, return null instead of an exception, so the DriverManager can keep looking for a suitable JDBC driver. Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 224 diff changeset	98 return null;
199 e87d89d371f1 Make some public non-JDBC methods accessable only to classes of the same package. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 194 diff changeset	99
295 003ae6d881db Add "final" keyword to method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 262 diff changeset	100 final Properties props = new Properties();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	101 // set the optional properties and their defaults here
785 e00866975421 Get rid of JDBC_DEF_PORT Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 784 diff changeset	102 props.put("port", "50000");
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	103 props.put("debug", "false");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	104 props.put("language", "sql"); // mal, sql, <future>
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	105 props.put("so_timeout", "0");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	106
199 e87d89d371f1 Make some public non-JDBC methods accessable only to classes of the same package. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 194 diff changeset	107 if (info != null)
e87d89d371f1 Make some public non-JDBC methods accessable only to classes of the same package. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 194 diff changeset	108 props.putAll(info);
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	109 info = props;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	110
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	111 // remove leading "jdbc:" so the rest is a valid hierarchical URI
295 003ae6d881db Add "final" keyword to method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 262 diff changeset	112 final URI uri;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	113 try {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	114 uri = new URI(url.substring(5));
295 003ae6d881db Add "final" keyword to method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 262 diff changeset	115 } catch (java.net.URISyntaxException e) {
254 27b7166860c8 According to the JDBC specification if the JDBC URL is invalid, return null instead of an exception, so the DriverManager can keep looking for a suitable JDBC driver. Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 224 diff changeset	116 return null;
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
295 003ae6d881db Add "final" keyword to method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 262 diff changeset	119 final String uri_host = uri.getHost();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	120 if (uri_host == null)
254 27b7166860c8 According to the JDBC specification if the JDBC URL is invalid, return null instead of an exception, so the DriverManager can keep looking for a suitable JDBC driver. Pedro Ferreira <pedro.ferreira@monetdbsolutions.com> parents: 224 diff changeset	121 return null;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	122 info.put("host", uri_host);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	123
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	124 int uri_port = uri.getPort();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	125 if (uri_port > 0)
180 fdf4c888d5b7 Small code and layout improvements Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 175 diff changeset	126 info.put("port", Integer.toString(uri_port));
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 // check the database
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	129 String uri_path = uri.getPath();
199 e87d89d371f1 Make some public non-JDBC methods accessable only to classes of the same package. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 194 diff changeset	130 if (uri_path != null && !uri_path.isEmpty()) {
e87d89d371f1 Make some public non-JDBC methods accessable only to classes of the same package. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 194 diff changeset	131 uri_path = uri_path.substring(1).trim();
e87d89d371f1 Make some public non-JDBC methods accessable only to classes of the same package. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 194 diff changeset	132 if (!uri_path.isEmpty())
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	133 info.put("database", uri_path);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	134 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	135
295 003ae6d881db Add "final" keyword to method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 262 diff changeset	136 final String uri_query = uri.getQuery();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	137 if (uri_query != null) {
199 e87d89d371f1 Make some public non-JDBC methods accessable only to classes of the same package. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 194 diff changeset	138 int pos;
e87d89d371f1 Make some public non-JDBC methods accessable only to classes of the same package. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 194 diff changeset	139 // handle additional connection properties separated by the & character
295 003ae6d881db Add "final" keyword to method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 262 diff changeset	140 final String args[] = uri_query.split("&");
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	141 for (int i = 0; i < args.length; i++) {
199 e87d89d371f1 Make some public non-JDBC methods accessable only to classes of the same package. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 194 diff changeset	142 pos = args[i].indexOf('=');
e87d89d371f1 Make some public non-JDBC methods accessable only to classes of the same package. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 194 diff changeset	143 if (pos > 0)
e87d89d371f1 Make some public non-JDBC methods accessable only to classes of the same package. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 194 diff changeset	144 info.put(args[i].substring(0, pos), args[i].substring(pos + 1));
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	145 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	146 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	147
199 e87d89d371f1 Make some public non-JDBC methods accessable only to classes of the same package. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 194 diff changeset	148 // finally return the Connection object as requested
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	149 return new MonetConnection(info);
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	150 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	151
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	152 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	153 * Retrieves the driver's major version number. Initially this should be 1.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	154 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	155 * @return this driver's major version number
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	156 */
144 d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	157 @Override
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	158 public int getMajorVersion() {
786 f7df78989ac5 Generate MonetVersion.java rather than MonetDriver.java Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 785 diff changeset	159 // defer to the static version of this method
f7df78989ac5 Generate MonetVersion.java rather than MonetDriver.java Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 785 diff changeset	160 return getDriverMajorVersion();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	161 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	162
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	163 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	164 * Gets the driver's minor version number. Initially this should be 0.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	165 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	166 * @return this driver's minor version number
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	167 */
144 d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	168 @Override
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	169 public int getMinorVersion() {
786 f7df78989ac5 Generate MonetVersion.java rather than MonetDriver.java Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 785 diff changeset	170 // defer to the static version of this method
f7df78989ac5 Generate MonetVersion.java rather than MonetDriver.java Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 785 diff changeset	171 return getDriverMinorVersion();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	172 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	173
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	174 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	175 * Gets information about the possible properties for this driver.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	176 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	177 * The getPropertyInfo method is intended to allow a generic GUI tool to
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	178 * discover what properties it should prompt a human for in order to get
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	179 * enough information to connect to a database. Note that depending on the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	180 * values the human has supplied so far, additional values may become
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	181 * necessary, so it may be necessary to iterate though several calls to the
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	182 * getPropertyInfo method.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	183 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	184 * @param url the URL of the database to which to connect
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	185 * @param info a proposed list of tag/value pairs that will be sent on
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	186 * connect open
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	187 * @return an array of DriverPropertyInfo objects describing possible
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	188 * properties. This array may be an empty array if no properties
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	189 * are required.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	190 */
144 d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	191 @Override
295 003ae6d881db Add "final" keyword to method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 262 diff changeset	192 public DriverPropertyInfo[] getPropertyInfo(final String url, final Properties info) {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	193 if (!acceptsURL(url))
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	194 return null;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	195
295 003ae6d881db Add "final" keyword to method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 262 diff changeset	196 final String[] boolean_choices = new String[] { "true", "false" };
658 108123ca6889 Add autocommit=true/false option to jdbc url Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 642 diff changeset	197 final DriverPropertyInfo[] dpi = new DriverPropertyInfo[10]; // we currently support 10 connection properties
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	198
224 ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	199 DriverPropertyInfo prop = new DriverPropertyInfo("user", info != null ? info.getProperty("user") : null);
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	200 prop.required = true;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	201 prop.description = "The user loginname to use when authenticating on the database server";
224 ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	202 dpi[0] = prop;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	203
224 ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	204 prop = new DriverPropertyInfo("password", info != null ? info.getProperty("password") : null);
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	205 prop.required = true;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	206 prop.description = "The password to use when authenticating on the database server";
224 ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	207 dpi[1] = prop;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	208
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	209 prop = new DriverPropertyInfo("debug", "false");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	210 prop.required = false;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	211 prop.description = "Whether or not to create a log file for debugging purposes";
224 ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	212 prop.choices = boolean_choices;
ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	213 dpi[2] = prop;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	214
224 ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	215 prop = new DriverPropertyInfo("logfile", null);
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	216 prop.required = false;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	217 prop.description = "The filename to write the debug log to. Only takes effect if debug is set to true. If the file exists, an incrementing number is added, till the filename is unique.";
224 ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	218 dpi[3] = prop;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	219
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	220 prop = new DriverPropertyInfo("language", "sql");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	221 prop.required = false;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	222 prop.description = "What language to use for MonetDB conversations (experts only)";
333 55330e40cbf1 Eliminate the need for private static final variables which are filled by preproccesor. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 295 diff changeset	223 prop.choices = new String[] { "sql", "mal" };
224 ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	224 dpi[4] = prop;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	225
224 ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	226 prop = new DriverPropertyInfo("hash", null);
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	227 prop.required = false;
363 34ce6e1b1be8 Remove support for deprecated MD5 encryption algorithm in MapiSocket. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 350 diff changeset	228 prop.description = "Force the use of the given hash algorithm (SHA512 or SHA384 or SHA256 or SHA1) during challenge response";
34ce6e1b1be8 Remove support for deprecated MD5 encryption algorithm in MapiSocket. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 350 diff changeset	229 prop.choices = new String[] { "SHA512", "SHA384", "SHA256", "SHA1" };
224 ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	230 dpi[5] = prop;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	231
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: 380 diff changeset	232 prop = new DriverPropertyInfo("treat_blob_as_binary", "true");
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	233 prop.required = false;
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: 380 diff changeset	234 prop.description = "Should blob columns be mapped to Types.VARBINARY instead of Types.BLOB in ResultSets and PreparedStatements"; // recommend for increased performance due to less overhead
224 ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	235 prop.choices = boolean_choices;
ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	236 dpi[6] = prop;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	237
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: 380 diff changeset	238 prop = new DriverPropertyInfo("treat_clob_as_varchar", "true");
175 8700d9ef2ace Added possibility via a connection property to let the JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 144 diff changeset	239 prop.required = false;
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: 380 diff changeset	240 prop.description = "Should clob columns be mapped to Types.VARCHAR instead of Types.CLOB in ResultSets and PreparedStatements"; // recommend for increased performance due to less overhead
224 ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	241 prop.choices = boolean_choices;
ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	242 dpi[7] = prop;
175 8700d9ef2ace Added possibility via a connection property to let the JDBC driver Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 144 diff changeset	243
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	244 prop = new DriverPropertyInfo("so_timeout", "0");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	245 prop.required = false;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	246 prop.description = "Defines the maximum time to wait in milliseconds on a blocking read socket call"; // this corresponds to the Connection.setNetworkTimeout() method introduced in JDBC 4.1
224 ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	247 dpi[8] = prop;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	248
658 108123ca6889 Add autocommit=true/false option to jdbc url Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 642 diff changeset	249 prop = new DriverPropertyInfo("autocommit", "true");
224 ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	250 prop.required = false;
658 108123ca6889 Add autocommit=true/false option to jdbc url Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 642 diff changeset	251 prop.description = "Whether the connection should start in auto-commit mode";
224 ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	252 prop.choices = boolean_choices;
ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	253 dpi[9] = prop;
ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	254
ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	255 return dpi;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	256 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	257
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	258 /**
194 1296dbcc4958 Resolved javadoc many errors and warnings, such as: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 180 diff changeset	259 * Reports whether this driver is a genuine JDBC Compliant™ driver. A
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	260 * driver may only report true here if it passes the JDBC compliance tests;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	261 * otherwise it is required to return false.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	262 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	263 * JDBC compliance requires full support for the JDBC API and full support
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	264 * for SQL 92 Entry Level. It is expected that JDBC compliant drivers will
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	265 * be available for all the major commercial databases.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	266 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	267 * This method is not intended to encourage the development of non-JDBC
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	268 * compliant drivers, but is a recognition of the fact that some vendors are
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	269 * interested in using the JDBC API and framework for lightweight databases
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	270 * that do not support full database functionality, or for special databases
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	271 * such as document information retrieval where a SQL implementation may not
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	272 * be feasible.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	273 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	274 * @return true if this driver is JDBC Compliant; false otherwise
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	275 */
144 d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	276 @Override
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	277 public boolean jdbcCompliant() {
295 003ae6d881db Add "final" keyword to method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 262 diff changeset	278 // We're not fully JDBC compliant, but what we support is compliant
003ae6d881db Add "final" keyword to method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 262 diff changeset	279 return false;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	280 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	281
144 d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	282 /**
d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	283 * Return the parent Logger of all the Loggers used by this data source.
d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	284 * This should be the Logger farthest from the root Logger that is
d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	285 * still an ancestor of all of the Loggers used by this data source.
d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	286 * Configuring this Logger will affect all of the log messages
d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	287 * generated by the data source.
d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	288 * In the worst case, this may be the root Logger.
d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	289 *
d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	290 * @return the parent Logger for this data source
d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	291 * @throws SQLFeatureNotSupportedException if the data source does
d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	292 * not use java.util.logging
d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	293 * @since 1.7
d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	294 */
d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	295 @Override
295 003ae6d881db Add "final" keyword to method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 262 diff changeset	296 public java.util.logging.Logger getParentLogger() throws SQLFeatureNotSupportedException {
262 2d62ca1f758b Moved utility method newSQLFeatureNotSupportedException(String name) from MonetPreparedStatement.java and MonetResultSet.java Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 261 diff changeset	297 throw MonetWrapper.newSQLFeatureNotSupportedException("getParentLogger");
144 d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	298 }
d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	299
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	300 //== end methods of interface driver
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	301
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	302
333 55330e40cbf1 Eliminate the need for private static final variables which are filled by preproccesor. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 295 diff changeset	303 /**
709 bdeabbd46ec6 Resolve javac and javadoc warnings when compiled with JDK19. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 708 diff changeset	304 * Get MonetDB JDBC Driver major version number
bdeabbd46ec6 Resolve javac and javadoc warnings when compiled with JDK19. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 708 diff changeset	305 * method called by MonetDatabaseMetaData methods
bdeabbd46ec6 Resolve javac and javadoc warnings when compiled with JDK19. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 708 diff changeset	306 * @return MonetDB JDBC Driver major version number
333 55330e40cbf1 Eliminate the need for private static final variables which are filled by preproccesor. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 295 diff changeset	307 */
55330e40cbf1 Eliminate the need for private static final variables which are filled by preproccesor. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 295 diff changeset	308 static final int getDriverMajorVersion() {
786 f7df78989ac5 Generate MonetVersion.java rather than MonetDriver.java Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 785 diff changeset	309 // defer to the generated MonetVersion class
f7df78989ac5 Generate MonetVersion.java rather than MonetDriver.java Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 785 diff changeset	310 return MonetVersion.majorVersion;
333 55330e40cbf1 Eliminate the need for private static final variables which are filled by preproccesor. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 295 diff changeset	311 }
55330e40cbf1 Eliminate the need for private static final variables which are filled by preproccesor. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 295 diff changeset	312
709 bdeabbd46ec6 Resolve javac and javadoc warnings when compiled with JDK19. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 708 diff changeset	313 /**
bdeabbd46ec6 Resolve javac and javadoc warnings when compiled with JDK19. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 708 diff changeset	314 * Get MonetDB JDBC Driver minor version number
bdeabbd46ec6 Resolve javac and javadoc warnings when compiled with JDK19. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 708 diff changeset	315 * method called by MonetDatabaseMetaData methods
bdeabbd46ec6 Resolve javac and javadoc warnings when compiled with JDK19. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 708 diff changeset	316 * @return MonetDB JDBC Driver minor version number
bdeabbd46ec6 Resolve javac and javadoc warnings when compiled with JDK19. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 708 diff changeset	317 */
333 55330e40cbf1 Eliminate the need for private static final variables which are filled by preproccesor. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 295 diff changeset	318 static final int getDriverMinorVersion() {
786 f7df78989ac5 Generate MonetVersion.java rather than MonetDriver.java Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 785 diff changeset	319 // defer to the generated MonetVersion class
f7df78989ac5 Generate MonetVersion.java rather than MonetDriver.java Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 785 diff changeset	320 return MonetVersion.minorVersion;
333 55330e40cbf1 Eliminate the need for private static final variables which are filled by preproccesor. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 295 diff changeset	321 }
55330e40cbf1 Eliminate the need for private static final variables which are filled by preproccesor. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 295 diff changeset	322
55330e40cbf1 Eliminate the need for private static final variables which are filled by preproccesor. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 295 diff changeset	323 /**
55330e40cbf1 Eliminate the need for private static final variables which are filled by preproccesor. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 295 diff changeset	324 * Returns a touched up identifying version string of this driver.
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	325 * It is made public as it is called from org/monetdb/client/JdbcClient.java
333 55330e40cbf1 Eliminate the need for private static final variables which are filled by preproccesor. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 295 diff changeset	326 * @return the version string
55330e40cbf1 Eliminate the need for private static final variables which are filled by preproccesor. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 295 diff changeset	327 */
55330e40cbf1 Eliminate the need for private static final variables which are filled by preproccesor. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 295 diff changeset	328 public static final String getDriverVersion() {
786 f7df78989ac5 Generate MonetVersion.java rather than MonetDriver.java Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 785 diff changeset	329 return MonetVersion.driverVersion;
333 55330e40cbf1 Eliminate the need for private static final variables which are filled by preproccesor. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 295 diff changeset	330 }
55330e40cbf1 Eliminate the need for private static final variables which are filled by preproccesor. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 295 diff changeset	331
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	332 /** A static Map containing the mapping between MonetDB types and Java SQL types */
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	333 /* use SELECT sqlname, * FROM sys.types order by 1, id; to view all MonetDB types */
380 bf521f343172 Added support for new Java 8 java.sql.Types: Types.TIME_WITH_TIMEZONE and Types.TIMESTAMP_WITH_TIMEZONE. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 379 diff changeset	334 /* see http://docs.oracle.com/javase/8/docs/api/java/sql/Types.html to view all supported java SQL types */
295 003ae6d881db Add "final" keyword to method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 262 diff changeset	335 private static final java.util.Map<String, Integer> typeMap = new java.util.HashMap<String, Integer>();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	336 static {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	337 // fill the typeMap once
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	338 // typeMap.put("any", Integer.valueOf(Types.???));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	339 typeMap.put("bigint", Integer.valueOf(Types.BIGINT));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	340 typeMap.put("blob", Integer.valueOf(Types.BLOB));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	341 typeMap.put("boolean", Integer.valueOf(Types.BOOLEAN));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	342 typeMap.put("char", Integer.valueOf(Types.CHAR));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	343 typeMap.put("clob", Integer.valueOf(Types.CLOB));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	344 typeMap.put("date", Integer.valueOf(Types.DATE));
415 50e43af49d47 Improved DatabaseMetaData.getTypeInfo() output for temporal data types: sec_interval, day_interval, month_interval, date, time, timetz, timestamp and timestamptz. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 414 diff changeset	345 typeMap.put("day_interval", Integer.valueOf(Types.NUMERIC)); // New as of Oct2020 release
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	346 typeMap.put("decimal", Integer.valueOf(Types.DECIMAL));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	347 typeMap.put("double", Integer.valueOf(Types.DOUBLE));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	348 // typeMap.put("geometry", Integer.valueOf(Types.???));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	349 // typeMap.put("geometrya", Integer.valueOf(Types.???));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	350 typeMap.put("hugeint", Integer.valueOf(Types.NUMERIC));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	351 typeMap.put("inet", Integer.valueOf(Types.VARCHAR));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	352 typeMap.put("int", Integer.valueOf(Types.INTEGER));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	353 typeMap.put("json", Integer.valueOf(Types.VARCHAR));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	354 // typeMap.put("mbr", Integer.valueOf(Types.???));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	355 typeMap.put("month_interval", Integer.valueOf(Types.INTEGER));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	356 typeMap.put("oid", Integer.valueOf(Types.BIGINT));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	357 // typeMap.put("ptr", Integer.valueOf(Types.???));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	358 typeMap.put("real", Integer.valueOf(Types.REAL));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	359 typeMap.put("sec_interval", Integer.valueOf(Types.DECIMAL));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	360 typeMap.put("smallint", Integer.valueOf(Types.SMALLINT));
642 dd9b4fb14256 Added recognition of 'xml' type. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 626 diff changeset	361 typeMap.put("str", Integer.valueOf(Types.VARCHAR)); // MonetDB prepare <stmt> uses type 'str' (instead of varchar) for the schema, table and column metadata output. DO NOT REMOVE this entry!
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	362 // typeMap.put("table", Integer.valueOf(Types.???));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	363 typeMap.put("time", Integer.valueOf(Types.TIME));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	364 typeMap.put("timestamp", Integer.valueOf(Types.TIMESTAMP));
380 bf521f343172 Added support for new Java 8 java.sql.Types: Types.TIME_WITH_TIMEZONE and Types.TIMESTAMP_WITH_TIMEZONE. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 379 diff changeset	365 typeMap.put("timestamptz", Integer.valueOf(Types.TIMESTAMP_WITH_TIMEZONE)); // new in Java 8: Types.TIMESTAMP_WITH_TIMEZONE (value 2014)
bf521f343172 Added support for new Java 8 java.sql.Types: Types.TIME_WITH_TIMEZONE and Types.TIMESTAMP_WITH_TIMEZONE. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 379 diff changeset	366 typeMap.put("timetz", Integer.valueOf(Types.TIME_WITH_TIMEZONE)); // new in Java 8: Types.TIME_WITH_TIMEZONE (value 2013)
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	367 typeMap.put("tinyint", Integer.valueOf(Types.TINYINT));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	368 typeMap.put("url", Integer.valueOf(Types.VARCHAR));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	369 typeMap.put("uuid", Integer.valueOf(Types.VARCHAR));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	370 typeMap.put("varchar", Integer.valueOf(Types.VARCHAR));
642 dd9b4fb14256 Added recognition of 'xml' type. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 626 diff changeset	371 typeMap.put("wrd", Integer.valueOf(Types.BIGINT)); // keep it in for old (pre Dec2016) MonetDB servers
dd9b4fb14256 Added recognition of 'xml' type. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 626 diff changeset	372 typeMap.put("xml", Integer.valueOf(Types.VARCHAR)); // used when "CREATE TYPE xml EXTERNAL NAME xml;" is executed
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	373 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	374
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	375 /**
223 e8139dbe3883 Rename internal method MonetDriver.getJavaType() into MonetDriver.getJdbcSQLType() Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 200 diff changeset	376 * Returns the java.sql.Types equivalent of the given MonetDB type name.
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	377 *
223 e8139dbe3883 Rename internal method MonetDriver.getJavaType() into MonetDriver.getJdbcSQLType() Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 200 diff changeset	378 * @param type the SQL data type name as used by MonetDB
e8139dbe3883 Rename internal method MonetDriver.getJavaType() into MonetDriver.getJdbcSQLType() Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 200 diff changeset	379 * @return the matching java.sql.Types constant or
e8139dbe3883 Rename internal method MonetDriver.getJavaType() into MonetDriver.getJdbcSQLType() Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 200 diff changeset	380 * java.sql.Types.OTHER if nothing matched the given type name
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	381 */
295 003ae6d881db Add "final" keyword to method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 262 diff changeset	382 static final int getJdbcSQLType(final String type) {
223 e8139dbe3883 Rename internal method MonetDriver.getJavaType() into MonetDriver.getJdbcSQLType() Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 200 diff changeset	383 // find the column type name in the typeMap
295 003ae6d881db Add "final" keyword to method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 262 diff changeset	384 final Integer tp = typeMap.get(type);
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	385 if (tp != null) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	386 return tp.intValue();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	387 }
223 e8139dbe3883 Rename internal method MonetDriver.getJavaType() into MonetDriver.getJdbcSQLType() Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 200 diff changeset	388 // When type name is not found in the map, for instance
e8139dbe3883 Rename internal method MonetDriver.getJavaType() into MonetDriver.getJdbcSQLType() Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 200 diff changeset	389 // when it is a new type (not yet added in the above typeMap) or
e8139dbe3883 Rename internal method MonetDriver.getJavaType() into MonetDriver.getJdbcSQLType() Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 200 diff changeset	390 // when type name is: any or geometry or geometrya or mbr or ptr or table.
e8139dbe3883 Rename internal method MonetDriver.getJavaType() into MonetDriver.getJdbcSQLType() Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 200 diff changeset	391 return Types.OTHER;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	392 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	393
714 ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	394 /**
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	395 * Returns the Class object for a given java.sql.Types value.
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	396 *
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	397 * @param type a value from java.sql.Types
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	398 * @return a Class object from which an instance would be returned
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	399 */
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	400 static final Class<?> getClassForType(final int type) {
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	401 /**
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	402 * This switch returns the types as objects according to table B-3 from
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	403 * Oracle's JDBC specification 4.1
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	404 */
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	405 switch(type) {
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	406 case Types.CHAR:
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	407 case Types.VARCHAR:
735 3dd0d43014e8 Disable checks for Types.LONGVARCHAR and Types.LONGVARBINARY as MonetDB server does not support these data types, and no mappings exists to these JDBC Types and thus these cases will never be reached in JDBC Driver. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 716 diff changeset	408 /* case Types.LONGVARCHAR: // MonetDB doesn't use type LONGVARCHAR */
714 ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	409 return String.class;
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	410 case Types.NUMERIC:
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	411 case Types.DECIMAL:
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	412 return java.math.BigDecimal.class;
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	413 case Types.BOOLEAN:
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	414 return Boolean.class;
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	415 case Types.TINYINT:
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	416 case Types.SMALLINT:
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	417 return Short.class;
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	418 case Types.INTEGER:
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	419 return Integer.class;
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	420 case Types.BIGINT:
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	421 return Long.class;
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	422 case Types.REAL:
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	423 return Float.class;
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	424 case Types.FLOAT:
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	425 case Types.DOUBLE:
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	426 return Double.class;
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	427 case Types.BINARY: // MonetDB currently does not support these
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	428 case Types.VARBINARY: // see treat_blob_as_binary property
735 3dd0d43014e8 Disable checks for Types.LONGVARCHAR and Types.LONGVARBINARY as MonetDB server does not support these data types, and no mappings exists to these JDBC Types and thus these cases will never be reached in JDBC Driver. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 716 diff changeset	429 /* case Types.LONGVARBINARY: // MonetDB doesn't use type LONGVARBINARY */
714 ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	430 return byte[].class;
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	431 case Types.DATE:
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	432 return java.sql.Date.class;
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	433 case Types.TIME:
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	434 case Types.TIME_WITH_TIMEZONE:
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	435 return java.sql.Time.class;
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	436 case Types.TIMESTAMP:
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	437 case Types.TIMESTAMP_WITH_TIMEZONE:
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	438 return java.sql.Timestamp.class;
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	439 case Types.CLOB:
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	440 return java.sql.Clob.class;
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	441 case Types.BLOB:
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	442 return java.sql.Blob.class;
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	443
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	444 // all the rest are currently not implemented and used
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	445 default:
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	446 return String.class;
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	447 }
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	448 }
ad7b08ef7745 Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 709 diff changeset	449
708 5022a57f9d97 Resolve javadoc errors. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 662 diff changeset	450 private static String TypeMapppingSQL; // cache to optimise getSQLTypeMap()
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	451 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	452 * Returns a String usable in an SQL statement to map the server types
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	453 * to values of java.sql.Types using the global static type map.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	454 * The returned string will be a SQL CASE x statement where the x is
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	455 * replaced with the given column name (or expression) string.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	456 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	457 * @param column a String representing the value that should be evaluated
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	458 * in the SQL CASE statement
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	459 * @return a SQL CASE statement
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	460 */
295 003ae6d881db Add "final" keyword to method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 262 diff changeset	461 static final String getSQLTypeMap(final String column) {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	462 if (TypeMapppingSQL == null) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	463 // first time, compose TypeMappping SQL string
295 003ae6d881db Add "final" keyword to method arguments and local variables where possible. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 262 diff changeset	464 final StringBuilder val = new StringBuilder((typeMap.size() * (7 + 7 + 7 + 4)) + 14);
8 a27ee2cb14a0 Replace String methods equals("") and "".equals( with isEmpty() Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	465 for (Entry<String, Integer> entry : typeMap.entrySet()) {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	466 val.append(" WHEN '").append(entry.getKey()).append("' THEN ").append(entry.getValue().toString());
8 a27ee2cb14a0 Replace String methods equals("") and "".equals( with isEmpty() Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 0 diff changeset	467 }
761 e1389c0ffb7c A few more places where we can remove append() calls for static int values in construction of Strings. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 735 diff changeset	468 val.append(" ELSE " + Types.OTHER + " END");
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	469 // as the typeMap is static, cache this SQL part for all next calls
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	470 TypeMapppingSQL = val.toString();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	471 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	472 return "CASE " + column + TypeMapppingSQL;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	473 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	474 }

Mercurial > hg > monetdb-java

annotate src/main/java/org/monetdb/jdbc/MonetDriver.java @ 788:2f36ac68ac35 monetdbs