1. Description
2. Nested Class Summary
3. Enum Constant Summary
4. Method Summary
5. Enum Constant Details
   1. BIT
   2. TINYINT
   3. SMALLINT
   4. INTEGER
   5. BIGINT
   6. FLOAT
   7. REAL
   8. DOUBLE
   9. NUMERIC
   10. DECIMAL
   11. CHAR
   12. VARCHAR
   13. LONGVARCHAR
   14. DATE
   15. TIME
   16. TIMESTAMP
   17. BINARY
   18. VARBINARY
   19. LONGVARBINARY
   20. NULL
   21. OTHER
   22. JAVA_OBJECT
   23. DISTINCT
   24. STRUCT
   25. ARRAY
   26. BLOB
   27. CLOB
   28. REF
   29. DATALINK
   30. BOOLEAN
   31. ROWID
   32. NCHAR
   33. NVARCHAR
   34. LONGNVARCHAR
   35. NCLOB
   36. SQLXML
   37. REF_CURSOR
   38. TIME_WITH_TIMEZONE
   39. TIMESTAMP_WITH_TIMEZONE
6. Method Details
   1. values()
   2. valueOf(String)
   3. getName()
   4. getVendor()
   5. getVendorTypeNumber()
   6. valueOf(int)

All Implemented Interfaces:

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

  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 MethodsStatic MethodsInstance MethodsConcrete 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 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.Enum

  clone, compareTo, describeConstable, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

  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.

  • 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 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

Report a bug or suggest an enhancement
For further API reference and developer documentation see the Java SE Documentation, which contains more detailed, developer-targeted descriptions with conceptual overviews, definitions of terms, workarounds, and working code examples. Other versions.
Java is a trademark or registered trademark of Oracle and/or its affiliates in the US and other countries.
Copyright © 1993, 2025, Oracle and/or its affiliates, 500 Oracle Parkway, Redwood Shores, CA 94065 USA.
All rights reserved. Use is subject to license terms and the documentation redistribution policy.