W3cubDocs

/OpenJDK 21

Enum Class JDBCType

All Implemented Interfaces:
Serializable, Comparable<JDBCType>, Constable, SQLType
public enum JDBCType extends Enum<JDBCType> implements SQLType

Defines the constants that are used to identify generic SQL types, called JDBC types.

Since:
1.8
See Also:

Nested Class Summary

Nested classes/interfaces declared in class java.lang.Enum

Enum.EnumDesc<E extends Enum<E>>

Enum Constant Summary

Enum Constant Description
ARRAY
Identifies the generic SQL type ARRAY.
BIGINT
Identifies the generic SQL type BIGINT.
BINARY
Identifies the generic SQL type BINARY.
BIT
Identifies the generic SQL type BIT.
BLOB
Identifies the generic SQL type BLOB.
BOOLEAN
Identifies the generic SQL type BOOLEAN.
CHAR
Identifies the generic SQL type CHAR.
CLOB
Identifies the generic SQL type CLOB.
DATALINK
Identifies the generic SQL type DATALINK.
DATE
Identifies the generic SQL type DATE.
DECIMAL
Identifies the generic SQL type DECIMAL.
DISTINCT
Identifies the generic SQL type DISTINCT.
DOUBLE
Identifies the generic SQL type DOUBLE.
FLOAT
Identifies the generic SQL type FLOAT.
INTEGER
Identifies the generic SQL type INTEGER.
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.
LONGNVARCHAR
Identifies the generic SQL type LONGNVARCHAR.
LONGVARBINARY
Identifies the generic SQL type LONGVARBINARY.
LONGVARCHAR
Identifies the generic SQL type LONGVARCHAR.
NCHAR
Identifies the generic SQL type NCHAR.
NCLOB
Identifies the generic SQL type NCLOB.
NULL
Identifies the generic SQL value NULL.
NUMERIC
Identifies the generic SQL type NUMERIC.
NVARCHAR
Identifies the generic SQL type NVARCHAR.
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
Identifies the generic SQL type REAL.
REF
Identifies the generic SQL type REF.
REF_CURSOR
Identifies the generic SQL type REF_CURSOR.
ROWID
Identifies the SQL type ROWID.
SMALLINT
Identifies the generic SQL type SMALLINT.
SQLXML
Identifies the generic SQL type SQLXML.
STRUCT
Identifies the generic SQL type STRUCT.
TIME
Identifies the generic SQL type TIME.
TIME_WITH_TIMEZONE
Identifies the generic SQL type TIME_WITH_TIMEZONE.
TIMESTAMP
Identifies the generic SQL type TIMESTAMP.
TIMESTAMP_WITH_TIMEZONE
Identifies the generic SQL type TIMESTAMP_WITH_TIMEZONE.
TINYINT
Identifies the generic SQL type TINYINT.
VARBINARY
Identifies the generic SQL type VARBINARY.
VARCHAR
Identifies the generic SQL type VARCHAR.

Method Summary

Modifier and Type Method Description
String getName()
Returns the SQLType name that represents a SQL data type.
String getVendor()
Returns the name of the vendor that supports this data type.
Integer getVendorTypeNumber()
Returns the vendor specific type number for the data type.
static JDBCType valueOf(int type)
Returns the JDBCType that corresponds to the specified Types value
static JDBCType valueOf(String name)
Returns the enum constant of this class with the specified name.
static JDBCType[] values()
Returns an array containing the constants of this enum class, in the order they are declared.

Methods declared in class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Details

BIT

public static final JDBCType BIT
Identifies the generic SQL type BIT.

TINYINT

public static final JDBCType TINYINT
Identifies the generic SQL type TINYINT.

SMALLINT

public static final JDBCType SMALLINT
Identifies the generic SQL type SMALLINT.

INTEGER

public static final JDBCType INTEGER
Identifies the generic SQL type INTEGER.

BIGINT

public static final JDBCType BIGINT
Identifies the generic SQL type BIGINT.

FLOAT

public static final JDBCType FLOAT
Identifies the generic SQL type FLOAT.

REAL

public static final JDBCType REAL
Identifies the generic SQL type REAL.

DOUBLE

public static final JDBCType DOUBLE
Identifies the generic SQL type DOUBLE.

NUMERIC

public static final JDBCType NUMERIC
Identifies the generic SQL type NUMERIC.

DECIMAL

public static final JDBCType DECIMAL
Identifies the generic SQL type DECIMAL.

CHAR

public static final JDBCType CHAR
Identifies the generic SQL type CHAR.

VARCHAR

public static final JDBCType VARCHAR
Identifies the generic SQL type VARCHAR.

LONGVARCHAR

public static final JDBCType LONGVARCHAR
Identifies the generic SQL type LONGVARCHAR.

DATE

public static final JDBCType DATE
Identifies the generic SQL type DATE.

TIME

public static final JDBCType TIME
Identifies the generic SQL type TIME.

TIMESTAMP

public static final JDBCType TIMESTAMP
Identifies the generic SQL type TIMESTAMP.

BINARY

public static final JDBCType BINARY
Identifies the generic SQL type BINARY.

VARBINARY

public static final JDBCType VARBINARY
Identifies the generic SQL type VARBINARY.

LONGVARBINARY

public static final JDBCType LONGVARBINARY
Identifies the generic SQL type LONGVARBINARY.

NULL

public static final JDBCType NULL
Identifies the generic SQL value NULL.

OTHER

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.

JAVA_OBJECT

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.

DISTINCT

public static final JDBCType DISTINCT
Identifies the generic SQL type DISTINCT.

STRUCT

public static final JDBCType STRUCT
Identifies the generic SQL type STRUCT.

ARRAY

public static final JDBCType ARRAY
Identifies the generic SQL type ARRAY.

BLOB

public static final JDBCType BLOB
Identifies the generic SQL type BLOB.

CLOB

public static final JDBCType CLOB
Identifies the generic SQL type CLOB.

REF

public static final JDBCType REF
Identifies the generic SQL type REF.

BOOLEAN

public static final JDBCType BOOLEAN
Identifies the generic SQL type BOOLEAN.

ROWID

public static final JDBCType ROWID
Identifies the SQL type ROWID.

NCHAR

public static final JDBCType NCHAR
Identifies the generic SQL type NCHAR.

NVARCHAR

public static final JDBCType NVARCHAR
Identifies the generic SQL type NVARCHAR.

LONGNVARCHAR

public static final JDBCType LONGNVARCHAR
Identifies the generic SQL type LONGNVARCHAR.

NCLOB

public static final JDBCType NCLOB
Identifies the generic SQL type NCLOB.

SQLXML

public static final JDBCType SQLXML
Identifies the generic SQL type SQLXML.

REF_CURSOR

public static final JDBCType REF_CURSOR
Identifies the generic SQL type REF_CURSOR.

TIME_WITH_TIMEZONE

public static final JDBCType TIME_WITH_TIMEZONE
Identifies the generic SQL type TIME_WITH_TIMEZONE.

TIMESTAMP_WITH_TIMEZONE

public static final JDBCType TIMESTAMP_WITH_TIMEZONE
Identifies the generic SQL type TIMESTAMP_WITH_TIMEZONE.

Method Details

values

public static JDBCType[] values()
Returns an array containing the constants of this enum class, in the order they are declared.
Returns:
an array containing the constants of this enum class, in the order they are declared

valueOf

public static JDBCType valueOf(String name)
Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (Extraneous whitespace characters are not permitted.)
Parameters:
name - the name of the enum constant to be returned.
Returns:
the enum constant with the specified name
Throws:
IllegalArgumentException - if this enum class has no constant with the specified name
NullPointerException - if the argument is null

getName

public String getName()
Returns the SQLType name that represents a SQL data type.
Specified by:
getName in interface SQLType
Returns:
The name of this SQLType.

getVendor

public String getVendor()
Returns the name of the vendor that supports this data type.
Specified by:
getVendor in interface SQLType
Returns:
The name of the vendor for this data type which is java.sql for JDBCType.

getVendorTypeNumber

public Integer getVendorTypeNumber()
Returns the vendor specific type number for the data type.
Specified by:
getVendorTypeNumber in interface SQLType
Returns:
An Integer representing the data type. For JDBCType, the value will be the same value as in Types for the data type.

valueOf

public static JDBCType valueOf(int type)
Returns the JDBCType that corresponds to the specified Types value
Parameters:
type - Types value
Returns:
The JDBCType constant
Throws:
IllegalArgumentException - if this enum type has no constant with the specified Types value
See Also:

© 1993, 2023, Oracle and/or its affiliates. All rights reserved.
Documentation extracted from Debian's OpenJDK Development Kit package.
Licensed under the GNU General Public License, version 2, with the Classpath Exception.
Various third party code in OpenJDK is licensed under different licenses (see Debian package).
Java and OpenJDK are trademarks or registered trademarks of Oracle and/or its affiliates.
https://docs.oracle.com/en/java/javase/21/docs/api/java.sql/java/sql/JDBCType.html