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

annotate src/main/java/org/monetdb/jdbc/MonetResultSetMetaData.java @ 760:f2f7039f93b1

Optimization: When number of resultcolumns is less than MAX_COLUMNS_PER_QUERY (which is 80) we can make a StringBuilder with a smaller initial capacity.

author	Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date	Thu, 29 Jun 2023 16:07:56 +0200 (22 months ago)
parents	846a456f0f0c
children	e8afd7de2538

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 */
718 7138bbc6952e Do not make this class public as it is to be used only within this package. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 717 diff changeset	26 final class MonetResultSetMetaData
713 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
717 7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	33 /** The number of columns, it can be zero !! */
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	34 private final int colCount;
713 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
720 99baab703566 Resolve some javac -Xdoclint warnings Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 718 diff changeset	54 /**
99baab703566 Resolve some javac -Xdoclint warnings Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 718 diff changeset	55 * For the methods: isNullable() and isAutoIncrement(), we need to query the server.
713 c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	56 * 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	57 * 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	58 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	59 private final int array_size;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	60 /** 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	61 private final boolean[] _is_queried;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	62 /** 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	63 private final boolean[] _is_fetched;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	64 /** 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	65 private final int[] _isNullable;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	66 /** 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	67 private final boolean[] _isAutoincrement;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	68 /** 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	69 private int nextUpperbound;
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 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	73 * 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	74 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	75 * @param connection the parent connection
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	76 * @param header a ResultSetResponse containing the metadata
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	77 * @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	78 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	79 MonetResultSetMetaData(
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	80 final MonetConnection connection,
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	81 final MonetConnection.ResultSetResponse header)
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	82 throws IllegalArgumentException
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	83 {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	84 if (connection == null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	85 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	86 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	87 if (header == null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	88 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	89 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	90 this.conn = connection;
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
717 7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	99 colCount = columns.length;
713 c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	100 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	101 throw new IllegalArgumentException("Inconsistent Header metadata");
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
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	104 // 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	105 JdbcSQLTypes = new int[types.length];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	106 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	107 int javaSQLtype = MonetDriver.getJdbcSQLType(types[i]);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	108 if (javaSQLtype == Types.CLOB) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	109 if (connection.mapClobAsVarChar())
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	110 javaSQLtype = Types.VARCHAR;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	111 } else
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	112 if (javaSQLtype == Types.BLOB) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	113 if (connection.mapBlobAsVarBinary())
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	114 javaSQLtype = Types.VARBINARY;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	115 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	116 JdbcSQLTypes[i] = javaSQLtype;
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
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	119 // initialize structures for storing columns info on nullability and autoincrement
717 7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	120 array_size = colCount + 1; // add 1 as in JDBC columns start from 1 (array from 0).
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	121 _is_queried = new boolean[array_size];
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	122 _is_fetched = new boolean[array_size];
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	123 _isNullable = new int[array_size];
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	124 _isAutoincrement = new boolean[array_size];
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	125 nextUpperbound = array_size;
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	126 }
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	127
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	128 /**
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	129 * Alternative constructor backed by the given connection and metadata arrays.
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	130 * It is used by MonetPreparedStatement.
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	131 *
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	132 * @param connection the parent connection
720 99baab703566 Resolve some javac -Xdoclint warnings Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 718 diff changeset	133 * @param colcount the number of result columns, it can be zero !!
717 7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	134 * @param schemas the schema names
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	135 * @param tables the table names
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	136 * @param columns the column names
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	137 * @param types the MonetDB type names
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	138 * @param jdbcTypes the JDBC SQL type codes
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	139 * @param lengths the maximum display length for each column
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	140 * @param precisions the precision for each column
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	141 * @param scales the scale for each column
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	142 * @throws IllegalArgumentException if called with null for one of the arguments
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	143 */
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	144 MonetResultSetMetaData(
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	145 final MonetConnection connection,
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	146 final int colcount,
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	147 final String[] schemas,
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	148 final String[] tables,
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	149 final String[] columns,
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	150 final String[] types,
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	151 final int[] jdbcTypes,
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	152 final int[] lengths,
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	153 final int[] precisions,
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	154 final int[] scales)
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	155 throws IllegalArgumentException
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	156 {
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	157 if (connection == null) {
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	158 throw new IllegalArgumentException("Connection may not be null!");
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	159 }
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	160 if (schemas == null) {
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	161 throw new IllegalArgumentException("Schemas may not be null!");
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	162 }
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	163 if (tables == null) {
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	164 throw new IllegalArgumentException("Tables may not be null!");
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	165 }
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	166 if (columns == null) {
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	167 throw new IllegalArgumentException("Columns may not be null!");
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	168 }
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	169 if (types == null) {
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	170 throw new IllegalArgumentException("MonetDB Types may not be null!");
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	171 }
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	172 if (jdbcTypes == null) {
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	173 throw new IllegalArgumentException("JDBC Types may not be null!");
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	174 }
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	175 if (lengths == null) {
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	176 throw new IllegalArgumentException("Lengths may not be null!");
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	177 }
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	178 if (precisions == null) {
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	179 throw new IllegalArgumentException("Precisions may not be null!");
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	180 }
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	181 if (scales == null) {
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	182 throw new IllegalArgumentException("Scales may not be null!");
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	183 }
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	184 if (columns.length != tables.length \|\| columns.length != types.length ) {
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	185 throw new IllegalArgumentException("Inconsistent Header metadata");
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	186 }
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	187 this.conn = connection;
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	188 this.colCount = colcount;
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	189 this.schemas = schemas;
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	190 this.tables = tables;
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	191 this.columns = columns;
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	192 this.lengths = lengths;
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	193 this.types = types;
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	194 this.JdbcSQLTypes = jdbcTypes;
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	195 this.precisions = precisions;
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	196 this.scales = scales;
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	197
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	198 // initialize structures for storing columns info on nullability and autoincrement
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	199 array_size = colCount + 1; // add 1 as in JDBC columns start from 1 (array from 0).
713 c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	200 _is_queried = new boolean[array_size];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	201 _is_fetched = new boolean[array_size];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	202 _isNullable = new int[array_size];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	203 _isAutoincrement = new boolean[array_size];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	204 nextUpperbound = array_size;
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
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	207 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	208 * 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	209 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	210 * @return the number of columns
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	211 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	212 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	213 public int getColumnCount() {
717 7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	214 // for debug: System.out.println("In rsmd.getColumnCount() = " + colCount + ". this rsmd object = " + this.toString());
7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	215 return colCount;
713 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
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	218 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	219 * 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	220 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	221 * 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	222 * INTEGER, SMALLINT and TINYINT result column types
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	223 * 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	224 * database using an SQL meta data query.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	225 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	226 * @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	227 * @return true if so; false otherwise
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	228 * @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	229 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	230 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	231 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	232 // 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	233 // 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	234 switch (getColumnType(column)) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	235 case Types.BIGINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	236 case Types.INTEGER:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	237 case Types.SMALLINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	238 case Types.TINYINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	239 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	240 if (_is_fetched[column] != true) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	241 fetchColumnInfo(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	242 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	243 return _isAutoincrement[column];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	244 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	245 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	246 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	247 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	248
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	249 return false;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	250 }
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 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	253 * Indicates whether a column's case matters.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	254 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	255 * @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	256 * @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	257 * @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	258 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	259 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	260 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	261 switch (getColumnType(column)) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	262 case Types.CHAR:
735 3dd0d43014e8 Disable checks for Types.LONGVARCHAR and Types.LONGVARBINARY as MonetDB server does not support these data types, and no mappings exists to these JDBC Types and thus these cases will never be reached in JDBC Driver. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 726 diff changeset	263 /* case Types.LONGVARCHAR: // MonetDB doesn't use type LONGVARCHAR */
713 c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	264 case Types.CLOB:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	265 return true;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	266 case Types.VARCHAR:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	267 final String monettype = getColumnTypeName(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	268 if (monettype != null && monettype.length() == 4) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	269 // 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	270 if ("inet".equals(monettype)
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	271 \|\| "uuid".equals(monettype))
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	272 return false;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	273 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	274 return true;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	275 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	276
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	277 return false;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	278 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	279
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	280 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	281 * 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	282 * where clause.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	283 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	284 * 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	285 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	286 * @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	287 * @return true
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	288 * @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	289 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	290 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	291 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	292 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	293 return true;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	294 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	295
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	296 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	297 * 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	298 * 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	299 * 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	300 * 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	301 * we can always return false here.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	302 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	303 * @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	304 * @return false
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	305 * @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	306 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	307 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	308 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	309 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	310 return false;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	311 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	312
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	313 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	314 * 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	315 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	316 * 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	317 * 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	318 * meta data query.
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 * @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	321 * @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	322 * columnNoNulls, columnNullable or columnNullableUnknown
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	323 * @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	324 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	325 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	326 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	327 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	328 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	329 if (_is_fetched[column] != true) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	330 fetchColumnInfo(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	331 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	332 return _isNullable[column];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	333 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	334 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	335 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	336 }
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 * 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	340 * numbers.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	341 * 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	342 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	343 * @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	344 * @return true if so; false otherwise
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	345 * @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	346 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	347 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	348 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	349 // 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	350 switch (getColumnType(column)) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	351 case Types.TINYINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	352 case Types.SMALLINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	353 case Types.INTEGER:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	354 case Types.REAL:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	355 case Types.FLOAT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	356 case Types.DOUBLE:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	357 case Types.DECIMAL:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	358 case Types.NUMERIC:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	359 return true;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	360 case Types.BIGINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	361 final String monettype = getColumnTypeName(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	362 if (monettype != null && monettype.length() == 3) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	363 // 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	364 if ("oid".equals(monettype)
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	365 \|\| "ptr".equals(monettype))
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	366 return false;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	367 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	368 return true;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	369 // All other types should return false
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	370 // case Types.BOOLEAN:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	371 // case Types.DATE: // can year be negative?
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	372 // case Types.TIME: // can time be negative?
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	373 // case Types.TIME_WITH_TIMEZONE:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	374 // case Types.TIMESTAMP: // can year be negative?
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	375 // case Types.TIMESTAMP_WITH_TIMEZONE:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	376 default:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	377 return false;
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 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	380
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	381 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	382 * 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	383 * characters.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	384 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	385 * @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	386 * @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	387 * width of the designated column
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	388 * @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	389 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	390 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	391 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	392 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	393 if (lengths != null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	394 try {
726 89bbd04036cd For type inet we always get 0 as length from the server. As inet has a maximum display length of 18 we should return that more useful value instead. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 725 diff changeset	395 int len = lengths[column - 1];
89bbd04036cd For type inet we always get 0 as length from the server. As inet has a maximum display length of 18 we should return that more useful value instead. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 725 diff changeset	396 if (len == 0) {
89bbd04036cd For type inet we always get 0 as length from the server. As inet has a maximum display length of 18 we should return that more useful value instead. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 725 diff changeset	397 final String monettype = getColumnTypeName(column);
89bbd04036cd For type inet we always get 0 as length from the server. As inet has a maximum display length of 18 we should return that more useful value instead. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 725 diff changeset	398 // in case of inet it always has 0 as length. we need to correct it.
89bbd04036cd For type inet we always get 0 as length from the server. As inet has a maximum display length of 18 we should return that more useful value instead. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 725 diff changeset	399 if (monettype != null && "inet".equals(monettype)) {
89bbd04036cd For type inet we always get 0 as length from the server. As inet has a maximum display length of 18 we should return that more useful value instead. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 725 diff changeset	400 len = 18; // 128.127.126.125/24
89bbd04036cd For type inet we always get 0 as length from the server. As inet has a maximum display length of 18 we should return that more useful value instead. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 725 diff changeset	401 }
89bbd04036cd For type inet we always get 0 as length from the server. As inet has a maximum display length of 18 we should return that more useful value instead. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 725 diff changeset	402 }
89bbd04036cd For type inet we always get 0 as length from the server. As inet has a maximum display length of 18 we should return that more useful value instead. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 725 diff changeset	403 return len;
713 c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	404 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	405 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	406 }
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 return 1;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	409 }
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 * 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	413 * 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	414 * 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	415 * 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	416 * the value returned by the getColumnName method.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	417 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	418 * @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	419 * @return the suggested column title
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	420 * @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	421 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	422 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	423 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	424 return getColumnName(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	425 }
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 * Gets the designated column's name
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 * @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	431 * @return the column name
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	432 * @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	433 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	434 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	435 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	436 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	437 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	438 return columns[column - 1];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	439 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	440 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	441 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	442 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	443
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	444 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	445 * 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	446 * 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	447 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	448 * @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	449 * @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	450 * column appears or "" if not applicable
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	451 * @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	452 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	453 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	454 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	455 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	456 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	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 schema name.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	462 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	463 * @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	464 * @return schema name or "" if not applicable
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	465 * @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	466 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	467 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	468 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	469 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	470 if (schemas != null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	471 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	472 return schemas[column - 1];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	473 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	474 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	475 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	476 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	477 return "";
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	478 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	479
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	480 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	481 * Gets the designated column's table name.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	482 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	483 * @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	484 * @return table name or "" if not applicable
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	485 * @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	486 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	487 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	488 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	489 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	490 if (tables != null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	491 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	492 return tables[column - 1];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	493 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	494 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	495 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	496 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	497 return "";
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	498 }
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 * Retrieves the designated column's SQL type.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	502 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	503 * @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	504 * @return SQL type from java.sql.Types
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	505 * @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	506 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	507 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	508 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	509 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	510 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	511 return JdbcSQLTypes[column - 1];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	512 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	513 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	514 }
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
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	517 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	518 * 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	519 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	520 * @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	521 * @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	522 * 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	523 * returned.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	524 * @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	525 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	526 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	527 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	528 checkColumnIndexValidity(column);
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 final String monettype = types[column - 1];
725 224d73363dc9 Fixed issue when you create a new Statement, call getGeneratedKeys().getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 720 diff changeset	531 if (monettype != null && monettype.endsWith("_interval")) {
713 c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	532 /* 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	533 * 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	534 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	535 if ("day_interval".equals(monettype))
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	536 return "interval day";
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	537 if ("month_interval".equals(monettype))
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	538 return "interval month";
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	539 if ("sec_interval".equals(monettype))
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	540 return "interval second";
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 return monettype;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	543 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	544 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	545 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	546 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	547
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	548 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	549 * 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	550 * 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	551 * 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	552 * 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	553 * of the String representation (assuming the maximum
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	554 * allowed precision of the fractional seconds component).
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	555 * 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	556 * 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	557 * 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	558 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	559 * @param column the first column is 1, the second is 2, ...
717 7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	560 * @return maximum precision or length in characters
713 c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	561 * @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	562 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	563 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	564 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	565 switch (getColumnType(column)) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	566 case Types.BIGINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	567 return 19;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	568 case Types.INTEGER:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	569 return 10;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	570 case Types.SMALLINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	571 return 5;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	572 case Types.TINYINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	573 return 3;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	574 case Types.REAL:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	575 return 7;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	576 case Types.FLOAT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	577 case Types.DOUBLE:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	578 return 15;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	579 case Types.DECIMAL:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	580 case Types.NUMERIC:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	581 // 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	582 if (precisions != null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	583 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	584 return precisions[column - 1];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	585 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	586 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	587 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	588 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	589 return 18;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	590 case Types.CHAR:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	591 case Types.VARCHAR:
735 3dd0d43014e8 Disable checks for Types.LONGVARCHAR and Types.LONGVARBINARY as MonetDB server does not support these data types, and no mappings exists to these JDBC Types and thus these cases will never be reached in JDBC Driver. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 726 diff changeset	592 /* case Types.LONGVARCHAR: // MonetDB doesn't use type LONGVARCHAR */
713 c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	593 case Types.CLOB:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	594 // these data types have a variable length
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	595 if (precisions != null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	596 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	597 int prec = precisions[column - 1];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	598 if (prec <= 0) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	599 // 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	600 // use columnDisplaySize() value as fallback
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	601 prec = getColumnDisplaySize(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	602 precisions[column - 1] = prec;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	603 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	604 return prec;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	605 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	606 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	607 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	608 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	609 // apparently no precisions array is available
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	610 // use columnDisplaySize() value as alternative
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	611 return getColumnDisplaySize(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	612 case Types.BINARY:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	613 case Types.VARBINARY:
735 3dd0d43014e8 Disable checks for Types.LONGVARCHAR and Types.LONGVARBINARY as MonetDB server does not support these data types, and no mappings exists to these JDBC Types and thus these cases will never be reached in JDBC Driver. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 726 diff changeset	614 /* case Types.LONGVARBINARY: // MonetDB doesn't use type LONGVARBINARY */
713 c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	615 case Types.BLOB:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	616 // these data types have a variable length
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	617 if (precisions != null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	618 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	619 int prec = precisions[column - 1];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	620 if (prec <= 0) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	621 // 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	622 // use columnDisplaySize() value as fallback
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	623 // 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	624 prec = (getColumnDisplaySize(column) / 2) +1;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	625 precisions[column - 1] = prec;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	626 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	627 return prec;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	628 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	629 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	630 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	631 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	632 // apparently no precisions array is available
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	633 // use columnDisplaySize() value as alternative
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	634 // 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	635 return (getColumnDisplaySize(column) / 2) +1;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	636 case Types.DATE:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	637 return 10; // 2020-10-08
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	638 case Types.TIME:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	639 return 15; // 21:51:34.399753
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	640 case Types.TIME_WITH_TIMEZONE:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	641 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	642 case Types.TIMESTAMP:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	643 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	644 case Types.TIMESTAMP_WITH_TIMEZONE:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	645 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	646 case Types.BOOLEAN:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	647 return 1;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	648 default:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	649 // All other types should return 0
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	650 return 0;
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 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	653
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 * 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	656 * the decimal point.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	657 * 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	658 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	659 * @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	660 * @return scale
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	661 * @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	662 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	663 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	664 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	665 switch (getColumnType(column)) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	666 case Types.DECIMAL:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	667 case Types.NUMERIC:
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 // 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	670
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	671 // 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	672 // 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	673 // 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	674 final String monettype = getColumnTypeName(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	675 if ("interval day".equals(monettype))
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	676 return 0;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	677 if ("interval second".equals(monettype))
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	678 return 3;
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 if (scales != null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	681 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	682 return scales[column - 1];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	683 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	684 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
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 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	687 return 0;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	688 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	689 case Types.TIME:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	690 case Types.TIME_WITH_TIMEZONE:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	691 case Types.TIMESTAMP:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	692 case Types.TIMESTAMP_WITH_TIMEZONE:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	693 if (scales != null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	694 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	695 return scales[column - 1];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	696 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	697 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	698 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	699 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	700 // support microseconds, so scale 6
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	701 return 6; // 21:51:34.399753
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	702
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	703 // All other types should return 0
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	704 // case Types.BIGINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	705 // case Types.INTEGER:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	706 // case Types.SMALLINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	707 // case Types.TINYINT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	708 // case Types.REAL:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	709 // case Types.FLOAT:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	710 // case Types.DOUBLE:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	711 // case Types.CHAR:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	712 // case Types.VARCHAR:
735 3dd0d43014e8 Disable checks for Types.LONGVARCHAR and Types.LONGVARBINARY as MonetDB server does not support these data types, and no mappings exists to these JDBC Types and thus these cases will never be reached in JDBC Driver. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 726 diff changeset	713 // case Types.LONGVARCHAR: // MonetDB doesn't use type LONGVARCHAR
713 c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	714 // case Types.CLOB:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	715 // case Types.BINARY:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	716 // case Types.VARBINARY:
735 3dd0d43014e8 Disable checks for Types.LONGVARCHAR and Types.LONGVARBINARY as MonetDB server does not support these data types, and no mappings exists to these JDBC Types and thus these cases will never be reached in JDBC Driver. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 726 diff changeset	717 // case Types.LONGVARBINARY: // MonetDB doesn't use type LONGVARBINARY
713 c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	718 // case Types.BLOB:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	719 // case Types.DATE:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	720 // case Types.BOOLEAN:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	721 default:
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	722 return 0;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	723 }
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
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	726 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	727 * 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	728 * 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	729 * nothing is writable.
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 * @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	732 * @return true if so; false otherwise
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	733 * @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	734 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	735 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	736 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	737 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	738 return true;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	739 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	740
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	741 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	742 * 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	743 * designated column to succeed.
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 * @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	746 * @return true if so; false otherwise
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	747 * @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	748 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	749 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	750 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	751 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	752 return false;
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
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	755 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	756 * 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	757 * definitely succeed.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	758 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	759 * @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	760 * @return true if so; false otherwise
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	761 * @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	762 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	763 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	764 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	765 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	766 return false;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	767 }
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 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	770 * 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	771 * 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	772 * retrieve a value from the column.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	773 * 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	774 * this method.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	775 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	776 * @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	777 * @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	778 * 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	779 * 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	780 * class name used for custom mapping.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	781 * @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	782 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	783 @Override
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	784 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	785 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	786 try {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	787 final String MonetDBType = types[column - 1];
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	788 Class<?> type = null;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	789 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	790 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	791 if (map != null && map.containsKey(MonetDBType)) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	792 type = (Class)map.get(MonetDBType);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	793 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	794 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	795 if (type == null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	796 // 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	797 type = MonetDriver.getClassForType(JdbcSQLTypes[column - 1]);
713 c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	798 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	799 if (type != null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	800 return type.getCanonicalName();
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	801 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	802 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	803 } catch (IndexOutOfBoundsException e) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	804 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	805 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	806 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	807
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	808
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	809 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	810 * 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	811 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	812 * @param column the first column is 1, the second is 2, ...
720 99baab703566 Resolve some javac -Xdoclint warnings Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 718 diff changeset	813 * @throws java.sql.SQLDataException when invalid column index number
713 c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	814 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	815 private final void checkColumnIndexValidity(final int column) throws java.sql.SQLDataException {
717 7240d2dd369f Improved implementation of PreparedStatement.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 714 diff changeset	816 if (column < 1 \|\| column > colCount)
713 c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	817 throw MonetResultSet.newSQLInvalidColumnIndexException(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	818 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	819
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	820 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	821 * 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	822 * combined for a specific column.
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	823 * 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	824 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	825 * @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	826 * @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	827 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	828 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	829 // for debug: System.out.println("fetchColumnInfo(" + column + ")");
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	830 checkColumnIndexValidity(column);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	831 if (_is_fetched[column] != true) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	832 // 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	833 fetchManyColumnsInfo(column);
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 if (_is_fetched[column])
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	836 return;
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 // 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	839 _isNullable[column] = columnNullableUnknown;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	840 _isAutoincrement[column] = false;
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
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	843 /**
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	844 * 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	845 * 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	846 * 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	847 * 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	848 * 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	849 * 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	850 * 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	851 * 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	852 *
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	853 * @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	854 * @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	855 */
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	856 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	857 // for debug: System.out.println("fetchManyColumnsInfo(" + column + ")");
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	858
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	859 // 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	860 // 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	861 final int MAX_COLUMNS_PER_QUERY = 80;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	862
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	863 // 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	864 int startcol = column;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	865 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	866 // 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	867 startcol = nextUpperbound - MAX_COLUMNS_PER_QUERY;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	868 if (startcol < 1) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	869 startcol = 1;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	870 } else
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	871 if (startcol > column) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	872 startcol = column;
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 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	875 // 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	876 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	877
760 f2f7039f93b1 Optimization: When number of resultcolumns is less than MAX_COLUMNS_PER_QUERY (which is 80) we can make a StringBuilder with a smaller initial capacity. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 759 diff changeset	878 final StringBuilder query = new StringBuilder(410 + (java.lang.Math.min(MAX_COLUMNS_PER_QUERY, colCount) * 150));
713 c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	879 /* 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	880 query.append("SELECT " +
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	881 "s.\"name\" AS schnm, " +
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	882 "t.\"name\" AS tblnm, " +
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	883 "c.\"name\" AS colnm, " +
759 846a456f0f0c Remove append() calls for static int values in construction of Strings. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 735 diff changeset	884 "cast(CASE c.\"null\" WHEN true THEN " + ResultSetMetaData.columnNullable +
846a456f0f0c Remove append() calls for static int values in construction of Strings. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 735 diff changeset	885 " WHEN false THEN " + ResultSetMetaData.columnNoNulls +
846a456f0f0c Remove append() calls for static int values in construction of Strings. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 735 diff changeset	886 " ELSE " + ResultSetMetaData.columnNullableUnknown +
846a456f0f0c Remove append() calls for static int values in construction of Strings. Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: 735 diff changeset	887 " END AS int) AS nullable, " +
713 c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	888 "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	889 "FROM \"sys\".\"columns\" c " +
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	890 "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	891 "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	892 "WHERE ");
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 /* 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	895 String schName = null;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	896 String tblName = null;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	897 String colName = null;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	898 int queriedcolcount = 0;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	899 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	900 if (_is_fetched[col] != true) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	901 if (_is_queried[col] != true) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	902 _isNullable[col] = columnNullableUnknown;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	903 _isAutoincrement[col] = false;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	904 schName = getSchemaName(col);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	905 if (schName != null && !schName.isEmpty()) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	906 tblName = getTableName(col);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	907 if (tblName != null && !tblName.isEmpty()) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	908 colName = getColumnName(col);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	909 if (colName != null && !colName.isEmpty()) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	910 if (queriedcolcount > 0)
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	911 query.append(" OR ");
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	912 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	913 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	914 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	915 query.append(")");
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	916 _is_queried[col] = true; // flag it
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	917 queriedcolcount++;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	918 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	919 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	920 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	921 if (_is_queried[col] != true) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	922 // 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	923 _is_fetched[col] = true;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	924 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	925 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	926 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	927 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	928
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	929 if (queriedcolcount == 0)
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	930 return;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	931
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	932 // 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	933 final java.sql.Statement stmt = conn.createStatement();
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	934 if (stmt != null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	935 // 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	936 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	937 if (rs != null) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	938 String rsSchema = null;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	939 String rsTable = null;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	940 String rsColumn = null;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	941 while (rs.next()) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	942 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	943 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	944 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	945 // 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	946 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	947 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	948 colName = getColumnName(col);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	949 if (colName != null && colName.equals(rsColumn)) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	950 tblName = getTableName(col);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	951 if (tblName != null && tblName.equals(rsTable)) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	952 schName = getSchemaName(col);
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	953 if (schName != null && schName.equals(rsSchema)) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	954 // found matching entry
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	955 // 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	956 _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	957 _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	958 _is_fetched[col] = true;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	959 queriedcolcount--;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	960 // 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	961 col = array_size;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	962 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	963 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	964 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	965 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	966 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	967 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	968 rs.close();
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	969 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	970 stmt.close();
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	971 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	972
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	973 if (queriedcolcount != 0) {
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	974 // 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	975 // 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	976 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	977 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	978 _is_fetched[col] = true;
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	979 // 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	980 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	981 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	982 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	983 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	984 }
c3c424a90a42 Improve implementation of ResultSet.getMetaData(). Martin van Dinther <martin.van.dinther@monetdbsolutions.com> parents: diff changeset	985

Mercurial > hg > monetdb-java

annotate src/main/java/org/monetdb/jdbc/MonetResultSetMetaData.java @ 760:f2f7039f93b1