# Constant Field Values

## Contents

- org.hsqldb.*

## org.hsqldb.*

- org.hsqldb.jdbc.JDBCBlobFile
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final java.lang.String` | `TEMP_FILE_PREFIX` | `"hsql_jdbc_blob_file_"`
  `public static final java.lang.String` | `TEMP_FILE_SUFFIX` | `".tmp"`

- org.hsqldb.jdbc.JDBCClobFile
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final java.lang.String` | `TEMP_FILE_PREFIX` | `"hsql_jdbc_clob_file_"`
  `public static final java.lang.String` | `TEMP_FILE_SUFFIX` | `".tmp"`

- org.hsqldb.jdbc.JDBCDatabaseMetaData
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final int` | `JDBC_MAJOR` | `4`
  `public static final int` | `JDBC_MINOR` | `2`
  `public static final java.lang.String` | `THIS_VERSION` | `"2.7.4"`

- org.hsqldb.jdbc.JDBCStatement
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final int` | `RETURN_PRIMARY_KEYS` | `31`

- org.hsqldb.lib.ArrayUtil
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final int` | `CLASS_CODE_BOOLEAN` | `90`
  `public static final int` | `CLASS_CODE_BYTE` | `66`
  `public static final int` | `CLASS_CODE_CHAR` | `67`
  `public static final int` | `CLASS_CODE_DOUBLE` | `68`
  `public static final int` | `CLASS_CODE_FLOAT` | `70`
  `public static final int` | `CLASS_CODE_INT` | `73`
  `public static final int` | `CLASS_CODE_LONG` | `74`
  `public static final int` | `CLASS_CODE_OBJECT` | `76`
  `public static final int` | `CLASS_CODE_SHORT` | `83`

- org.hsqldb.lib.AsciiInputStream
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final int` | `ASCII_BITS` | `7`
  `public static final int` | `ASCII_MASK` | `127`
  `public static final int` | `ASCII_MAX` | `127`
  `public static final int` | `NON_ASCII_MIN` | `128`
  `public static final int` | `NON_ASCII_REPLACEMENT` | `63`

- org.hsqldb.lib.AsciiOutputStream
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final int` | `ASCII_BITS` | `7`
  `public static final int` | `ASCII_MASK` | `127`
  `public static final int` | `ASCII_MAX` | `127`
  `public static final int` | `NON_ASCII_MIN` | `128`
  `public static final int` | `NON_ASCII_REPLACEMENT` | `65533`

- org.hsqldb.lib.FileAccess
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final int` | `ELEMENT_READ` | `1`
  `public static final int` | `ELEMENT_READWRITE` | `7`
  `public static final int` | `ELEMENT_SEEKABLEREAD` | `3`
  `public static final int` | `ELEMENT_TRUNCATE` | `8`
  `public static final int` | `ELEMENT_WRITE` | `4`

- org.hsqldb.lib.FileArchiver
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final int` | `COMPRESSION_GZIP` | `2`
  `public static final int` | `COMPRESSION_NONE` | `0`
  `public static final int` | `COMPRESSION_ZIP` | `1`

- org.hsqldb.lib.InOutUtil
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final long` | `DEFAULT_COPY_AMOUNT` | `9223372036854775807L`
  `public static final int` | `DEFAULT_COPY_BUFFER_SIZE` | `8192`

- org.hsqldb.lib.RefCapablePropertyResourceBundle
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final int` | `EMPTYSTRING_BEHAVIOR` | `1`
  `public static final int` | `NOOP_BEHAVIOR` | `2`
  `public static final int` | `THROW_BEHAVIOR` | `0`

- org.hsqldb.lib.ScannerSearchAlgorithm
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final int` | `SUGGESTED_MAX_LITERAL_SIZE` | `1024`

- org.hsqldb.lib.SimpleLog
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final int` | `LOG_DETAIL` | `4`
  `public static final int` | `LOG_ERROR` | `1`
  `public static final int` | `LOG_NONE` | `0`
  `public static final int` | `LOG_NORMAL` | `3`
  `public static final int` | `LOG_SQL_BASIC` | `1`
  `public static final int` | `LOG_SQL_DETAIL` | `3`
  `public static final int` | `LOG_SQL_NORMAL` | `2`
  `public static final int` | `LOG_SQL_RESULT` | `4`
  `public static final int` | `LOG_WARNING` | `2`
  `public static final java.lang.String` | `logTypeName` | `"ENGINE"`

- org.hsqldb.lib.ValidatingResourceBundle
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final int` | `EMPTYSTRING_BEHAVIOR` | `1`
  `public static final int` | `NOOP_BEHAVIOR` | `2`
  `public static final int` | `THROW_BEHAVIOR` | `0`

- org.hsqldb.lib.tar.TarFileOutputStream.Compression
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final int` | `DEFAULT_BLOCKS_PER_RECORD` | `20`
  `public static final int` | `DEFAULT_COMPRESSION` | `0`
  `public static final int` | `GZIP_COMPRESSION` | `1`
  `public static final int` | `NO_COMPRESSION` | `0`

- org.hsqldb.lib.tar.TarReader
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final int` | `EXTRACT_MODE` | `1`
  `public static final int` | `LIST_MODE` | `0`
  `public static final int` | `OVERWRITE_MODE` | `2`

- org.hsqldb.server.PgType
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final int` | `TYPE_ABSTIME` | `702`
  `public static final int` | `TYPE_BIT` | `1560`
  `public static final int` | `TYPE_BLOB` | `9998`
  `public static final int` | `TYPE_BOOL` | `16`
  `public static final int` | `TYPE_BOX` | `603`
  `public static final int` | `TYPE_BPCHAR` | `1042`
  `public static final int` | `TYPE_BPCHARARRAY` | `1014`
  `public static final int` | `TYPE_BYTEA` | `17`
  `public static final int` | `TYPE_CHAR` | `18`
  `public static final int` | `TYPE_CHAR2` | `409`
  `public static final int` | `TYPE_CHAR4` | `410`
  `public static final int` | `TYPE_CHAR8` | `411`
  `public static final int` | `TYPE_CID` | `29`
  `public static final int` | `TYPE_CIDR` | `650`
  `public static final int` | `TYPE_DATE` | `1082`
  `public static final int` | `TYPE_DATETIME` | `1184`
  `public static final int` | `TYPE_FILENAME` | `605`
  `public static final int` | `TYPE_FLOAT4` | `700`
  `public static final int` | `TYPE_FLOAT8` | `701`
  `public static final int` | `TYPE_INET` | `869`
  `public static final int` | `TYPE_INT2` | `21`
  `public static final int` | `TYPE_INT2VECTOR` | `22`
  `public static final int` | `TYPE_INT4` | `23`
  `public static final int` | `TYPE_INT8` | `20`
  `public static final int` | `TYPE_LSEG` | `601`
  `public static final int` | `TYPE_MACADDR` | `829`
  `public static final int` | `TYPE_MONEY` | `790`
  `public static final int` | `TYPE_NAME` | `19`
  `public static final int` | `TYPE_NUMERIC` | `1700`
  `public static final int` | `TYPE_OID` | `26`
  `public static final int` | `TYPE_OIDINT2` | `810`
  `public static final int` | `TYPE_OIDINT4` | `910`
  `public static final int` | `TYPE_OIDNAME` | `911`
  `public static final int` | `TYPE_OIDVECTOR` | `30`
  `public static final int` | `TYPE_PATH` | `602`
  `public static final int` | `TYPE_POINT` | `600`
  `public static final int` | `TYPE_POLYGON` | `604`
  `public static final int` | `TYPE_RECORD` | `2249`
  `public static final int` | `TYPE_REGPROC` | `24`
  `public static final int` | `TYPE_RELTIME` | `703`
  `public static final int` | `TYPE_SET` | `32`
  `public static final int` | `TYPE_TEXT` | `25`
  `public static final int` | `TYPE_TEXTARRAY` | `1009`
  `public static final int` | `TYPE_TID` | `27`
  `public static final int` | `TYPE_TIME` | `1083`
  `public static final int` | `TYPE_TIME_WITH_TMZONE` | `1266`
  `public static final int` | `TYPE_TIMESTAMP` | `1296`
  `public static final int` | `TYPE_TIMESTAMP_NO_TMZONE` | `1114`
  `public static final int` | `TYPE_TINTERVAL` | `704`
  `public static final int` | `TYPE_TINYINT` | `9999`
  `public static final int` | `TYPE_UNKNOWN` | `705`
  `public static final int` | `TYPE_UUID` | `2950`
  `public static final int` | `TYPE_VARBIT` | `1562`
  `public static final int` | `TYPE_VARCHAR` | `1043`
  `public static final int` | `TYPE_VARCHARARRAY` | `1015`
  `public static final int` | `TYPE_VOID` | `2278`
  `public static final int` | `TYPE_XID` | `28`
  `public static final int` | `TYPE_XML` | `142`
  `public static final int` | `TYPE_XMLARRAY` | `143`

- org.hsqldb.server.ServerConstants
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final java.lang.String` | `SC_DEFAULT_ADDRESS` | `"0.0.0.0"`
  `public static final int` | `SC_DEFAULT_BER_SERVER_PORT` | `9101`
  `public static final java.lang.String` | `SC_DEFAULT_DATABASE` | `"test"`
  `public static final int` | `SC_DEFAULT_HSQL_SERVER_PORT` | `9001`
  `public static final int` | `SC_DEFAULT_HSQLS_SERVER_PORT` | `554`
  `public static final int` | `SC_DEFAULT_HTTP_SERVER_PORT` | `80`
  `public static final int` | `SC_DEFAULT_HTTPS_SERVER_PORT` | `443`
  `public static final int` | `SC_DEFAULT_MAX_DATABASES` | `10`
  `public static final int` | `SC_DEFAULT_MAX_WAIT` | `1000`
  `public static final boolean` | `SC_DEFAULT_NO_SYSTEM_EXIT` | `true`
  `public static final boolean` | `SC_DEFAULT_REMOTE_OPEN_DB` | `false`
  `public static final boolean` | `SC_DEFAULT_SERVER_AUTORESTART` | `false`
  `public static final boolean` | `SC_DEFAULT_SILENT` | `true`
  `public static final boolean` | `SC_DEFAULT_TLS` | `false`
  `public static final boolean` | `SC_DEFAULT_TRACE` | `false`
  `public static final java.lang.String` | `SC_DEFAULT_WEB_MIME` | `"text/html"`
  `public static final java.lang.String` | `SC_DEFAULT_WEB_PAGE` | `"index.html"`
  `public static final java.lang.String` | `SC_DEFAULT_WEB_ROOT` | `"."`
  `public static final int` | `SC_PROTOCOL_BER` | `2`
  `public static final int` | `SC_PROTOCOL_HSQL` | `1`
  `public static final int` | `SC_PROTOCOL_HTTP` | `0`
  `public static final int` | `SERVER_STATE_CLOSING` | `8`
  `public static final int` | `SERVER_STATE_ONLINE` | `1`
  `public static final int` | `SERVER_STATE_OPENING` | `4`
  `public static final int` | `SERVER_STATE_SHUTDOWN` | `16`

- org.hsqldb.trigger.Trigger
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final int` | `DELETE_AFTER` | `1`
  `public static final int` | `DELETE_AFTER_ROW` | `4`
  `public static final int` | `DELETE_BEFORE_ROW` | `7`
  `public static final int` | `INSERT_AFTER` | `0`
  `public static final int` | `INSERT_AFTER_ROW` | `3`
  `public static final int` | `INSERT_BEFORE_ROW` | `6`
  `public static final int` | `UPDATE_AFTER` | `2`
  `public static final int` | `UPDATE_AFTER_ROW` | `5`
  `public static final int` | `UPDATE_BEFORE_ROW` | `8`

- org.hsqldb.util.RCData
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final java.lang.String` | `DEFAULT_JDBC_DRIVER` | `"org.hsqldb.jdbc.JDBCDriver"`

- org.hsqldb.util.TableSorter
  Modifier and Type | Constant Field | Value
  --- | --- | ---
  `public static final int` | `ASCENDING` | `1`
  `public static final int` | `DESCENDING` | `-1`
  `public static final int` | `NOT_SORTED` | `0`