/*
* JBoss, Home of Professional Open Source.
* See the COPYRIGHT.txt file distributed with this work for information
* regarding copyright ownership. Some portions may be licensed
* to Red Hat, Inc. under one or more contributor license agreements.
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*/
package org.teiid.jdbc;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.RowIdLifetime;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Collections;
import java.util.List;
import java.util.Map;
import java.util.logging.Logger;
import org.teiid.client.metadata.ResultsMetadataConstants;
import org.teiid.core.CoreConstants;
import org.teiid.core.types.DataTypeManagerService;
import org.teiid.core.types.JDBCSQLTypeInfo;
import org.teiid.core.util.PropertiesUtils;
import org.teiid.designer.annotation.Since;
import org.teiid.designer.runtime.version.spi.TeiidServerVersion.Version;
import org.teiid.runtime.client.Messages;
public class DatabaseMetaDataImpl extends WrapperImpl implements DatabaseMetaData {
public static final String REPORT_AS_VIEWS = "reportAsViews"; //$NON-NLS-1$
private static final String IS_NULLABLE = "CASE NullType WHEN 'Nullable' THEN 'YES' WHEN 'No Nulls' THEN 'NO' ELSE '' END AS IS_NULLABLE"; //$NON-NLS-1$
private static final String DATA_TYPES = "DataTypes"; //$NON-NLS-1$
private static Logger logger = Logger.getLogger("org.teiid.jdbc"); //$NON-NLS-1$
/** CONSTANTS */
private static final String PERCENT = "%"; //$NON-NLS-1$
// constant value indicating that there is not limit
private final static int NO_LIMIT = 0;
// constant value giving preferred name for a schema
private final static String SCHEMA_TERM = "Schema"; //$NON-NLS-1$
// constant value giving an empty string value
private final static String EMPTY_STRING = ""; //$NON-NLS-1$
// constant value giving a string used to escape search strings
private final static String ESCAPE_SEARCH_STRING = "\\"; //$NON-NLS-1$
// constant value giving an identifier quoting char
//private final static String SINGLE_QUOTE = "\'";
// constant value giving an identifier quoting string
private final static String DOUBLE_QUOTE = "\""; //$NON-NLS-1$
// constant value giving extra name characters used in Identifiers
private final static String EXTRA_CHARS = ".@"; //$NON-NLS-1$
// constant value giving the key words not in SQL-92
final static String KEY_WORDS = "OPTION, BIGDECIMAL"+ //$NON-NLS-1$
", BIGDECIMAL, BIGINTEGER, BREAK, BYTE, CRITERIA, ERROR, LIMIT, LONG, LOOP, MAKEDEP, MAKENOTDEP"+ //$NON-NLS-1$
", NOCACHE, STRING, VIRTUAL, WHILE"; //$NON-NLS-1$
// constant value giving preferred name for a procedure
private final static String PROCEDURE_TERM = "StoredProcedure"; //$NON-NLS-1$
// constant value giving the names of numeric functions supported
final static String NUMERIC_FUNCTIONS =
"ABS, ACOS, ASIN, ATAN, ATAN2, BITAND, BITNOT, BITOR, BITXOR, CEILING" //$NON-NLS-1$
+ ", COS, COT, DEGREES, EXP, FLOOR, FORMATBIGDECIMAL, FORMATBIGINTEGER" //$NON-NLS-1$
+ ", FORMATDOUBLE, FORMATFLOAT, FORMATINTEGER, FORMATLONG, LOG, LOG10" //$NON-NLS-1$
+ ", MOD, PARSEBIGDECIMAL, PARSEBIGINTEGER, PARSEDOUBLE, PARSEFLOAT" //$NON-NLS-1$
+ ", PARSEINTEGER, PARSELONG, PI, POWER, RADIANS, RAND, ROUND, SIGN, SIN, SQRT, TAN"; //$NON-NLS-1$
// constant value giving the names of string functions supported
final static String STRING_FUNCTIONS =
"ASCII, CHR, CHAR, CONCAT, CONCAT2, INITCAP, INSERT, LCASE, LEFT, LENGTH, LOCATE, LOWER, LPAD, LTRIM, " + //$NON-NLS-1$
"REPEAT, REPLACE, RIGHT, RPAD, RTRIM, SUBSTRING, TRANSLATE, UCASE, UPPER"; //$NON-NLS-1$
// constant value giving the names of date/time functions supported
final static String DATE_FUNCTIONS =
"CURDATE, CURTIME, NOW, DAYNAME, DAYOFMONTH, DAYOFWEEK, DAYOFYEAR, FORMATDATE, " + //$NON-NLS-1$
"FORMATTIME, FORMATTIMESTAMP, FROM_UNIXTIME, HOUR, MINUTE, MONTH, MONTHNAME, PARSEDATE, PARSETIME, " + //$NON-NLS-1$
"PARSETIMESTAMP, QUARTER, SECOND, TIMESTAMPADD, TIMESTAMPDIFF, WEEK, YEAR"; //$NON-NLS-1$
// constant value giving the names of system functions supported
final static String SYSTEM_FUNCTIONS =
"CAST, COALESCE, CONVERT, DECODESTRING, DECODEINTEGER, IFNULL, NULLIF, NVL, LOOKUP, UUID, UNESCAPE, ARRAY_GET, ARRAY_LENGTH"; //$NON-NLS-1$
// constant value giving max length of a catalog name
private final static int MAX_CATALOG_NAME_LENGTH = 255;
// constant value giving max length of a procedure name
private final static int MAX_PROCEDURE_NAME_LENGTH = 255;
// constant value giving max length of a table name
private final static int MAX_TABLE_NAME_LENGTH = 255;
// constant value giving max length of a column name
private final static int MAX_COLUMN_NAME_LENGTH = 255;
// constant value giving max length of a user name
private final static int MAX_USER_NAME_LENGTH = 255;
// constant value giving min value of a columns scale
//private final static short MIN_SCALE = 0;
// constant value giving max value of a columns scale
//private final static short MAX_SCALE = 256;
private final static String LIKE_ESCAPE = " LIKE ? ESCAPE '" + ESCAPE_SEARCH_STRING + "' ";//$NON-NLS-1$//$NON-NLS-2$
final private static class RUNTIME_MODEL{
public final static String VIRTUAL_MODEL_NAME = CoreConstants.SYSTEM_MODEL;
}
private static final String NULLABILITY_MAPPING =
new StringBuffer("No Nulls, ").append(DatabaseMetaData.columnNoNulls) //$NON-NLS-1$
.append( ", Nullable, ").append(DatabaseMetaData.columnNullable) //$NON-NLS-1$
.append( ", Unknown, ") .append(DatabaseMetaData.columnNullableUnknown) //$NON-NLS-1$
.toString();
private static final String PROC_COLUMN_NULLABILITY_MAPPING =
new StringBuffer("No Nulls, ").append(DatabaseMetaData.procedureNoNulls) //$NON-NLS-1$
.append( ", Nullable, ").append(DatabaseMetaData.procedureNullable) //$NON-NLS-1$
.append( ", Unknown, ") .append(DatabaseMetaData.procedureNullableUnknown) //$NON-NLS-1$
.toString();
private static final String PARAM_DIRECTION_MAPPING =
new StringBuffer("In,") .append(DatabaseMetaData.procedureColumnIn) //$NON-NLS-1$
.append( ", Out,") .append(DatabaseMetaData.procedureColumnOut) //$NON-NLS-1$
.append( ", InOut,") .append(DatabaseMetaData.procedureColumnInOut) //$NON-NLS-1$
.append( ", ReturnValue,").append(DatabaseMetaData.procedureColumnReturn) //$NON-NLS-1$
.append( ", ResultSet,") .append(DatabaseMetaData.procedureColumnResult) //$NON-NLS-1$
.toString();
// private static final String UDT_NAME_MAPPING =
// new StringBuffer("JAVA_OBJECT, ").append(Types.JAVA_OBJECT) //$NON-NLS-1$
// .append( ", DISTINCT, ") .append(Types.DISTINCT) //$NON-NLS-1$
// .append( ", STRUCT, ") .append(Types.STRUCT) //$NON-NLS-1$
// .append( ", null, ") .append(Types.JAVA_OBJECT).toString(); //$NON-NLS-1$
// Queries
private final static String QUERY_REFERENCE_KEYS =
new StringBuffer("SELECT PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, PKCOLUMN_NAME, FKTABLE_CAT, FKTABLE_SCHEM") //$NON-NLS-1$
.append(", FKTABLE_NAME, FKCOLUMN_NAME, KEY_SEQ, UPDATE_RULE, DELETE_RULE, FK_NAME, PK_NAME, DEFERRABILITY FROM ") //$NON-NLS-1$
.append(RUNTIME_MODEL.VIRTUAL_MODEL_NAME).append(".ReferenceKeyColumns").toString(); //$NON-NLS-1$
private final static String QUERY_CROSS_REFERENCES = new StringBuffer(QUERY_REFERENCE_KEYS)
.append(" WHERE UCASE(PKTABLE_CAT)").append(LIKE_ESCAPE).append("AND UCASE(FKTABLE_CAT)").append(LIKE_ESCAPE) //$NON-NLS-1$//$NON-NLS-2$
.append(" AND UCASE(PKTABLE_SCHEM)").append(LIKE_ESCAPE).append("AND UCASE(FKTABLE_SCHEM)").append(LIKE_ESCAPE) //$NON-NLS-1$//$NON-NLS-2$
.append(" AND UCASE(PKTABLE_NAME)").append(LIKE_ESCAPE).append("AND UCASE(FKTABLE_NAME)").append(LIKE_ESCAPE) //$NON-NLS-1$//$NON-NLS-2$
.append("ORDER BY FKTABLE_NAME, KEY_SEQ").toString(); //$NON-NLS-1$
private final static String QUERY_EXPORTED_KEYS = new StringBuffer(QUERY_REFERENCE_KEYS)
.append(" WHERE UCASE(PKTABLE_CAT)").append(LIKE_ESCAPE) //$NON-NLS-1$
.append(" AND UCASE(PKTABLE_SCHEM)").append(LIKE_ESCAPE) //$NON-NLS-1$
.append(" AND UCASE(PKTABLE_NAME)").append(LIKE_ESCAPE).append("ORDER BY FKTABLE_NAME, KEY_SEQ").toString(); //$NON-NLS-1$//$NON-NLS-2$
private final static String QUERY_IMPORTED_KEYS = new StringBuffer(QUERY_REFERENCE_KEYS)
.append(" WHERE UCASE(FKTABLE_CAT)").append(LIKE_ESCAPE) //$NON-NLS-1$
.append(" AND UCASE(FKTABLE_SCHEM)").append(LIKE_ESCAPE) //$NON-NLS-1$
.append(" AND UCASE(FKTABLE_NAME)").append(LIKE_ESCAPE).append("ORDER BY PKTABLE_NAME, KEY_SEQ").toString(); //$NON-NLS-1$//$NON-NLS-2$
/* Note that we're retrieving length as DATA_TYPE. Once retrieved when then correct this.
* This allows us to reuse the ResultSetMetadata.
*/
private final static String QUERY_COLUMNS = new StringBuffer("SELECT VDBName AS TABLE_CAT") //$NON-NLS-1$
.append(", SchemaName AS TABLE_SCHEM, TableName AS TABLE_NAME, Name AS COLUMN_NAME") //$NON-NLS-1$
.append(", Length AS DATA_TYPE") //$NON-NLS-1$
.append(", DataType AS TYPE_NAME") //$NON-NLS-1$
.append(", e.Precision AS COLUMN_SIZE") //$NON-NLS-1$
.append(", NULL AS BUFFER_LENGTH, Scale AS DECIMAL_DIGITS, Radix AS NUM_PREC_RADIX") //$NON-NLS-1$
.append(", convert(decodeString(NullType, '").append(NULLABILITY_MAPPING).append("', ','), integer) AS NULLABLE") //$NON-NLS-1$ //$NON-NLS-2$
.append(", Description AS REMARKS, DefaultValue AS COLUMN_DEF, NULL AS SQL_DATA_TYPE, NULL AS SQL_DATETIME_SUB") //$NON-NLS-1$
.append(", CharOctetLength AS CHAR_OCTET_LENGTH, Position AS ORDINAL_POSITION") //$NON-NLS-1$
.append(", " + IS_NULLABLE) //$NON-NLS-1$
.append(", NULL AS SCOPE_CATALOG, NULL AS SCOPE_SCHEMA, NULL AS SCOPE_TABLE, NULL AS SOURCE_DATA_TYPE, CASE WHEN e.IsAutoIncremented = 'true' THEN 'YES' ELSE 'NO' END AS IS_AUTOINCREMENT") //$NON-NLS-1$
.append(" FROM ").append(RUNTIME_MODEL.VIRTUAL_MODEL_NAME) //$NON-NLS-1$
.append(".Columns e") //$NON-NLS-1$
.append(" WHERE UCASE(SchemaName)").append(LIKE_ESCAPE)//$NON-NLS-1$
.append("AND UCASE(TableName)") .append(LIKE_ESCAPE) //$NON-NLS-1$
.append("AND UCASE(Name)").append(LIKE_ESCAPE) //$NON-NLS-1$
.append("AND UCASE(VDBName)").append(LIKE_ESCAPE) //$NON-NLS-1$
.append(" ORDER BY TABLE_NAME, ORDINAL_POSITION").toString(); //$NON-NLS-1$
private static final String QUERY_INDEX_INFO_CARDINALITY =
new StringBuffer("SELECT VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME") //$NON-NLS-1$
.append(", FALSE AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, null AS INDEX_NAME") //$NON-NLS-1$
.append(", 0 AS TYPE, cast(0 as short) AS ORDINAL_POSITION, null AS COLUMN_NAME") //$NON-NLS-1$
.append(", NULL AS ASC_OR_DESC, CARDINALITY, 1 AS PAGES, NULL AS FILTER_CONDITION") //$NON-NLS-1$
.append(" FROM ").append(RUNTIME_MODEL.VIRTUAL_MODEL_NAME).append(".Tables t") //$NON-NLS-1$ //$NON-NLS-2$
.append(" WHERE Cardinality > -1") //$NON-NLS-1$
.append(" AND UCASE(VDBName)").append(LIKE_ESCAPE)//$NON-NLS-1$
.append(" AND UCASE(SchemaName)").append(LIKE_ESCAPE)//$NON-NLS-1$
.append(" AND UCASE(Name)") .append(LIKE_ESCAPE).toString(); //$NON-NLS-1$
private static final String QUERY_PRIMARY_KEYS =
new StringBuffer("SELECT VDBName as TABLE_CAT, SchemaName AS TABLE_SCHEM, TableName AS TABLE_NAME") //$NON-NLS-1$
.append(", k.Name AS COLUMN_NAME, convert(Position, short) AS KEY_SEQ, KeyName AS PK_NAME") //$NON-NLS-1$
.append(" FROM ").append(RUNTIME_MODEL.VIRTUAL_MODEL_NAME).append(".KeyColumns k") //$NON-NLS-1$ //$NON-NLS-2$
.append(" WHERE UCASE(VDBName)").append(LIKE_ESCAPE)//$NON-NLS-1$
.append(" AND UCASE(SchemaName)").append(LIKE_ESCAPE)//$NON-NLS-1$
.append(" AND UCASE(TableName)") .append(LIKE_ESCAPE) //$NON-NLS-1$
.append(" AND KeyType LIKE 'Primary'") //$NON-NLS-1$
.append(" ORDER BY COLUMN_NAME, KEY_SEQ").toString(); //$NON-NLS-1$
private final static String QUERY_PROCEDURES =
new StringBuffer("SELECT VDBName AS PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM") //$NON-NLS-1$
.append(", p.Name AS PROCEDURE_NAME, convert(null, string) AS RESERVED_1") //$NON-NLS-1$
.append(", convert(null, string) AS RESERVED_2, convert(null, string) AS RESERVED_3, p.Description AS REMARKS") //$NON-NLS-1$
.append(", convert(decodeString(p.ReturnsResults, 'true, ").append(DatabaseMetaData.procedureReturnsResult) //$NON-NLS-1$
.append(", false, ").append(DatabaseMetaData.procedureNoResult).append("'), short) AS PROCEDURE_TYPE, p.Name AS SPECIFIC_NAME FROM ") //$NON-NLS-1$ //$NON-NLS-2$
.append(RUNTIME_MODEL.VIRTUAL_MODEL_NAME).append(".Procedures as p") //$NON-NLS-1$
.append(" WHERE UCASE(VDBName)").append(LIKE_ESCAPE)//$NON-NLS-1$
.append(" AND UCASE(SchemaName)").append(LIKE_ESCAPE)//$NON-NLS-1$
.append(" AND UCASE(p.Name)").append(LIKE_ESCAPE) //$NON-NLS-1$
.append(" ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME").toString(); //$NON-NLS-1$
private static final String QUERY_SCHEMAS =
new StringBuffer("SELECT Name AS TABLE_SCHEM, VDBName AS TABLE_CATALOG") //$NON-NLS-1$
.append(" FROM ").append(RUNTIME_MODEL.VIRTUAL_MODEL_NAME).append(".Schemas") //$NON-NLS-1$ //$NON-NLS-2$
.append(" WHERE UCASE(VDBName)").append(LIKE_ESCAPE)//$NON-NLS-1$
.append(" AND UCASE(Name)").append(LIKE_ESCAPE)//$NON-NLS-1$
.append(" ORDER BY TABLE_SCHEM").toString(); //$NON-NLS-1$
@Since(Version.TEIID_8_9)
private static final String QUERY_FUNCTIONS = new StringBuffer("SELECT VDBName AS Function_CAT, SchemaName AS FUNCTION_SCHEM, " //$NON-NLS-1$
+ "Name AS FUNCTION_NAME, Description as REMARKS, 1 as FUNCTION_TYPE, UID AS SPECIFIC_NAME") //$NON-NLS-1$
.append(" FROM ").append(RUNTIME_MODEL.VIRTUAL_MODEL_NAME).append(".Functions") //$NON-NLS-1$ //$NON-NLS-2$
.append(" WHERE UCASE(VDBName)").append(LIKE_ESCAPE)//$NON-NLS-1$
.append(" AND UCASE(SchemaName)").append(LIKE_ESCAPE)//$NON-NLS-1$
.append(" AND UCASE(Name)").append(LIKE_ESCAPE)//$NON-NLS-1$
.append(" ORDER BY FUNCTION_CAT, FUNCTION_SCHEM, FUNCTION_NAME, SPECIFIC_NAME").toString(); //$NON-NLS-1$
@Since(Version.TEIID_8_9)
private static final String QUERY_FUNCTION_COLUMNS = new StringBuffer("SELECT VDBName AS Function_CAT, SchemaName AS FUNCTION_SCHEM, ") //$NON-NLS-1$
.append("FunctionName AS FUNCTION_NAME, Name as COLUMN_NAME, CASE WHEN Type = 'ReturnValue' Then 4 WHEN Type = 'In' Then 1 ELSE 0 END AS COLUMN_TYPE") //$NON-NLS-1$
.append(", 1 AS DATA_TYPE") //$NON-NLS-1$
.append(", DataType AS TYPE_NAME, \"Precision\" AS \"PRECISION\", TypeLength AS LENGTH, convert(case when scale > 32767 then 32767 else Scale end, short) AS SCALE") //$NON-NLS-1$
.append(", Radix AS RADIX, convert(decodeString(NullType, '") //$NON-NLS-1$
.append(PROC_COLUMN_NULLABILITY_MAPPING).append("', ','), integer) AS NULLABLE") //$NON-NLS-1$
.append(", Description AS REMARKS, NULL AS CHAR_OCTET_LENGTH, Position AS ORDINAL_POSITION,") //$NON-NLS-1$
.append(IS_NULLABLE).append(", FunctionUID as SPECIFIC_NAME") //$NON-NLS-1$
.append(" FROM ").append(RUNTIME_MODEL.VIRTUAL_MODEL_NAME).append(".FunctionParams") //$NON-NLS-1$ //$NON-NLS-2$
.append(" WHERE UCASE(VDBName)").append(LIKE_ESCAPE)//$NON-NLS-1$
.append(" AND UCASE(SchemaName)").append(LIKE_ESCAPE)//$NON-NLS-1$
.append(" AND UCASE(FunctionName)").append(LIKE_ESCAPE)//$NON-NLS-1$
.append(" AND UCASE(Name)").append(LIKE_ESCAPE)//$NON-NLS-1$
.append(" ORDER BY FUNCTION_CAT, FUNCTION_SCHEM, FUNCTION_NAME, SPECIFIC_NAME, ORDINAL_POSITION").toString(); //$NON-NLS-1$
private final String TABLE_TYPE;
private final String QUERY_TABLES;
// private static final String QUERY_UDT =
// new StringBuffer("SELECT NULL AS TYPE_CAT, v.Name AS TYPE_SCHEM, TypeName AS TYPE_NAME") //$NON-NLS-1$
// .append(", JavaClass AS CLASS_NAME, decodeString(JavaClass, '").append(UDT_NAME_MAPPING).append("', ',') AS DATA_TYPE") //$NON-NLS-1$ //$NON-NLS-2$
// .append(", Description AS REMARKS") //$NON-NLS-1$
// .append(", decodeString(BaseType, '").append(UDT_NAME_MAPPING).append("', ',') AS BASE_TYPE ") //$NON-NLS-1$ //$NON-NLS-2$
// .append(" FROM ").append(RUNTIME_MODEL.VIRTUAL_MODEL_NAME).append(".DataTypes CROSS JOIN ") //$NON-NLS-1$ //$NON-NLS-2$
// .append(RUNTIME_MODEL.VIRTUAL_MODEL_NAME).append(".VirtualDatabases v") //$NON-NLS-1$
// .append(" WHERE UCASE(v.Name)").append(LIKE_ESCAPE).append("AND UCASE(TypeName)").append(LIKE_ESCAPE).append("ORDER BY DATA_TYPE, TYPE_SCHEM, TYPE_NAME ").toString(); //$NON-NLS-1$
/** ATTRIBUTES */
// driver's connection object used in constructin this object.
private ConnectionImpl driverConnection;
/**
* <p>Constructor which initializes with the connection object on which metadata
* is sought
* @param driver's connection object.
* @throws SQLException if the connection is already closed.
*/
DatabaseMetaDataImpl(ConnectionImpl connection) {
super(connection.getTeiidVersion());
this.driverConnection = connection;
if (PropertiesUtils.getBooleanProperty(connection.getConnectionProps(), REPORT_AS_VIEWS, false)) {
TABLE_TYPE = "CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' WHEN IsPhysical <> 'true' AND UCASE(Type) = 'TABLE' THEN 'VIEW' ELSE UCASE(Type) END"; //$NON-NLS-1$
} else {
TABLE_TYPE = "CASE WHEN IsSystem = 'true' and UCASE(Type) = 'TABLE' THEN 'SYSTEM TABLE' ELSE UCASE(Type) END"; //$NON-NLS-1$
}
QUERY_TABLES = new StringBuffer("SELECT VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, Name AS TABLE_NAME") //$NON-NLS-1$
.append(", ").append(TABLE_TYPE).append(" AS TABLE_TYPE, Description AS REMARKS, NULL AS TYPE_CAT, NULL AS TYPE_SCHEM") //$NON-NLS-1$ //$NON-NLS-2$
.append(", NULL AS TYPE_NAME, NULL AS SELF_REFERENCING_COL_NAME, NULL AS REF_GENERATION, IsPhysical AS ISPHYSICAL") //$NON-NLS-1$
.append(" FROM ").append(RUNTIME_MODEL.VIRTUAL_MODEL_NAME).append(".Tables g ") //$NON-NLS-1$ //$NON-NLS-2$
.append(" WHERE UCASE(VDBName)").append(LIKE_ESCAPE)//$NON-NLS-1$
.append(" AND UCASE(SchemaName)").append(LIKE_ESCAPE)//$NON-NLS-1$
.append(" AND UCASE(Name)") .append(LIKE_ESCAPE).toString(); //$NON-NLS-1$
}
private boolean isTeiidVersionOrGreater(Version version) {
return getTeiidVersion().isGreaterThanOrEqualTo(version.get());
}
private DataTypeManagerService getDataTypeManager() {
return DataTypeManagerService.getInstance(getTeiidVersion());
}
/**
* <p>Checks whether the current user has the required security rights to call
* all the procedures returned by the method getProcedures.</p>
* @return true if the precedures are selectable else return false
*/
@Override
public boolean allProceduresAreCallable() throws SQLException {
return true;
}
@Override
public boolean allTablesAreSelectable() throws SQLException {
return true;
}
/**
* <p>Checks whether a DDL statement within a transaction forces the transaction
* to commit.</p>
* @return if so return true else return false.
* @throws SQLException Should never occur.
*/
@Override
public boolean dataDefinitionCausesTransactionCommit() throws SQLException {
return false;
}
/**
* <p>Checks whether a DDL statement within a transaction is ignored.</p>
* @return if so return true, else false
*/
@Override
public boolean dataDefinitionIgnoredInTransactions() throws SQLException {
return false;
}
/**
* <p>Indicates whether or not a visible row delete can be detected by
* calling ResultSet.rowDeleted(). If deletesAreDetected()
* returns false, then deleted rows are removed from the result set.
* @param type result set type, i.e. ResultSet.TYPE_XXX
* @return true if changes are detected by the resultset type
* @throws SQLException, should never occur
*/
@Override
public boolean deletesAreDetected(int type) throws SQLException {
return false;
}
/**
* <p>Did getMaxRowSize() include LONGVARCHAR and LONGVARBINARY
* blobs?</p>
* @return <code>true</code> if so; <code>false</code> otherwise
* @throws SQLException, should never occur
*/
@Override
public boolean doesMaxRowSizeIncludeBlobs() throws SQLException {
return false;
}
/**
* <p>Gets a description of a table's optimal set of columns that uniquely identifies a row.</p>
* @param name of the catalog from which metadata needs
* @param catalog name in which the table is present.
* @param schema name in which this table is present.
* @param table name whose best row identifier info is sought.
* @param int indicating the scope of the result.
* @param boolean indicating whether the nullable columns can be included.
* @return ResultSet object containing the bestrow indetifier info.
*/
@Override
public ResultSet getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) throws SQLException {
// here it always returns a empty result set, when this functionality
// is being changed make sure that we check the catelog & schema here
// to filter.
// list containing records/rows in the ResultSet
List records = new ArrayList (0);
/***********************************************************************
* Hardcoding JDBC column names for the columns returned in results object
***********************************************************************/
Map[] metadataList = new Map[8];
// HardCoding metadata details for SCOPE column
metadataList[0] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.BEST_ROW.SCOPE,
DataTypeManagerService.DefaultDataTypes.SHORT, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, driverConnection);
// HardCoding metadata details for COLUMN_NAME column
metadataList[1] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.BEST_ROW.COLUMN_NAME,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, driverConnection);
// HardCoding metadata details for DATA_TYPE column
metadataList[2] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.BEST_ROW.DATA_TYPE,
DataTypeManagerService.DefaultDataTypes.SHORT, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, driverConnection);
// HardCoding metadata details for TYPE_NAME column
metadataList[3] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.BEST_ROW.TYPE_NAME,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, driverConnection);
// HardCoding metadata details for COLUMN_SIZE column
metadataList[4] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.BEST_ROW.COLUMN_SIZE,
DataTypeManagerService.DefaultDataTypes.INTEGER, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, driverConnection);
// HardCoding metadata details for BUFFER_LENGTH column
metadataList[5] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.BEST_ROW.BUFFER_LENGTH,
DataTypeManagerService.DefaultDataTypes.INTEGER, ResultsMetadataConstants.NULL_TYPES.NULLABLE, driverConnection);
// HardCoding metadata details for DECIMAL_DIGITS column
metadataList[6] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.BEST_ROW.DECIMAL_DIGITS,
DataTypeManagerService.DefaultDataTypes.SHORT, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, driverConnection);
// HardCoding metadata details for PSEUDO_COLUMN column
metadataList[7] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.BEST_ROW.PSEUDO_COLUMN,
DataTypeManagerService.DefaultDataTypes.SHORT, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, driverConnection);
// logging
String logMsg = Messages.getString(Messages.JDBC.MMDatabaseMetadata_Best_row_sucess, table);
logger.fine(logMsg);
// construct results object from column values and their metadata
return dummyStatement().createResultSet(records, metadataList);
}
@Override
public ResultSet getCatalogs() throws SQLException {
// list containing records/rows in the ResultSet
List<List<String>> records = new ArrayList<List<String>> (1);
records.add(Arrays.asList(this.driverConnection.getCatalog()));
/***********************************************************************
* Hardcoding JDBC column names for the columns returned in results object
***********************************************************************/
Map[] metadataList = new Map[1];
// HardCoding metadata details for TABLE_CAT column
metadataList[0] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.CATALOGS.TABLE_CAT,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NULLABLE, driverConnection);
// logging
String logMsg = Messages.getString(Messages.JDBC.MMDatabaseMetadata_Catalog_success);
logger.fine(logMsg);
// construct results object from column values and their metadata
return dummyStatement().createResultSet(records, metadataList);
}
/**
* <p>Gets the String object used to separate a catalog name and a table name
* @return String delimiter
* @throws SQLException, should never occur.
*/
@Override
public String getCatalogSeparator() throws SQLException {
return "."; //$NON-NLS-1$
}
@Override
public String getCatalogTerm() throws SQLException {
return "VirtualDatabase"; //$NON-NLS-1$
}
/**
* <p>Gets a description of the access rights for a column of the given name.
* Catalog name should match the virtualdatabasename used to obtain
* this driver connection.</p>
* @param name of the catalog to which columns belong.
* @param name of the schema to which columns belong.
* @param name of the table to which columns belong.
* @param name pattern to be matched by column names.
* @return ResultSet containing column privilege information.
* @throws SQLException if there is an error obtaining server results
*/
@Override
public ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnName) throws SQLException {
List records = new ArrayList (0);
/***********************************************************************
* Hardcoding JDBC column names for the columns returned in results object
***********************************************************************/
Map[] metadataList = new Map[8];
metadataList[0] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.PRIVILEGES.TABLE_CAT,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NULLABLE, driverConnection);
metadataList[1] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.PRIVILEGES.TABLE_SCHEM,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NULLABLE, driverConnection);
metadataList[2] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.PRIVILEGES.TABLE_NAME,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, driverConnection);
metadataList[3] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.PRIVILEGES.COLUMN_NAME,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, driverConnection);
metadataList[4] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.PRIVILEGES.GRANTOR,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NULLABLE, driverConnection);
metadataList[5] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.PRIVILEGES.GRANTEE,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, driverConnection);
metadataList[6] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.PRIVILEGES.PRIVILEGE,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, driverConnection);
metadataList[7] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.PRIVILEGES.IS_GRANTABLE,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NULLABLE, driverConnection);
return dummyStatement().createResultSet(records, metadataList);
}
/**
* <p>Get's the metadata information about the columns whose names match the given
* columnNamePattern. Catalog names should match the
* virtualdatabasename used to obtain this driver connection.</p>
* <p> The ResultSet returned by this method contains the following additional
* columns that are not specified in the JDBC specification.</p>
* <OL>
* <LI><B>Format</B> String => format of the column
* <LI><B>MinRange</B> String => minimum range value of the column
* <LI><B>MaxRange</B> String => maximum range value of the column
* <OL>
* @param catalog name to which the columns belong.
* @param schema name to which the columns belong.
* @param pattern name to be matched by table name.
* @param pattern name to be matched by column name.
* @return ResultSet containing column metadata info.
* @throws SQLException if there is an error obtaining server results.
*/
@Override
public ResultSet getColumns(String catalog, String schema, String tableNamePattern, String columnNamePattern) throws SQLException {
if (catalog == null) {
catalog = PERCENT;
}
if (schema == null) {
schema = PERCENT;
}
// Get columns in all the tables if tableNamePattern is null
if(tableNamePattern == null) {
tableNamePattern = PERCENT;
}
// Get all columns if columnNamePattern is null
if(columnNamePattern == null) {
columnNamePattern = PERCENT;
}
// list which represent records containing column info
List records = new ArrayList ();
ResultSetMetaData rmetadata = null;
ResultSetImpl results = null;
PreparedStatement prepareQuery = null;
try {
prepareQuery = driverConnection.prepareStatement(QUERY_COLUMNS);
prepareQuery.setObject(1, schema.toUpperCase());
prepareQuery.setObject(2, tableNamePattern.toUpperCase());
prepareQuery.setObject(3, columnNamePattern.toUpperCase());
prepareQuery.setObject(4, catalog.toUpperCase());
// make a query against runtimemetadata and get results
results = (ResultSetImpl) prepareQuery.executeQuery();
// build the list of records of column description
while (results.next ()) {
// list represents a record on the Results object.
List currentRow = new ArrayList(JDBCColumnPositions.COLUMNS.MAX_COLUMNS);
// add values in the current record on the Results object to the list
// number of values to be fetched from each row is MAX_COLUMNS.
for(int i=0; i < JDBCColumnPositions.COLUMNS.MAX_COLUMNS; i++) {
// get the value at the current index add it to currentRow
currentRow.add(results.getObject(i+1));
}
String typeName = (String)currentRow.get(JDBCColumnPositions.COLUMNS.TYPE_NAME-1);
Integer length = (Integer)currentRow.get(JDBCColumnPositions.COLUMNS.DATA_TYPE-1);
Integer precision = (Integer)currentRow.get(JDBCColumnPositions.COLUMNS.COLUMN_SIZE-1);
if (typeName != null) {
currentRow.set(JDBCColumnPositions.COLUMNS.DATA_TYPE-1, JDBCSQLTypeInfo.getSQLType(getTeiidVersion(), typeName));
if (!Number.class.isAssignableFrom(getDataTypeManager().getDataTypeClass(typeName))) {
if (length != null && length <= 0) {
currentRow.set(JDBCColumnPositions.COLUMNS.COLUMN_SIZE-1, JDBCSQLTypeInfo.getDefaultPrecision(getTeiidVersion(), typeName));
} else {
currentRow.set(JDBCColumnPositions.COLUMNS.COLUMN_SIZE-1, length);
}
} else if (precision != null && precision <= 0) {
currentRow.set(JDBCColumnPositions.COLUMNS.COLUMN_SIZE-1, JDBCSQLTypeInfo.getDefaultPrecision(getTeiidVersion(), typeName));
}
} else {
currentRow.set(JDBCColumnPositions.COLUMNS.DATA_TYPE-1, null);
currentRow.set(JDBCColumnPositions.COLUMNS.COLUMN_SIZE-1, null);
}
records.add(currentRow);
}// end of while
// get the metadata for the results
rmetadata = results.getMetaData();
// logging
String logMsg = Messages.getString(Messages.JDBC.MMDatabaseMetadata_getCols_success, columnNamePattern, tableNamePattern);
logger.fine(logMsg);
// construct results object from column values and their metadata
return dummyStatement().createResultSet(records, rmetadata);
} catch(Exception e) {
// logging
String logMsg = Messages.getString(Messages.JDBC.MMDatabaseMetadata_getCols_error, columnNamePattern, tableNamePattern, e.getMessage());
throw new SQLException(logMsg, e);
} finally {
if (prepareQuery != null) {
prepareQuery.close();
}
}
}
/**
* <p>Gets the description of the foreign key columns in the table foreignTable.
* These foreign key columns reference primary key columns of primaryTable.
* Catalog names(primary and foreign) should match the
* virtualdatabasename used to obtain this driver connection.
* @param name of the catalog containing primary keys.
* @param name of the schema containing primary keys.
* @param name of the table containing primary keys.
* @param name of the catalog containing foreign keys.
* @param name of the schema containing foreign keys.
* @param name of the table containing foreign keys.
* @return ResultSet giving description of foreign key columns.
* @throws SQLException if there is an error obtaining server results
*/
@Override
public ResultSet getCrossReference(String primaryCatalog, String primarySchema,String primaryTable,String foreignCatalog,String foreignSchema, String foreignTable) throws SQLException {
if (primaryCatalog == null) {
primaryCatalog = PERCENT;
}
if (foreignCatalog == null) {
foreignCatalog = PERCENT;
}
if (primarySchema == null) {
primarySchema = PERCENT;
}
if (foreignSchema == null) {
foreignSchema = PERCENT;
}
if (primaryTable == null) {
primaryTable = PERCENT;
}
if (foreignTable == null) {
foreignTable = PERCENT;
}
ResultSet results = null;
PreparedStatement prepareQuery = null;
try {
prepareQuery = driverConnection.prepareStatement(QUERY_CROSS_REFERENCES);
prepareQuery.setObject(1, primaryCatalog.toUpperCase());
prepareQuery.setObject(2, foreignCatalog.toUpperCase());
prepareQuery.setObject(3, primarySchema.toUpperCase());
prepareQuery.setObject(4, foreignSchema.toUpperCase());
prepareQuery.setObject(5, primaryTable.toUpperCase());
prepareQuery.setObject(6, foreignTable.toUpperCase());
// make a query against runtimemetadata and get results
results = prepareQuery.executeQuery();
ResultSet resultSet = getReferenceKeys(results);
// logging
String logMsg = Messages.getString(Messages.JDBC.MMDatabaseMetadata_getCrossRef_success, primaryTable, foreignTable);
logger.fine(logMsg);
return resultSet;
} catch(Exception e) {
// logging
String logMsg = Messages.getString(Messages.JDBC.MMDatabaseMetadata_getCrossRef_error, primaryTable, foreignTable, e.getMessage());
throw new SQLException(logMsg, e);
} finally {
if (prepareQuery != null) {
prepareQuery.close();
}
}
}
/**
* Retrieves the minor version number of the underlying database.
* @return intValue of database's minor version
* @throws SQLException if a database access error occurs.
*/
@Override
public int getDatabaseMinorVersion() throws SQLException {
return TeiidDriver.getInstance().getMinorVersion();
}
/**
* Retrieves the major version number of the underlying database.
* @return intValue of database's minor version
* @throws SQLException if a database access error occurs.
*/
@Override
public int getDatabaseMajorVersion() throws SQLException {
return TeiidDriver.getInstance().getMajorVersion();
}
/**
* Retrieves the major JDBC version number for this driver.
* @return intValue JDBC major version number
* @throws SQLException should never occur.
*/
@Override
public int getJDBCMajorVersion() throws SQLException {
return 3;
}
/**
* Retrieves the minor JDBC version number for this driver.
* @return intValue JDBC major version number
* @throws SQLException should never occur.
*/
@Override
public int getJDBCMinorVersion() throws SQLException {
return 0;
}
/**
* <p>Gets the product name for this database
* @return String representing the product name
* @throws SQLException should never occur.
*/
@Override
public String getDatabaseProductName() throws SQLException {
return this.driverConnection.getDatabaseName();
}
@Override
public String getDatabaseProductVersion() throws SQLException {
return TeiidDriver.getInstance().getMajorVersion() + "." + TeiidDriver.getInstance().getMinorVersion(); //$NON-NLS-1$
}
@Override
public int getDefaultTransactionIsolation() throws SQLException {
return ConnectionImpl.DEFAULT_ISOLATION;
}
/**
* <p>Gets this drivers major version number
* @return int representing the driver's major version
*/
@Override
public int getDriverMajorVersion() {
return TeiidDriver.getInstance().getMajorVersion();
}
/**
* <p>Gets this drivers minor version number
* @return int representing the driver's minor version
*/
@Override
public int getDriverMinorVersion() {
return TeiidDriver.getInstance().getMinorVersion();
}
/**
* <p>Get the name of this JDBC driver
* @return String representing the driver's name
* @throws SQLException, if the connection is already closed.
*/
@Override
public String getDriverName() throws SQLException {
return TeiidDriver.getInstance().getDriverName();
}
/**
* <p>This method gets the version of this JDBC driver. It combines the major
* and minor version numbers
* @return String representing the driver's version
* @throws SQLException, should never occur.
*/
@Override
public String getDriverVersion() throws SQLException {
return getDriverMajorVersion()+"."+getDriverMinorVersion (); //$NON-NLS-1$
}
@Override
public ResultSet getExportedKeys(String catalog, String schema, String table) throws SQLException {
if (catalog == null) {
catalog = PERCENT;
}
if (schema == null) {
schema = PERCENT;
}
if (table == null) {
table = PERCENT;
}
ResultSet results = null;
PreparedStatement prepareQuery = null;
try {
prepareQuery = driverConnection.prepareStatement(QUERY_EXPORTED_KEYS);
prepareQuery.setObject(1, catalog.toUpperCase());
prepareQuery.setObject(2, schema.toUpperCase());
prepareQuery.setObject(3, table.toUpperCase());
// make a query against runtimemetadata and get results
results = prepareQuery.executeQuery();
ResultSet resultSet = getReferenceKeys(results);
logger.fine(Messages.getString(Messages.JDBC.MMDatabaseMetadata_getExpKey_success, table));
return resultSet;
} catch(Exception e) {
// logging
String logMsg = Messages.getString(Messages.JDBC.MMDatabaseMetadata_getExpKey_error, table, e.getMessage());
throw new SQLException(logMsg, e);
} finally {
if (prepareQuery != null) {
prepareQuery.close();
}
}
}
/**
* <p>Gets the extra characters that can be used in unquoted identifier names
* (those beyond a-z, 0-9, and _)
* @return String representing extra charachters that can be used in identifier names.
* @throws SQLException, should never occur
*/
@Override
public String getExtraNameCharacters() throws SQLException {
return EXTRA_CHARS;// ".@" is use in fully qualified identifier names
}
/**
* <p>Get's the string used to quote SQL identifiers. This returns a " " if identifier
* quoting is not supported.
* @return string used to quote SQL identifiers.
* @throws SQLException, should never occur
*/
@Override
public String getIdentifierQuoteString() throws SQLException {
return DOUBLE_QUOTE;
}
@Override
public ResultSet getImportedKeys(String catalog, String schema, String table) throws SQLException {
if (catalog == null) {
catalog = PERCENT;
}
if (schema == null) {
schema = PERCENT;
}
if (table == null) {
table = PERCENT;
}
ResultSet results = null;
PreparedStatement prepareQuery = null;
try {
prepareQuery = driverConnection.prepareStatement(QUERY_IMPORTED_KEYS);
prepareQuery.setObject(1, catalog.toUpperCase());
prepareQuery.setObject(2, schema.toUpperCase());
prepareQuery.setObject(3, table.toUpperCase());
// make a query against runtimemetadata and get results
results = prepareQuery.executeQuery();
ResultSet resultSet = getReferenceKeys(results);
logger.fine(Messages.getString(Messages.JDBC.MMDatabaseMetadata_getImpKey_success, table));
return resultSet;
} catch(Exception e) {
String logMsg = Messages.getString(Messages.JDBC.MMDatabaseMetadata_getImpKey_error, table, e.getMessage());
throw new SQLException(logMsg, e);
} finally {
if (prepareQuery != null) {
prepareQuery.close();
}
}
}
private String getQueryIndexInfoStatement() {
StringBuffer buf = new StringBuffer();
buf.append("SELECT VDBName AS TABLE_CAT, SchemaName AS TABLE_SCHEM, TableName AS TABLE_NAME") //$NON-NLS-1$
.append(", case when KeyType = 'Index' then TRUE else FALSE end AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, KeyName AS INDEX_NAME"); //$NON-NLS-1$
if (isTeiidVersionOrGreater(Version.TEIID_8_7))
buf.append(", 3 AS TYPE, convert(Position, short) AS ORDINAL_POSITION, k.Name AS COLUMN_NAME"); //$NON-NLS-1$
else
buf.append(", 0 AS TYPE, convert(Position, short) AS ORDINAL_POSITION, k.Name AS COLUMN_NAME"); //$NON-NLS-1$
buf.append(", NULL AS ASC_OR_DESC, 0 AS CARDINALITY, 1 AS PAGES, NULL AS FILTER_CONDITION") //$NON-NLS-1$
.append(" FROM ").append(RUNTIME_MODEL.VIRTUAL_MODEL_NAME).append(".KeyColumns k") //$NON-NLS-1$ //$NON-NLS-2$
.append(" WHERE UCASE(VDBName)").append(LIKE_ESCAPE)//$NON-NLS-1$
.append(" AND UCASE(SchemaName)").append(LIKE_ESCAPE)//$NON-NLS-1$
.append(" AND UCASE(TableName)") .append(LIKE_ESCAPE); //$NON-NLS-1$
if (isTeiidVersionOrGreater(Version.TEIID_8_7))
buf.append(" AND KeyType IN ('Unique', ?)"); //$NON-NLS-1$
else
buf.append(" AND KeyType IN ('Index', ?)"); //$NON-NLS-1$
buf.append(" ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION").toString(); //$NON-NLS-1$
return buf.toString();
}
private String getQueryProcedureColumns() {
StringBuffer buf = new StringBuffer();
buf.append("SELECT VDBName PROCEDURE_CAT, SchemaName AS PROCEDURE_SCHEM") //$NON-NLS-1$
.append(", ProcedureName AS PROCEDURE_NAME, p.Name AS COLUMN_NAME") //$NON-NLS-1$
.append(", convert(decodeString(TYPE, '").append(PARAM_DIRECTION_MAPPING).append("', ','), short) AS COLUMN_TYPE") //$NON-NLS-1$ //$NON-NLS-2$
.append(", 1 AS DATA_TYPE"); //$NON-NLS-1$
if (isTeiidVersionOrGreater(Version.TEIID_8_7))
buf.append(", DataType AS TYPE_NAME, p.Precision AS \"PRECISION\", TypeLength AS LENGTH, convert(case when scale > 32767 then 32767 else Scale end, short) AS SCALE"); //$NON-NLS-1$
else
buf.append(", DataType AS TYPE_NAME, p.Precision AS \"PRECISION\", TypeLength AS LENGTH, convert(Scale, short) AS SCALE"); //$NON-NLS-1$
buf.append(", Radix AS RADIX, convert(decodeString(NullType, '") //$NON-NLS-1$
.append(PROC_COLUMN_NULLABILITY_MAPPING).append("', ','), integer) AS NULLABLE") //$NON-NLS-1$
.append(", p.Description AS REMARKS, NULL AS COLUMN_DEF") //$NON-NLS-1$
.append(", NULL AS SQL_DATA_TYPE, NULL AS SQL_DATETIME_SUB, NULL AS CHAR_OCTET_LENGTH, p.Position AS ORDINAL_POSITION") //$NON-NLS-1$
.append(", "+IS_NULLABLE+", p.ProcedureName as SPECIFIC_NAME FROM ") //$NON-NLS-1$ //$NON-NLS-2$
.append(RUNTIME_MODEL.VIRTUAL_MODEL_NAME)
.append(".ProcedureParams as p") //$NON-NLS-1$
.append(" WHERE UCASE(VDBName)").append(LIKE_ESCAPE)//$NON-NLS-1$
.append(" AND UCASE(SchemaName)").append(LIKE_ESCAPE)//$NON-NLS-1$
.append(" AND UCASE(ProcedureName)").append(LIKE_ESCAPE) //$NON-NLS-1$
.append(" AND UCASE(p.Name)").append(LIKE_ESCAPE) //$NON-NLS-1$
.append(" ORDER BY PROCEDURE_SCHEM, PROCEDURE_NAME, COLUMN_TYPE, POSITION").toString(); //$NON-NLS-1$
return buf.toString();
}
@Override
public ResultSet getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) throws SQLException {
if (catalog == null) {
catalog = PERCENT;
}
if (schema == null) {
schema = PERCENT;
}
if (table == null) {
table = PERCENT;
}
// list which represent records containing primary key info
List records = new ArrayList ();
ResultSetMetaData rmetadata = null;
ResultSetImpl results = null;
PreparedStatement prepareQuery = null;
try {
String query = getQueryIndexInfoStatement();
if (isTeiidVersionOrGreater(Version.TEIID_8_8)) {
if (approximate) {
query += " UNION ALL " + QUERY_INDEX_INFO_CARDINALITY;
}
query += " ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION";
}
prepareQuery = driverConnection.prepareStatement(query);
prepareQuery.setObject(1, catalog.toUpperCase());
prepareQuery.setObject(2, schema.toUpperCase());
prepareQuery.setObject(3, table.toUpperCase());
if (isTeiidVersionOrGreater(Version.TEIID_8_7))
prepareQuery.setObject(4, unique?null:"Index"); //$NON-NLS-1$
else
prepareQuery.setObject(4, unique?null:"NonUnique"); //$NON-NLS-1$
if (isTeiidVersionOrGreater(Version.TEIID_8_8)) {
if (approximate) {
prepareQuery.setObject(5, catalog.toUpperCase());
prepareQuery.setObject(6, schema.toUpperCase());
prepareQuery.setObject(7, table.toUpperCase());
}
}
// make a query against runtimemetadata and get results
results = (ResultSetImpl) prepareQuery.executeQuery();
// build the list of records from server's Results object.
while (results.next ()) {
// list represents a record on the Results object.
List currentRow = new ArrayList (13);
// add values in the current record on the Results object to the list
// number of values to be fetched from each row is MAX_COLUMNS.
for(int i=0; i < JDBCColumnPositions.INDEX_INFO.MAX_COLUMNS; i++) {
// get the value at the current index add it to currentRow
currentRow.add(results.getObject(i+1));
}
// add the current row to the list of records.
records.add(currentRow);
}// end of while
// get the metadata for the results
rmetadata = results.getMetaData();
logger.fine(Messages.getString(Messages.JDBC.MMDatabaseMetadata_getIndex_success, table));
// construct results object from column values and their metadata
return dummyStatement().createResultSet(records, rmetadata);
} catch (Exception e) {
throw new SQLException(Messages.getString(Messages.JDBC.MMDatabaseMetadata_getIndex_error, table, e.getMessage()), e);
} finally {
if (prepareQuery != null) {
prepareQuery.close();
}
}
}
/**
* <p>Gets the maximum number of hexadecimal characters allowed in an inline
* binary literal
* @return int value giving maximum length of a binary literal
* @throws SQLException, should never occur
*/
@Override
public int getMaxBinaryLiteralLength() throws SQLException {
return NO_LIMIT;
}
/**
* <p>Gets the maximum number of characters allowed in a catalog name
* @return int value giving maximum length of a catalog name
* @throws SQLException, should never occur
*/
@Override
public int getMaxCatalogNameLength() throws SQLException {
return MAX_CATALOG_NAME_LENGTH;
}
/**
* <p>Gets the maximum number of characters allowed in a character literal
* @return int value giving maximum length of a charachter literal
* @throws SQLException, should never occur
*/
@Override
public int getMaxCharLiteralLength() throws SQLException {
return NO_LIMIT;
}
/**
* <p>Gets the maximum number of characters allowed in a column name
* @return int value giving maximum length of the column name
* @throws SQLException, should never occur
*/
@Override
public int getMaxColumnNameLength() throws SQLException {
return MAX_COLUMN_NAME_LENGTH;
}
/**
* <p>Gets the maximum number of columns allowed in a GROUP BY clause
* @return int values giving max columns in GROUP BY
* @throws SQLException, should never occur
*/
@Override
public int getMaxColumnsInGroupBy() throws SQLException {
return NO_LIMIT;
}
/**
* <p>Gets the maximum number of columns allowed in an index
* @return int gives maximum columns in an index.
* @throws SQLException, should never occur
*/
@Override
public int getMaxColumnsInIndex() throws SQLException {
return NO_LIMIT;
}
/**
* <p>Gets the maximum number of columns allowed in a ORDER BY clause
* @return int gives maximum columns in an order by.
* @throws SQLException, should never occur
*/
@Override
public int getMaxColumnsInOrderBy() throws SQLException {
return NO_LIMIT;
}
/**
* <p>Gets the maximum number of columns allowed in a SELECT clause
* @return int gives maximum columns in a select.
* @throws SQLException, should never occur
*/
@Override
public int getMaxColumnsInSelect() throws SQLException {
return NO_LIMIT;
}
@Override
public int getMaxColumnsInTable() throws SQLException {
return NO_LIMIT;
}
@Override
public int getMaxConnections() throws SQLException {
return NO_LIMIT;
}
@Override
public int getMaxCursorNameLength() throws SQLException {
return NO_LIMIT;
}
@Override
public int getMaxIndexLength() throws SQLException {
return NO_LIMIT;
}
/**
* <p>Gets the maximum number of characters allowed in a procedure name
* @return int gives maximum length of procedure name.
* @throws SQLException, should never occur
*/
@Override
public int getMaxProcedureNameLength() throws SQLException {
return MAX_PROCEDURE_NAME_LENGTH;
}
/**
* <p>Gets the maximum number of bytes allowed in a single row
* @return int max row size in the result set.
* @throws SQLException, should never occur
*/
@Override
public int getMaxRowSize() throws SQLException {
return NO_LIMIT;
}
/**
* <p>Gets the maximum number of characters allowed in a schema name
* @return int maximum length of a schema.
* @throws SQLException, should never occur
*/
@Override
public int getMaxSchemaNameLength() throws SQLException {
return NO_LIMIT;
}
/**
* <p>Gets the maximum number of characters allowed in an SQL statement
* @return maximum length of a statement
* @throws SQLException, should never occur
*/
@Override
public int getMaxStatementLength() throws SQLException {
return NO_LIMIT;
}
/**
* <p>Gets the maximum number of active statements that may be open on one
* connection at any time
* @return max number of open statements on a connection.
* @throws SQLException, should never occur
*/
@Override
public int getMaxStatements() throws SQLException {
return NO_LIMIT;
}
/**
* <p>Gets the maximum number of characters allowed in a table name
* @return max length of table name.
* @throws SQLException, should never occur
*/
@Override
public int getMaxTableNameLength() throws SQLException {
return MAX_TABLE_NAME_LENGTH;
}
/**
* <p>Gets the maximum number of tables allowed in a SELECT clause
* @return max tables in a select.
* @throws SQLException, should never occur
*/
@Override
public int getMaxTablesInSelect() throws SQLException {
return NO_LIMIT;
}
/**
* <p>Gets the maximum number of characters allowed in a user name
* @return max length of user name.
* @throws SQLException, should never occur
*/
@Override
public int getMaxUserNameLength() throws SQLException {
return MAX_USER_NAME_LENGTH;
}
@Override
public String getNumericFunctions() throws SQLException {
return NUMERIC_FUNCTIONS;
}
@Override
public ResultSet getPrimaryKeys(String catalog, String schema, String table) throws SQLException {
if (catalog == null) {
catalog = PERCENT;
}
if (schema == null) {
schema = PERCENT;
}
if (table == null) {
table = PERCENT;
}
// list which represent records containing primary key info
List records = new ArrayList ();
ResultSetMetaData rmetadata = null;
ResultSetImpl results = null;
PreparedStatement prepareQuery = null;
try {
prepareQuery = driverConnection.prepareStatement(QUERY_PRIMARY_KEYS);
prepareQuery.setObject(1, catalog.toUpperCase());
prepareQuery.setObject(2, schema.toUpperCase());
prepareQuery.setObject(3, table.toUpperCase());
// make a query against runtimemetadata and get results
results = (ResultSetImpl) prepareQuery.executeQuery();
// build the list of records from server's Results object.
while (results.next ()) {
// list represents a record on the Results object.
List currentRow = new ArrayList (7);
// add values in the current record on the Results object to the list
// number of values to be fetched from each row is MAX_COLUMNS.
for(int i=0; i < JDBCColumnPositions.PRIMARY_KEYS.MAX_COLUMNS; i++) {
// get the value at the current index add it to currentRow
currentRow.add(results.getObject(i+1));
}
// add the current row to the list of records.
records.add(currentRow);
}// end of while
// get the metadata for the results
rmetadata = results.getMetaData();
logger.fine(Messages.getString(Messages.JDBC.MMDatabaseMetadata_getPrimaryKey_success));
// construct results object from column values and their metadata
return dummyStatement().createResultSet(records, rmetadata);
} catch (Exception e) {
throw new SQLException(Messages.getString(Messages.JDBC.MMDatabaseMetadata_getPrimaryKey_error, table, e.getMessage()), e);
} finally {
if (prepareQuery != null) {
prepareQuery.close();
}
}
}
@Override
public ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) throws SQLException {
if (catalog == null) {
catalog = PERCENT;
}
if (schemaPattern == null) {
schemaPattern = PERCENT;
}
// Get all columns in all procedures if procedureNamePattern is null
if(procedureNamePattern == null) {
procedureNamePattern = PERCENT;
}
// Get all columns if columnNamePattern is null
if(columnNamePattern == null) {
columnNamePattern = PERCENT;
}
// list which represent records containing procedure column info
List records = new ArrayList ();
ResultSetMetaData rmetadata = null;
ResultSetImpl results = null;
PreparedStatement prepareQuery = null;
try {
prepareQuery = driverConnection.prepareStatement(getQueryProcedureColumns());
prepareQuery.setObject(1, catalog.toUpperCase());
prepareQuery.setObject(2, schemaPattern.toUpperCase());
prepareQuery.setObject(3, procedureNamePattern.toUpperCase());
prepareQuery.setObject(4, columnNamePattern.toUpperCase());
// make a query against runtimemetadata and get results
results = (ResultSetImpl) prepareQuery.executeQuery();
// build the list of records from server's Results object.
while (results.next ()) {
// list represents a record on the Results object.
List currentRow = new ArrayList (13);
// add values in the current record on the Results object to the list
// number of values to be fetched from each row is MAX_COLUMNS.
for(int i=0; i < JDBCColumnPositions.PROCEDURE_COLUMNS.MAX_COLUMNS; i++) {
// get the value at the current index add it to currentRow
currentRow.add(results.getObject(i+1));
}
String typeName = (String)currentRow.get(JDBCColumnPositions.PROCEDURE_COLUMNS.TYPE_NAME-1);
Integer length = (Integer)currentRow.get(JDBCColumnPositions.PROCEDURE_COLUMNS.LENGTH-1);
Integer precision = (Integer)currentRow.get(JDBCColumnPositions.PROCEDURE_COLUMNS.PRECISION-1);
if (precision != null && precision <= 0) {
currentRow.set(JDBCColumnPositions.PROCEDURE_COLUMNS.PRECISION-1, JDBCSQLTypeInfo.getDefaultPrecision(getTeiidVersion(), typeName));
}
if (length != null && length <= 0) {
currentRow.set(JDBCColumnPositions.PROCEDURE_COLUMNS.LENGTH-1, JDBCSQLTypeInfo.getDefaultPrecision(getTeiidVersion(), typeName));
}
if (typeName != null) {
currentRow.set(JDBCColumnPositions.PROCEDURE_COLUMNS.DATA_TYPE-1, JDBCSQLTypeInfo.getSQLType(getTeiidVersion(), typeName));
} else {
currentRow.set(JDBCColumnPositions.PROCEDURE_COLUMNS.DATA_TYPE-1, null);
}
// add the current row to the list of records.
records.add(currentRow);
}// end of while
rmetadata = results.getMetaData();
logger.fine(Messages.getString(Messages.JDBC.MMDatabaseMetadata_getProcCol_success, columnNamePattern, procedureNamePattern));
// construct results object from column values and their metadata
return dummyStatement().createResultSet(records, rmetadata);
} catch (Exception e) {
throw new SQLException(Messages.getString(Messages.JDBC.MMDatabaseMetadata_getProcCol_error, columnNamePattern, e.getMessage()), e);
} finally {
if (prepareQuery != null) {
prepareQuery.close();
}
}
}
@Override
public ResultSet getProcedures(String catalog, String schemaPattern, String procedureNamePattern) throws SQLException {
if (catalog == null) {
catalog = PERCENT;
}
if (schemaPattern == null) {
schemaPattern = PERCENT;
}
// Get all procedures if procedureNamePattern is null
if(procedureNamePattern == null) {
procedureNamePattern = PERCENT;
}
// list which represent records containing procedure info
List records = new ArrayList ();
ResultSetMetaData rmetadata = null;
ResultSetImpl results = null;
PreparedStatement prepareQuery = null;
try {
prepareQuery = driverConnection.prepareStatement(QUERY_PROCEDURES);
prepareQuery.setObject(1, catalog.toUpperCase());
prepareQuery.setObject(2, schemaPattern.toUpperCase());
prepareQuery.setObject(3, procedureNamePattern.toUpperCase());
// make a query against runtimemetadata and get results
results = (ResultSetImpl) prepareQuery.executeQuery();
// build the list of records from server's Results object.
while (results.next ()) {
// list represents a record on the Results object.
List currentRow = new ArrayList (JDBCColumnPositions.PROCEDURES.MAX_COLUMNS);
// add values in the current record on the Results object to the list
// number of values to be fetched from each row is MAX_COLUMNS.
// there are 3 columns are reserved for future use
for(int i=0; i < JDBCColumnPositions.PROCEDURES.MAX_COLUMNS; i++) {
// get the value at the current index add it to currentRow
currentRow.add(results.getObject(i+1));
}
// add the current row to the list of records.
records.add(currentRow);
}// end of while
// get the metadata for the results
rmetadata = results.getMetaData();
logger.fine(Messages.getString(Messages.JDBC.MMDatabaseMetadata_getProc_success, procedureNamePattern));
// construct results object from column values and their metadata
return dummyStatement().createResultSet(records, rmetadata);
} catch (Exception e) {
throw new SQLException(Messages.getString(Messages.JDBC.MMDatabaseMetadata_getProc_error, procedureNamePattern, e.getMessage()), e);
} finally {
if (prepareQuery != null) {
prepareQuery.close();
}
}
}
@Override
public String getProcedureTerm() throws SQLException {
return PROCEDURE_TERM;
}
@Override
public ResultSet getSchemas() throws SQLException {
return getSchemas(null, null);
}
@Override
public String getSchemaTerm() throws SQLException {
return SCHEMA_TERM;
}
/**
* <p>Gets the string that can be used to escape "_" or "%" wildcards in the
* string search pattern used for search parameters
* @return String that is used for escaping wildcards
* @throws SQLException, should never occur
*/
@Override
public String getSearchStringEscape() throws SQLException {
return ESCAPE_SEARCH_STRING;
}
@Override
public String getSQLKeywords() throws SQLException {
return KEY_WORDS;
}
/**
* Indicates whether the SQLSTATE returned by SQLException.getSQLState is X/Open
* (now known as Open Group) SQL CLI or SQL99.
* @return intValue, the type of SQLSTATE; one of: sqlStateXOpen or sqlStateSQL99
*/
@Override
public int getSQLStateType() throws SQLException {
//return sqlStateSQL99;
return 2;
}
@Override
public String getStringFunctions() throws SQLException {
return STRING_FUNCTIONS;
}
/**
* Retrieves a description of the table hierarchies defined in a
* particular schema in this database.
* @param catalog A catalog name; "" retrieves those without a catalog;
* null means drop catalog name from the selection criteria.
* @param schemaPattern A schema name pattern; "" retrieves those without a schema.
* @param tableNamePattern A table name pattern; may be a fully-qualified name.
* @throws SQLException since not supported
*/
@Override
public ResultSet getSuperTables(String catalog, String schemaPattern,
String tableNamePattern) throws SQLException {
List records = new ArrayList (0);
/***********************************************************************
* Hardcoding JDBC column names for the columns returned in results object
***********************************************************************/
Map[] metadataList = new Map[4];
// HardCoding metadata details for TABLE_CAT column
metadataList[0] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.SUPER_TABLES.TABLE_CAT,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NULLABLE, driverConnection);
// HardCoding metadata details for TABLE_SCHEM column
metadataList[1] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.SUPER_TABLES.TABLE_SCHEM,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NULLABLE, driverConnection);
// HardCoding metadata details for TABLE_NAME column
metadataList[2] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.SUPER_TABLES.TABLE_NAME,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, driverConnection);
// HardCoding metadata details for SUPERTABLE_NAME column
metadataList[3] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.SUPER_TABLES.SUPERTABLE_NAME,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, driverConnection);
// construct results object from column values and their metadata
return dummyStatement().createResultSet(records, metadataList);
}
/**
* Retrieves a description of the user-defined type (UDT) hierarchies
* defined in a particular schema in this database.
* @param catalog A catalog name; "" retrieves those without a catalog;
* null means drop catalog name from the selection criteria.
* @param schemaPattern A schema name pattern; "" retrieves those without a schema.
* @param tableNamePattern A table name pattern; may be a fully-qualified name.
*/
@Override
public ResultSet getSuperTypes(String catalog, String schemaPattern,
String tableNamePattern) throws SQLException {
List records = new ArrayList (0);
/***********************************************************************
* Hardcoding JDBC column names for the columns returned in results object
***********************************************************************/
Map[] metadataList = new Map[6];
// HardCoding metadata details for TYPE_CAT column
metadataList[0] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.SUPER_TYPES.TYPE_CAT,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NULLABLE, driverConnection);
// HardCoding metadata details for TYPE_SCHEM column
metadataList[1] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.SUPER_TYPES.TYPE_SCHEM,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NULLABLE, driverConnection);
// HardCoding metadata details for TYPE_NAME column
metadataList[2] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.SUPER_TYPES.TYPE_NAME,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, driverConnection);
// HardCoding metadata details for SUPERTYPE_CAT column
metadataList[3] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.SUPER_TYPES.SUPERTYPE_CAT,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NULLABLE, driverConnection);
// HardCoding metadata details for SUPERTYPE_SCHEM column
metadataList[4] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.SUPER_TYPES.SUPERTYPE_SCHEM,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NULLABLE, driverConnection);
// HardCoding metadata details for SUPERTYPE_NAME column
metadataList[5] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.SUPER_TYPES.SUPERTYPE_NAME,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, driverConnection);
// construct results object from column values and their metadata
return dummyStatement().createResultSet(records, metadataList);
}
@Override
public String getSystemFunctions() throws SQLException {
return SYSTEM_FUNCTIONS;
}
@Override
public ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableName) throws SQLException {
List records = new ArrayList (0);
/***********************************************************************
* Hardcoding JDBC column names for the columns returned in results object
***********************************************************************/
Map[] metadataList = new Map[7];
metadataList[0] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.PRIVILEGES.TABLE_CAT,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NULLABLE, driverConnection);
metadataList[1] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.PRIVILEGES.TABLE_SCHEM,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NULLABLE, driverConnection);
metadataList[2] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.PRIVILEGES.TABLE_NAME,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, driverConnection);
metadataList[3] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.PRIVILEGES.GRANTOR,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NULLABLE, driverConnection);
metadataList[4] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.PRIVILEGES.GRANTEE,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, driverConnection);
metadataList[5] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.PRIVILEGES.PRIVILEGE,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, driverConnection);
metadataList[6] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.PRIVILEGES.IS_GRANTABLE,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NULLABLE, driverConnection);
return dummyStatement().createResultSet(records, metadataList);
}
@Override
public ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String types[]) throws SQLException {
if (catalog == null) {
catalog = PERCENT;
}
if (schemaPattern == null) {
schemaPattern = PERCENT;
}
// Get all tables if tableNamePattern is null
if(tableNamePattern == null) {
tableNamePattern = PERCENT;
}
// list which represent records containing tables info
List records = new ArrayList ();
// query string to be submitted to get table metadata info
StringBuffer sqlQuery = new StringBuffer(QUERY_TABLES);
if (types != null) {
StringBuffer typesString = new StringBuffer("("); // criteria string for different table types //$NON-NLS-1$
if (types.length == 0) {
typesString.append("1 = 0"); //$NON-NLS-1$
} else {
// construct the criteria string
for(int i=0; i < types.length; i++) {
if (types[i] != null && types[i].length() > 0) {
if (i > 0) {
typesString.append(" OR "); //$NON-NLS-1$
}
typesString.append(TABLE_TYPE).append(LIKE_ESCAPE);
}
}
}
typesString.append(")"); //$NON-NLS-1$
sqlQuery.append(" AND ").append(typesString.toString()); //$NON-NLS-1$
}
sqlQuery.append(" ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME"); //$NON-NLS-1$
ResultSetMetaData rmetadata = null;
ResultSetImpl results = null;
PreparedStatement prepareQuery = null;
try {
prepareQuery = driverConnection.prepareStatement(sqlQuery.toString());
int columnIndex = 0;
prepareQuery.setObject(++columnIndex, catalog.toUpperCase());
prepareQuery.setObject(++columnIndex, schemaPattern.toUpperCase());
prepareQuery.setObject(++columnIndex, tableNamePattern.toUpperCase());
if(types != null) {
for(int i=0; i < types.length; i++) {
if (types[i] != null && types[i].length() > 0) {
prepareQuery.setObject(++columnIndex, types[i].toUpperCase());
}
}
}
// make a query against runtimemetadata and get results
results = (ResultSetImpl) prepareQuery.executeQuery();
// build the list of records from server's Results object.
while (results.next ()) {
// list represents a record on the Results object.
List currentRow = new ArrayList (11);
// add values in the current record on the Results object to the list
// number of values to be fetched from each row is MAX_COLUMNS.
for(int i=0; i < JDBCColumnPositions.TABLES.MAX_COLUMNS; i++) {
// get the value at the current index add it to currentRow
currentRow.add(results.getObject(i+1));
}
// add the current row to the list of records.
records.add(currentRow);
}// end of while
// get the metadata for the results
rmetadata = results.getMetaData();
logger.fine(Messages.getString(Messages.JDBC.MMDatabaseMetadata_getTable_success, tableNamePattern));
// construct results object from column values and their metadata
return dummyStatement().createResultSet(records, rmetadata);
} catch (Exception e) {
throw new SQLException(Messages.getString(Messages.JDBC.MMDatabaseMetadata_getTable_error, tableNamePattern, e.getMessage()), e);
} finally {
if (prepareQuery != null) {
prepareQuery.close();
}
}
}
@Override
public ResultSet getTableTypes() throws SQLException {
// list which represent records containing Table Type info
List records = new ArrayList (5);
/********************************
* HardCoding JDBC specific values
*********************************/
records.add(Arrays.asList(new String[] {"DOCUMENT"})); //$NON-NLS-1$
records.add(Arrays.asList(new String[] {"TABLE"})); //$NON-NLS-1$
records.add(Arrays.asList(new String[] {"VIEW"})); //$NON-NLS-1$
records.add(Arrays.asList(new String[] {"XMLSTAGINGTABLE"})); //$NON-NLS-1$
records.add(Arrays.asList(new String[] {"SYSTEM TABLE"})); //$NON-NLS-1$
/***********************************************************************
* Hardcoding JDBC column names for the columns returned in results object
***********************************************************************/
Map[] metadataList = new Map[1];
metadataList[0] = StatementImpl.getColumnMetadata(null, JDBCColumnNames.TABLE_TYPES.TABLE_TYPE,
DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, driverConnection);
logger.fine(Messages.getString(Messages.JDBC.MMDatabaseMetadata_getTableType_success));
// construct results object from column values and their metadata
return dummyStatement().createResultSet(records, metadataList);
}
@Override
public String getTimeDateFunctions() throws SQLException {
return DATE_FUNCTIONS;
}
@Override
public ResultSet getTypeInfo() throws SQLException {
// list which represent records containing data type info
List<List<Object>> records = new ArrayList<List<Object>>();
records.add(Arrays.asList(createTypeInfoRow("boolean", "{b'", "}", Boolean.TRUE, Boolean.TRUE, 0))); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
records.add(Arrays.asList(createTypeInfoRow("byte", null, null, Boolean.TRUE, Boolean.TRUE, 0))); //$NON-NLS-1$
records.add(Arrays.asList(createTypeInfoRow("tinyint", null, null, Boolean.TRUE, Boolean.TRUE, 0))); //$NON-NLS-1$
records.add(Arrays.asList(createTypeInfoRow("long", null, null, Boolean.FALSE, Boolean.FALSE, 10))); //$NON-NLS-1$
records.add(Arrays.asList(createTypeInfoRow("bigint", null, null, Boolean.FALSE, Boolean.FALSE, 10))); //$NON-NLS-1$
records.add(Arrays.asList(createTypeInfoRow("char", "'", "'", Boolean.TRUE, Boolean.TRUE, 0))); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
records.add(Arrays.asList(createTypeInfoRow("bigdecimal",null, null, Boolean.FALSE, Boolean.TRUE, 10))); //$NON-NLS-1$
records.add(Arrays.asList(createTypeInfoRow("decimal",null, null, Boolean.FALSE, Boolean.TRUE, 10))); //$NON-NLS-1$
records.add(Arrays.asList(createTypeInfoRow("biginteger", null, null, Boolean.FALSE, Boolean.FALSE, 10))); //$NON-NLS-1$
records.add(Arrays.asList(createTypeInfoRow("integer", null, null, Boolean.FALSE, Boolean.FALSE, 10))); //$NON-NLS-1$
records.add(Arrays.asList(createTypeInfoRow("short", null, null, Boolean.FALSE, Boolean.FALSE, 10))); //$NON-NLS-1$
records.add(Arrays.asList(createTypeInfoRow("smallint", null, null, Boolean.FALSE, Boolean.FALSE, 10))); //$NON-NLS-1$
records.add(Arrays.asList(createTypeInfoRow("float", null, null, Boolean.FALSE, Boolean.FALSE, 10))); //$NON-NLS-1$
records.add(Arrays.asList(createTypeInfoRow("real", null, null, Boolean.FALSE, Boolean.FALSE, 10))); //$NON-NLS-1$
records.add(Arrays.asList(createTypeInfoRow("double", null, null, Boolean.FALSE, Boolean.FALSE, 10))); //$NON-NLS-1$
records.add(Arrays.asList(createTypeInfoRow("string", "'", "'", Boolean.TRUE, Boolean.TRUE, 0))); //$NON-NLS-1$ //$NON-NLS-2$//$NON-NLS-3$
records.add(Arrays.asList(createTypeInfoRow("varchar", "'", "'", Boolean.TRUE, Boolean.TRUE, 0))); //$NON-NLS-1$ //$NON-NLS-2$//$NON-NLS-3$
records.add(Arrays.asList(createTypeInfoRow("xml", null, null, Boolean.TRUE, Boolean.TRUE, 0))); //$NON-NLS-1$
records.add(Arrays.asList(createTypeInfoRow("date", "{d'", "}", Boolean.TRUE, Boolean.TRUE, 0))); //$NON-NLS-1$ //$NON-NLS-2$//$NON-NLS-3$
records.add(Arrays.asList(createTypeInfoRow("time", "{t'", "}", Boolean.TRUE, Boolean.TRUE, 0))); //$NON-NLS-1$ //$NON-NLS-2$//$NON-NLS-3$
records.add(Arrays.asList(createTypeInfoRow("timestamp", "{ts'", "}", Boolean.TRUE, Boolean.TRUE, 0))); //$NON-NLS-1$ //$NON-NLS-2$//$NON-NLS-3$
records.add(Arrays.asList(createTypeInfoRow("object", null, null, Boolean.TRUE, Boolean.TRUE, 0))); //$NON-NLS-1$
records.add(Arrays.asList(createTypeInfoRow("blob", null, null, Boolean.TRUE, Boolean.TRUE, 0))); //$NON-NLS-1$
records.add(Arrays.asList(createTypeInfoRow("varbinary", "X'", "'", Boolean.TRUE, Boolean.TRUE, 0))); //$NON-NLS-1$ //$NON-NLS-2$//$NON-NLS-3$
records.add(Arrays.asList(createTypeInfoRow("clob", null, null, Boolean.TRUE, Boolean.TRUE, 0))); //$NON-NLS-1$
Map[] metadataList = new Map[18];
metadataList[0] = StatementImpl.getColumnMetadata(CoreConstants.SYSTEM_MODEL + "." + DATA_TYPES, JDBCColumnNames.TYPE_INFO.TYPE_NAME, DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, ResultsMetadataConstants.SEARCH_TYPES.SEARCHABLE, Boolean.FALSE, Boolean.FALSE, Boolean.FALSE, driverConnection);//$NON-NLS-1$
metadataList[1] = StatementImpl.getColumnMetadata(CoreConstants.SYSTEM_MODEL + "." + DATA_TYPES, JDBCColumnNames.TYPE_INFO.DATA_TYPE, DataTypeManagerService.DefaultDataTypes.INTEGER, ResultsMetadataConstants.NULL_TYPES.NULLABLE, ResultsMetadataConstants.SEARCH_TYPES.SEARCHABLE, Boolean.TRUE, Boolean.TRUE, Boolean.FALSE, driverConnection);//$NON-NLS-1$
metadataList[2] = StatementImpl.getColumnMetadata(CoreConstants.SYSTEM_MODEL + "." + DATA_TYPES, JDBCColumnNames.TYPE_INFO.PRECISION, DataTypeManagerService.DefaultDataTypes.INTEGER, ResultsMetadataConstants.NULL_TYPES.NULLABLE, ResultsMetadataConstants.SEARCH_TYPES.SEARCHABLE, Boolean.TRUE, Boolean.TRUE, Boolean.FALSE, driverConnection);//$NON-NLS-1$
metadataList[3] = StatementImpl.getColumnMetadata(CoreConstants.SYSTEM_MODEL + "." + DATA_TYPES, JDBCColumnNames.TYPE_INFO.LITERAL_PREFIX, DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NULLABLE, ResultsMetadataConstants.SEARCH_TYPES.SEARCHABLE, Boolean.TRUE, Boolean.TRUE, Boolean.FALSE, driverConnection);//$NON-NLS-1$
metadataList[4] = StatementImpl.getColumnMetadata(CoreConstants.SYSTEM_MODEL + "." + DATA_TYPES, JDBCColumnNames.TYPE_INFO.LITERAL_SUFFIX, DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NULLABLE, ResultsMetadataConstants.SEARCH_TYPES.SEARCHABLE, Boolean.TRUE, Boolean.TRUE, Boolean.FALSE, driverConnection);//$NON-NLS-1$
metadataList[5] = StatementImpl.getColumnMetadata(CoreConstants.SYSTEM_MODEL + "." + DATA_TYPES, JDBCColumnNames.TYPE_INFO.CREATE_PARAMS, DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NULLABLE, ResultsMetadataConstants.SEARCH_TYPES.SEARCHABLE, Boolean.TRUE, Boolean.TRUE, Boolean.FALSE, driverConnection);//$NON-NLS-1$
metadataList[6] = StatementImpl.getColumnMetadata(CoreConstants.SYSTEM_MODEL + "." + DATA_TYPES, JDBCColumnNames.TYPE_INFO.NULLABLE, DataTypeManagerService.DefaultDataTypes.SHORT, ResultsMetadataConstants.NULL_TYPES.NULLABLE, ResultsMetadataConstants.SEARCH_TYPES.SEARCHABLE, Boolean.TRUE, Boolean.TRUE, Boolean.FALSE, driverConnection);//$NON-NLS-1$
metadataList[7] = StatementImpl.getColumnMetadata(CoreConstants.SYSTEM_MODEL + "." + DATA_TYPES, JDBCColumnNames.TYPE_INFO.CASE_SENSITIVE, DataTypeManagerService.DefaultDataTypes.BOOLEAN, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, ResultsMetadataConstants.SEARCH_TYPES.SEARCHABLE, Boolean.FALSE, Boolean.FALSE, Boolean.TRUE, driverConnection);//$NON-NLS-1$
metadataList[8] = StatementImpl.getColumnMetadata(CoreConstants.SYSTEM_MODEL + "." + DATA_TYPES, JDBCColumnNames.TYPE_INFO.SEARCHABLE, DataTypeManagerService.DefaultDataTypes.SHORT, ResultsMetadataConstants.NULL_TYPES.NULLABLE, ResultsMetadataConstants.SEARCH_TYPES.SEARCHABLE, Boolean.TRUE, Boolean.TRUE, Boolean.FALSE, driverConnection);//$NON-NLS-1$
metadataList[9] = StatementImpl.getColumnMetadata(CoreConstants.SYSTEM_MODEL + "." + DATA_TYPES, JDBCColumnNames.TYPE_INFO.UNSIGNED_ATTRIBUTE, DataTypeManagerService.DefaultDataTypes.BOOLEAN, ResultsMetadataConstants.NULL_TYPES.NULLABLE, ResultsMetadataConstants.SEARCH_TYPES.SEARCHABLE, Boolean.TRUE, Boolean.TRUE, Boolean.FALSE, driverConnection);//$NON-NLS-1$
metadataList[10] = StatementImpl.getColumnMetadata(CoreConstants.SYSTEM_MODEL + "." + DATA_TYPES, JDBCColumnNames.TYPE_INFO.FIXED_PREC_SCALE, DataTypeManagerService.DefaultDataTypes.BOOLEAN, ResultsMetadataConstants.NULL_TYPES.NULLABLE, ResultsMetadataConstants.SEARCH_TYPES.SEARCHABLE, Boolean.TRUE, Boolean.TRUE, Boolean.FALSE, driverConnection);//$NON-NLS-1$
metadataList[11] = StatementImpl.getColumnMetadata(CoreConstants.SYSTEM_MODEL + "." + DATA_TYPES, JDBCColumnNames.TYPE_INFO.AUTOINCREMENT, DataTypeManagerService.DefaultDataTypes.BOOLEAN, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, ResultsMetadataConstants.SEARCH_TYPES.SEARCHABLE, Boolean.FALSE, Boolean.TRUE, Boolean.TRUE, driverConnection);//$NON-NLS-1$
metadataList[12] = StatementImpl.getColumnMetadata(CoreConstants.SYSTEM_MODEL + "." + DATA_TYPES, JDBCColumnNames.TYPE_INFO.LOCAL_TYPE_NAME, DataTypeManagerService.DefaultDataTypes.STRING, ResultsMetadataConstants.NULL_TYPES.NOT_NULL, ResultsMetadataConstants.SEARCH_TYPES.SEARCHABLE, Boolean.FALSE, Boolean.FALSE, Boolean.FALSE, driverConnection);//$NON-NLS-1$
metadataList[13] = StatementImpl.getColumnMetadata(CoreConstants.SYSTEM_MODEL + "." + DATA_TYPES, JDBCColumnNames.TYPE_INFO.MINIMUM_SCALE, DataTypeManagerService.DefaultDataTypes.SHORT, ResultsMetadataConstants.NULL_TYPES.NULLABLE, ResultsMetadataConstants.SEARCH_TYPES.SEARCHABLE, Boolean.TRUE, Boolean.TRUE, Boolean.FALSE, driverConnection);//$NON-NLS-1$
metadataList[14] = StatementImpl.getColumnMetadata(CoreConstants.SYSTEM_MODEL + "." + DATA_TYPES, JDBCColumnNames.TYPE_INFO.MAXIMUM_SCALE, DataTypeManagerService.DefaultDataTypes.SHORT, ResultsMetadataConstants.NULL_TYPES.NULLABLE, ResultsMetadataConstants.SEARCH_TYPES.SEARCHABLE, Boolean.TRUE, Boolean.TRUE, Boolean.FALSE, driverConnection);//$NON-NLS-1$
metadataList[15] = StatementImpl.getColumnMetadata(CoreConstants.SYSTEM_MODEL + "." + DATA_TYPES, JDBCColumnNames.TYPE_INFO.SQL_DATA_TYPE, DataTypeManagerService.DefaultDataTypes.INTEGER, ResultsMetadataConstants.NULL_TYPES.NULLABLE, ResultsMetadataConstants.SEARCH_TYPES.SEARCHABLE, Boolean.TRUE, Boolean.TRUE, Boolean.FALSE, driverConnection);//$NON-NLS-1$
metadataList[16] = StatementImpl.getColumnMetadata(CoreConstants.SYSTEM_MODEL + "." + DATA_TYPES, JDBCColumnNames.TYPE_INFO.SQL_DATETIME_SUB, DataTypeManagerService.DefaultDataTypes.INTEGER, ResultsMetadataConstants.NULL_TYPES.NULLABLE, ResultsMetadataConstants.SEARCH_TYPES.SEARCHABLE, Boolean.TRUE, Boolean.TRUE, Boolean.FALSE, driverConnection);//$NON-NLS-1$
metadataList[17] = StatementImpl.getColumnMetadata(CoreConstants.SYSTEM_MODEL + "." + DATA_TYPES, JDBCColumnNames.TYPE_INFO.NUM_PREC_RADIX, DataTypeManagerService.DefaultDataTypes.INTEGER, ResultsMetadataConstants.NULL_TYPES.NULLABLE, ResultsMetadataConstants.SEARCH_TYPES.SEARCHABLE, Boolean.FALSE, Boolean.FALSE, Boolean.FALSE, driverConnection);//$NON-NLS-1$
ResultSetMetaData rmetadata = new ResultSetMetaDataImpl(getTeiidVersion(), new MetadataProvider(metadataList), null);
logger.fine(Messages.getString(Messages.JDBC.MMDatabaseMetadata_getTypes_success));
// construct results object from column values and their metadata
return dummyStatement().createResultSet(records, rmetadata);
}
private Object[] createTypeInfoRow(String typeName, String prefix, String suffix, Boolean unsigned, Boolean fixedPrecScale, int radix){
return new Object[] {typeName, new Integer(JDBCSQLTypeInfo.getSQLType(getTeiidVersion(), typeName)), JDBCSQLTypeInfo.getDefaultPrecision(getTeiidVersion(), typeName), prefix, suffix, null, new Short((short)DatabaseMetaData.typeNullable), Boolean.FALSE, new Short((short)DatabaseMetaData.typeSearchable), unsigned, fixedPrecScale, Boolean.FALSE, typeName, new Short((short)0), new Short((short)255), null, null, new Integer(radix)};
}
/**
* <p>Gets a description of the user-defined types defined in a particular
* schema. Schema-specific UDTs may have type JAVA_OBJECT, STRUCT, or DISTINCT.
* Supports 1.4
* @param catalog a catalog name
* @param schemaPattern a schema name pattern
* @param typeNamePattern a type name pattern
* @param types a list of user-named types to include (JAVA_OBJECT, STRUCT,
* or DISTINCT); null returns all types
* @return ResultSet. Empty ResultSet object as this method is not supported.
* @throws SQLException if catalog/schema info does not match for the given connection.
*/
@Override
public ResultSet getUDTs(String catalog, String schemaPattern,
String typeNamePattern, int[] types) throws SQLException {
return emptyUDTSResultSet();
}
/**
* Return a empty result set for to aid getUDTS() functions.
* @return ResultSet.
*/
private ResultSet emptyUDTSResultSet() throws SQLException {
String[] columnNames = new String[] {
JDBCColumnNames.UDTS.TYPE_CAT,
JDBCColumnNames.UDTS.TYPE_SCHEM,
JDBCColumnNames.UDTS.TYPE_NAME,
JDBCColumnNames.UDTS.CLASS_NAME,
JDBCColumnNames.UDTS.DATA_TYPE,
JDBCColumnNames.UDTS.REMARKS,
JDBCColumnNames.UDTS.BASE_TYPE
};
String[] dataTypes = new String[] {
DataTypeManagerService.DefaultDataTypes.STRING.getId(),
DataTypeManagerService.DefaultDataTypes.STRING.getId(),
DataTypeManagerService.DefaultDataTypes.STRING.getId(),
DataTypeManagerService.DefaultDataTypes.STRING.getId(),
DataTypeManagerService.DefaultDataTypes.STRING.getId(),
DataTypeManagerService.DefaultDataTypes.STRING.getId(),
DataTypeManagerService.DefaultDataTypes.SHORT.getId()
};
return dummyStatement().createResultSet(Collections.EMPTY_LIST, columnNames, dataTypes);
}
private StatementImpl dummyStatement() {
return new StatementImpl(this.driverConnection, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
}
@Override
public String getURL() throws SQLException {
return driverConnection.getUrl();
}
@Override
public String getUserName() throws SQLException {
return driverConnection.getUserName();
}
/**
* <p>Gets the description of the columns in a table that are automatically updated
* when any value in a row is updated. The column descriptions are not ordered.
* @param name of the catalog in which the table is present.
* @param name of the schema in which the table is present.
* @param name of the table which has the version columns.
* @return ResultSet object containing version column information.
* @throws SQLException, should never occur
*/
@Override
public ResultSet getVersionColumns(String catalog, String schema, String table) throws SQLException {
// ResultSet returned has the same columns as best row identifier
// Method not supported, retuning empty ResultSet
ResultSet resultSet = getBestRowIdentifier(catalog, schema, table, 0, true);
logger.fine(Messages.getString(Messages.JDBC.MMDatabaseMetadata_getVersionCols_success));
return resultSet;
}
/**
* <p>Checks whether a catalog name appears at the start of a fully qualified table
* name. If it is not at the beginning, it appears at the end.</p>
* @return if so return true, else false.
* @throws SQLException, should never occur.
*/
@Override
public boolean isCatalogAtStart() throws SQLException {
return false;
}
/**
* <p>Indicates whether or not a visible row insert can be detected
* by calling ResultSet.rowInserted().</p>
* @param result set type, i.e. ResultSet.TYPE_XXX
* @return true if changes are detected by the resultset type
* @throws SQLException, should never occur
*/
@Override
public boolean insertsAreDetected(int type) throws SQLException {
return false;
}
@Override
public boolean isReadOnly() throws SQLException {
return false;
}
/**
* <p>Indicates whether updates made to a LOB are made on a copy or directly to the LOB. </p>
* @return if so return true, else false.
* @throws SQLException, should never occur.
*/
@Override
public boolean locatorsUpdateCopy() throws SQLException {
return false;
}
/**
* <p>Checks whether the concatenation of a NULL vaule and a non-NULL value results
* in a NULL value.</p>
* @return if so return true, else false.
* @throws SQLException, should never occur.
*/
@Override
public boolean nullPlusNonNullIsNull() throws SQLException {
return true;
}
/**
* <p>Checks whether NULL vaules are sorted at the end regardless of sort order.</p>
* @return if so return true, else false.
* @throws SQLException, should never occur.
*/
@Override
public boolean nullsAreSortedAtEnd() throws SQLException {
return false;
}
/**
* <p>Checks whether NULL vaules are sorted at the start regardless of sort order.</p>
* @return if so return true, else false.
* @throws SQLException, should never occur.
*/
@Override
public boolean nullsAreSortedAtStart() throws SQLException {
return false;
}
/**
* <p>Checks whether NULL vaules are sorted high.</p>
* @return if so return true, else false.
* @throws SQLException, should never occur.
*/
@Override
public boolean nullsAreSortedHigh() throws SQLException {
return false;
}
/**
* <p>Checks whether NULL vaules are sorted low.</p>
* @return if so return true, else false.
* @throws SQLException, should never occur.
*/
@Override
public boolean nullsAreSortedLow() throws SQLException {
return true;
}
/**
* <p>Indicates whether a result set's own updates are visible.</p>
* @param result set type, i.e. ResultSet.TYPE_XXX
* @return <code>true</code> if updates are visible for the result set type;
* <code>false</code> otherwise
* @throws SQLException, should never occur
*/
@Override
public boolean ownUpdatesAreVisible(int type) throws SQLException {
return false;
}
/**
* <p>Indicates whether a result set's own deletes are visible.</p>
* @param result set type, i.e. ResultSet.TYPE_XXX
* @return <code>true</code> if deletes are visible for the result set type;
* <code>false</code> otherwise
* @throws SQLException, should never occur
*/
@Override
public boolean ownDeletesAreVisible(int type) throws SQLException {
return false;
}
/**
* <p>Indicates whether a result set's own inserts are visible.</p>
* @param result set type, i.e. ResultSet.TYPE_XXX
* @return <code>true</code> if inserts are visible for the result set type;
* <code>false</code> otherwise
* @throws SQLException, should never occur
*/
@Override
public boolean ownInsertsAreVisible(int type) throws SQLException {
return false;
}
/**
* <p>Indicates whether updates made by others are visible.</p>
* @param result set type, i.e. ResultSet.TYPE_XXX
* @return <code>true</code> if updates made by others
* are visible for the result set type;
* <code>false</code> otherwise
* @throws SQLException, should never occur
*/
@Override
public boolean othersUpdatesAreVisible(int type) throws SQLException {
return false;
}
/**
* <p>Indicates whether deletes made by others are visible.</p>
* @param result set type, i.e. ResultSet.TYPE_XXX
* @return <code>true</code> if deletes made by others
* are visible for the result set type;
* <code>false</code> otherwise
* @throws SQLException, should never occur
*/
@Override
public boolean othersDeletesAreVisible(int type) throws SQLException {
return false;
}
/**
* <p>Indicates whether inserts made by others are visible.</p>
* @param result set type, i.e. ResultSet.TYPE_XXX
* @return true if updates are visible for the result set type <code>true</code>
* if inserts made by others are visible for the result set type;
* <code>false</code> otherwise
* @throws SQLException, should never occur
*/
@Override
public boolean othersInsertsAreVisible(int type) throws SQLException {
return false;
}
@Override
public boolean storesLowerCaseIdentifiers() throws SQLException {
return false;
}
@Override
public boolean storesLowerCaseQuotedIdentifiers() throws SQLException {
return false;
}
@Override
public boolean storesMixedCaseIdentifiers() throws SQLException {
return true;
}
@Override
public boolean storesMixedCaseQuotedIdentifiers() throws SQLException {
return true;
}
@Override
public boolean storesUpperCaseIdentifiers() throws SQLException {
return false;
}
@Override
public boolean storesUpperCaseQuotedIdentifiers() throws SQLException {
return false;
}
@Override
public boolean supportsAlterTableWithAddColumn() throws SQLException {
return false;
}
@Override
public boolean supportsAlterTableWithDropColumn() throws SQLException {
return false;
}
@Override
public boolean supportsANSI92EntryLevelSQL() throws SQLException {
return false;
}
@Override
public boolean supportsANSI92FullSQL() throws SQLException {
return false;
}
@Override
public boolean supportsANSI92IntermediateSQL() throws SQLException {
return false;
}
/**
* <p>Indicates whether the driver supports batch updates.</p>
* @return true if the driver supports batch updates; false otherwise
* @throws SQLException, should never occur
*/
@Override
public boolean supportsBatchUpdates() throws SQLException {
return true;
}
@Override
public boolean supportsCatalogsInDataManipulation() throws SQLException {
return false;
}
@Override
public boolean supportsCatalogsInIndexDefinitions() throws SQLException {
return false;
}
@Override
public boolean supportsCatalogsInPrivilegeDefinitions() throws SQLException {
return false;
}
@Override
public boolean supportsCatalogsInProcedureCalls() throws SQLException {
return false;
}
@Override
public boolean supportsCatalogsInTableDefinitions() throws SQLException {
return false;
}
@Override
public boolean supportsColumnAliasing() throws SQLException {
return true;
}
@Override
public boolean supportsConvert() throws SQLException {
return true;
}
@Override
public boolean supportsConvert(int fromType, int toType) throws SQLException {
String fromName = JDBCSQLTypeInfo.getTypeName(getTeiidVersion(), fromType);
String toName = JDBCSQLTypeInfo.getTypeName(getTeiidVersion(), toType);
if (fromName.equals(toName)) {
if (fromName.equals(DataTypeManagerService.DefaultDataTypes.OBJECT.getId()) && fromName != toName) {
return false;
}
return true;
}
return getDataTypeManager().isTransformable(fromName, toName);
}
@Override
public boolean supportsCorrelatedSubqueries() throws SQLException {
return true;
}
@Override
public boolean supportsCoreSQLGrammar() throws SQLException {
return false;
}
@Override
public boolean supportsDataDefinitionAndDataManipulationTransactions() throws SQLException {
return false;
}
@Override
public boolean supportsDataManipulationTransactionsOnly() throws SQLException {
return false;
}
@Override
public boolean supportsDifferentTableCorrelationNames() throws SQLException {
return false;
}
@Override
public boolean supportsExpressionsInOrderBy() throws SQLException {
return true;
}
@Override
public boolean supportsExtendedSQLGrammar() throws SQLException {
return false;
}
@Override
public boolean supportsFullOuterJoins() throws SQLException {
return true;
}
@Override
public boolean supportsGetGeneratedKeys() throws SQLException {
if (driverConnection.isLessThanTeiidEight())
return false;
return true;
}
@Override
public boolean supportsGroupBy() throws SQLException {
return true;
}
@Override
public boolean supportsGroupByBeyondSelect() throws SQLException {
return true;
}
@Override
public boolean supportsGroupByUnrelated() throws SQLException {
return true;
}
@Override
public boolean supportsIntegrityEnhancementFacility() throws SQLException {
return false;
}
@Override
public boolean supportsLikeEscapeClause() throws SQLException {
return true;
}
@Override
public boolean supportsLimitedOuterJoins() throws SQLException {
return true;
}
@Override
public boolean supportsMinimumSQLGrammar() throws SQLException {
return true;
}
@Override
public boolean supportsMixedCaseIdentifiers() throws SQLException {
return false;
}
@Override
public boolean supportsMixedCaseQuotedIdentifiers() throws SQLException {
return false;
}
@Override
public boolean supportsOpenCursorsAcrossCommit() throws SQLException {
return false;
}
@Override
public boolean supportsMultipleResultSets() throws SQLException {
return false;
}
@Override
public boolean supportsMultipleOpenResults() throws SQLException {
return false;
}
@Override
public boolean supportsMultipleTransactions() throws SQLException {
return true;
}
@Override
public boolean supportsNamedParameters() throws SQLException {
if (driverConnection.isLessThanTeiidEight())
return false;
return true;
}
@Override
public boolean supportsNonNullableColumns() throws SQLException {
return true;
}
@Override
public boolean supportsOpenCursorsAcrossRollback() throws SQLException {
return false;
}
@Override
public boolean supportsOpenStatementsAcrossCommit() throws SQLException {
return true;
}
@Override
public boolean supportsOpenStatementsAcrossRollback() throws SQLException {
return true;
}
@Override
public boolean supportsOrderByUnrelated() throws SQLException {
return true;
}
@Override
public boolean supportsOuterJoins() throws SQLException {
return true;
}
@Override
public boolean supportsPositionedDelete() throws SQLException {
return false;
}
@Override
public boolean supportsPositionedUpdate() throws SQLException {
return false;
}
@Override
public boolean supportsResultSetConcurrency(int type, int concurrency)
throws SQLException {
if(type == java.sql.ResultSet.TYPE_FORWARD_ONLY || type == java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE) {
if(concurrency == java.sql.ResultSet.CONCUR_READ_ONLY) {
return true;
}
return false;
}
return false;
}
/**
* Retrieves whether database supports the given result set holdability.
* Holdability - one of the following constants:
* ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT.
* @param intValue holdability
* @return boolean true if so; false otherwise
* @throws SQLException, should never occur
*/
@Override
public boolean supportsResultSetHoldability(int holdability) throws SQLException {
return false;
}
/**
* <p>Does the database support the given result set type?</p>
* @param type defined in <code>java.sql.ResultSet</code>
* @return <code>true</code> if so; <code>false</code> otherwise
* @throws SQLException, should never occur
* @see Connection
*/
@Override
public boolean supportsResultSetType(int type) throws SQLException {
if(type == java.sql.ResultSet.TYPE_FORWARD_ONLY || type == java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE) {
return true;
}
return false;
}
@Override
public boolean supportsSavepoints() throws SQLException {
return false;
}
@Override
public boolean supportsSchemasInDataManipulation() throws SQLException {
return true;
}
@Override
public boolean supportsSchemasInIndexDefinitions() throws SQLException {
return false;
}
@Override
public boolean supportsSchemasInPrivilegeDefinitions() throws SQLException {
return false;
}
@Override
public boolean supportsSchemasInProcedureCalls() throws SQLException {
return true;
}
@Override
public boolean supportsSchemasInTableDefinitions() throws SQLException {
return false;
}
@Override
public boolean supportsSelectForUpdate() throws SQLException {
return false;
}
@Override
public boolean supportsStatementPooling() throws SQLException {
return false;
}
@Override
public boolean supportsStoredProcedures() throws SQLException {
return true;
}
@Override
public boolean supportsSubqueriesInComparisons() throws SQLException {
return true;
}
@Override
public boolean supportsSubqueriesInExists() throws SQLException {
return true;
}
@Override
public boolean supportsSubqueriesInIns() throws SQLException {
return true;
}
@Override
public boolean supportsSubqueriesInQuantifieds() throws SQLException {
return true;
}
@Override
public boolean supportsTableCorrelationNames() throws SQLException {
return true;
}
@Override
public boolean supportsTransactionIsolationLevel(int level) throws SQLException {
return false;
}
@Override
public boolean supportsTransactions() throws SQLException {
return true;
}
@Override
public boolean supportsUnion() throws SQLException {
return true;
}
@Override
public boolean supportsUnionAll() throws SQLException {
return true;
}
@Override
public boolean updatesAreDetected(int type) throws SQLException {
return false;
}
@Override
public boolean usesLocalFilePerTable() throws SQLException {
return false;
}
@Override
public boolean usesLocalFiles() throws SQLException {
return false;
}
/**
* <p>This method is used to produce ResultSets from server's Results objects for
* getCrossReference, getExportedKeys and getImportedKeys methods.
* @param server's Results object.
* @return ResultSet object giving the reference key info.
* @throws SQLException if there is an accesing server results
*/
private ResultSet getReferenceKeys(ResultSet results) throws SQLException {
// list which represent records containing reference key info
List records = new ArrayList ();
ResultSetMetaData rmetadata = null;
try {
// build the list of records from Results object.
while (results.next()) {
// list represents a record on the Results object.
List currentRow = new ArrayList (15);
// add values in the current record on the Results object to the list
// number of values to be fetched from each row is MAX_COLUMNS.
for(int i=0; i < JDBCColumnPositions.REFERENCE_KEYS.MAX_COLUMNS; i++) {
// get the value at the current index add it to currentRow
currentRow.add(results.getObject(i+1));
}
// add the current row to the list of records.
records.add(currentRow);
}// end of while
// get the metadata for the results
rmetadata = results.getMetaData();
} catch (Exception e) {
String msg = Messages.getString(Messages.JDBC.MMDatabaseMetadata_Err_getting_primary_keys);
throw new SQLException(msg, e);
}
// close the resultset and driver connection
//results.close();
logger.fine(Messages.getString(Messages.JDBC.MMDatabaseMetadata_getRefKey_success));
// construct results object from column values and their metadata
return dummyStatement().createResultSet(records, rmetadata);
}
@Override
public boolean autoCommitFailureClosesAllResultSets() throws SQLException {
return false;
}
@Override
public int getResultSetHoldability() throws SQLException {
return ResultSet.HOLD_CURSORS_OVER_COMMIT;
}
@Override
public Connection getConnection() throws SQLException {
return driverConnection;
}
@Override
public boolean supportsStoredFunctionsUsingCallSyntax() throws SQLException {
return false;
}
@Override
public ResultSet getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern)
throws SQLException {
throw new UnsupportedOperationException();
}
@Override
public ResultSet getClientInfoProperties() throws SQLException {
throw new UnsupportedOperationException();
}
@Override
public ResultSet getFunctionColumns(String catalog, String schemaPattern,
String functionNamePattern, String columnNamePattern)
throws SQLException {
if (isTeiidVersionOrGreater(Version.TEIID_8_9)) {
if (catalog == null) {
catalog = PERCENT;
}
if (schemaPattern == null) {
schemaPattern = PERCENT;
}
if (functionNamePattern == null) {
functionNamePattern = PERCENT;
}
if (columnNamePattern == null) {
columnNamePattern = PERCENT;
}
List records = new ArrayList ();
ResultSetMetaData rmetadata = null;
ResultSetImpl results = null;
PreparedStatementImpl prepareQuery = null;
try {
prepareQuery = driverConnection.prepareStatement(QUERY_FUNCTION_COLUMNS);
prepareQuery.setString(1, catalog.toUpperCase());
prepareQuery.setString(2, schemaPattern.toUpperCase());
prepareQuery.setString(3, functionNamePattern.toUpperCase());
prepareQuery.setString(4, columnNamePattern.toUpperCase());
results = prepareQuery.executeQuery();
// Get the metadata for the results
rmetadata = results.getMetaData();
int cols = rmetadata.getColumnCount();
while (results.next ()) {
List currentRow = new ArrayList (cols);
for(int i=0; i < cols; i++) {
currentRow.add(results.getObject(i+1));
}
String typeName = (String)currentRow.get(6);
Integer length = (Integer)currentRow.get(8);
Integer precision = (Integer)currentRow.get(7);
if (precision != null && precision <= 0) {
currentRow.set(7, JDBCSQLTypeInfo.getDefaultPrecision(getTeiidVersion(), typeName));
}
if (length != null && length <= 0) {
currentRow.set(8, JDBCSQLTypeInfo.getDefaultPrecision(getTeiidVersion(), typeName));
}
if (typeName != null) {
currentRow.set(5, JDBCSQLTypeInfo.getSQLType(getTeiidVersion(), typeName));
} else {
currentRow.set(5, null);
}
// add the current row to the list of records.
records.add(currentRow);
}// end of while
logger.fine(Messages.getString(Messages.JDBC.MMDatabaseMetadata_getfunctioncolumns_success));
// construct results object from column values and their metadata
return dummyStatement().createResultSet(records, rmetadata);
} catch(Exception e) {
throw new SQLException(Messages.getString(Messages.JDBC.MMDatabaseMetadata_getfunctioncolumns_error, e.getMessage()), e);
} finally {
if (prepareQuery != null) {
prepareQuery.close();
}
}
}
throw new UnsupportedOperationException();
}
@Override
public ResultSet getFunctions(String catalog, String schemaPattern,
String functionNamePattern) throws SQLException {
if (isTeiidVersionOrGreater(Version.TEIID_8_9)) {
if (catalog == null) {
catalog = PERCENT;
}
if (schemaPattern == null) {
schemaPattern = PERCENT;
}
if (functionNamePattern == null) {
functionNamePattern = PERCENT;
}
List records = new ArrayList();
ResultSetMetaData rmetadata = null;
ResultSetImpl results = null;
PreparedStatementImpl prepareQuery = null;
try {
prepareQuery = driverConnection.prepareStatement(QUERY_FUNCTIONS);
prepareQuery.setString(1, catalog.toUpperCase());
prepareQuery.setString(2, schemaPattern.toUpperCase());
prepareQuery.setString(3, functionNamePattern.toUpperCase());
results = prepareQuery.executeQuery();
// Get the metadata for the results
rmetadata = results.getMetaData();
int cols = rmetadata.getColumnCount();
while (results.next()) {
List currentRow = new ArrayList(cols);
for (int i = 0; i < cols; i++) {
currentRow.add(results.getObject(i + 1));
}
records.add(currentRow);
}
logger.fine(Messages.getString(Messages.JDBC.MMDatabaseMetadata_getfunctions_success));
// construct results object from column values and their metadata
return dummyStatement().createResultSet(records, rmetadata);
} catch (Exception e) {
throw new SQLException(Messages.getString(Messages.JDBC.MMDatabaseMetadata_getfunctions_error, e.getMessage()), e);
} finally {
if (prepareQuery != null) {
prepareQuery.close();
}
}
}
throw new UnsupportedOperationException();
}
@Override
public RowIdLifetime getRowIdLifetime() throws SQLException {
throw new UnsupportedOperationException();
}
@Override
public ResultSet getSchemas(String catalog, String schemaPattern) throws SQLException {
if (catalog == null) {
catalog = PERCENT;
}
if (schemaPattern == null) {
schemaPattern = PERCENT;
}
// list which represent records containing schema info
List records = new ArrayList();
ResultSetMetaData rmetadata = null;
ResultSetImpl results = null;
PreparedStatementImpl prepareQuery = null;
try {
prepareQuery = driverConnection.prepareStatement(QUERY_SCHEMAS);
prepareQuery.setObject(1, catalog.toUpperCase());
prepareQuery.setObject(2, schemaPattern.toUpperCase());
// make a query against runtimemetadata and get results
results = (ResultSetImpl)prepareQuery.executeQuery();
while (results.next()) {
// each row will have only one column(Virtual database name)
List currentRow = new ArrayList(2);
for (int i = 0; i < JDBCColumnPositions.SCHEMAS.MAX_COLUMNS; i++) {
// get the value at the current index add it to currentRow
currentRow.add(results.getObject(i + 1));
}
records.add(currentRow);
}
// Get the metadata for the results
rmetadata = results.getMetaData();
logger.fine(Messages.getString(Messages.JDBC.MMDatabaseMetadata_getschema_success));
// construct results object from column values and their metadata
return dummyStatement().createResultSet(records, rmetadata);
} catch (Exception e) {
throw new SQLException(Messages.getString(Messages.JDBC.MMDatabaseMetadata_getschema_error, e.getMessage()), e);
} finally {
if (prepareQuery != null) {
prepareQuery.close();
}
}
}
/* Do not override to allow compatibility with jdk 1.6 */
public boolean generatedKeyAlwaysReturned() throws SQLException {
return false;
}
/* Do not override to allow compatibility with jdk 1.6 */
public ResultSet getPseudoColumns(String catalog, String schemaPattern,
String tableNamePattern, String columnNamePattern)
throws SQLException {
throw new UnsupportedOperationException();
}
}