| java.lang.Object
 org.hsqldb.Types
| Types | | public class Types (Code) | | Defines the constants that are used to identify SQL types for HSQLDB JDBC
inteface type reporting. The actual type constant values are equivalent
to those defined in the latest java.sql.Types, where available,
or those defined by ansi/iso SQL 200n otherwise. A type sub-identifer
has been added to differentiate HSQLDB-specific type specializations.
author:
boucherb@users
version:
1.7.2
since:
1.7.2 |
| Field Summary | |
| final static int[][] | ALL_TYPES
Every (type,type-sub) combination known in the HSQLDB context. | | final public static int | ARRAY
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type
ARRAY. | | final public static int | BIGINT
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
BIGINT. | | final public static int | BINARY
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
BINARY. | | final public static int | BLOB
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type
BLOB. | | final public static int | BOOLEAN
The constant in the Java programming language, somtimes referred to
as a type code, that identifies the generic SQL type
BOOLEAN. | | final public static int | CHAR
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
CHAR. | | final public static int | CLOB
| | final public static int | DATALINK
The constant in the Java programming language, somtimes referred to
as a type code, that identifies the generic SQL type DATALINK. | | final public static int | DATE
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
DATE. | | final public static int | DECIMAL
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
DECIMAL. | | final public static int | DISTINCT
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type
DISTINCT. | | final public static int | DOUBLE
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
DOUBLE. | | final public static String | DateClassName
| | final public static String | DecimalClassName
Names of types. | | final public static int | FLOAT
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
FLOAT. | | final public static int | INTEGER
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
INTEGER. | | final public static 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. | | final public static int | LONGVARBINARY
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
LONGVARBINARY. | | final public static int | LONGVARCHAR
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
LONGVARCHAR. | | final public static 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. | | final public static int | NULL
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
NULL. | | final public static int | NUMERIC
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
NUMERIC. | | final public static 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. | | final public static int | REAL
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
REAL. | | final public static int | REF
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type
REF. | | final public static int | SMALLINT
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
SMALLINT. | | final static int | SQL_ALL_TYPES
| | final static int | SQL_ARRAY
| | final static int | SQL_ARRAY_LOCATOR
| | final static int | SQL_BIGINT
| | final static int | SQL_BINARY_LARGE_OBJECT
| | final static int | SQL_BIT_VARYING
| | final static int | SQL_BLOB
| | final static int | SQL_BLOB_LOCATOR
| | final static int | SQL_BOOLEAN
| | final static int | SQL_CHAR
| | final static int | SQL_CHARACTER
| | final static int | SQL_CHARACTER_LARGE_OBJECT
| | final static int | SQL_CHARACTER_VARYING
| | final static int | SQL_CHAR_VARYING
| | final static int | SQL_CLOB
| | final static int | SQL_CLOB_LOCATOR
| | final static int | SQL_DATALINK
| | final static int | SQL_DATE
| | final static int | SQL_DATETIME
| | final static int | SQL_DEC
| | final static int | SQL_DECIMAL
| | final static int | SQL_DISTINCT
| | final static int | SQL_DOUBLE
| | final static int | SQL_FLOAT
| | final static int | SQL_INT
| | final static int | SQL_INTEGER
| | final static int | SQL_INTERVAL
| | final static int | SQL_INTERVAL_DAY
| | final static int | SQL_INTERVAL_DAY_TO_HOUR
| | final static int | SQL_INTERVAL_DAY_TO_MINUTE
| | final static int | SQL_INTERVAL_DAY_TO_SECOND
| | final static int | SQL_INTERVAL_HOUR
| | final static int | SQL_INTERVAL_HOUR_TO_MINUTE
| | final static int | SQL_INTERVAL_HOUR_TO_SECOND
| | final static int | SQL_INTERVAL_MINUTE
| | final static int | SQL_INTERVAL_MINUTE_TO_SECOND
| | final static int | SQL_INTERVAL_MONTH
| | final static int | SQL_INTERVAL_SECOND
| | final static int | SQL_INTERVAL_YEAR
| | final static int | SQL_INTERVAL_YEAR_TO_MONTH
| | final static int | SQL_MULTISET
| | final static int | SQL_MULTISET_LOCATOR
| | final static int | SQL_NUMERIC
| | final static int | SQL_REAL
| | final static int | SQL_REF
| | final static int | SQL_ROW
| | final static int | SQL_SCTRUCTURED
| | final static int | SQL_SMALLINT
| | final static int | SQL_TIME
| | final static int | SQL_TIMESTAMP
| | final static int | SQL_TIMESTAMP_WITH_TIME_ZONE
| | final static int | SQL_TIME_WITH_TIME_ZONE
| | final static int | SQL_UDT
| | final static int | SQL_UDT_LOCATOR
| | final static int | SQL_USER_DEFINED_TYPE
| | final static int | SQL_VARCHAR
| | final static int | SQL_XML
| | final public static int | STRUCT
The constant in the Java programming language, sometimes referred to
as a type code, that identifies the generic SQL type
STRUCT. | | final public static int | TIME
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
TIME. | | final public static int | TIMESTAMP
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
TIMESTAMP. | | final public static int | TINYINT
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
TINYINT. | | final public static int | TYPE_SUB_DEFAULT
The default HSQLODB type sub-identifier. | | final public static int | TYPE_SUB_IGNORECASE
The IGNORECASE type sub-identifier. | | final public static String | TimeClassName
| | final public static String | TimestampClassName
| | final public static int | VARBINARY
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
VARBINARY. | | final public static int | VARCHAR
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
VARCHAR. | | final public static int | VARCHAR_IGNORECASE
| | final public static int | XML
The constant in the Java programming language, sometimes referred
to as a type code, that identifies the recent SQL 200n SQL type
XML. | | static HashMap | javaTypeNames
| | static IntValueHashMap | typeAliases
| | static IntKeyHashMap | typeNames
|
| ALL_TYPES | | final static int[][] ALL_TYPES(Code) | | 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 | | final public static int ARRAY(Code) | | 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 | | final public static int BIGINT(Code) | | The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
BIGINT.
|
| BINARY | | final public static int BINARY(Code) | | The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
BINARY.
|
| BLOB | | final public static int BLOB(Code) | | 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 |
| BOOLEAN | | final public static int BOOLEAN(Code) | | The constant in the Java programming language, somtimes referred to
as a type code, that identifies the generic SQL type
BOOLEAN.
since:
JDK 1.4 |
| CHAR | | final public static int CHAR(Code) | | The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
CHAR.
|
| CLOB | | final public static int CLOB(Code) | | 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 |
| DATALINK | | final public static int DATALINK(Code) | | The constant in the Java programming language, somtimes referred to
as a type code, that identifies the generic SQL type DATALINK.
since:
JDK 1.4 |
| DATE | | final public static int DATE(Code) | | The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
DATE.
|
| DECIMAL | | final public static int DECIMAL(Code) | | The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
DECIMAL.
|
| DISTINCT | | final public static int DISTINCT(Code) | | 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 | | final public static int DOUBLE(Code) | | The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
DOUBLE.
|
| DecimalClassName | | final public static String DecimalClassName(Code) | | Names of types.
Used for external, JDBC reporting
Used for library and user function arguments
|
| FLOAT | | final public static int FLOAT(Code) | | The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
FLOAT.
|
| INTEGER | | final public static int INTEGER(Code) | | The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
INTEGER.
|
| JAVA_OBJECT | | final public static int JAVA_OBJECT(Code) | | 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 |
| LONGVARBINARY | | final public static int LONGVARBINARY(Code) | | The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
LONGVARBINARY.
|
| LONGVARCHAR | | final public static int LONGVARCHAR(Code) | | 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 | | final public static int MAX_CHAR_OR_VARCHAR_DISPLAY_SIZE(Code) | | 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
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.
|
| NULL | | final public static int NULL(Code) | | The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
NULL.
|
| NUMERIC | | final public static int NUMERIC(Code) | | The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
NUMERIC.
|
| OTHER | | final public static int OTHER(Code) | | 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 | | final public static int REAL(Code) | | The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
REAL.
|
| REF | | final public static int REF(Code) | | 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 |
| SMALLINT | | final public static int SMALLINT(Code) | | The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
SMALLINT.
|
| SQL_ALL_TYPES | | final static int SQL_ALL_TYPES(Code) | | |
| SQL_ARRAY | | final static int SQL_ARRAY(Code) | | |
| SQL_ARRAY_LOCATOR | | final static int SQL_ARRAY_LOCATOR(Code) | | |
| SQL_BIGINT | | final static int SQL_BIGINT(Code) | | |
| SQL_BINARY_LARGE_OBJECT | | final static int SQL_BINARY_LARGE_OBJECT(Code) | | |
| SQL_BIT_VARYING | | final static int SQL_BIT_VARYING(Code) | | |
| SQL_BLOB | | final static int SQL_BLOB(Code) | | |
| SQL_BLOB_LOCATOR | | final static int SQL_BLOB_LOCATOR(Code) | | |
| SQL_BOOLEAN | | final static int SQL_BOOLEAN(Code) | | |
| SQL_CHAR | | final static int SQL_CHAR(Code) | | |
| SQL_CHARACTER | | final static int SQL_CHARACTER(Code) | | |
| SQL_CHARACTER_LARGE_OBJECT | | final static int SQL_CHARACTER_LARGE_OBJECT(Code) | | |
| SQL_CHARACTER_VARYING | | final static int SQL_CHARACTER_VARYING(Code) | | |
| SQL_CHAR_VARYING | | final static int SQL_CHAR_VARYING(Code) | | |
| SQL_CLOB | | final static int SQL_CLOB(Code) | | |
| SQL_CLOB_LOCATOR | | final static int SQL_CLOB_LOCATOR(Code) | | |
| SQL_DATALINK | | final static int SQL_DATALINK(Code) | | |
| SQL_DATE | | final static int SQL_DATE(Code) | | |
| SQL_DATETIME | | final static int SQL_DATETIME(Code) | | |
| SQL_DEC | | final static int SQL_DEC(Code) | | |
| SQL_DECIMAL | | final static int SQL_DECIMAL(Code) | | |
| SQL_DISTINCT | | final static int SQL_DISTINCT(Code) | | |
| SQL_DOUBLE | | final static int SQL_DOUBLE(Code) | | |
| SQL_FLOAT | | final static int SQL_FLOAT(Code) | | |
| SQL_INT | | final static int SQL_INT(Code) | | |
| SQL_INTEGER | | final static int SQL_INTEGER(Code) | | |
| SQL_INTERVAL | | final static int SQL_INTERVAL(Code) | | |
| SQL_INTERVAL_DAY | | final static int SQL_INTERVAL_DAY(Code) | | |
| SQL_INTERVAL_DAY_TO_HOUR | | final static int SQL_INTERVAL_DAY_TO_HOUR(Code) | | |
| SQL_INTERVAL_DAY_TO_MINUTE | | final static int SQL_INTERVAL_DAY_TO_MINUTE(Code) | | |
| SQL_INTERVAL_DAY_TO_SECOND | | final static int SQL_INTERVAL_DAY_TO_SECOND(Code) | | |
| SQL_INTERVAL_HOUR | | final static int SQL_INTERVAL_HOUR(Code) | | |
| SQL_INTERVAL_HOUR_TO_MINUTE | | final static int SQL_INTERVAL_HOUR_TO_MINUTE(Code) | | |
| SQL_INTERVAL_HOUR_TO_SECOND | | final static int SQL_INTERVAL_HOUR_TO_SECOND(Code) | | |
| SQL_INTERVAL_MINUTE | | final static int SQL_INTERVAL_MINUTE(Code) | | |
| SQL_INTERVAL_MINUTE_TO_SECOND | | final static int SQL_INTERVAL_MINUTE_TO_SECOND(Code) | | |
| SQL_INTERVAL_MONTH | | final static int SQL_INTERVAL_MONTH(Code) | | |
| SQL_INTERVAL_SECOND | | final static int SQL_INTERVAL_SECOND(Code) | | |
| SQL_INTERVAL_YEAR | | final static int SQL_INTERVAL_YEAR(Code) | | |
| SQL_INTERVAL_YEAR_TO_MONTH | | final static int SQL_INTERVAL_YEAR_TO_MONTH(Code) | | |
| SQL_MULTISET | | final static int SQL_MULTISET(Code) | | |
| SQL_MULTISET_LOCATOR | | final static int SQL_MULTISET_LOCATOR(Code) | | |
| SQL_NUMERIC | | final static int SQL_NUMERIC(Code) | | |
| SQL_REAL | | final static int SQL_REAL(Code) | | |
| SQL_REF | | final static int SQL_REF(Code) | | |
| SQL_ROW | | final static int SQL_ROW(Code) | | |
| SQL_SCTRUCTURED | | final static int SQL_SCTRUCTURED(Code) | | |
| SQL_SMALLINT | | final static int SQL_SMALLINT(Code) | | |
| SQL_TIME | | final static int SQL_TIME(Code) | | |
| SQL_TIMESTAMP | | final static int SQL_TIMESTAMP(Code) | | |
| SQL_TIMESTAMP_WITH_TIME_ZONE | | final static int SQL_TIMESTAMP_WITH_TIME_ZONE(Code) | | |
| SQL_TIME_WITH_TIME_ZONE | | final static int SQL_TIME_WITH_TIME_ZONE(Code) | | |
| SQL_UDT | | final static int SQL_UDT(Code) | | |
| SQL_UDT_LOCATOR | | final static int SQL_UDT_LOCATOR(Code) | | |
| SQL_USER_DEFINED_TYPE | | final static int SQL_USER_DEFINED_TYPE(Code) | | |
| SQL_VARCHAR | | final static int SQL_VARCHAR(Code) | | |
| SQL_XML | | final static int SQL_XML(Code) | | |
| STRUCT | | final public static int STRUCT(Code) | | 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 | | final public static int TIME(Code) | | The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
TIME.
|
| TIMESTAMP | | final public static int TIMESTAMP(Code) | | The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
TIMESTAMP.
|
| TINYINT | | final public static int TINYINT(Code) | | The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
TINYINT.
|
| TYPE_SUB_DEFAULT | | final public static int TYPE_SUB_DEFAULT(Code) | | The default HSQLODB type sub-identifier. This indicates that an
HSQLDB type with this sub-type, if supported, is the very closest
thing HSQLDB offerers to the JDBC/SQL200n type
|
| TYPE_SUB_IGNORECASE | | final public static int TYPE_SUB_IGNORECASE(Code) | | The IGNORECASE type sub-identifier. This indicates that an HSQLDB type
with this sub-type, if supported, is the closest thing HSQLDB offerers
to the JDBC/SQL200n type, except that case is ignored in comparisons
|
| TimestampClassName | | final public static String TimestampClassName(Code) | | |
| VARBINARY | | final public static int VARBINARY(Code) | | The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
VARBINARY.
|
| VARCHAR | | final public static int VARCHAR(Code) | | The constant in the Java programming language, sometimes referred
to as a type code, that identifies the generic SQL type
VARCHAR.
|
| VARCHAR_IGNORECASE | | final public static int VARCHAR_IGNORECASE(Code) | | |
| XML | | final public static int XML(Code) | | The constant in the Java programming language, sometimes referred
to as a type code, that identifies the recent SQL 200n SQL type
XML.
since:
SQL 200n |
| acceptsPrecisionCreateParam | | public static boolean acceptsPrecisionCreateParam(int type)(Code) | | Types that accept precition params in column definition or casts.
We ignore the parameter in many cases but accept it for compatibility
with other engines. CHAR, VARCHAR and VARCHAR_IGNORECASE params
are used when the sql.enforce_strict_types is true.
|
| acceptsScaleCreateParam | | public static boolean acceptsScaleCreateParam(int type)(Code) | | |
| getColStClsName | | public static String getColStClsName(int type)(Code) | | |
| getFunctionReturnClassName | | static String getFunctionReturnClassName(String methodReturnType)(Code) | | Translates a type name returned from a method into the name of type
returned in a ResultSet
|
| getMaxDisplaySize | | public static int getMaxDisplaySize(int type)(Code) | | |
| getParameterTypeNr | | static int getParameterTypeNr(Class c) throws HsqlException(Code) | | Retieves the type number corresponding to the class
of an IN, IN OUT or OUT parameter.
This method extends getTypeNr to return OTHER for
primitive arrays, classes that directly implement
java.io.Serializable and non-primitive arrays whose
base component implements java.io.Serializable,
allowing, for instance, arguments and return types of
primitive arrays, Serializable objects and arrays,
of Serializable objects. Direct primitive types
other than those mapping directly to the internal
wrapper form are not yet handled. That is, HSQLDB
cannot yet properly deal with CALLs involving methods
with primitive byte, short, float or their
corresponding wrappers, due to the way internal
conversion works and lack of detection and narrowing
code in Function to allow this. In other words,
passing in or retrieving any of the mentioned types
always causes conversion to a wider internal wrapper
which is genrally incompatible under reflective
invocation, resulting in an IllegalArgumentException.
Parameters:
c - a Class instance java.sql.Types int value
throws:
HsqlException - |
| getPrecision | | public static int getPrecision(int type)(Code) | | |
| getTypeString | | public static String getTypeString(int type)(Code) | | Returns SQL type string for a java.sql.Types int value
|
| getTypeString | | public static String getTypeString(int type, int precision, int scale)(Code) | | Returns SQL type string for a java.sql.Types int value
|
| isCaseSensitive | | public static Boolean isCaseSensitive(int type)(Code) | | |
| isCharacterType | | public static boolean isCharacterType(int type)(Code) | | |
| isDatetimeType | | static boolean isDatetimeType(int type)(Code) | | |
| isNumberType | | public static boolean isNumberType(int type)(Code) | | |
| isSearchable | | public static boolean isSearchable(int type)(Code) | | |
| isUnsignedAttribute | | public static Boolean isUnsignedAttribute(int type)(Code) | | |
| numericPrecisionCreateParamRadix | | public static int numericPrecisionCreateParamRadix(int type)(Code) | | |
|
|