HyperSQL Database 2.7.4 · org.hsqldb.types.Types · APIdia, the JavaDoc alternative

Field Summary

Modifier and Type	Field and Description
public static final int[][]	ALL_TYPES Every (type,type-sub) combination known in the HSQLDB context.
public static final int	ARRAY The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `ARRAY`.
public static final int	BIGINT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `BIGINT`.
public static final int	BINARY The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `BINARY`.
public static final int	BIT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `BIT`.
public static final int	BLOB The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `BLOB`.
public static final String	BlobClassName
public static final int	BOOLEAN The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `BOOLEAN`.
public static final int	CHAR The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `CHAR`.
public static final int	CLOB The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `CLOB`
public static final String	ClobClassName
public static final int	DATALINK The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `DATALINK`.
public static final int	DATE The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `DATE`.
public static final String	DateClassName
public static final int	DECIMAL The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `DECIMAL`.
public static final String	DecimalClassName Names of types returned by JDBC methods and accepted as library and user function arguments
public static final int	DISTINCT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `DISTINCT`.
public static final int	DOUBLE The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `DOUBLE`.
public static final int	DTI_DAY_NAME
public static final int	DTI_DAY_OF_MONTH
public static final int	DTI_DAY_OF_WEEK
public static final int	DTI_DAY_OF_YEAR
public static final int	DTI_ISO_WEEK_OF_YEAR
public static final int	DTI_ISO_YEAR
public static final int	DTI_MICROSECOND
public static final int	DTI_MILLISECOND
public static final int	DTI_MONTH_NAME
public static final int	DTI_NANOSECOND
public static final int	DTI_QUARTER
public static final int	DTI_SECONDS_MIDNIGHT
public static final int	DTI_TIMEZONE
public static final int	DTI_TIMEZONE_HOUR
public static final int	DTI_TIMEZONE_MINUTE
public static final int	DTI_WEEK_OF_YEAR
public static final int	FLOAT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `FLOAT`.
private static final HashSet<Class<T>>	illegalParameterClasses
public static final int	INTEGER The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `INTEGER`.
public static final int	JAVA_OBJECT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `JAVA_OBJECT`.
pack-priv static final IntValueHashMap<String>	javaTypeNumbers
public static final int	LONGNVARCHAR The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `LONGNVARCHAR`.
public static final int	LONGVARBINARY The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `LONGVARBINARY`.
public static final int	LONGVARCHAR The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `LONGVARCHAR`.
public static final int	MAX_CHAR_OR_VARCHAR_DISPLAY_SIZE A reasonable/customizable number to avoid the shortcomings/defects associated with doing a dynamic scan of results to determine the value.
public static final int	MULTISET The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `MULTISET`.
public static final int	NCHAR The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `NCHAR`
public static final int	NCLOB The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `NCLOB`.
public static final int	NULL The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `NULL`.
public static final int	NUMERIC The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `NUMERIC`.
public static final int	NVARCHAR The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `NVARCHAR`.
public static final int	OTHER The constant in the Java programming language that indicates that the SQL type is database-specific and gets mapped to a Java object that can be accessed via the methods `getObject` and `setObject`.
public static final int	REAL The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `REAL`.
public static final int	REF The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `REF`.
public static final int	REF_CURSOR The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `REF_CURSOR`.
public static final int	ROWID The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `ROWID`
public static final int	SMALLINT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `SMALLINT`.
public static final int	SQL_ALL_TYPES
public static final int	SQL_ARRAY
public static final int	SQL_ARRAY_LOCATOR
public static final int	SQL_BIGINT
public static final int	SQL_BINARY
public static final int	SQL_BIT
public static final int	SQL_BIT_VARYING
public static final int	SQL_BLOB
public static final int	SQL_BLOB_LOCATOR
public static final int	SQL_BOOLEAN
public static final int	SQL_CHAR
public static final int	SQL_CLOB
public static final int	SQL_CLOB_LOCATOR
public static final int	SQL_DATALINK
public static final int	SQL_DATE
public static final int	SQL_DATETIME
public static final int	SQL_DECIMAL
public static final int	SQL_DOUBLE
public static final int	SQL_FLOAT
public static final int	SQL_GUID
public static final int	SQL_IMAGE
public static final int	SQL_INTEGER
public static final int	SQL_INTERVAL
public static final int	SQL_INTERVAL_DAY
public static final int	SQL_INTERVAL_DAY_TO_HOUR
public static final int	SQL_INTERVAL_DAY_TO_MINUTE
public static final int	SQL_INTERVAL_DAY_TO_SECOND
public static final int	SQL_INTERVAL_HOUR
public static final int	SQL_INTERVAL_HOUR_TO_MINUTE
public static final int	SQL_INTERVAL_HOUR_TO_SECOND
public static final int	SQL_INTERVAL_MINUTE
public static final int	SQL_INTERVAL_MINUTE_TO_SECOND
public static final int	SQL_INTERVAL_MONTH
public static final int	SQL_INTERVAL_SECOND
public static final int	SQL_INTERVAL_YEAR
public static final int	SQL_INTERVAL_YEAR_TO_MONTH
public static final int	SQL_LONGVARBINARY
public static final int	SQL_MULTISET
public static final int	SQL_MULTISET_LOCATOR
public static final int	SQL_NCHAR
public static final int	SQL_NTEXT
public static final int	SQL_NUMERIC
public static final int	SQL_NVARCHAR
public static final int	SQL_REAL
public static final int	SQL_REF
public static final int	SQL_ROW
public static final int	SQL_SMALLINT
public static final int	SQL_SUB_DISTINCT
public static final int	SQL_SUB_STRUCTURED
public static final int	SQL_TIME
public static final int	SQL_TIME_WITH_TIME_ZONE
public static final int	SQL_TIMESTAMP
public static final int	SQL_TIMESTAMP_WITH_TIME_ZONE
public static final int	SQL_TYPE_NUMBER_LIMIT
public static final int	SQL_UDT
public static final int	SQL_UDT_LOCATOR
public static final int	SQL_USER_DEFINED_TYPE
public static final int	SQL_VARBINARY
public static final int	SQL_VARCHAR
public static final int	SQL_VARIANT
public static final int	SQL_WCHAR
public static final int	SQL_WLONGVARCHAR
public static final int	SQL_WVARCHAR
public static final int	SQL_XML
public static final int	SQLXML The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `XML`.
public static final int	STRUCT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `STRUCT`.
public static final int	TIME The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `TIME`.
public static final int	TIME_WITH_TIMEZONE The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `TIME_WITH_TIMEZONE` .
public static final String	TimeClassName
public static final int	TIMESTAMP The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `TIMESTAMP`.
public static final int	TIMESTAMP_WITH_TIMEZONE The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `TIMESTAMP_WITH_TIMEZONE` .
public static final String	TimestampClassName
public static final int	TINYINT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `TINYINT`.
public static final int	TYPE_SUB_DEFAULT The default HSQLODB type sub-identifier.
public static final int	VARBINARY The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `VARBINARY`.
public static final int	VARCHAR The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `VARCHAR`.
public static final int	VARCHAR_IGNORECASE

Access	Constructor and Description
public	Types()

Modifier and Type	Method and Description
public static boolean	acceptsPrecision(int type) Types that accept precision params in column definition or casts.
public static boolean	acceptsScaleCreateParam(int type)
public static boolean	acceptsZeroPrecision(int type)
public static Type	Returns: java.sql.Types int value getParameterSQLType(Class<T> a Class instance c) Retrieves the type object corresponding to the class of an IN, IN OUT or OUT parameter or a return type.
public static boolean	isSearchable(int type)
private static int	MAX_CHAR_OR_VARCHAR_DISPLAY_SIZE()
public static boolean	requiresPrecision(int type)

Field Detail

ALL_TYPES	back to summary
public static final int[][] ALL_TYPES Every (type,type-sub) combination known in the HSQLDB context. Not every combination need be supported as a table or procedure column type -- such determinations are handled in DITypeInfo.

ARRAY back to summary

ARRAY	back to summary
public static final int ARRAY The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `ARRAY`. Since JDK 1.2

public static final int ARRAY

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type ARRAY.

Since: JDK 1.2

BIGINT back to summary

BIGINT	back to summary
public static final int BIGINT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `BIGINT`.

public static final int BIGINT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BIGINT.

BINARY back to summary

BINARY	back to summary
public static final int BINARY The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `BINARY`.

public static final int BINARY

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BINARY.

BIT back to summary

BIT	back to summary
public static final int BIT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `BIT`.

public static final int BIT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BIT.

BLOB back to summary

BLOB	back to summary
public static final int BLOB The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `BLOB`. Since JDK 1.2

public static final int BLOB

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BLOB.

Since: JDK 1.2

BlobClassName	back to summary
public static final String BlobClassName

BOOLEAN back to summary

BOOLEAN	back to summary
public static final int BOOLEAN The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `BOOLEAN`. Since JDK 1.4

public static final int BOOLEAN

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BOOLEAN.

Since: JDK 1.4

CHAR back to summary

CHAR	back to summary
public static final int CHAR The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `CHAR`.

public static final int CHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type CHAR.

CLOB back to summary

CLOB	back to summary
public static final int CLOB The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `CLOB` Since JDK 1.2

public static final int CLOB

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type CLOB

Since: JDK 1.2

ClobClassName	back to summary
public static final String ClobClassName

DATALINK back to summary

DATALINK	back to summary
public static final int DATALINK The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `DATALINK`. Since JDK 1.4

public static final int DATALINK

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DATALINK.

Since: JDK 1.4

DATE back to summary

DATE	back to summary
public static final int DATE The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `DATE`.

public static final int DATE

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DATE.

DateClassName	back to summary
public static final String DateClassName

DECIMAL back to summary

DECIMAL	back to summary
public static final int DECIMAL The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `DECIMAL`.

public static final int DECIMAL

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DECIMAL.

DecimalClassName	back to summary
public static final String DecimalClassName Names of types returned by JDBC methods and accepted as library and user function arguments

DISTINCT back to summary

DISTINCT	back to summary
public static final int DISTINCT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `DISTINCT`. Since JDK 1.2

public static final int DISTINCT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DISTINCT.

Since: JDK 1.2

DOUBLE back to summary

DOUBLE	back to summary
public static final int DOUBLE The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `DOUBLE`.

public static final int DOUBLE

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DOUBLE.

DTI_DAY_NAME	back to summary
public static final int DTI_DAY_NAME

DTI_DAY_OF_MONTH	back to summary
public static final int DTI_DAY_OF_MONTH

DTI_DAY_OF_WEEK	back to summary
public static final int DTI_DAY_OF_WEEK

DTI_DAY_OF_YEAR	back to summary
public static final int DTI_DAY_OF_YEAR

DTI_ISO_WEEK_OF_YEAR	back to summary
public static final int DTI_ISO_WEEK_OF_YEAR

DTI_ISO_YEAR	back to summary
public static final int DTI_ISO_YEAR

DTI_MICROSECOND	back to summary
public static final int DTI_MICROSECOND

DTI_MILLISECOND	back to summary
public static final int DTI_MILLISECOND

DTI_MONTH_NAME	back to summary
public static final int DTI_MONTH_NAME

DTI_NANOSECOND	back to summary
public static final int DTI_NANOSECOND

DTI_QUARTER	back to summary
public static final int DTI_QUARTER

DTI_SECONDS_MIDNIGHT	back to summary
public static final int DTI_SECONDS_MIDNIGHT

DTI_TIMEZONE	back to summary
public static final int DTI_TIMEZONE

DTI_TIMEZONE_HOUR	back to summary
public static final int DTI_TIMEZONE_HOUR

DTI_TIMEZONE_MINUTE	back to summary
public static final int DTI_TIMEZONE_MINUTE

DTI_WEEK_OF_YEAR	back to summary
public static final int DTI_WEEK_OF_YEAR

FLOAT back to summary

FLOAT	back to summary
public static final int FLOAT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `FLOAT`.

public static final int FLOAT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type FLOAT.

illegalParameterClasses	back to summary
private static final HashSet<Class<T>> illegalParameterClasses

INTEGER back to summary

INTEGER	back to summary
public static final int INTEGER The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `INTEGER`.

public static final int INTEGER

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type INTEGER.

JAVA_OBJECT back to summary

JAVA_OBJECT	back to summary
public static final int JAVA_OBJECT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `JAVA_OBJECT`. Since JDK 1.2

public static final int JAVA_OBJECT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type JAVA_OBJECT.

Since: JDK 1.2

javaTypeNumbers	back to summary
pack-priv static final IntValueHashMap<String> javaTypeNumbers

LONGNVARCHAR back to summary

LONGNVARCHAR	back to summary
public static final int LONGNVARCHAR The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `LONGNVARCHAR`. Since JDK 1.6, HSQLDB 1.8.x

public static final int LONGNVARCHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGNVARCHAR.

Since: JDK 1.6, HSQLDB 1.8.x

LONGVARBINARY back to summary

LONGVARBINARY	back to summary
public static final int LONGVARBINARY The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `LONGVARBINARY`.

public static final int LONGVARBINARY

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGVARBINARY.

LONGVARCHAR back to summary

LONGVARCHAR	back to summary
public static final int LONGVARCHAR The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `LONGVARCHAR`.

public static final int LONGVARCHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGVARCHAR.

MAX_CHAR_OR_VARCHAR_DISPLAY_SIZE	back to summary
public static final int MAX_CHAR_OR_VARCHAR_DISPLAY_SIZE A reasonable/customizable number to avoid the shortcomings/defects associated with doing a dynamic scan of results to determine the value. In practice, it turns out that single query yielding widely varying values for display size of CHAR and VARCHAR columns on repeated execution results in patently poor usability, as some fairly high-profile, otherwise "enterprise-quality" RAD tools depend on the first value returned to lay out forms and limit the size of single line edit controls, set corresponding local datastore storage sizes, etc. In practice, It also turns out that many tools (due to the original lack of PreparedStatement.getMetaData() in JDK 1.1) emulate a SQL_DESCRIBE by executing a query hopefully guaranteed to return no or very few rows for example: select ... from ... where 1=0. Using the dynamic scan of 1.7.2 RC5 and previous, therefore, the minimum display size value (1) was often being generated during a tool's describe phase. Upon subsequent "real" retrievals, some tools complain that CHAR and VARCHAR result values exceeded the originally reported display size and refused to fetch further values.

MAX_CHAR_OR_VARCHAR_DISPLAY_SIZE

back to summary

public static final int MAX_CHAR_OR_VARCHAR_DISPLAY_SIZE

A reasonable/customizable number to avoid the shortcomings/defects associated with doing a dynamic scan of results to determine the value. In practice, it turns out that single query yielding widely varying values for display size of CHAR and VARCHAR columns on repeated execution results in patently poor usability, as some fairly high-profile, otherwise "enterprise-quality" RAD tools depend on the first value returned to lay out forms and limit the size of single line edit controls, set corresponding local datastore storage sizes, etc. In practice, It also turns out that many tools (due to the original lack of PreparedStatement.getMetaData() in JDK 1.1) emulate a SQL_DESCRIBE by executing a query hopefully guaranteed to return no or very few rows for example: select ... from ... where 1=0. Using the dynamic scan of 1.7.2 RC5 and previous, therefore, the minimum display size value (1) was often being generated during a tool's describe phase. Upon subsequent "real" retrievals, some tools complain that CHAR and VARCHAR result values exceeded the originally reported display size and refused to fetch further values.

MULTISET back to summary

MULTISET	back to summary
public static final int MULTISET The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `MULTISET`.

public static final int MULTISET

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type MULTISET.

NCHAR back to summary

NCHAR	back to summary
public static final int NCHAR The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `NCHAR` Since JDK 1.6, HSQLDB 1.8.x

public static final int NCHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NCHAR

Since: JDK 1.6, HSQLDB 1.8.x

NCLOB back to summary

NCLOB	back to summary
public static final int NCLOB The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `NCLOB`. Since JDK 1.6, HSQLDB 1.8.x

public static final int NCLOB

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NCLOB.

Since: JDK 1.6, HSQLDB 1.8.x

NULL back to summary

NULL	back to summary
public static final int NULL The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `NULL`.

public static final int NULL

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NULL.

NUMERIC back to summary

public static final int NUMERIC

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NUMERIC.

NVARCHAR back to summary

public static final int NVARCHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NVARCHAR.

Since: JDK 1.6, HSQLDB 1.8.x

OTHER	back to summary
public static final int OTHER The constant in the Java programming language that indicates that the SQL type is database-specific and gets mapped to a Java object that can be accessed via the methods `getObject` and `setObject`.

REAL back to summary

public static final int REAL

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REAL.

REF back to summary

public static final int REF

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REF.

Since: JDK 1.2

REF_CURSOR back to summary

public static final int REF_CURSOR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REF_CURSOR.

Since: JDK 1.8

ROWID back to summary

public static final int ROWID

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type ROWID

Since: JDK 1.6, HSQLDB 1.8.x

SMALLINT back to summary

public static final int SMALLINT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type SMALLINT.

SQL_ALL_TYPES	back to summary
public static final int SQL_ALL_TYPES

SQL_ARRAY	back to summary
public static final int SQL_ARRAY

SQL_ARRAY_LOCATOR	back to summary
public static final int SQL_ARRAY_LOCATOR

SQL_BIGINT	back to summary
public static final int SQL_BIGINT

SQL_BINARY	back to summary
public static final int SQL_BINARY

SQL_BIT	back to summary
public static final int SQL_BIT

SQL_BIT_VARYING	back to summary
public static final int SQL_BIT_VARYING

SQL_BLOB	back to summary
public static final int SQL_BLOB

SQL_BLOB_LOCATOR	back to summary
public static final int SQL_BLOB_LOCATOR

SQL_BOOLEAN	back to summary
public static final int SQL_BOOLEAN

SQL_CHAR	back to summary
public static final int SQL_CHAR

SQL_CLOB	back to summary
public static final int SQL_CLOB

SQL_CLOB_LOCATOR	back to summary
public static final int SQL_CLOB_LOCATOR

SQL_DATALINK	back to summary
public static final int SQL_DATALINK

SQL_DATE	back to summary
public static final int SQL_DATE

SQL_DATETIME	back to summary
public static final int SQL_DATETIME

SQL_DECIMAL	back to summary
public static final int SQL_DECIMAL

SQL_DOUBLE	back to summary
public static final int SQL_DOUBLE

SQL_FLOAT	back to summary
public static final int SQL_FLOAT

SQL_GUID	back to summary
public static final int SQL_GUID

SQL_IMAGE	back to summary
public static final int SQL_IMAGE

SQL_INTEGER	back to summary
public static final int SQL_INTEGER

SQL_INTERVAL	back to summary
public static final int SQL_INTERVAL

SQL_INTERVAL_DAY	back to summary
public static final int SQL_INTERVAL_DAY

SQL_INTERVAL_DAY_TO_HOUR	back to summary
public static final int SQL_INTERVAL_DAY_TO_HOUR

SQL_INTERVAL_DAY_TO_MINUTE	back to summary
public static final int SQL_INTERVAL_DAY_TO_MINUTE

SQL_INTERVAL_DAY_TO_SECOND	back to summary
public static final int SQL_INTERVAL_DAY_TO_SECOND

SQL_INTERVAL_HOUR	back to summary
public static final int SQL_INTERVAL_HOUR

SQL_INTERVAL_HOUR_TO_MINUTE	back to summary
public static final int SQL_INTERVAL_HOUR_TO_MINUTE

SQL_INTERVAL_HOUR_TO_SECOND	back to summary
public static final int SQL_INTERVAL_HOUR_TO_SECOND

SQL_INTERVAL_MINUTE	back to summary
public static final int SQL_INTERVAL_MINUTE

SQL_INTERVAL_MINUTE_TO_SECOND	back to summary
public static final int SQL_INTERVAL_MINUTE_TO_SECOND

SQL_INTERVAL_MONTH	back to summary
public static final int SQL_INTERVAL_MONTH

SQL_INTERVAL_SECOND	back to summary
public static final int SQL_INTERVAL_SECOND

SQL_INTERVAL_YEAR	back to summary
public static final int SQL_INTERVAL_YEAR

SQL_INTERVAL_YEAR_TO_MONTH	back to summary
public static final int SQL_INTERVAL_YEAR_TO_MONTH

SQL_LONGVARBINARY	back to summary
public static final int SQL_LONGVARBINARY

SQL_MULTISET	back to summary
public static final int SQL_MULTISET

SQL_MULTISET_LOCATOR	back to summary
public static final int SQL_MULTISET_LOCATOR

SQL_NCHAR	back to summary
public static final int SQL_NCHAR

SQL_NTEXT	back to summary
public static final int SQL_NTEXT

SQL_NUMERIC	back to summary
public static final int SQL_NUMERIC

SQL_NVARCHAR	back to summary
public static final int SQL_NVARCHAR

SQL_REAL	back to summary
public static final int SQL_REAL

SQL_REF	back to summary
public static final int SQL_REF

SQL_ROW	back to summary
public static final int SQL_ROW

SQL_SMALLINT	back to summary
public static final int SQL_SMALLINT

SQL_SUB_DISTINCT	back to summary
public static final int SQL_SUB_DISTINCT

SQL_SUB_STRUCTURED	back to summary
public static final int SQL_SUB_STRUCTURED

SQL_TIME	back to summary
public static final int SQL_TIME

SQL_TIME_WITH_TIME_ZONE	back to summary
public static final int SQL_TIME_WITH_TIME_ZONE

SQL_TIMESTAMP	back to summary
public static final int SQL_TIMESTAMP

SQL_TIMESTAMP_WITH_TIME_ZONE	back to summary
public static final int SQL_TIMESTAMP_WITH_TIME_ZONE

SQL_TYPE_NUMBER_LIMIT	back to summary
public static final int SQL_TYPE_NUMBER_LIMIT

SQL_UDT	back to summary
public static final int SQL_UDT

SQL_UDT_LOCATOR	back to summary
public static final int SQL_UDT_LOCATOR

SQL_USER_DEFINED_TYPE	back to summary
public static final int SQL_USER_DEFINED_TYPE

SQL_VARBINARY	back to summary
public static final int SQL_VARBINARY

SQL_VARCHAR	back to summary
public static final int SQL_VARCHAR

SQL_VARIANT	back to summary
public static final int SQL_VARIANT

SQL_WCHAR	back to summary
public static final int SQL_WCHAR

SQL_WLONGVARCHAR	back to summary
public static final int SQL_WLONGVARCHAR

SQL_WVARCHAR	back to summary
public static final int SQL_WVARCHAR

SQL_XML	back to summary
public static final int SQL_XML

SQLXML back to summary

public static final int SQLXML

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type XML.

Since: JDK 1.6, HSQLDB 1.8.x

STRUCT back to summary

public static final int STRUCT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type STRUCT.

Since: JDK 1.2

TIME back to summary

public static final int TIME

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIME.

TIME_WITH_TIMEZONE back to summary

public static final int TIME_WITH_TIMEZONE

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIME_WITH_TIMEZONE .

Since: JDK 1.8

TimeClassName	back to summary
public static final String TimeClassName

TIMESTAMP back to summary

public static final int TIMESTAMP

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIMESTAMP.

TIMESTAMP_WITH_TIMEZONE back to summary

public static final int TIMESTAMP_WITH_TIMEZONE

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIMESTAMP_WITH_TIMEZONE .

Since: JDK 1.8

TimestampClassName	back to summary
public static final String TimestampClassName

TINYINT back to summary

public static final int TINYINT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TINYINT.

TYPE_SUB_DEFAULT	back to summary
public static final int TYPE_SUB_DEFAULT The default HSQLODB type sub-identifier. This indicates that an HSQLDB type with this sub-type, if supported, is the very closest thing HSQLDB offers to the JDBC/SQL2003 type

VARBINARY back to summary

public static final int VARBINARY

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type VARBINARY.

VARCHAR back to summary

public static final int VARCHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type VARCHAR.

VARCHAR_IGNORECASE	back to summary
public static final int VARCHAR_IGNORECASE

public Class Types

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail