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

annotate src/main/java/org/monetdb/jdbc/MonetDriver.java @ 793:5bfe3357fb1c monetdbs

Use the new url parser

author	Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
date	Wed, 06 Dec 2023 16:17:13 +0100 (16 months ago)
parents	2f36ac68ac35
children	04a27386789f

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
793 5bfe3357fb1c Use the new url parser Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 788 diff changeset	11 import org.monetdb.mcl.net.MonetUrlParser;
5bfe3357fb1c Use the new url parser Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 788 diff changeset	12 import org.monetdb.mcl.net.Parameter;
5bfe3357fb1c Use the new url parser Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 788 diff changeset	13 import org.monetdb.mcl.net.Target;
5bfe3357fb1c Use the new url parser Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 788 diff changeset	14 import org.monetdb.mcl.net.ValidationError;
5bfe3357fb1c Use the new url parser Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 788 diff changeset	15
5bfe3357fb1c Use the new url parser Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 788 diff changeset	16 import java.net.URISyntaxException;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	17 import java.sql.Connection;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	18 import java.sql.Driver;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	19 import java.sql.DriverManager;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	20 import java.sql.DriverPropertyInfo;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	21 import java.sql.SQLException;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	22 import java.sql.SQLFeatureNotSupportedException;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	23 import java.sql.Types;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	24 import java.util.Map.Entry;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	25 import java.util.Properties;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	26
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	27 /**
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	28 *<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	29 * 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	30 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	31 * 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	32 * 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	33 * will supply a Connection suitable for MonetDB.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	34 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	35 * 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	36 * 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	37 * 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	38 *
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	39 * 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	40 * <code>jdbc:monetdb://<host>[:<port>]/<database></code>
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	41 * 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	42 * 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	43 *</pre>
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	44 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	45 * @author Fabian Groffen
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	46 */
768 a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.. classes and package. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 761 diff changeset	47 public final class MonetDriver implements Driver {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	48 // 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	49 // 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	50
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	51 // initialize this class: register it at the DriverManager
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	52 // 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	53 static {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	54 try {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	55 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	56 } catch (SQLException e) {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	57 e.printStackTrace();
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 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	60
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	61 //== methods of interface Driver
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 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	64 * 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	65 * 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	66 * 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	67 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	68 * @param url the URL of the database
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	69 * @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	70 */
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	71 @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	72 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	73 return url != null && url.startsWith("jdbc:monetdb://");
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	74 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	75
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	76 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	77 * 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	78 * 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	79 * 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	80 * 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	81 * loaded driver in turn.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	82 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	83 * 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	84 * 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	85 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	86 * 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	87 * 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	88 * "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	89 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	90 * @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	91 * @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	92 * 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	93 * should be included
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	94 * @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	95 * @throws SQLException if a database access error occurs
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	96 */
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	97 @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	98 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	99 throws SQLException
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	100 {
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	101 // 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	102 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	103 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	104
793 5bfe3357fb1c Use the new url parser Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 788 diff changeset	105 Target target = new Target();
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	106
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	107 try {
793 5bfe3357fb1c Use the new url parser Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 788 diff changeset	108 if (info != null) {
5bfe3357fb1c Use the new url parser Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 788 diff changeset	109 for (String key : info.stringPropertyNames()) {
5bfe3357fb1c Use the new url parser Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 788 diff changeset	110 String value = info.getProperty(key);
5bfe3357fb1c Use the new url parser Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 788 diff changeset	111 if (key.equals(Parameter.HOST.name))
5bfe3357fb1c Use the new url parser Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 788 diff changeset	112 value = Target.unpackHost(value);
5bfe3357fb1c Use the new url parser Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 788 diff changeset	113 target.setString(key, value);
5bfe3357fb1c Use the new url parser Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 788 diff changeset	114 }
5bfe3357fb1c Use the new url parser Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 788 diff changeset	115 }
5bfe3357fb1c Use the new url parser Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 788 diff changeset	116 MonetUrlParser.parse(target, url.substring(5));
5bfe3357fb1c Use the new url parser Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 788 diff changeset	117 } catch (ValidationError \| URISyntaxException e) {
5bfe3357fb1c Use the new url parser Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 788 diff changeset	118 throw new SQLException(e.getMessage());
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	119 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	120
793 5bfe3357fb1c Use the new url parser Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 788 diff changeset	121 // finally return the Connection object as requested
5bfe3357fb1c Use the new url parser Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 788 diff changeset	122 return new MonetConnection(target);
0 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
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	125 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	126 * 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	127 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	128 * @return this driver's major version number
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	129 */
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	130 @Override
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	131 public int getMajorVersion() {
786 f7df78989ac5 Generate MonetVersion.java rather than MonetDriver.java Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 785 diff changeset	132 // 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	133 return getDriverMajorVersion();
0 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
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	136 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	137 * 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	138 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	139 * @return this driver's minor version number
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	140 */
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	141 @Override
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	142 public int getMinorVersion() {
786 f7df78989ac5 Generate MonetVersion.java rather than MonetDriver.java Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 785 diff changeset	143 // 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	144 return getDriverMinorVersion();
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 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	148 * 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	149 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	150 * 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	151 * 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	152 * 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	153 * 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	154 * 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	155 * getPropertyInfo method.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	156 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	157 * @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	158 * @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	159 * connect open
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	160 * @return an array of DriverPropertyInfo objects describing possible
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	161 * 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	162 * are required.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	163 */
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	164 @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	165 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	166 if (!acceptsURL(url))
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	167 return null;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	168
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	169 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	170 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	171
224 ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	172 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	173 prop.required = true;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	174 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	175 dpi[0] = prop;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	176
224 ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	177 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	178 prop.required = true;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	179 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	180 dpi[1] = prop;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	181
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	182 prop = new DriverPropertyInfo("debug", "false");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	183 prop.required = false;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	184 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	185 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	186 dpi[2] = prop;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	187
224 ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	188 prop = new DriverPropertyInfo("logfile", null);
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	189 prop.required = false;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	190 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	191 dpi[3] = prop;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	192
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	193 prop = new DriverPropertyInfo("language", "sql");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	194 prop.required = false;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	195 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	196 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	197 dpi[4] = prop;
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 prop = new DriverPropertyInfo("hash", null);
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	200 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	201 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	202 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	203 dpi[5] = prop;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	204
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	205 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	206 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	207 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	208 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	209 dpi[6] = prop;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	210
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	211 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	212 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	213 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	214 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	215 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	216
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	217 prop = new DriverPropertyInfo("so_timeout", "0");
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	218 prop.required = false;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	219 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	220 dpi[8] = prop;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	221
658 108123ca6889 Add autocommit=true/false option to jdbc url Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> parents: 642 diff changeset	222 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	223 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	224 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	225 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	226 dpi[9] = prop;
ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	227
ea729e0cf24d Improve and extend MonetDriver.getPropertyInfo() with choice values Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 223 diff changeset	228 return dpi;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	229 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	230
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	231 /**
194 1296dbcc4958 Resolved javadoc many errors and warnings, such as: Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 180 diff changeset	232 * 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	233 * 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	234 * otherwise it is required to return false.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	235 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	236 * 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	237 * 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	238 * be available for all the major commercial databases.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	239 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	240 * 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	241 * 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	242 * 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	243 * 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	244 * 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	245 * be feasible.
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	246 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	247 * @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	248 */
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	249 @Override
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	250 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	251 // 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	252 return false;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	253 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	254
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	255 /**
d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	256 * 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	257 * 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	258 * 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	259 * 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	260 * 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	261 * 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	262 *
d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	263 * @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	264 * @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	265 * 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	266 * @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	267 */
d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	268 @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	269 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	270 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	271 }
d6abd1ffffbb Use SQLNonTransientConnectionException instead of SQLException where applicable (SQLState starts with 08) Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 90 diff changeset	272
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	273 //== end methods of interface driver
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	274
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	275
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	276 /**
709 bdeabbd46ec6 Resolve javac and javadoc warnings when compiled with JDK19. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 708 diff changeset	277 * 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	278 * 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	279 * @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	280 */
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	281 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	282 // 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	283 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	284 }
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	285
709 bdeabbd46ec6 Resolve javac and javadoc warnings when compiled with JDK19. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 708 diff changeset	286 /**
bdeabbd46ec6 Resolve javac and javadoc warnings when compiled with JDK19. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 708 diff changeset	287 * 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	288 * 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	289 * @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	290 */
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	291 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	292 // 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	293 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	294 }
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	295
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	296 /**
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	297 * 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	298 * 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	299 * @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	300 */
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	301 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	302 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	303 }
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	304
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	305 /** 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	306 /* 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	307 /* 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	308 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	309 static {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	310 // fill the typeMap once
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	311 // typeMap.put("any", Integer.valueOf(Types.???));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	312 typeMap.put("bigint", Integer.valueOf(Types.BIGINT));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	313 typeMap.put("blob", Integer.valueOf(Types.BLOB));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	314 typeMap.put("boolean", Integer.valueOf(Types.BOOLEAN));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	315 typeMap.put("char", Integer.valueOf(Types.CHAR));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	316 typeMap.put("clob", Integer.valueOf(Types.CLOB));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	317 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	318 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	319 typeMap.put("decimal", Integer.valueOf(Types.DECIMAL));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	320 typeMap.put("double", Integer.valueOf(Types.DOUBLE));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	321 // typeMap.put("geometry", Integer.valueOf(Types.???));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	322 // typeMap.put("geometrya", Integer.valueOf(Types.???));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	323 typeMap.put("hugeint", Integer.valueOf(Types.NUMERIC));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	324 typeMap.put("inet", Integer.valueOf(Types.VARCHAR));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	325 typeMap.put("int", Integer.valueOf(Types.INTEGER));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	326 typeMap.put("json", Integer.valueOf(Types.VARCHAR));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	327 // typeMap.put("mbr", Integer.valueOf(Types.???));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	328 typeMap.put("month_interval", Integer.valueOf(Types.INTEGER));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	329 typeMap.put("oid", Integer.valueOf(Types.BIGINT));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	330 // typeMap.put("ptr", Integer.valueOf(Types.???));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	331 typeMap.put("real", Integer.valueOf(Types.REAL));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	332 typeMap.put("sec_interval", Integer.valueOf(Types.DECIMAL));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	333 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	334 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	335 // typeMap.put("table", Integer.valueOf(Types.???));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	336 typeMap.put("time", Integer.valueOf(Types.TIME));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	337 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	338 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	339 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	340 typeMap.put("tinyint", Integer.valueOf(Types.TINYINT));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	341 typeMap.put("url", Integer.valueOf(Types.VARCHAR));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	342 typeMap.put("uuid", Integer.valueOf(Types.VARCHAR));
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	343 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	344 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	345 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	346 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	347
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	348 /**
223 e8139dbe3883 Rename internal method MonetDriver.getJavaType() into MonetDriver.getJdbcSQLType() Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 200 diff changeset	349 * 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	350 *
223 e8139dbe3883 Rename internal method MonetDriver.getJavaType() into MonetDriver.getJdbcSQLType() Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 200 diff changeset	351 * @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	352 * @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	353 * 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	354 */
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	355 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	356 // 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	357 final Integer tp = typeMap.get(type);
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	358 if (tp != null) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	359 return tp.intValue();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	360 }
223 e8139dbe3883 Rename internal method MonetDriver.getJavaType() into MonetDriver.getJdbcSQLType() Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 200 diff changeset	361 // 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	362 // 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	363 // 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	364 return Types.OTHER;
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	365 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	366
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	367 /**
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	368 * 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	369 *
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	370 * @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	371 * @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	372 */
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	373 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	374 /**
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	375 * 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	376 * 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	377 */
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	378 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	379 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	380 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	381 /* 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	382 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	383 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	384 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	385 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	386 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	387 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	388 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	389 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	390 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	391 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	392 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	393 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	394 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	395 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	396 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	397 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	398 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	399 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	400 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	401 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	402 /* 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	403 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	404 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	405 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	406 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	407 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	408 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	409 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	410 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	411 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	412 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	413 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	414 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	415 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	416
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 // 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	418 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	419 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	420 }
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 }
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
708 5022a57f9d97 Resolve javadoc errors. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 662 diff changeset	423 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	424 /**
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	425 * 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	426 * 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	427 * 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	428 * 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	429 *
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	430 * @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	431 * in the SQL CASE statement
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	432 * @return a SQL CASE statement
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	433 */
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	434 static final String getSQLTypeMap(final String column) {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	435 if (TypeMapppingSQL == null) {
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	436 // 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	437 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	438 for (Entry<String, Integer> entry : typeMap.entrySet()) {
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	439 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	440 }
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	441 val.append(" ELSE " + Types.OTHER + " END");
0 a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	442 // 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	443 TypeMapppingSQL = val.toString();
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	444 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	445 return "CASE " + column + TypeMapppingSQL;
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	446 }
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31. Sjoerd Mullender <sjoerd@acm.org> parents: diff changeset	447 }

Mercurial > hg > monetdb-java

annotate src/main/java/org/monetdb/jdbc/MonetDriver.java @ 793:5bfe3357fb1c monetdbs