JDBCType (Java Platform SE 8 )

java.lang.Object
- java.lang.Enum<JDBCType>
- - java.sql.JDBCType

All Implemented Interfaces:

Serializable, Comparable<JDBCType>, 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:

SQLType

Enum Constant Summary

Enum Constants
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

All Methods Static Methods Instance Methods Concrete Methods
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 type with the specified name.
`static JDBCType[]`	`values()`	Returns an array containing the constants of this enum type, in the order they are declared.

Methods inherited from class java.lang.Enum
clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object
getClass, notify, notifyAll, wait, wait, wait

- Enum Constant Detail
  - 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.
  - DATALINK
```
public static final JDBCType DATALINK
```
    Identifies the generic SQL type DATALINK.
  - 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 Detail
  - values
```
public static JDBCType[] values()
```
    Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:
```
for (JDBCType c : JDBCType.values())
    System.out.println(c);
```
    Returns:
    
    an array containing the constants of this enum type, in the order they are declared
  - valueOf
```
public static JDBCType valueOf(String name)
```
    Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (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 type 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:
    
    Types

Submit a bug or feature
For further API reference and developer documentation, see Java SE Documentation. That documentation contains more detailed, developer-targeted descriptions, with conceptual overviews, definitions of terms, workarounds, and working code examples.
Copyright © 1993, 2025, Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. Also see the documentation redistribution policy.

Enum JDBCType

Enum Constant Summary

Method Summary

Methods inherited from class java.lang.Enum

Methods inherited from class java.lang.Object

Enum Constant Detail

BIT

TINYINT

SMALLINT

INTEGER

BIGINT

FLOAT

REAL

DOUBLE

NUMERIC

DECIMAL

CHAR

VARCHAR

LONGVARCHAR

DATE

TIME

TIMESTAMP

BINARY

VARBINARY

LONGVARBINARY

NULL

OTHER

JAVA_OBJECT

DISTINCT

STRUCT

ARRAY

BLOB

CLOB

REF

DATALINK

BOOLEAN

ROWID

NCHAR

NVARCHAR

LONGNVARCHAR

NCLOB

SQLXML

REF_CURSOR

TIME_WITH_TIMEZONE

TIMESTAMP_WITH_TIMEZONE

Method Detail

values

valueOf

getName

getVendor

getVendorTypeNumber

valueOf