Module java.sql
Package java.sql

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:
SQLType
  • Nested Class Summary

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

    Enum.EnumDesc<E extends Enum<E>>
  • Enum Constant Summary

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

    Modifier and Type
    Method
    Description
    Returns the SQLType name that represents a SQL data type.
    Returns the name of the vendor that supports this data type.
    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[]
    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:
      Types