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

All Implemented Interfaces:

java.io.Serializable, java.lang.Comparable<JDBCTypes>, SQLType
```
public enum JDBCTypes
extends java.lang.Enum<JDBCTypes>
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 and 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`.
`TIMESTAMP` Identifies the generic SQL type `TIMESTAMP`.
`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 and Description
`java.lang.String`	`getName()` Returns the name of the data type.
`java.lang.String`	`getVendor()` Returns the name of the vendor that supports this data type.
`java.lang.Integer`	`getVendorTypeNumber()` Returns the vendor specific type number for the data type.
`static JDBCTypes`	`valueOf(java.lang.String name)` Returns the enum constant of this type with the specified name.
`static JDBCTypes[]`	`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 JDBCTypes BIT
```
    Identifies the generic SQL type BIT.
  - TINYINT
```
public static final JDBCTypes TINYINT
```
    Identifies the generic SQL type TINYINT.
  - SMALLINT
```
public static final JDBCTypes SMALLINT
```
    Identifies the generic SQL type SMALLINT.
  - INTEGER
```
public static final JDBCTypes INTEGER
```
    Identifies the generic SQL type INTEGER.
  - BIGINT
```
public static final JDBCTypes BIGINT
```
    Identifies the generic SQL type BIGINT.
  - FLOAT
```
public static final JDBCTypes FLOAT
```
    Identifies the generic SQL type FLOAT.
  - REAL
```
public static final JDBCTypes REAL
```
    Identifies the generic SQL type REAL.
  - DOUBLE
```
public static final JDBCTypes DOUBLE
```
    Identifies the generic SQL type DOUBLE.
  - NUMERIC
```
public static final JDBCTypes NUMERIC
```
    Identifies the generic SQL type NUMERIC.
  - DECIMAL
```
public static final JDBCTypes DECIMAL
```
    Identifies the generic SQL type DECIMAL.
  - CHAR
```
public static final JDBCTypes CHAR
```
    Identifies the generic SQL type CHAR.
  - VARCHAR
```
public static final JDBCTypes VARCHAR
```
    Identifies the generic SQL type VARCHAR.
  - LONGVARCHAR
```
public static final JDBCTypes LONGVARCHAR
```
    Identifies the generic SQL type LONGVARCHAR.
  - DATE
```
public static final JDBCTypes DATE
```
    Identifies the generic SQL type DATE.
  - TIME
```
public static final JDBCTypes TIME
```
    Identifies the generic SQL type TIME.
  - TIMESTAMP
```
public static final JDBCTypes TIMESTAMP
```
    Identifies the generic SQL type TIMESTAMP.
  - BINARY
```
public static final JDBCTypes BINARY
```
    Identifies the generic SQL type BINARY.
  - VARBINARY
```
public static final JDBCTypes VARBINARY
```
    Identifies the generic SQL type VARBINARY.
  - LONGVARBINARY
```
public static final JDBCTypes LONGVARBINARY
```
    Identifies the generic SQL type LONGVARBINARY.
  - NULL
```
public static final JDBCTypes NULL
```
    Identifies the generic SQL value NULL.
  - OTHER
```
public static final JDBCTypes 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 JDBCTypes 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 JDBCTypes DISTINCT
```
    Identifies the generic SQL type DISTINCT.
  - STRUCT
```
public static final JDBCTypes STRUCT
```
    Identifies the generic SQL type STRUCT.
  - ARRAY
```
public static final JDBCTypes ARRAY
```
    Identifies the generic SQL type ARRAY.
  - BLOB
```
public static final JDBCTypes BLOB
```
    Identifies the generic SQL type BLOB.
  - CLOB
```
public static final JDBCTypes CLOB
```
    Identifies the generic SQL type CLOB.
  - REF
```
public static final JDBCTypes REF
```
    Identifies the generic SQL type REF.
  - DATALINK
```
public static final JDBCTypes DATALINK
```
    Identifies the generic SQL type DATALINK.
  - BOOLEAN
```
public static final JDBCTypes BOOLEAN
```
    Identifies the generic SQL type BOOLEAN.
  - ROWID
```
public static final JDBCTypes ROWID
```
    Identifies the SQL type ROWID.
  - NCHAR
```
public static final JDBCTypes NCHAR
```
    Identifies the generic SQL type NCHAR.
  - NVARCHAR
```
public static final JDBCTypes NVARCHAR
```
    Identifies the generic SQL type NVARCHAR.
  - LONGNVARCHAR
```
public static final JDBCTypes LONGNVARCHAR
```
    Identifies the generic SQL type LONGNVARCHAR.
  - NCLOB
```
public static final JDBCTypes NCLOB
```
    Identifies the generic SQL type NCLOB.
  - SQLXML
```
public static final JDBCTypes SQLXML
```
    Identifies the generic SQL type SQLXML.
  - REF_CURSOR
```
public static final JDBCTypes REF_CURSOR
```
    Identifies the generic SQL type REF_CURSOR.
- Method Detail
  - values
```
public static JDBCTypes[] 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 (JDBCTypes c : JDBCTypes.values())
    System.out.println(c);
```
    Returns:
    
    an array containing the constants of this enum type, in the order they are declared
  - valueOf
```
public static JDBCTypes valueOf(java.lang.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:
    
    java.lang.IllegalArgumentException - if this enum type has no constant with the specified name
    
    java.lang.NullPointerException - if the argument is null
  - getName
```
public java.lang.String getName()
```
    Returns the name of the data type.
    
    Specified by:
    
    getName in interface SQLType
    
    Returns:
    
    The name of the data type.
  - getVendor
```
public java.lang.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 JDBCTypes.
  - getVendorTypeNumber
```
public java.lang.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 JDBCTypes, the value will be the same value as in Types for the data type.

Enum JDBCTypes

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

Method Detail

values

valueOf

getName

getVendor

getVendorTypeNumber