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

annotate src/main/java/org/monetdb/jdbc/MonetResultSetMetaData.java @ 714:ad7b08ef7745

Moving static method getClassForType() from MonetResulSet to MonetDriver class which is a much more logical place.

author	Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date	Thu, 05 Jan 2023 00:01:06 +0100 (2023-01-04)
parents	c3c424a90a42
children	7240d2dd369f

rev	line source
713 c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	1 /*
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	2 * This Source Code Form is subject to the terms of the Mozilla Public
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	3 * License, v. 2.0. If a copy of the MPL was not distributed with this
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	4 * file, You can obtain one at http://mozilla.org/MPL/2.0/.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	5 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	6 * Copyright 1997 - July 2008 CWI, August 2008 - 2023 MonetDB B.V.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	7 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	8
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	9 package org.monetdb.jdbc;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	10
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: 713 diff changeset	11 import java.sql.ResultSetMetaData;
713 c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	12 import java.sql.SQLException;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	13 import java.sql.Types;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	14
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	15 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	16 *<pre>
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	17 * A {@link ResultSetMetaData} suitable for the MonetDB database.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	18 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	19 * An object that can be used to get information about the types and
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	20 * properties of the columns in a ResultSet object.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	21 *</pre>
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	22 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	23 * @author Martin van Dinther
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	24 * @version 1.0
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	25 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	26 public final class MonetResultSetMetaData
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	27 extends MonetWrapper
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	28 implements ResultSetMetaData
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	29 {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	30 /** The parental Connection object */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	31 private final MonetConnection conn;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	32
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	33 /** A ResultSetResponse object to retrieve resultset metadata from */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	34 private final MonetConnection.ResultSetResponse header;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	35
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	36 /** The schema names of the columns in this ResultSet */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	37 private final String[] schemas;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	38 /** The table names of the columns in this ResultSet */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	39 private final String[] tables;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	40 /** The names of the columns in this ResultSet */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	41 private final String[] columns;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	42 /** The MonetDB type names of the columns in this ResultSet */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	43 private final String[] types;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	44 /** The JDBC SQL type codes of the columns in this ResultSet.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	45 * The content will be derived once from the MonetDB String[] types */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	46 private final int[] JdbcSQLTypes;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	47 /** The lengths of the columns in this ResultSet */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	48 private final int[] lengths;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	49 /** The precisions of the columns in this ResultSet */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	50 private final int[] precisions;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	51 /** The scales of the columns in this ResultSet */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	52 private final int[] scales;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	53
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	54 /* For the methods: isNullable() and isAutoIncrement(), we need to query the server.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	55 * To do this efficiently we query many columns combined in one SELECT
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	56 * query and cache the results in following arrays.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	57 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	58 private final int array_size;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	59 /** Whether info for a column is already queried or not */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	60 private final boolean[] _is_queried;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	61 /** Whether info for a column is already fetched or not */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	62 private final boolean[] _is_fetched;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	63 /** The nullability of the columns in this ResultSet */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	64 private final int[] _isNullable;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	65 /** The auto increment property of the columns in this ResultSet */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	66 private final boolean[] _isAutoincrement;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	67 /** an upper bound value to calculate the range of columns to query */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	68 private int nextUpperbound;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	69
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	70
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	71 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	72 * Main constructor backed by the given connection and header.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	73 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	74 * @param connection the parent connection
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	75 * @param header a ResultSetResponse containing the metadata
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	76 * @throws IllegalArgumentException if called with null for one of the arguments
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	77 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	78 MonetResultSetMetaData(
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	79 final MonetConnection connection,
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	80 final MonetConnection.ResultSetResponse header)
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	81 throws IllegalArgumentException
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	82 {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	83 if (connection == null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	84 throw new IllegalArgumentException("Connection may not be null!");
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	85 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	86 if (header == null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	87 throw new IllegalArgumentException("Header may not be null!");
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	88 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	89 this.conn = connection;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	90 this.header = header;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	91 schemas = header.getSchemaNames();
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	92 tables = header.getTableNames();
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	93 columns = header.getNames();
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	94 lengths = header.getColumnLengths();
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	95 types = header.getTypes();
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	96 precisions = header.getColumnPrecisions();
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	97 scales = header.getColumnScales();
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	98
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	99 if (columns.length != tables.length \|\| columns.length != types.length ) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	100 throw new IllegalArgumentException("Inconsistent Header metadata");
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	101 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	102
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	103 // derive the JDBC SQL type codes from the types[] names once
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	104 JdbcSQLTypes = new int[types.length];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	105 for (int i = 0; i < types.length; i++) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	106 int javaSQLtype = MonetDriver.getJdbcSQLType(types[i]);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	107 if (javaSQLtype == Types.CLOB) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	108 if (connection.mapClobAsVarChar())
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	109 javaSQLtype = Types.VARCHAR;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	110 } else
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	111 if (javaSQLtype == Types.BLOB) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	112 if (connection.mapBlobAsVarBinary())
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	113 javaSQLtype = Types.VARBINARY;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	114 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	115 JdbcSQLTypes[i] = javaSQLtype;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	116 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	117
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	118 // initialize structures for storing columns info on nullability and autoincrement
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	119 array_size = columns.length + 1; // add 1 as in JDBC columns start from 1 (array from 0).
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	120 _is_queried = new boolean[array_size];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	121 _is_fetched = new boolean[array_size];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	122 _isNullable = new int[array_size];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	123 _isAutoincrement = new boolean[array_size];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	124 nextUpperbound = array_size;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	125 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	126
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	127 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	128 * Returns the number of columns in this ResultSet object.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	129 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	130 * @return the number of columns
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	131 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	132 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	133 public int getColumnCount() {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	134 // for debug: System.out.println("In rsmd.getColumnCount() = " + columns.length + ". this rsmd object = " + this.toString());
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	135 return columns.length;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	136 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	137
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	138 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	139 * Indicates whether the designated column is automatically numbered.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	140 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	141 * This method is currently very expensive for BIGINT,
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	142 * INTEGER, SMALLINT and TINYINT result column types
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	143 * as it needs to retrieve the information from the
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	144 * database using an SQL meta data query.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	145 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	146 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	147 * @return true if so; false otherwise
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	148 * @throws SQLException if there is no such column or a database access error occurs
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	149 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	150 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	151 public boolean isAutoIncrement(final int column) throws SQLException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	152 // only few integer types can be auto incrementable in MonetDB
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	153 // see: https://www.monetdb.org/Documentation/SQLReference/DataTypes/SerialDatatypes
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	154 switch (getColumnType(column)) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	155 case Types.BIGINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	156 case Types.INTEGER:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	157 case Types.SMALLINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	158 case Types.TINYINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	159 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	160 if (_is_fetched[column] != true) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	161 fetchColumnInfo(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	162 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	163 return _isAutoincrement[column];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	164 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	165 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	166 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	167 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	168
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	169 return false;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	170 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	171
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	172 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	173 * Indicates whether a column's case matters.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	174 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	175 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	176 * @return true for all character string columns else false
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	177 * @throws SQLException if there is no such column
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	178 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	179 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	180 public boolean isCaseSensitive(final int column) throws SQLException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	181 switch (getColumnType(column)) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	182 case Types.CHAR:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	183 case Types.LONGVARCHAR: // MonetDB doesn't use type LONGVARCHAR, it's here for completeness
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	184 case Types.CLOB:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	185 return true;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	186 case Types.VARCHAR:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	187 final String monettype = getColumnTypeName(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	188 if (monettype != null && monettype.length() == 4) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	189 // data of type inet or uuid is not case sensitive
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	190 if ("inet".equals(monettype)
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	191 \|\| "uuid".equals(monettype))
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	192 return false;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	193 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	194 return true;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	195 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	196
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	197 return false;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	198 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	199
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	200 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	201 * Indicates whether the designated column can be used in a
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	202 * where clause.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	203 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	204 * Returning true for all here, even for CLOB, BLOB.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	205 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	206 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	207 * @return true
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	208 * @throws SQLException if there is no such column
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	209 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	210 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	211 public boolean isSearchable(final int column) throws SQLException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	212 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	213 return true;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	214 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	215
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	216 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	217 * Indicates whether the designated column is a cash value.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	218 * From the MonetDB database perspective it is by definition
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	219 * unknown whether the value is a currency, because there are
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	220 * no currency datatypes such as MONEY. With this knowledge
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	221 * we can always return false here.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	222 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	223 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	224 * @return false
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	225 * @throws SQLException if there is no such column
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	226 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	227 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	228 public boolean isCurrency(final int column) throws SQLException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	229 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	230 return false;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	231 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	232
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	233 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	234 * Indicates the nullability of values in the designated column.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	235 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	236 * This method is currently very expensive as it needs to
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	237 * retrieve the information from the database using an SQL
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	238 * meta data query.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	239 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	240 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	241 * @return the nullability status of the given column; one of
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	242 * columnNoNulls, columnNullable or columnNullableUnknown
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	243 * @throws SQLException if there is no such column or a database access error occurs
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	244 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	245 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	246 public int isNullable(final int column) throws SQLException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	247 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	248 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	249 if (_is_fetched[column] != true) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	250 fetchColumnInfo(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	251 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	252 return _isNullable[column];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	253 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	254 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	255 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	256 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	257
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	258 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	259 * Indicates whether values in the designated column are signed
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	260 * numbers.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	261 * Within MonetDB all numeric types (except oid and ptr) are signed.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	262 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	263 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	264 * @return true if so; false otherwise
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	265 * @throws SQLException if there is no such column
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	266 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	267 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	268 public boolean isSigned(final int column) throws SQLException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	269 // we can hardcode this, based on the colum type
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	270 switch (getColumnType(column)) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	271 case Types.TINYINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	272 case Types.SMALLINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	273 case Types.INTEGER:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	274 case Types.REAL:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	275 case Types.FLOAT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	276 case Types.DOUBLE:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	277 case Types.DECIMAL:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	278 case Types.NUMERIC:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	279 return true;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	280 case Types.BIGINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	281 final String monettype = getColumnTypeName(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	282 if (monettype != null && monettype.length() == 3) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	283 // data of type oid or ptr is not signed
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	284 if ("oid".equals(monettype)
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	285 \|\| "ptr".equals(monettype))
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	286 return false;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	287 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	288 return true;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	289 // All other types should return false
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	290 // case Types.BOOLEAN:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	291 // case Types.DATE: // can year be negative?
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	292 // case Types.TIME: // can time be negative?
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	293 // case Types.TIME_WITH_TIMEZONE:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	294 // case Types.TIMESTAMP: // can year be negative?
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	295 // case Types.TIMESTAMP_WITH_TIMEZONE:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	296 default:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	297 return false;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	298 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	299 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	300
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	301 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	302 * Indicates the designated column's normal maximum width in
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	303 * characters.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	304 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	305 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	306 * @return the normal maximum number of characters allowed as the
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	307 * width of the designated column
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	308 * @throws SQLException if there is no such column
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	309 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	310 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	311 public int getColumnDisplaySize(final int column) throws SQLException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	312 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	313 if (lengths != null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	314 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	315 return lengths[column - 1];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	316 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	317 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	318 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	319 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	320 return 1;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	321 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	322
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	323 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	324 * Gets the designated column's suggested title for use in
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	325 * printouts and displays. The suggested title is usually
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	326 * specified by the SQL AS clause. If a SQL AS is not specified,
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	327 * the value returned from getColumnLabel will be the same as
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	328 * the value returned by the getColumnName method.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	329 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	330 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	331 * @return the suggested column title
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	332 * @throws SQLException if there is no such column
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	333 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	334 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	335 public String getColumnLabel(final int column) throws SQLException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	336 return getColumnName(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	337 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	338
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	339 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	340 * Gets the designated column's name
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	341 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	342 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	343 * @return the column name
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	344 * @throws SQLException if there is no such column
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	345 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	346 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	347 public String getColumnName(final int column) throws SQLException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	348 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	349 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	350 return columns[column - 1];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	351 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	352 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	353 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	354 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	355
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	356 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	357 * Gets the designated column's table's catalog name.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	358 * MonetDB does not support the catalog naming concept as in: catalog.schema.table naming scheme
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	359 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	360 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	361 * @return null or the name of the catalog for the table in which the given
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	362 * column appears or "" if not applicable
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	363 * @throws SQLException if there is no such column
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	364 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	365 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	366 public String getCatalogName(final int column) throws SQLException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	367 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	368 return null; // MonetDB does NOT support catalog qualifiers
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	369
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	370 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	371
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	372 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	373 * Get the designated column's schema name.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	374 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	375 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	376 * @return schema name or "" if not applicable
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	377 * @throws SQLException if there is no such column
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	378 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	379 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	380 public String getSchemaName(final int column) throws SQLException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	381 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	382 if (schemas != null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	383 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	384 return schemas[column - 1];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	385 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	386 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	387 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	388 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	389 return "";
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	390 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	391
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	392 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	393 * Gets the designated column's table name.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	394 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	395 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	396 * @return table name or "" if not applicable
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	397 * @throws SQLException if there is no such column
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	398 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	399 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	400 public String getTableName(final int column) throws SQLException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	401 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	402 if (tables != null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	403 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	404 return tables[column - 1];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	405 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	406 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	407 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	408 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	409 return "";
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	410 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	411
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	412 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	413 * Retrieves the designated column's SQL type.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	414 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	415 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	416 * @return SQL type from java.sql.Types
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	417 * @throws SQLException if there is no such column
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	418 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	419 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	420 public int getColumnType(final int column) throws SQLException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	421 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	422 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	423 return JdbcSQLTypes[column - 1];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	424 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	425 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	426 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	427 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	428
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	429 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	430 * Retrieves the designated column's database-specific type name.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	431 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	432 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	433 * @return type name used by the database. If the column type is a
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	434 * user-defined type, then a fully-qualified type name is
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	435 * returned.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	436 * @throws SQLException if there is no such column
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	437 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	438 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	439 public String getColumnTypeName(final int column) throws SQLException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	440 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	441 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	442 final String monettype = types[column - 1];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	443 if (monettype.endsWith("_interval")) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	444 /* convert the interval type names to valid SQL data type names,
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	445 * such that generic applications can use them in create table statements
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	446 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	447 if ("day_interval".equals(monettype))
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	448 return "interval day";
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	449 if ("month_interval".equals(monettype))
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	450 return "interval month";
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	451 if ("sec_interval".equals(monettype))
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	452 return "interval second";
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	453 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	454 return monettype;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	455 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	456 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	457 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	458 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	459
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	460 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	461 * Get the designated column's specified column size.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	462 * For numeric data, this is the maximum precision.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	463 * For character data, this is the length in characters.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	464 * For datetime datatypes, this is the length in characters
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	465 * of the String representation (assuming the maximum
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	466 * allowed precision of the fractional seconds component).
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	467 * For binary data, this is the length in bytes.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	468 * For the ROWID datatype, this is the length in bytes.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	469 * 0 is returned for data types where the column size is not applicable.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	470 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	471 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	472 * @return precision
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	473 * @throws SQLException if there is no such column
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	474 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	475 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	476 public int getPrecision(final int column) throws SQLException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	477 switch (getColumnType(column)) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	478 case Types.BIGINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	479 return 19;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	480 case Types.INTEGER:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	481 return 10;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	482 case Types.SMALLINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	483 return 5;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	484 case Types.TINYINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	485 return 3;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	486 case Types.REAL:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	487 return 7;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	488 case Types.FLOAT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	489 case Types.DOUBLE:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	490 return 15;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	491 case Types.DECIMAL:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	492 case Types.NUMERIC:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	493 // these data types have a variable precision (max precision is 38)
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	494 if (precisions != null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	495 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	496 return precisions[column - 1];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	497 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	498 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	499 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	500 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	501 return 18;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	502 case Types.CHAR:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	503 case Types.VARCHAR:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	504 case Types.LONGVARCHAR: // MonetDB doesn't use type LONGVARCHAR, it's here for completeness
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	505 case Types.CLOB:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	506 // these data types have a variable length
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	507 if (precisions != null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	508 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	509 int prec = precisions[column - 1];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	510 if (prec <= 0) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	511 // apparently no positive precision or max length could be fetched
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	512 // use columnDisplaySize() value as fallback
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	513 prec = getColumnDisplaySize(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	514 precisions[column - 1] = prec;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	515 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	516 return prec;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	517 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	518 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	519 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	520 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	521 // apparently no precisions array is available
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	522 // use columnDisplaySize() value as alternative
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	523 return getColumnDisplaySize(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	524 case Types.BINARY:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	525 case Types.VARBINARY:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	526 case Types.BLOB:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	527 // these data types have a variable length
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	528 if (precisions != null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	529 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	530 int prec = precisions[column - 1];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	531 if (prec <= 0) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	532 // apparently no positive precision or max length could be fetched
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	533 // use columnDisplaySize() value as fallback
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	534 // It expect number of bytes, not number of hex chars
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	535 prec = (getColumnDisplaySize(column) / 2) +1;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	536 precisions[column - 1] = prec;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	537 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	538 return prec;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	539 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	540 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	541 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	542 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	543 // apparently no precisions array is available
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	544 // use columnDisplaySize() value as alternative
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	545 // It expect number of bytes, not number of hex chars
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	546 return (getColumnDisplaySize(column) / 2) +1;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	547 case Types.DATE:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	548 return 10; // 2020-10-08
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	549 case Types.TIME:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	550 return 15; // 21:51:34.399753
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	551 case Types.TIME_WITH_TIMEZONE:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	552 return 21; // 21:51:34.399753+02:00
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	553 case Types.TIMESTAMP:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	554 return 26; // 2020-10-08 21:51:34.399753
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	555 case Types.TIMESTAMP_WITH_TIMEZONE:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	556 return 32; // 2020-10-08 21:51:34.399753+02:00
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	557 case Types.BOOLEAN:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	558 return 1;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	559 default:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	560 // All other types should return 0
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	561 return 0;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	562 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	563 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	564
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	565 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	566 * Gets the designated column's number of digits to right of
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	567 * the decimal point.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	568 * 0 is returned for data types where the scale is not applicable.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	569 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	570 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	571 * @return scale
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	572 * @throws SQLException if there is no such column
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	573 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	574 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	575 public int getScale(final int column) throws SQLException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	576 switch (getColumnType(column)) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	577 case Types.DECIMAL:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	578 case Types.NUMERIC:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	579 {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	580 // these data types may have a variable scale, max scale is 38
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	581
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	582 // Special handling for: day_interval and sec_interval as they are
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	583 // mapped to Types.NUMERIC and Types.DECIMAL types (see MonetDriver typeMap)
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	584 // They appear to have a fixed scale (tested against Oct2020)
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	585 final String monettype = getColumnTypeName(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	586 if ("interval day".equals(monettype))
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	587 return 0;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	588 if ("interval second".equals(monettype))
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	589 return 3;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	590
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	591 if (scales != null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	592 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	593 return scales[column - 1];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	594 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	595 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	596 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	597 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	598 return 0;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	599 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	600 case Types.TIME:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	601 case Types.TIME_WITH_TIMEZONE:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	602 case Types.TIMESTAMP:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	603 case Types.TIMESTAMP_WITH_TIMEZONE:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	604 if (scales != null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	605 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	606 return scales[column - 1];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	607 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	608 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	609 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	610 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	611 // support microseconds, so scale 6
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	612 return 6; // 21:51:34.399753
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	613
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	614 // All other types should return 0
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	615 // case Types.BIGINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	616 // case Types.INTEGER:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	617 // case Types.SMALLINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	618 // case Types.TINYINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	619 // case Types.REAL:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	620 // case Types.FLOAT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	621 // case Types.DOUBLE:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	622 // case Types.CHAR:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	623 // case Types.VARCHAR:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	624 // case Types.LONGVARCHAR: // MonetDB doesn't use type LONGVARCHAR, it's here for completeness
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	625 // case Types.CLOB:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	626 // case Types.BINARY:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	627 // case Types.VARBINARY:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	628 // case Types.BLOB:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	629 // case Types.DATE:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	630 // case Types.BOOLEAN:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	631 default:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	632 return 0;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	633 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	634 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	635
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	636 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	637 * Indicates whether the designated column is definitely not
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	638 * writable. MonetDB does not support cursor updates, so
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	639 * nothing is writable.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	640 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	641 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	642 * @return true if so; false otherwise
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	643 * @throws SQLException if there is no such column
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	644 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	645 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	646 public boolean isReadOnly(final int column) throws SQLException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	647 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	648 return true;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	649 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	650
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	651 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	652 * Indicates whether it is possible for a write on the
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	653 * designated column to succeed.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	654 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	655 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	656 * @return true if so; false otherwise
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	657 * @throws SQLException if there is no such column
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	658 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	659 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	660 public boolean isWritable(final int column) throws SQLException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	661 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	662 return false;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	663 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	664
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	665 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	666 * Indicates whether a write on the designated column will
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	667 * definitely succeed.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	668 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	669 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	670 * @return true if so; false otherwise
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	671 * @throws SQLException if there is no such column
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	672 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	673 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	674 public boolean isDefinitelyWritable(final int column) throws SQLException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	675 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	676 return false;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	677 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	678
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	679 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	680 * Returns the fully-qualified name of the Java class whose instances
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	681 * are manufactured if the method ResultSet.getObject is called to
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	682 * retrieve a value from the column.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	683 * ResultSet.getObject may return a subclass of the class returned by
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	684 * this method.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	685 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	686 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	687 * @return the fully-qualified name of the class in the Java programming
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	688 * language that would be used by the method ResultSet.getObject
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	689 * to retrieve the value in the specified column. This is the
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	690 * class name used for custom mapping.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	691 * @throws SQLException if there is no such column
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	692 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	693 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	694 public String getColumnClassName(final int column) throws SQLException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	695 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	696 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	697 final String MonetDBType = types[column - 1];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	698 Class<?> type = null;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	699 if (conn != null) {
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: 713 diff changeset	700 final java.util.Map<String,Class<?>> map = conn.getTypeMap();
713 c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	701 if (map != null && map.containsKey(MonetDBType)) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	702 type = (Class)map.get(MonetDBType);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	703 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	704 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	705 if (type == null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	706 // fallback to the standard SQL type Class mappings
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: 713 diff changeset	707 type = MonetDriver.getClassForType(JdbcSQLTypes[column - 1]);
713 c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	708 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	709 if (type != null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	710 return type.getCanonicalName();
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	711 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	712 throw new SQLException("column type mapping null: " + MonetDBType, "M0M03");
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	713 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	714 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	715 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	716 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	717
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	718
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	719 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	720 * A private utility method to check validity of column index number
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	721 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	722 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	723 * @throws SQLDataException when invalid column index number
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	724 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	725 private final void checkColumnIndexValidity(final int column) throws java.sql.SQLDataException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	726 if (column < 1 \|\| column > columns.length)
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	727 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	728 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	729
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	730 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	731 * A private method to fetch the isNullable and isAutoincrement values
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	732 * combined for a specific column.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	733 * The fetched values are stored in the array caches.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	734 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	735 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	736 * @throws SQLException if there is no such column
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	737 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	738 private final void fetchColumnInfo(final int column) throws SQLException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	739 // for debug: System.out.println("fetchColumnInfo(" + column + ")");
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	740 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	741 if (_is_fetched[column] != true) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	742 // fetch column info for multiple columns combined in one go
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	743 fetchManyColumnsInfo(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	744 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	745 if (_is_fetched[column])
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	746 return;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	747
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	748 // apparently no data could be fetched for this resultset column, fall back to defaults
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	749 _isNullable[column] = columnNullableUnknown;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	750 _isAutoincrement[column] = false;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	751 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	752
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	753 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	754 * A private method to fetch the isNullable and isAutoincrement values
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	755 * for many fully qualified columns combined in one SQL query to reduce the number of queries sent.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	756 * As fetching this meta information from the server per column is costly we combine the querying of
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	757 * the isNullable and isAutoincrement values and cache it in internal arrays.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	758 * We also do this for many columns combined in one query to reduce
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	759 * the number of queries needed for fetching this metadata for all resultset columns.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	760 * Many generic JDBC database tools (e.g. SQuirreL, DBeaver) request this meta data for each
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	761 * column of each resultset, so these optimisations reduces the number of meta data queries significantly.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	762 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	763 * @param column the first column is 1, the second is 2, ...
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	764 * @throws SQLException if a database access error occurs
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	765 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	766 private final void fetchManyColumnsInfo(final int column) throws SQLException {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	767 // for debug: System.out.println("fetchManyColumnsInfo(" + column + ")");
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	768
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	769 // Most queries have less than 80 resultset columns
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	770 // So 80 is a good balance between speedup (up to 79x) and size of generated query sent to server
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	771 final int MAX_COLUMNS_PER_QUERY = 80;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	772
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	773 // Determine the optimal startcol to make use of fetching up to 80 columns in one query.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	774 int startcol = column;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	775 if ((startcol > 1) && (startcol + MAX_COLUMNS_PER_QUERY >= nextUpperbound)) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	776 // we can fetch info from more columns in one query if we start with a lower startcol
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	777 startcol = nextUpperbound - MAX_COLUMNS_PER_QUERY;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	778 if (startcol < 1) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	779 startcol = 1;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	780 } else
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	781 if (startcol > column) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	782 startcol = column;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	783 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	784 nextUpperbound = startcol; // next time this nextUpperbound value will be used
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	785 // for debug: System.out.println("fetchManyColumnsInfo(" + column + ")" + (startcol != column ? " changed into startcol: " + startcol : "") + " nextUpperbound: " + nextUpperbound);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	786 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	787
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	788 final StringBuilder query = new StringBuilder(410 + (MAX_COLUMNS_PER_QUERY * 150));
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	789 /* next SQL query is a simplified version of query in MonetDatabaseMetaData.getColumns(), to fetch only the needed attributes of a column */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	790 query.append("SELECT " +
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	791 "s.\"name\" AS schnm, " +
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	792 "t.\"name\" AS tblnm, " +
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	793 "c.\"name\" AS colnm, " +
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	794 "cast(CASE c.\"null\" WHEN true THEN ").append(ResultSetMetaData.columnNullable)
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	795 .append(" WHEN false THEN ").append(ResultSetMetaData.columnNoNulls)
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	796 .append(" ELSE ").append(ResultSetMetaData.columnNullableUnknown)
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	797 .append(" END AS int) AS nullable, ").append(
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	798 "cast(CASE WHEN c.\"default\" IS NOT NULL AND c.\"default\" LIKE 'next value for %' THEN true ELSE false END AS boolean) AS isautoincrement " +
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	799 "FROM \"sys\".\"columns\" c " +
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	800 "JOIN \"sys\".\"tables\" t ON c.\"table_id\" = t.\"id\" " +
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	801 "JOIN \"sys\".\"schemas\" s ON t.\"schema_id\" = s.\"id\" " +
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	802 "WHERE ");
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	803
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	804 /* combine the conditions for multiple (up to 80) columns into the WHERE-clause */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	805 String schName = null;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	806 String tblName = null;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	807 String colName = null;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	808 int queriedcolcount = 0;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	809 for (int col = startcol; col < array_size && queriedcolcount < MAX_COLUMNS_PER_QUERY; col++) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	810 if (_is_fetched[col] != true) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	811 if (_is_queried[col] != true) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	812 _isNullable[col] = columnNullableUnknown;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	813 _isAutoincrement[col] = false;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	814 schName = getSchemaName(col);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	815 if (schName != null && !schName.isEmpty()) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	816 tblName = getTableName(col);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	817 if (tblName != null && !tblName.isEmpty()) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	818 colName = getColumnName(col);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	819 if (colName != null && !colName.isEmpty()) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	820 if (queriedcolcount > 0)
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	821 query.append(" OR ");
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	822 query.append("(s.\"name\" = ").append(MonetWrapper.sq(schName));
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	823 query.append(" AND t.\"name\" = ").append(MonetWrapper.sq(tblName));
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	824 query.append(" AND c.\"name\" = ").append(MonetWrapper.sq(colName));
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	825 query.append(")");
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	826 _is_queried[col] = true; // flag it
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	827 queriedcolcount++;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	828 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	829 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	830 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	831 if (_is_queried[col] != true) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	832 // make sure we do not try to query it again next time as it is not queryable
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	833 _is_fetched[col] = true;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	834 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	835 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	836 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	837 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	838
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	839 if (queriedcolcount == 0)
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	840 return;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	841
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	842 // execute query to get information on queriedcolcount (or less) columns.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	843 final java.sql.Statement stmt = conn.createStatement();
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	844 if (stmt != null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	845 // for debug: System.out.println("SQL (len " + query.length() + "): " + query.toString());
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	846 final java.sql.ResultSet rs = stmt.executeQuery(query.toString());
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	847 if (rs != null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	848 String rsSchema = null;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	849 String rsTable = null;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	850 String rsColumn = null;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	851 while (rs.next()) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	852 rsSchema = rs.getString(1); // col 1 is schnm
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	853 rsTable = rs.getString(2); // col 2 is tblnm
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	854 rsColumn = rs.getString(3); // col 3 is colnm
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	855 // find the matching schema.table.column entry in the array
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	856 for (int col = 1; col < array_size; col++) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	857 if (_is_fetched[col] != true && _is_queried[col]) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	858 colName = getColumnName(col);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	859 if (colName != null && colName.equals(rsColumn)) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	860 tblName = getTableName(col);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	861 if (tblName != null && tblName.equals(rsTable)) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	862 schName = getSchemaName(col);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	863 if (schName != null && schName.equals(rsSchema)) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	864 // found matching entry
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	865 // for debug: System.out.println("Found match at [" + col + "] for " + schName + "." + tblName + "." + colName);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	866 _isNullable[col] = rs.getInt(4); // col 4 is nullable (or "NULLABLE")
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	867 _isAutoincrement[col] = rs.getBoolean(5); // col 5 is isautoincrement (or "IS_AUTOINCREMENT")
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	868 _is_fetched[col] = true;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	869 queriedcolcount--;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	870 // we found the match, exit the for-loop
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	871 col = array_size;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	872 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	873 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	874 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	875 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	876 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	877 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	878 rs.close();
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	879 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	880 stmt.close();
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	881 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	882
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	883 if (queriedcolcount != 0) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	884 // not all queried columns have resulted in a returned data row.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	885 // make sure we do not match those columns again next run
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	886 for (int col = startcol; col < array_size; col++) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	887 if (_is_fetched[col] != true && _is_queried[col]) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	888 _is_fetched[col] = true;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	889 // for debug: System.out.println("Found NO match at [" + col + "] for " + getSchemaName(col) + "." + getTableName(col) + "." + getColumnName(col));
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	890 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	891 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	892 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	893 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	894 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	895

Mercurial > hg > monetdb-java

annotate src/main/java/org/monetdb/jdbc/MonetResultSetMetaData.java @ 714:ad7b08ef7745