Defines the constants that are used to identify generic SQL types, called JDBC types.
SQLType
| Modifier and Type | Field and Description |
|---|---|
| public static final JDBCType | ARRAY
Identifies the generic SQL type |
| public static final JDBCType | BIGINT
Identifies the generic SQL type |
| public static final JDBCType | BINARY
Identifies the generic SQL type |
| public static final JDBCType | BIT
Identifies the generic SQL type |
| public static final JDBCType | BLOB
Identifies the generic SQL type |
| public static final JDBCType | BOOLEAN
Identifies the generic SQL type |
| public static final JDBCType | CHAR
Identifies the generic SQL type |
| public static final JDBCType | CLOB
Identifies the generic SQL type |
| public static final JDBCType | DATALINK
Identifies the generic SQL type |
| public static final JDBCType | DATE
Identifies the generic SQL type |
| public static final JDBCType | DECFLOAT
Identifies the generic SQL type |
| public static final JDBCType | DECIMAL
Identifies the generic SQL type |
| public static final JDBCType | DISTINCT
Identifies the generic SQL type |
| public static final JDBCType | DOUBLE
Identifies the generic SQL type |
| public static final JDBCType | FLOAT
Identifies the generic SQL type |
| public static final JDBCType | INTEGER
Identifies the generic SQL type |
| public static final JDBCType | JAVA_OBJECT
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 JDBCType | JSON
Identifies the generic SQL type |
| public static final JDBCType | LONGNVARCHAR
Identifies the generic SQL type |
| public static final JDBCType | LONGVARBINARY
Identifies the generic SQL type |
| public static final JDBCType | LONGVARCHAR
Identifies the generic SQL type |
| public static final JDBCType | NCHAR
Identifies the generic SQL type |
| public static final JDBCType | NCLOB
Identifies the generic SQL type |
| public static final JDBCType | NULL
Identifies the generic SQL value |
| public static final JDBCType | NUMERIC
Identifies the generic SQL type |
| public static final JDBCType | NVARCHAR
Identifies the generic SQL type |
| public static final JDBCType | OTHER
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 JDBCType | REAL
Identifies the generic SQL type |
| public static final JDBCType | REF
Identifies the generic SQL type |
| public static final JDBCType | REF_CURSOR
Identifies the generic SQL type |
| public static final JDBCType | ROWID
Identifies the SQL type |
| public static final JDBCType | SMALLINT
Identifies the generic SQL type |
| public static final JDBCType | SQLXML
Identifies the generic SQL type |
| public static final JDBCType | STRUCT
Identifies the generic SQL type |
| public static final JDBCType | TIME
Identifies the generic SQL type |
| public static final JDBCType | TIME_WITH_TIMEZONE
Identifies the generic SQL type |
| public static final JDBCType | TIMESTAMP
Identifies the generic SQL type |
| public static final JDBCType | TIMESTAMP_WITH_TIMEZONE
Identifies the generic SQL type |
| public static final JDBCType | TINYINT
Identifies the generic SQL type |
| private final Integer | type
The Integer value for the JDBCType. |
| public static final JDBCType | VARBINARY
Identifies the generic SQL type |
| public static final JDBCType | VARCHAR
Identifies the generic SQL type |
| Access | Constructor and Description |
|---|---|
| private |
| Modifier and Type | Method and Description |
|---|---|
| public String | Returns: The name of thisSQLType.Implements java. Returns the |
| public String | Returns: The name of the vendor for this data type which is java.sql for JDBCType.Implements java. Returns the name of the vendor that supports this data type. |
| public Integer | Returns: An Integer representing the data type. ForJDBCType,
the value will be the same value as in Types for the data type.Implements java. Returns the vendor specific type number for the data type. |
| public static JDBCType | |
| public static JDBCType | Returns: TheJDBCType constantTypes valueReturns the |
| public static JDBCType[] |
| ARRAY | back to summary |
|---|---|
| public static final JDBCType ARRAY Identifies the generic SQL type | |
| BIGINT | back to summary |
|---|---|
| public static final JDBCType BIGINT Identifies the generic SQL type | |
| BINARY | back to summary |
|---|---|
| public static final JDBCType BINARY Identifies the generic SQL type | |
| BIT | back to summary |
|---|---|
| public static final JDBCType BIT Identifies the generic SQL type | |
| BLOB | back to summary |
|---|---|
| public static final JDBCType BLOB Identifies the generic SQL type | |
| BOOLEAN | back to summary |
|---|---|
| public static final JDBCType BOOLEAN Identifies the generic SQL type | |
| CHAR | back to summary |
|---|---|
| public static final JDBCType CHAR Identifies the generic SQL type | |
| CLOB | back to summary |
|---|---|
| public static final JDBCType CLOB Identifies the generic SQL type | |
| DATALINK | back to summary |
|---|---|
| public static final JDBCType DATALINK Identifies the generic SQL type | |
| DATE | back to summary |
|---|---|
| public static final JDBCType DATE Identifies the generic SQL type | |
| DECFLOAT | back to summary |
|---|---|
| public static final JDBCType DECFLOAT Identifies the generic SQL type
| |
| DECIMAL | back to summary |
|---|---|
| public static final JDBCType DECIMAL Identifies the generic SQL type | |
| DISTINCT | back to summary |
|---|---|
| public static final JDBCType DISTINCT Identifies the generic SQL type | |
| DOUBLE | back to summary |
|---|---|
| public static final JDBCType DOUBLE Identifies the generic SQL type | |
| FLOAT | back to summary |
|---|---|
| public static final JDBCType FLOAT Identifies the generic SQL type | |
| INTEGER | back to summary |
|---|---|
| public static final JDBCType INTEGER Identifies the generic SQL type | |
| JAVA_OBJECT | back to summary |
|---|---|
| public static final JDBCType JAVA_OBJECT 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. | |
| JSON | back to summary |
|---|---|
| public static final JDBCType JSON Identifies the generic SQL type
| |
| LONGNVARCHAR | back to summary |
|---|---|
| public static final JDBCType LONGNVARCHAR Identifies the generic SQL type | |
| LONGVARBINARY | back to summary |
|---|---|
| public static final JDBCType LONGVARBINARY Identifies the generic SQL type | |
| LONGVARCHAR | back to summary |
|---|---|
| public static final JDBCType LONGVARCHAR Identifies the generic SQL type | |
| NCHAR | back to summary |
|---|---|
| public static final JDBCType NCHAR Identifies the generic SQL type | |
| NCLOB | back to summary |
|---|---|
| public static final JDBCType NCLOB Identifies the generic SQL type | |
| NULL | back to summary |
|---|---|
| public static final JDBCType NULL Identifies the generic SQL value | |
| NUMERIC | back to summary |
|---|---|
| public static final JDBCType NUMERIC Identifies the generic SQL type | |
| NVARCHAR | back to summary |
|---|---|
| public static final JDBCType NVARCHAR Identifies the generic SQL type | |
| OTHER | back to summary |
|---|---|
| public static final JDBCType OTHER 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 JDBCType REAL Identifies the generic SQL type | |
| REF | back to summary |
|---|---|
| public static final JDBCType REF Identifies the generic SQL type | |
| REF_CURSOR | back to summary |
|---|---|
| public static final JDBCType REF_CURSOR Identifies the generic SQL type | |
| ROWID | back to summary |
|---|---|
| public static final JDBCType ROWID Identifies the SQL type | |
| SMALLINT | back to summary |
|---|---|
| public static final JDBCType SMALLINT Identifies the generic SQL type | |
| SQLXML | back to summary |
|---|---|
| public static final JDBCType SQLXML Identifies the generic SQL type | |
| STRUCT | back to summary |
|---|---|
| public static final JDBCType STRUCT Identifies the generic SQL type | |
| TIME | back to summary |
|---|---|
| public static final JDBCType TIME Identifies the generic SQL type | |
| TIME_WITH_TIMEZONE | back to summary |
|---|---|
| public static final JDBCType TIME_WITH_TIMEZONE Identifies the generic SQL type | |
| TIMESTAMP | back to summary |
|---|---|
| public static final JDBCType TIMESTAMP Identifies the generic SQL type | |
| TIMESTAMP_WITH_TIMEZONE | back to summary |
|---|---|
| public static final JDBCType TIMESTAMP_WITH_TIMEZONE Identifies the generic SQL type | |
| TINYINT | back to summary |
|---|---|
| public static final JDBCType TINYINT Identifies the generic SQL type | |
| type | back to summary |
|---|---|
| private final Integer type The Integer value for the JDBCType. It maps to a value in
| |
| VARBINARY | back to summary |
|---|---|
| public static final JDBCType VARBINARY Identifies the generic SQL type | |
| VARCHAR | back to summary |
|---|---|
| public static final JDBCType VARCHAR Identifies the generic SQL type | |
| JDBCType | back to summary |
|---|---|
| private JDBCType(final Integer type) Constructor to specify the data type value from
| |
| getName | back to summary |
|---|---|
| public String getName() Implements java. Doc from java. Returns the
| |
| getVendor | back to summary |
|---|---|
| public String getVendor() Implements java. Returns the name of the vendor that supports this data type.
| |
| getVendorTypeNumber | back to summary |
|---|---|
| public Integer getVendorTypeNumber() Implements java. Returns the vendor specific type number for the data type.
| |
| valueOf | back to summary |
|---|---|
| public static JDBCType valueOf(String name) | |
| valueOf | back to summary |
|---|---|
| public static JDBCType valueOf(int type) Returns the
| |
| values | back to summary |
|---|---|
| public static JDBCType[] values() | |