compact2, compact3
java.sql

## Enum JDBCType

- 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, 2026, Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. Also see the documentation redistribution policy.