org.tarantool.util.JdbcConstants Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of connector Show documentation
Show all versions of connector Show documentation
Tarantool client for java
The newest version!
package org.tarantool.util;
import org.tarantool.jdbc.type.TarantoolSqlType;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.SQLNonTransientException;
import java.sql.Statement;
import java.util.Arrays;
import java.util.Collections;
import java.util.List;
public class JdbcConstants {
private JdbcConstants() {
}
public static void checkGeneratedKeysConstant(int autoGeneratedKeys) throws SQLException {
if (autoGeneratedKeys != Statement.NO_GENERATED_KEYS &&
autoGeneratedKeys != Statement.RETURN_GENERATED_KEYS) {
throw new SQLNonTransientException("", SQLStates.INVALID_PARAMETER_VALUE.getSqlState());
}
}
public static void checkHoldabilityConstant(int holdability) throws SQLException {
if (holdability != ResultSet.CLOSE_CURSORS_AT_COMMIT &&
holdability != ResultSet.HOLD_CURSORS_OVER_COMMIT) {
throw new SQLNonTransientException("", SQLStates.INVALID_PARAMETER_VALUE.getSqlState());
}
}
public static void checkCurrentResultConstant(int currentResult) throws SQLException {
if (currentResult != Statement.CLOSE_CURRENT_RESULT &&
currentResult != Statement.CLOSE_ALL_RESULTS &&
currentResult != Statement.KEEP_CURRENT_RESULT) {
throw new SQLNonTransientException("", SQLStates.INVALID_PARAMETER_VALUE.getSqlState());
}
}
public static class DatabaseMetadataTable {
private DatabaseMetadataTable() {
}
@SuppressWarnings("unchecked")
public static List> STORED_PROCEDURES = Arrays.asList(
TupleTwo.of("PROCEDURE_CAT", TarantoolSqlType.VARCHAR),
TupleTwo.of("PROCEDURE_SCHEM", TarantoolSqlType.VARCHAR),
TupleTwo.of("PROCEDURE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("RESERVED_1", TarantoolSqlType.UNKNOWN),
TupleTwo.of("RESERVED_2", TarantoolSqlType.UNKNOWN),
TupleTwo.of("RESERVED_3", TarantoolSqlType.UNKNOWN),
TupleTwo.of("REMARKS", TarantoolSqlType.VARCHAR),
TupleTwo.of("PROCEDURE_TYPE", TarantoolSqlType.INTEGER),
TupleTwo.of("SPECIFIC_NAME", TarantoolSqlType.VARCHAR)
);
@SuppressWarnings("unchecked")
public static List> STORED_PROCEDURE_COLUMNS = Arrays.asList(
TupleTwo.of("PROCEDURE_CAT", TarantoolSqlType.VARCHAR),
TupleTwo.of("PROCEDURE_SCHEM", TarantoolSqlType.VARCHAR),
TupleTwo.of("PROCEDURE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("COLUMN_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("COLUMN_TYPE", TarantoolSqlType.INTEGER),
TupleTwo.of("DATA_TYPE", TarantoolSqlType.INTEGER),
TupleTwo.of("TYPE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("PRECISION", TarantoolSqlType.INTEGER),
TupleTwo.of("LENGTH", TarantoolSqlType.INTEGER),
TupleTwo.of("SCALE", TarantoolSqlType.INTEGER),
TupleTwo.of("RADIX", TarantoolSqlType.INTEGER),
TupleTwo.of("NULLABLE", TarantoolSqlType.INTEGER),
TupleTwo.of("REMARKS", TarantoolSqlType.VARCHAR),
TupleTwo.of("COLUMN_DEF", TarantoolSqlType.VARCHAR),
TupleTwo.of("SQL_DATA_TYPE", TarantoolSqlType.INTEGER),
TupleTwo.of("SQL_DATETIME_SUB", TarantoolSqlType.INTEGER),
TupleTwo.of("CHAR_OCTET_LENGTH", TarantoolSqlType.INTEGER),
TupleTwo.of("ORDINAL_POSITION", TarantoolSqlType.INTEGER),
TupleTwo.of("IS_NULLABLE", TarantoolSqlType.VARCHAR),
TupleTwo.of("SPECIFIC_NAME", TarantoolSqlType.VARCHAR)
);
@SuppressWarnings("unchecked")
public static List> TABLES = Arrays.asList(
TupleTwo.of("TABLE_CAT", TarantoolSqlType.VARCHAR),
TupleTwo.of("TABLE_SCHEM", TarantoolSqlType.VARCHAR),
TupleTwo.of("TABLE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("TABLE_TYPE", TarantoolSqlType.VARCHAR),
TupleTwo.of("REMARKS", TarantoolSqlType.VARCHAR),
TupleTwo.of("TYPE_CAT", TarantoolSqlType.VARCHAR),
TupleTwo.of("TYPE_SCHEM", TarantoolSqlType.VARCHAR),
TupleTwo.of("TYPE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("SELF_REFERENCING_COL_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("REF_GENERATION", TarantoolSqlType.VARCHAR)
);
@SuppressWarnings("unchecked")
public static List> TABLE_TYPES = Collections.singletonList(
TupleTwo.of("TABLE_TYPE", TarantoolSqlType.VARCHAR)
);
@SuppressWarnings("unchecked")
public static List> SCHEMAS = Arrays.asList(
TupleTwo.of("TABLE_SCHEM", TarantoolSqlType.VARCHAR),
TupleTwo.of("TABLE_CATALOG", TarantoolSqlType.VARCHAR)
);
@SuppressWarnings("unchecked")
public static List> CATALOGS = Collections.singletonList(
TupleTwo.of("TABLE_CAT", TarantoolSqlType.VARCHAR)
);
@SuppressWarnings("unchecked")
public static List> BEST_ROW_IDENTIFIER = Arrays.asList(
TupleTwo.of("SCOPE", TarantoolSqlType.INTEGER),
TupleTwo.of("COLUMN_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("DATA_TYPE", TarantoolSqlType.INTEGER),
TupleTwo.of("TYPE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("COLUMN_SIZE", TarantoolSqlType.INTEGER),
TupleTwo.of("BUFFER_LENGTH", TarantoolSqlType.INTEGER),
TupleTwo.of("DECIMAL_DIGITS", TarantoolSqlType.INTEGER),
TupleTwo.of("PSEUDO_COLUMN", TarantoolSqlType.INTEGER)
);
@SuppressWarnings("unchecked")
public static List> COLUMNS = Arrays.asList(
TupleTwo.of("TABLE_CAT", TarantoolSqlType.VARCHAR),
TupleTwo.of("TABLE_SCHEM", TarantoolSqlType.VARCHAR),
TupleTwo.of("TABLE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("COLUMN_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("DATA_TYPE", TarantoolSqlType.INTEGER),
TupleTwo.of("TYPE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("COLUMN_SIZE", TarantoolSqlType.INTEGER),
TupleTwo.of("BUFFER_LENGTH", TarantoolSqlType.INTEGER),
TupleTwo.of("DECIMAL_DIGITS", TarantoolSqlType.INTEGER),
TupleTwo.of("NUM_PREC_RADIX", TarantoolSqlType.INTEGER),
TupleTwo.of("NULLABLE", TarantoolSqlType.INTEGER),
TupleTwo.of("REMARKS", TarantoolSqlType.VARCHAR),
TupleTwo.of("COLUMN_DEF", TarantoolSqlType.VARCHAR),
TupleTwo.of("SQL_DATA_TYPE", TarantoolSqlType.INTEGER),
TupleTwo.of("SQL_DATETIME_SUB", TarantoolSqlType.INTEGER),
TupleTwo.of("CHAR_OCTET_LENGTH", TarantoolSqlType.INTEGER),
TupleTwo.of("ORDINAL_POSITION", TarantoolSqlType.INTEGER),
TupleTwo.of("IS_NULLABLE", TarantoolSqlType.VARCHAR),
TupleTwo.of("SCOPE_CATALOG", TarantoolSqlType.VARCHAR),
TupleTwo.of("SCOPE_SCHEMA", TarantoolSqlType.VARCHAR),
TupleTwo.of("SCOPE_TABLE", TarantoolSqlType.VARCHAR),
TupleTwo.of("SOURCE_DATA_TYPE", TarantoolSqlType.INTEGER),
TupleTwo.of("IS_AUTOINCREMENT", TarantoolSqlType.VARCHAR),
TupleTwo.of("IS_GENERATEDCOLUMN", TarantoolSqlType.VARCHAR)
);
@SuppressWarnings("unchecked")
public static List> COLUMN_PRIVILEGES = Arrays.asList(
TupleTwo.of("TABLE_CAT", TarantoolSqlType.VARCHAR),
TupleTwo.of("TABLE_SCHEM", TarantoolSqlType.VARCHAR),
TupleTwo.of("TABLE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("COLUMN_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("GRANTOR", TarantoolSqlType.VARCHAR),
TupleTwo.of("GRANTEE", TarantoolSqlType.VARCHAR),
TupleTwo.of("PRIVILEGE", TarantoolSqlType.VARCHAR),
TupleTwo.of("IS_GRANTABLE", TarantoolSqlType.VARCHAR)
);
@SuppressWarnings("unchecked")
public static List> TABLE_PRIVILEGES = Arrays.asList(
TupleTwo.of("TABLE_CAT", TarantoolSqlType.VARCHAR),
TupleTwo.of("TABLE_SCHEM", TarantoolSqlType.VARCHAR),
TupleTwo.of("TABLE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("GRANTOR", TarantoolSqlType.VARCHAR),
TupleTwo.of("GRANTEE", TarantoolSqlType.VARCHAR),
TupleTwo.of("PRIVILEGE", TarantoolSqlType.VARCHAR),
TupleTwo.of("IS_GRANTABLE", TarantoolSqlType.VARCHAR)
);
@SuppressWarnings("unchecked")
public static List> VERSION_COLUMNS = Arrays.asList(
TupleTwo.of("SCOPE", TarantoolSqlType.INTEGER),
TupleTwo.of("COLUMN_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("DATA_TYPE", TarantoolSqlType.INTEGER),
TupleTwo.of("TYPE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("COLUMN_SIZE", TarantoolSqlType.INTEGER),
TupleTwo.of("BUFFER_LENGTH", TarantoolSqlType.INTEGER),
TupleTwo.of("DECIMAL_DIGITS", TarantoolSqlType.INTEGER),
TupleTwo.of("PSEUDO_COLUMN", TarantoolSqlType.INTEGER)
);
@SuppressWarnings("unchecked")
public static List> PRIMARY_KEYS = Arrays.asList(
TupleTwo.of("TABLE_CAT", TarantoolSqlType.VARCHAR),
TupleTwo.of("TABLE_SCHEM", TarantoolSqlType.VARCHAR),
TupleTwo.of("TABLE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("COLUMN_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("KEY_SEQ", TarantoolSqlType.INTEGER),
TupleTwo.of("PK_NAME", TarantoolSqlType.VARCHAR)
);
@SuppressWarnings("unchecked")
public static List> FOREIGN_KEYS = Arrays.asList(
TupleTwo.of("PKTABLE_CAT", TarantoolSqlType.VARCHAR),
TupleTwo.of("PKTABLE_SCHEM", TarantoolSqlType.VARCHAR),
TupleTwo.of("PKTABLE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("PKCOLUMN_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("FKTABLE_CAT", TarantoolSqlType.VARCHAR),
TupleTwo.of("FKTABLE_SCHEM", TarantoolSqlType.VARCHAR),
TupleTwo.of("FKTABLE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("FKCOLUMN_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("KEY_SEQ", TarantoolSqlType.INTEGER),
TupleTwo.of("UPDATE_RULE", TarantoolSqlType.INTEGER),
TupleTwo.of("DELETE_RULE", TarantoolSqlType.INTEGER),
TupleTwo.of("FK_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("PK_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("DEFERRABILITY", TarantoolSqlType.INTEGER)
);
@SuppressWarnings("unchecked")
public static List> TYPE_INFO = Arrays.asList(
TupleTwo.of("TYPE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("DATA_TYPE", TarantoolSqlType.INTEGER),
TupleTwo.of("PRECISION", TarantoolSqlType.INTEGER),
TupleTwo.of("LITERAL_PREFIX", TarantoolSqlType.VARCHAR),
TupleTwo.of("LITERAL_SUFFIX", TarantoolSqlType.VARCHAR),
TupleTwo.of("CREATE_PARAMS", TarantoolSqlType.VARCHAR),
TupleTwo.of("NULLABLE", TarantoolSqlType.INTEGER),
TupleTwo.of("CASE_SENSITIVE", TarantoolSqlType.BOOLEAN),
TupleTwo.of("SEARCHABLE", TarantoolSqlType.INTEGER),
TupleTwo.of("UNSIGNED_ATTRIBUTE", TarantoolSqlType.BOOLEAN),
TupleTwo.of("FIXED_PREC_SCALE", TarantoolSqlType.BOOLEAN),
TupleTwo.of("AUTO_INCREMENT", TarantoolSqlType.BOOLEAN),
TupleTwo.of("LOCAL_TYPE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("MINIMUM_SCALE", TarantoolSqlType.INTEGER),
TupleTwo.of("MAXIMUM_SCALE", TarantoolSqlType.INTEGER),
TupleTwo.of("SQL_DATA_TYPE", TarantoolSqlType.INTEGER),
TupleTwo.of("SQL_DATETIME_SUB", TarantoolSqlType.INTEGER),
TupleTwo.of("NUM_PREC_RADIX", TarantoolSqlType.INTEGER)
);
@SuppressWarnings("unchecked")
public static List> INDEX_INFO = Arrays.asList(
TupleTwo.of("TABLE_CAT", TarantoolSqlType.VARCHAR),
TupleTwo.of("TABLE_SCHEM", TarantoolSqlType.VARCHAR),
TupleTwo.of("TABLE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("NON_UNIQUE", TarantoolSqlType.BOOLEAN),
TupleTwo.of("INDEX_QUALIFIER", TarantoolSqlType.VARCHAR),
TupleTwo.of("INDEX_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("TYPE", TarantoolSqlType.INTEGER),
TupleTwo.of("ORDINAL_POSITION", TarantoolSqlType.INTEGER),
TupleTwo.of("COLUMN_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("ASC_OR_DESC", TarantoolSqlType.INTEGER),
TupleTwo.of("CARDINALITY", TarantoolSqlType.VARCHAR),
TupleTwo.of("PAGES", TarantoolSqlType.INTEGER),
TupleTwo.of("FILTER_CONDITION", TarantoolSqlType.VARCHAR)
);
@SuppressWarnings("unchecked")
public static List> UDTS = Arrays.asList(
TupleTwo.of("TYPE_CAT", TarantoolSqlType.VARCHAR),
TupleTwo.of("TYPE_SCHEM", TarantoolSqlType.VARCHAR),
TupleTwo.of("TYPE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("CLASS_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("DATA_TYPE", TarantoolSqlType.INTEGER),
TupleTwo.of("REMARKS", TarantoolSqlType.VARCHAR),
TupleTwo.of("BASE_TYPE", TarantoolSqlType.INTEGER)
);
@SuppressWarnings("unchecked")
public static List> SUPER_TYPES = Arrays.asList(
TupleTwo.of("TYPE_CAT", TarantoolSqlType.VARCHAR),
TupleTwo.of("TYPE_SCHEM", TarantoolSqlType.VARCHAR),
TupleTwo.of("TYPE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("SUPERTYPE_CAT", TarantoolSqlType.VARCHAR),
TupleTwo.of("SUPERTYPE_SCHEM", TarantoolSqlType.VARCHAR),
TupleTwo.of("SUPERTYPE_NAME", TarantoolSqlType.VARCHAR)
);
@SuppressWarnings("unchecked")
public static List> SUPER_TABLES = Arrays.asList(
TupleTwo.of("TYPE_CAT", TarantoolSqlType.VARCHAR),
TupleTwo.of("TABLE_SCHEM", TarantoolSqlType.VARCHAR),
TupleTwo.of("TABLE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("SUPERTABLE_NAME", TarantoolSqlType.VARCHAR)
);
@SuppressWarnings("unchecked")
public static List> FUNCTIONS = Arrays.asList(
TupleTwo.of("FUNCTION_CAT", TarantoolSqlType.VARCHAR),
TupleTwo.of("FUNCTION_SCHEM", TarantoolSqlType.VARCHAR),
TupleTwo.of("FUNCTION_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("REMARKS", TarantoolSqlType.VARCHAR),
TupleTwo.of("FUNCTION_TYPE", TarantoolSqlType.INTEGER),
TupleTwo.of("SPECIFIC_NAME", TarantoolSqlType.VARCHAR)
);
@SuppressWarnings("unchecked")
public static List> FUNCTION_COLUMNS = Arrays.asList(
TupleTwo.of("FUNCTION_CAT", TarantoolSqlType.VARCHAR),
TupleTwo.of("FUNCTION_SCHEM", TarantoolSqlType.VARCHAR),
TupleTwo.of("FUNCTION_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("COLUMN_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("COLUMN_TYPE", TarantoolSqlType.INTEGER),
TupleTwo.of("DATA_TYPE", TarantoolSqlType.INTEGER),
TupleTwo.of("TYPE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("PRECISION", TarantoolSqlType.INTEGER),
TupleTwo.of("LENGTH", TarantoolSqlType.INTEGER),
TupleTwo.of("SCALE", TarantoolSqlType.INTEGER),
TupleTwo.of("RADIX", TarantoolSqlType.INTEGER),
TupleTwo.of("NULLABLE", TarantoolSqlType.INTEGER),
TupleTwo.of("REMARKS", TarantoolSqlType.VARCHAR),
TupleTwo.of("CHAR_OCTET_LENGTH", TarantoolSqlType.INTEGER),
TupleTwo.of("ORDINAL_POSITION", TarantoolSqlType.INTEGER),
TupleTwo.of("IS_NULLABLE", TarantoolSqlType.VARCHAR),
TupleTwo.of("SPECIFIC_NAME", TarantoolSqlType.VARCHAR)
);
@SuppressWarnings("unchecked")
public static List> PSEUDO_COLUMNS = Arrays.asList(
TupleTwo.of("TABLE_CAT", TarantoolSqlType.VARCHAR),
TupleTwo.of("TABLE_SCHEM", TarantoolSqlType.VARCHAR),
TupleTwo.of("TABLE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("COLUMN_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("DATA_TYPE", TarantoolSqlType.INTEGER),
TupleTwo.of("COLUMN_SIZE", TarantoolSqlType.INTEGER),
TupleTwo.of("DECIMAL_DIGITS", TarantoolSqlType.INTEGER),
TupleTwo.of("NUM_PREC_RADIX", TarantoolSqlType.INTEGER),
TupleTwo.of("COLUMN_USAGE", TarantoolSqlType.VARCHAR),
TupleTwo.of("REMARKS", TarantoolSqlType.VARCHAR),
TupleTwo.of("CHAR_OCTET_LENGTH", TarantoolSqlType.INTEGER),
TupleTwo.of("IS_NULLABLE", TarantoolSqlType.VARCHAR)
);
@SuppressWarnings("unchecked")
public static List> ATTRIBUTES = Arrays.asList(
TupleTwo.of("TYPE_CAT", TarantoolSqlType.VARCHAR),
TupleTwo.of("TYPE_SCHEM", TarantoolSqlType.VARCHAR),
TupleTwo.of("TYPE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("ATTR_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("DATA_TYPE", TarantoolSqlType.INTEGER),
TupleTwo.of("ATTR_TYPE_NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("ATTR_SIZE", TarantoolSqlType.INTEGER),
TupleTwo.of("DECIMAL_DIGITS", TarantoolSqlType.INTEGER),
TupleTwo.of("NUM_PREC_RADIX", TarantoolSqlType.INTEGER),
TupleTwo.of("NULLABLE", TarantoolSqlType.INTEGER),
TupleTwo.of("REMARKS", TarantoolSqlType.VARCHAR),
TupleTwo.of("ATTR_DEF", TarantoolSqlType.VARCHAR),
TupleTwo.of("SQL_DATA_TYPE", TarantoolSqlType.INTEGER),
TupleTwo.of("SQL_DATETIME_SUB", TarantoolSqlType.INTEGER),
TupleTwo.of("CHAR_OCTET_LENGTH", TarantoolSqlType.INTEGER),
TupleTwo.of("ORDINAL_POSITION", TarantoolSqlType.INTEGER),
TupleTwo.of("IS_NULLABLE", TarantoolSqlType.VARCHAR),
TupleTwo.of("SCOPE_CATALOG", TarantoolSqlType.VARCHAR),
TupleTwo.of("SCOPE_SCHEMA", TarantoolSqlType.VARCHAR),
TupleTwo.of("SCOPE_TABLE", TarantoolSqlType.VARCHAR),
TupleTwo.of("SOURCE_DATA_TYPE", TarantoolSqlType.INTEGER)
);
@SuppressWarnings("unchecked")
public static List> CLIENT_INFO_PROPERTIES = Arrays.asList(
TupleTwo.of("NAME", TarantoolSqlType.VARCHAR),
TupleTwo.of("MAX_LEN", TarantoolSqlType.INTEGER),
TupleTwo.of("DEFAULT_VALUE", TarantoolSqlType.VARCHAR),
TupleTwo.of("DESCRIPTION", TarantoolSqlType.VARCHAR)
);
}
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy