/*
* ModeShape (http://www.modeshape.org)
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.modeshape.jdbc.metadata;
/* <p> This class contains constants indicating names of the columns in the
* result sets returned by methods on JcrMetaData. Each inner class represents
* a particular method and the class attributes give the names of the columns on
* methods ResultSet.</p>
*/
public 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 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 hard code the column names used in construction of 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 getCrossReference, getExportedKeys, and
* getImportedKeys methods on DatabaseMetaData. These constant values are be used to hard code the column names used in
* construction 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 hard code the column names used in construction 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 getIndexInfo method on DatabaseMetaData.
* These constant values are be used to hard code the column names used in construction 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 getImportedKeys method on
* DatabaseMetaData. These constant values are be used to hard code the column names used in construction the ResultSet obj.
*/
interface REFERENCE_KEYS_INFO {
// name of the column containing tables catalog name on which the primary key is present
static final String PK_TABLE_CAT = "PKTABLE_CAT"; //$NON-NLS-1$
// name of the column containing tables schema name on which the primary key is present
static final String PK_TABLE_SCHEM = "PKTABLE_SCHEM"; //$NON-NLS-1$
// name of the column containing primary key's table or group name.
static final String PK_TABLE_NAME = "PKTABLE_NAME"; //$NON-NLS-1$
// name of the column containing primary key's column name.
static final String PK_COLUMN_NAME = "PKCOLUMN_NAME"; //$NON-NLS-1$
// name of the column containing tables catalog name on which the foreign key is present
static final String FK_TABLE_CAT = "FKTABLE_CAT"; //$NON-NLS-1$
// name of the column containing tables schema name on which the foreign key is present
static final String FK_TABLE_SCHEM = "FKTABLE_SCHEM"; //$NON-NLS-1$
// name of the column containing foreign key's table or group name.
static final String FK_TABLE_NAME = "FKTABLE_NAME"; //$NON-NLS-1$
// name of the column containing foreign key's column name.
static final String FK_COLUMN_NAME = "PKCOLUMN_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 the delete rule
static final String UPDATE_RULE = "UPDATE_RULE"; //$NON-NLS-1$
// name of the column containing the delete rule
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$
static final String DEFERRABILITY = "DEFERRABILITY"; //$NON-NLS-1$
}
/**
* This class contains constants representing column names on ResultSet returned by getProcedures on DatabaseMetaData. These
* constant values are be used to hardcode the column names used in construction the ResultSet obj.
*/
interface PROCEDURES {
// name of the column containing catalog name.
static final String PROCEDURE_CAT = "PROCEDURE_CAT"; //$NON-NLS-1$
// name of the column containing schema name.
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$
static final String RESERVED1 = ""; //$NON-NLS-1$
static final String RESERVED2 = ""; //$NON-NLS-1$
static final String RESERVED3 = ""; //$NON-NLS-1$
// name of column containing explanatory notes.
static final String REMARKS = "REMARKS"; //$NON-NLS-1$
static final String PROCEDURE_TYPE = "PROCEDURE_TYPE"; //$NON-NLS-1$
static final String SPECIFIC_NAME = "SPECIFIC_NAME"; //$NON-NLS-1$
}
}