JDBCType (Java SE 13 & JDK 13 )

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

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

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 declared in class java.lang.Enum

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

Enum Constant Details
- 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
  
  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 type, in the order they are declared.
  
  Returns:
  
  an array containing the constants of this enum type, in the order they are declared
- valueOf
  
  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
  
  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

Nested Class Summary

Enum Constant Summary

Method Summary

Methods declared in class java.lang.Enum

Enum Constant Details

Method Details