# Constant Field Values

## Contents

- nl.topicus.*

## nl.topicus.*

nl.topicus.jdbc.CloudSpannerDatabaseMetaDataConstants
`public static final String` `FROM_TABLES_T` `" FROM INFORMATION_SCHEMA.TABLES AS T "`

`public static final String`

`GET_COLUMNS`

`"SELECT TABLE_CATALOG AS TABLE_CAT, TABLE_SCHEMA AS TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, \nCASE \n\tWHEN SPANNER_TYPE LIKE \'ARRAY%\' THEN 2003 \n\tWHEN SPANNER_TYPE = \'BOOL\' THEN 16 \n\tWHEN SPANNER_TYPE LIKE \'BYTES%\' THEN -2 \n\tWHEN SPANNER_TYPE = \'DATE\' THEN 91 \n\tWHEN SPANNER_TYPE = \'FLOAT64\' THEN 8 \n\tWHEN SPANNER_TYPE = \'INT64\' THEN -5 \n\tWHEN SPANNER_TYPE LIKE \'STRING%\' THEN -9 \n\tWHEN SPANNER_TYPE LIKE \'STRUCT%\' THEN 2002 \n\tWHEN SPANNER_TYPE = \'TIMESTAMP\' THEN 93 \nEND AS DATA_TYPE, \nSPANNER_TYPE AS TYPE_NAME, \nCASE \nWHEN strpos(spanner_type, \'(\')=0 then 0 \nELSE cast(replace(substr(spanner_type, strpos(spanner_type, \'(\')+1, strpos(spanner_type, \')\')-strpos(spanner_type, \'(\')-1), \'MAX\', \'0\') as INT64) \nEND AS COLUMN_SIZE, \n0 AS BUFFER_LENGTH, NULL AS DECIMAL_DIGITS, 0 AS NUM_PREC_RADIX, \nCASE \n\tWHEN IS_NULLABLE = \'YES\' THEN 1 \n\tWHEN IS_NULLABLE = \'NO\' THEN 0 \n\tELSE 2 \nEND AS NULLABLE, NULL AS REMARKS, NULL AS COLUMN_DEF, 0 AS SQL_DATA_TYPE, 0 AS SQL_DATETIME_SUB, 0 AS CHAR_OCTET_LENGTH, ORDINAL_POSITION, IS_NULLABLE, NULL AS SCOPE_CATALOG, \nNULL AS SCOPE_SCHEMA, NULL AS SCOPE_TABLE, NULL AS SOURCE_DATA_TYPE, \'NO\' AS IS_AUTOINCREMENT, \'NO\' AS IS_GENERATEDCOLUMN \nFROM INFORMATION_SCHEMA.COLUMNS C WHERE 1=1 "`

`public static final String`

`GET_INDEX_INFO`

`"SELECT IDX.TABLE_CATALOG AS TABLE_CAT, IDX.TABLE_SCHEMA AS TABLE_SCHEM, IDX.TABLE_NAME, CASE WHEN IS_UNIQUE THEN FALSE ELSE TRUE END AS NON_UNIQUE, NULL AS INDEX_QUALIFIER, IDX.INDEX_NAME, 3 AS TYPE, ORDINAL_POSITION, COLUMN_NAME, SUBSTR(COLUMN_ORDERING, 0, 1) AS ASC_OR_DESC, -1 AS CARDINALITY, -1 AS PAGES, NULL AS FILTER_CONDITION FROM INFORMATION_SCHEMA.INDEXES IDX INNER JOIN INFORMATION_SCHEMA.INDEX_COLUMNS COL on IDX.TABLE_CATALOG=COL.TABLE_CATALOG AND IDX.TABLE_SCHEMA=COL.TABLE_SCHEMA AND IDX.TABLE_NAME=COL.TABLE_NAME AND IDX.INDEX_NAME=COL.INDEX_NAME WHERE 1=1 "`

`public static final String`

`GET_TYPE_INFO`

`"SELECT \'BOOL\' AS TYPE_NAME, 16 AS DATA_TYPE, 1 AS PRECISION, NULL AS LITERAL_PREFIX, NULL AS LITERAL_SUFFIX, NULL AS CREATE_PARAMS, 1 AS NULLABLE, FALSE AS CASE_SENSITIVE, 2 AS SEARCHABLE, TRUE AS UNSIGNED_ATTRIBUTE, FALSE AS FIXED_PREC_SCALE, FALSE AS AUTO_INCREMENT, \'BOOL\' AS LOCAL_TYPE_NAME, 1 AS MINIMUM_SCALE, 1 AS MAXIMUM_SCALE, NULL AS SQL_DATA_TYPE, NULL AS SQL_DATETIME_SUB, NULL AS NUM_PREC_RADIX\nUNION ALL\nSELECT \'BYTES\' AS TYPE_NAME, -2 AS DATA_TYPE, 5000000 AS PRECISION, \'0x\' AS LITERAL_PREFIX, NULL AS LITERAL_SUFFIX, \'LENGTH\' AS CREATE_PARAMS, 1 AS NULLABLE, FALSE AS CASE_SENSITIVE, 2 AS SEARCHABLE, TRUE AS UNSIGNED_ATTRIBUTE, FALSE AS FIXED_PREC_SCALE, FALSE AS AUTO_INCREMENT, \'BYTES\' AS LOCAL_TYPE_NAME, 1 AS MINIMUM_SCALE, 5000000 AS MAXIMUM_SCALE, NULL AS SQL_DATA_TYPE, NULL AS SQL_DATETIME_SUB, NULL AS NUM_PREC_RADIX\nUNION ALL\nSELECT \'DATE\' AS TYPE_NAME, 91 AS DATA_TYPE, 8 AS PRECISION, \"{d \'\" AS LITERAL_PREFIX, \"\'}\" AS LITERAL_SUFFIX, NULL AS CREATE_PARAMS, 1 AS NULLABLE, FALSE AS CASE_SENSITIVE, 2 AS SEARCHABLE, TRUE AS UNSIGNED_ATTRIBUTE, FALSE AS FIXED_PREC_SCALE, FALSE AS AUTO_INCREMENT, \'DATE\' AS LOCAL_TYPE_NAME, 8 AS MINIMUM_SCALE, 8 AS MAXIMUM_SCALE, NULL AS SQL_DATA_TYPE, NULL AS SQL_DATETIME_SUB, NULL AS NUM_PREC_RADIX\nUNION ALL\nSELECT \'FLOAT64\' AS TYPE_NAME, 8 AS DATA_TYPE, 15 AS PRECISION, NULL AS LITERAL_PREFIX, NULL AS LITERAL_SUFFIX, NULL AS CREATE_PARAMS, 1 AS NULLABLE, FALSE AS CASE_SENSITIVE, 2 AS SEARCHABLE, FALSE AS UNSIGNED_ATTRIBUTE, FALSE AS FIXED_PREC_SCALE, FALSE AS AUTO_INCREMENT, \'FLOAT64\' AS LOCAL_TYPE_NAME, 15 AS MINIMUM_SCALE, 15 AS MAXIMUM_SCALE, NULL AS SQL_DATA_TYPE, NULL AS SQL_DATETIME_SUB, NULL AS NUM_PREC_RADIX\nUNION ALL\nSELECT \'INT64\' AS TYPE_NAME, -5 AS DATA_TYPE, 19 AS PRECISION, NULL AS LITERAL_PREFIX, NULL AS LITERAL_SUFFIX, NULL AS CREATE_PARAMS, 1 AS NULLABLE, FALSE AS CASE_SENSITIVE, 2 AS SEARCHABLE, FALSE AS UNSIGNED_ATTRIBUTE, FALSE AS FIXED_PREC_SCALE, FALSE AS AUTO_INCREMENT, \'INT64\' AS LOCAL_TYPE_NAME, 19 AS MINIMUM_SCALE, 19 AS MAXIMUM_SCALE, NULL AS SQL_DATA_TYPE, NULL AS SQL_DATETIME_SUB, NULL AS NUM_PREC_RADIX\nUNION ALL\nSELECT \'STRING\' AS TYPE_NAME, -9 AS DATA_TYPE, 5000000 AS PRECISION, \"\'\" AS LITERAL_PREFIX, \"\'\" AS LITERAL_SUFFIX, \'LENGTH\' AS CREATE_PARAMS, 1 AS NULLABLE, TRUE AS CASE_SENSITIVE, 3 AS SEARCHABLE, TRUE AS UNSIGNED_ATTRIBUTE, FALSE AS FIXED_PREC_SCALE, FALSE AS AUTO_INCREMENT, \'STRING\' AS LOCAL_TYPE_NAME, 1 AS MINIMUM_SCALE, 5000000 AS MAXIMUM_SCALE, NULL AS SQL_DATA_TYPE, NULL AS SQL_DATETIME_SUB, NULL AS NUM_PREC_RADIX\nUNION ALL\nSELECT \'TIMESTAMP\' AS TYPE_NAME, 93 AS DATA_TYPE, 19 AS PRECISION, \"{ts \'\" AS LITERAL_PREFIX, \"\'}\" AS LITERAL_SUFFIX, NULL AS CREATE_PARAMS, 1 AS NULLABLE, FALSE AS CASE_SENSITIVE, 2 AS SEARCHABLE, TRUE AS UNSIGNED_ATTRIBUTE, FALSE AS FIXED_PREC_SCALE, FALSE AS AUTO_INCREMENT, \'TIMESTAMP\' AS LOCAL_TYPE_NAME, 19 AS MINIMUM_SCALE, 19 AS MAXIMUM_SCALE, NULL AS SQL_DATA_TYPE, NULL AS SQL_DATETIME_SUB, NULL AS NUM_PREC_RADIX"`

`public static final String` `GET_UDTS` `"SELECT *\nFROM (SELECT NULL AS TYPE_CAT, NULL AS TYPE_SCHEM, NULL AS TYPE_NAME, NULL AS CLASS_NAME, NULL AS DATA_TYPE, NULL AS REMARKS, NULL AS BASE_TYPE) UDTS\nWHERE 1=2"`
`public static final String` `SELECT_TABLES_COLUMNS` `"SELECT CASE WHEN TABLE_CATALOG=\'\' THEN NULL ELSE TABLE_CATALOG END AS TABLE_CAT, CASE WHEN TABLE_SCHEMA=\'\' THEN NULL ELSE TABLE_SCHEMA END AS TABLE_SCHEM, TABLE_NAME, \'TABLE\' AS TABLE_TYPE, NULL AS REMARKS, NULL AS TYPE_CAT, NULL AS TYPE_SCHEM, NULL AS TYPE_NAME, NULL AS SELF_REFERENCING_COL_NAME, NULL AS REF_GENERATION "`
`public static final String` `WHERE_1_EQUALS_1` `" WHERE 1=1 "`

nl.topicus.jdbc.CloudSpannerDriver
`public static final int` `DEBUG` `2`
`public static final int` `INFO` `1`
`public static final int` `OFF` `0`

nl.topicus.jdbc.statement.AbstractCloudSpannerPreparedStatement
`protected static final String` `NO_MUTATIONS_IN_READ_ONLY_MODE_EXCEPTION` `"The connection is in read-only mode. Mutations are not allowed."`

nl.topicus.jdbc.statement.CloudSpannerPreparedStatement
`protected static final String` `NO_MUTATIONS_IN_READ_ONLY_MODE_EXCEPTION` `"The connection is in read-only mode. Mutations are not allowed."`

nl.topicus.jdbc.statement.CloudSpannerStatement
`protected static final String` `NO_MUTATIONS_IN_READ_ONLY_MODE_EXCEPTION` `"The connection is in read-only mode. Mutations are not allowed."`

nl.topicus.jdbc.util.Base64
`public static final int` `DECODE_FLAG` `0`
`public static final int` `DONT_BREAK_LINES` `8`
`public static final int` `ENCODE_FLAG` `1`
`public static final int` `NO_OPTIONS` `0`

nl.topicus.jdbc.xa.CloudSpannerXAConnection
`public static final String` `XA_MUTATION_COLUMN` `"MUTATION"`
`public static final String` `XA_NUMBER_COLUMN` `"NUMBER"`
`public static final String` `XA_PREPARED_MUTATIONS_TABLE` `"XA_PREPARED_MUTATIONS"`
`public static final String` `XA_XID_COLUMN` `"XID"`