/*
* 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;
/* <p> This class contains constants indicating names of the columns in the
* result sets returned by methods on DatabaseMetaData. Each inner class represents
* a particular method and the class attributes give the names of the columns on
* methods ResultSet.</p>
*/
interface JDBCColumnNames {
/**
* This class contains constants representing column names on ResultSet
* returned by getCatalogs method on DatabaseMetaData. These constant values
* are be used for the column names used in constructing the ResultSet obj.
*/
interface CATALOGS {
// name of the column containing catalog or Virtual database name.
static final String TABLE_CAT = "TABLE_CAT"; //$NON-NLS-1$
}
/**
* This class contains constants representing column names on ResultSet
* returned by getColumns method on DatabaseMetaData. These constant values
* are be used to hardcode the column names used in constructin the ResultSet obj.
*/
interface COLUMNS {
// name of the column containing catalog or Virtual database name.
static final String TABLE_CAT = "TABLE_CAT"; //$NON-NLS-1$
// name of the column containing schema or Virtual database version.
static final String TABLE_SCHEM = "TABLE_SCHEM"; //$NON-NLS-1$
// name of the column containing table or group name.
static final String TABLE_NAME = "TABLE_NAME"; //$NON-NLS-1$
// name of the column containing column or element name.
static final String COLUMN_NAME = "COLUMN_NAME"; //$NON-NLS-1$
/** name of column that contains SQL type from java.sql.Types for column's data type. */
static final String DATA_TYPE = "DATA_TYPE"; //$NON-NLS-1$
/** name of column that contains local type name used by the data source. */
static final String TYPE_NAME = "TYPE_NAME"; //$NON-NLS-1$
// name of the column containing column size.
static final String COLUMN_SIZE = "COLUMN_SIZE"; //$NON-NLS-1$
/** name of column that is not used will contain nulls */
static final String BUFFER_LENGTH = "BUFFER_LENGTH"; //$NON-NLS-1$
// name of the column containing number of digits to right of decimal
static final String DECIMAL_DIGITS = "DECIMAL_DIGITS"; //$NON-NLS-1$
// name of the column containing column's Radix.
static final String NUM_PREC_RADIX = "NUM_PREC_RADIX"; //$NON-NLS-1$
/** name of column that has an String value indicating nullablity */
static final String NULLABLE = "NULLABLE"; //$NON-NLS-1$
/** name of column containing explanatory notes. */
static final String REMARKS = "REMARKS"; //$NON-NLS-1$
/** name of column which contails default value for the column. */
static final String COLUMN_DEF = "COLUMN_DEF"; //$NON-NLS-1$
/** name of column that not used will contain nulls */
static final String SQL_DATA_TYPE = "SQL_DATA_TYPE"; //$NON-NLS-1$
/** name of column that not used will contain nulls */
static final String SQL_DATETIME_SUB = "SQL_DATETIME_SUB"; //$NON-NLS-1$
/** name of column that stores the max number of bytes in the column */
static final String CHAR_OCTET_LENGTH = "CHAR_OCTET_LENGTH"; //$NON-NLS-1$
/** name of column that stores the index of a column in the table */
static final String ORDINAL_POSITION = "ORDINAL_POSITION"; //$NON-NLS-1$
/** name of column that has an String value indicating nullablity */
static final String IS_NULLABLE = "IS_NULLABLE"; //$NON-NLS-1$
/** name of column that is the scope of a reference attribute (null if DATA_TYPE isn't REF)*/
static final String SCOPE_CATLOG = "SCOPE_CATLOG"; //$NON-NLS-1$
/** name of column that is the scope of a reference attribute (null if the DATA_TYPE isn't REF) */
static final String SCOPE_SCHEMA = "SCOPE_SCHEMA"; //$NON-NLS-1$
/** name of column that is the scope of a reference attribure (null if the DATA_TYPE isn't REF) */
static final String SCOPE_TABLE = "SCOPE_TABLE"; //$NON-NLS-1$
/**
* name of column that is source type of a distinct type or user-generated Ref type, SQL type
* from java.sql.Types (null if DATA_TYPE isn't DISTINCT or user-generated REF)
*/
static final String SOURCE_DATA_TYPE = "SOURCE_DATA_TYPE"; //$NON-NLS-1$
/** name of column that has an String value indicating format */
static final String FORMAT = "FORMAT"; //$NON-NLS-1$
/** name of column that has an String value indicating minimum range */
static final String MIN_RANGE = "MIN_RANGE"; //$NON-NLS-1$
/** name of column that has an String value indicating maximum range */
static final String MAX_RANGE = "MAX_RANGE"; //$NON-NLS-1$
}
/**
* This class contains constants representing column names on ResultSet
* returned by getColumnPrivileges and getTablePrivileges methods on
* DatabaseMetaData. These constant values are be used to hardcode the column
* names used in constructin the ResultSet obj.
*/
interface PRIVILEGES {
// name of the column containing catalog or Virtual database name.
static final String TABLE_CAT = "TABLE_CAT"; //$NON-NLS-1$
// name of the column containing schema or Virtual database version.
static final String TABLE_SCHEM = "TABLE_SCHEM"; //$NON-NLS-1$
// name of the column containing table or group name.
static final String TABLE_NAME = "TABLE_NAME"; //$NON-NLS-1$
// name of the column containing column or element name.
static final String COLUMN_NAME = "COLUMN_NAME"; //$NON-NLS-1$
// name of the column containing Grantor name
static final String GRANTOR = "GRANTOR"; //$NON-NLS-1$
// name of the column containing Grantee name
static final String GRANTEE = "GRANTEE"; //$NON-NLS-1$
// name of the column containing privilege name
static final String PRIVILEGE = "PRIVILEGE"; //$NON-NLS-1$
// name of the column containing privilage grantable info
static final String IS_GRANTABLE = "IS_GRANTABLE"; //$NON-NLS-1$
}
/**
* This class contains constants representing column names on ResultSet
* returned by getCrossReference, getExportedKeys, and getImportedKeys methods
* on DatabaseMetaData. These constant values are be used to hardcode the
* column names used in constructin the ResultSet obj.
*/
interface REFERENCE_KEYS {
// name of the column containing catalog or Virtual database name for primary key's table.
static final String PKTABLE_CAT = "PKTABLE_CAT"; //$NON-NLS-1$
// name of the column containing schema or Virtual database version for primary key's table.
static final String PKTABLE_SCHEM = "PKTABLE_SCHEM"; //$NON-NLS-1$
// name of the column containing table or group name for primary key's table.
static final String PKTABLE_NAME = "PKTABLE_NAME"; //$NON-NLS-1$
// name of the column containing column or element name of the primary key.
static final String PKCOLUMN_NAME = "PKCOLUMN_NAME"; //$NON-NLS-1$
// name of the column containing catalog or Virtual database name for foreign key's table.
static final String FKTABLE_CAT = "FKTABLE_CAT"; //$NON-NLS-1$
// name of the column containing schema or Virtual database version for foreign key's table.
static final String FKTABLE_SCHEM = "FKTABLE_SCHEM"; //$NON-NLS-1$
// name of the column containing table or group name for foreign key's table.
static final String FKTABLE_NAME = "FKTABLE_NAME"; //$NON-NLS-1$
// name of the column containing column or element name of the foreign key.
static final String FKCOLUMN_NAME = "FKCOLUMN_NAME"; //$NON-NLS-1$
// name of the column containing sequence number within the foreign key
static final String KEY_SEQ = "KEY_SEQ"; //$NON-NLS-1$
// name of the column containing effect on foreign key when PK is updated.
static final String UPDATE_RULE = "UPDATE_RULE"; //$NON-NLS-1$
// name of the column containing effect on foreign key when PK is deleted.
static final String DELETE_RULE = "DELETE_RULE"; //$NON-NLS-1$
// name of the column containing name of the foreign key.
static final String FK_NAME = "FK_NAME"; //$NON-NLS-1$
// name of the column containing name of the primary key.
static final String PK_NAME = "PK_NAME"; //$NON-NLS-1$
// name of the column containing deferability of foreign key constraStrings.
static final String DEFERRABILITY = "DEFERRABILITY"; //$NON-NLS-1$
static final String FKPOSITION = "FKPOSITION"; //$NON-NLS-1$
}
/**
* This class contains constants representing column names on ResultSet
* returned by getPrimaryKeys method on DatabaseMetaData. These constant values
* are be used to hardcode the column names used in constructin the ResultSet obj.
*/
interface PRIMARY_KEYS {
// name of the column containing catalog or Virtual database name.
static final String TABLE_CAT = "TABLE_CAT"; //$NON-NLS-1$
// name of the column containing schema or Virtual database version.
static final String TABLE_SCHEM = "TABLE_SCHEM"; //$NON-NLS-1$
// name of the column containing table or group name.
static final String TABLE_NAME = "TABLE_NAME"; //$NON-NLS-1$
// name of the column containing column or element name.
static final String COLUMN_NAME = "COLUMN_NAME"; //$NON-NLS-1$
// name of the column containing sequence number within the primary key
static final String KEY_SEQ = "KEY_SEQ"; //$NON-NLS-1$
// name of the column containing name of the primary key.
static final String PK_NAME = "PK_NAME"; //$NON-NLS-1$
static final String POSITION = "POSITION"; //$NON-NLS-1$
}
/**
* This class contains constants representing column names on ResultSet
* returned by getProcedureColumns method on DatabaseMetaData. These constant
* values are be used to hardcode the column names used in constructin the
* ResultSet obj.
*/
interface PROCEDURE_COLUMNS {
// name of the column containing procedure catalog or Virtual database name.
static final String PROCEDURE_CAT = "PROCEDURE_CAT"; //$NON-NLS-1$
// name of the column containing schema or Virtual database version.
static final String PROCEDURE_SCHEM = "PROCEDURE_SCHEM"; //$NON-NLS-1$
// name of the column containing table or group name.
static final String PROCEDURE_NAME = "PROCEDURE_NAME"; //$NON-NLS-1$
// name of the column containing column or element name.
static final String COLUMN_NAME = "COLUMN_NAME"; //$NON-NLS-1$
// name of the column containing column or element type.
static final String COLUMN_TYPE = "COLUMN_TYPE"; //$NON-NLS-1$
/** name of column that contains SQL type from java.sql.Types for column's data type. */
static final String DATA_TYPE = "DATA_TYPE"; //$NON-NLS-1$
/** name of column that contains local type name used by the data source. */
static final String TYPE_NAME = "TYPE_NAME"; //$NON-NLS-1$
// name of the column containing number of digits to right of decimal
static final String PRECISION = "PRECISION"; //$NON-NLS-1$
/** name of column that that contains length of data in bytes */
static final String LENGTH = "LENGTH"; //$NON-NLS-1$
// constant indiacting column's Radix.
static final String SCALE = "SCALE"; //$NON-NLS-1$
// constant indiacting column's Radix.
static final String RADIX = "RADIX"; //$NON-NLS-1$
/** name of column that has an String value indicating nullablity */
static final String NULLABLE = "NULLABLE"; //$NON-NLS-1$
/** name of column containing explanatory notes. */
static final String REMARKS = "REMARKS"; //$NON-NLS-1$
static final String POSITION = "POSITION"; //$NON-NLS-1$
}
/**
* This class contains constants representing column names on ResultSet
* returned by getProcedures method on DatabaseMetaData. These constant values
* are be used to hardcode the column names used in constructin the ResultSet obj.
*/
interface PROCEDURES {
// name of the column containing procedure catalog or Virtual database name.
static final String PROCEDURE_CAT = "PROCEDURE_CAT"; //$NON-NLS-1$
// name of the column containing schema or Virtual database version.
static final String PROCEDURE_SCHEM = "PROCEDURE_SCHEM"; //$NON-NLS-1$
// name of the column containing table or group name.
static final String PROCEDURE_NAME = "PROCEDURE_NAME"; //$NON-NLS-1$
// name of the column containing name of the column which is reserved
//static final String RESERVED = "RESERVED";
/** name of column containing explanatory notes. */
static final String REMARKS = "REMARKS"; //$NON-NLS-1$
/** name of column indicating kind of the procedure. */
static final String PROCEDURE_TYPE = "PROCEDURE_TYPE"; //$NON-NLS-1$
static final String RESERVED_1 = "RESERVED_1"; //$NON-NLS-1$
static final String RESERVED_2 = "RESERVED_2"; //$NON-NLS-1$
static final String RESERVED_3 = "RESERVED_3"; //$NON-NLS-1$
}
/**
* This class contains constants representing column names on ResultSet
* returned by getSchemas method on DatabaseMetaData. These constant values
* are be used to hardcode the column names used in constructin the ResultSet obj.
*/
interface SCHEMAS {
// name of the column containing procedure catalog or Virtual database name.
static final String TABLE_SCHEM = "TABLE_SCHEM"; //$NON-NLS-1$
// name of the column containing schema or Virtual database version.
static final String TABLE_CATALOG = "TABLE_CATALOG"; //$NON-NLS-1$
}
/**
* This class contains constants representing column names on ResultSet
* returned by getTables and getTableTypes methods on DatabaseMetaData. These
* constant values are be used to hardcode the column names used in construction
* the ResultSet obj.
*/
interface TABLES {
// name of the column containing catalog or Virtual database name.
static final String TABLE_CAT = "TABLE_CAT"; //$NON-NLS-1$
// name of the column containing schema or Virtual database version.
static final String TABLE_SCHEM = "TABLE_SCHEM"; //$NON-NLS-1$
// name of the column containing table or group name.
static final String TABLE_NAME = "TABLE_NAME"; //$NON-NLS-1$
// name of the column containing table or group type.
static final String TABLE_TYPE = "TABLE_TYPE"; //$NON-NLS-1$
/** name of column containing explanatory notes. */
static final String REMARKS = "REMARKS"; //$NON-NLS-1$
static final String TYPE_CAT = "TYPE_CAT"; //$NON-NLS-1$
static final String TYPE_SCHEM = "TYPE_SCHEM"; //$NON-NLS-1$
static final String TYPE_NAME = "TYPE_NAME"; //$NON-NLS-1$
static final String SELF_REFERENCING_COL_NAME = "SELF_REFERENCING_COL_NAME"; //$NON-NLS-1$
static final String REF_GENERATION = "REF_GENERATION"; //$NON-NLS-1$
static final String ISPHYSICAL = "ISPHYSICAL"; //$NON-NLS-1$
}
/**
* This class contains constants representing column names on ResultSet
* returned by getTables and getTableTypes methods on DatabaseMetaData. These
* constant values are be used to hardcode the column names used in construction
* the ResultSet obj.
*/
interface TABLE_TYPES {
// name of the column containing table or group type.
static final String TABLE_TYPE = "TABLE_TYPE"; //$NON-NLS-1$
}
/**
* This class contains constants representing column names on ResultSet
* returned by getTypeInfo method on DatabaseMetaData. These constant values
* are be used to hardcode the column names used in constructin the ResultSet obj.
*/
interface TYPE_INFO {
/** name of column that contains local type name used by the data source. */
static final String TYPE_NAME = "TYPE_NAME"; //$NON-NLS-1$
/** name of column that contains SQL type from java.sql.Types for column's data type. */
static final String DATA_TYPE = "DATA_TYPE"; //$NON-NLS-1$
// name of the column containing number of digits to right of decimal
static final String PRECISION = "PRECISION"; //$NON-NLS-1$
// name of the column containing prefix used to quote a literal
static final String LITERAL_PREFIX = "LITERAL_PREFIX"; //$NON-NLS-1$
// name of the column containing suffix used to quote a literal
static final String LITERAL_SUFFIX = "LITERAL_SUFFIX"; //$NON-NLS-1$
// name of the column containing params used in creating the type
static final String CREATE_PARAMS = "CREATE_PARAMS"; //$NON-NLS-1$
/** name of column that has an String value indicating nullablity */
static final String NULLABLE = "NULLABLE"; //$NON-NLS-1$
/** name of column that has an String value indicating case sensitivity */
static final String CASE_SENSITIVE = "CASE_SENSITIVE"; //$NON-NLS-1$
/** name of column that has an String value indicating searchability */
static final String SEARCHABLE = "SEARCHABLE"; //$NON-NLS-1$
/** name of column that has an String value indicating searchability */
static final String UNSIGNED_ATTRIBUTE = "UNSIGNED_ATTRIBUTE"; //$NON-NLS-1$
/** name of column that contains info if the column is a currency value */
static final String FIXED_PREC_SCALE = "FIXED_PREC_SCALE"; //$NON-NLS-1$
/** name of column that contains info whether the column is autoincrementable */
static final String AUTOINCREMENT = "AUTO_INCREMENT"; //$NON-NLS-1$
/** name of column that localised version of type name */
static final String LOCAL_TYPE_NAME = "LOCAL_TYPE_NAME"; //$NON-NLS-1$
/** name of column that gives the min scale supported */
static final String MINIMUM_SCALE = "MINIMUM_SCALE"; //$NON-NLS-1$
/** name of column that gives the max scale supported */
static final String MAXIMUM_SCALE = "MAXIMUM_SCALE"; //$NON-NLS-1$
/** name of column that not used will contain nulls */
static final String SQL_DATA_TYPE = "SQL_DATA_TYPE"; //$NON-NLS-1$
/** name of column that not used will contain nulls */
static final String SQL_DATETIME_SUB = "SQL_DATETIME_SUB"; //$NON-NLS-1$
// constant indiacting column's Radix.
static final String NUM_PREC_RADIX = "NUM_PREC_RADIX"; //$NON-NLS-1$
}
/**
* This class contains constants representing column names on ResultSet
* returned by getUDTS method on DatabaseMetaData. These constant values
* are be used to hardcode the column names used in constructin the ResultSet obj.
*/
interface UDTS {
// name of the column containing table or Groups name in which UDTS are present.
static final String TABLE_NAME = "UDTS"; //$NON-NLS-1$
// name of the column containing catalog or Virtual database name.
static final String TYPE_CAT = "TYPE_CAT"; //$NON-NLS-1$
// name of the column containing schema or Virtual database version.
static final String TYPE_SCHEM = "TYPE_SCHEM"; //$NON-NLS-1$
// name of the column containing name of type name column.
static final String TYPE_NAME = "TYPE_NAME"; //$NON-NLS-1$
// name of the column containing class name column.
static final String CLASS_NAME = "CLASS_NAME"; //$NON-NLS-1$
// name of the column containing name of sql datatype code column
static final String DATA_TYPE = "DATA_TYPE"; //$NON-NLS-1$
// name of the column containing comments column
static final String REMARKS = "REMARKS"; //$NON-NLS-1$
static final String BASE_TYPE = "BASE_TYPE"; //$NON-NLS-1$
}
/**
* This class contains constants representing column names on ResultSet
* returned by getIndexInfo method on DatabaseMetaData. These constant values
* are be used to hardcode the column names used in constructin the ResultSet obj.
*/
interface INDEX_INFO {
// name of the column containing tables catalog name on which the index is present
static final String TABLE_CAT = "TABLE_CAT"; //$NON-NLS-1$
// name of the column containing tables schema name on which the index is present
static final String TABLE_SCHEM = "TABLE_SCHEM"; //$NON-NLS-1$
// name of the column containing table or group name.
static final String TABLE_NAME = "TABLE_NAME"; //$NON-NLS-1$
// name of the column containing name of column showing if an index in non-unique
static final String NON_UNIQUE = "NON_UNIQUE"; //$NON-NLS-1$
// name of the column containing name of column containing index_qualifier string
static final String INDEX_QUALIFIER = "INDEX_QUALIFIER"; //$NON-NLS-1$
// name of the column containing name of column containing index names
static final String INDEX_NAME = "INDEX_NAME"; //$NON-NLS-1$
// name of the column containing name of column containing index types
static final String TYPE = "TYPE"; //$NON-NLS-1$
// name of the column containing name of the column containing column position.
static final String ORDINAL_POSITION = "ORDINAL_POSITION"; //$NON-NLS-1$
// name of the column containing name of the column containing column names.
static final String COLUMN_NAME = "COLUMN_NAME"; //$NON-NLS-1$
// name of the column containing name of column containing info if the index is asc or desc.
static final String ASC_OR_DESC = "ASC_OR_DESC"; //$NON-NLS-1$
// name of the column containing name of the column containing number of unique values in index.
static final String CARDINALITY = "CARDINALITY"; //$NON-NLS-1$
// name of the column containing name of the column giving number od pages used for the current index.
static final String PAGES = "PAGES"; //$NON-NLS-1$
// name of the column containing name of the column giving filter condition.
static final String FILTER_CONDITION = "FILTER_CONDITION"; //$NON-NLS-1$
}
/**
* This class contains constants representing column names on ResultSet
* returned by getBestRowIdentifier method on DatabaseMetaData. These constant values
* are be used to hardcode the column names used in constructin the ResultSet obj.
*/
interface BEST_ROW {
// name of the column containing SCOPE of the identifier
static final String SCOPE = "SCOPE"; //$NON-NLS-1$
// name of the column containing column name
static final String COLUMN_NAME = "COLUMN_NAME"; //$NON-NLS-1$
// name of the column containing data type code
static final String DATA_TYPE = "DATA_TYPE"; //$NON-NLS-1$
// name of the column containing data type name
static final String TYPE_NAME = "TYPE_NAME"; //$NON-NLS-1$
// name of the column containing size of the column
static final String COLUMN_SIZE = "COLUMN_SIZE"; //$NON-NLS-1$
// name of the column containing buffer length
static final String BUFFER_LENGTH = "BUFFER_LENGTH"; //$NON-NLS-1$
// name of the column containing decimal digits/ scale
static final String DECIMAL_DIGITS = "DECIMAL_DIGITS"; //$NON-NLS-1$
// name of the column containing name of the column containing column position.
static final String ORDINAL_POSITION = "ORDINAL_POSITION"; //$NON-NLS-1$
// name of the column containing pseudo column
static final String PSEUDO_COLUMN = "PSEUDO_COLUMN"; //$NON-NLS-1$
}
/**
* This class contains constants representing column names on ResultSet
* returned by getSuperTables method on DatabaseMetaData. These constant values
* are be used to hardcode the column names used in constructin the ResultSet obj.
*/
interface SUPER_TABLES {
// name of the column containing catalog or Virtual database name.
static final String TABLE_CAT = "TABLE_CAT"; //$NON-NLS-1$
// name of the column containing schema or Virtual database version.
static final String TABLE_SCHEM = "TABLE_SCHEM"; //$NON-NLS-1$
// name of the column containing table or Groups name .
static final String TABLE_NAME = "TABLE_NAME"; //$NON-NLS-1$
// name of the column containing super table.
static final String SUPERTABLE_NAME = "SUPERTABLE_NAME"; //$NON-NLS-1$
}
/**
* This class contains constants representing column names on ResultSet
* returned by getSuperTypes method on DatabaseMetaData. These constant values
* are be used to hardcode the column names used in constructin the ResultSet obj.
*/
interface SUPER_TYPES {
// name of the column containing catalog or Virtual database name.
static final String TYPE_CAT = "TYPE_CAT"; //$NON-NLS-1$
// name of the column containing schema or Virtual database version.
static final String TYPE_SCHEM = "TYPE_SCHEM"; //$NON-NLS-1$
// name of the column containing name of type name column.
static final String TYPE_NAME = "TYPE_NAME"; //$NON-NLS-1$
// name of the column containing super catalog or Virtual database name.
static final String SUPERTYPE_CAT = "SUPERTYPE_CAT"; //$NON-NLS-1$
// name of the column containing super schema or Virtual database version.
static final String SUPERTYPE_SCHEM = "SUPERTYPE_SCHEM"; //$NON-NLS-1$
// name of the column containing name of super type name column.
static final String SUPERTYPE_NAME = "SUPERTYPE_NAME"; //$NON-NLS-1$
}
}