APIdia Launch Partner
Top Description Fields Constructors Methods
java.sql

public Class Types

extends Object
Class Inheritance

The class that defines the constants that are used to identify generic SQL types, called JDBC types.

This class is never instantiated.

Since
1.1

Field Summary

Modifier and TypeField and Description
public static final int
ARRAY

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type ARRAY.

public static final int
BIGINT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BIGINT.

public static final int
BINARY

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BINARY.

public static final int
BIT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BIT.

public static final int
BLOB

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BLOB.

public static final int
BOOLEAN

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BOOLEAN.

public static final int
CHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type CHAR.

public static final int
CLOB

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type CLOB.

public static final int
DATALINK

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DATALINK.

public static final int
DATE

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DATE.

public static final int
DECFLOAT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DECFLOAT.

public static final int
DECIMAL

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DECIMAL.

public static final int
DISTINCT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DISTINCT.

public static final int
DOUBLE

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DOUBLE.

public static final int
FLOAT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type FLOAT.

public static final int
INTEGER

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type INTEGER.

public static final int
JAVA_OBJECT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type JAVA_OBJECT.

public static final int
JSON

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type JSON.

public static final int
LONGNVARCHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGNVARCHAR.

public static final int
LONGVARBINARY

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGVARBINARY.

public static final int
LONGVARCHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGVARCHAR.

public static final int
NCHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NCHAR

public static final int
NCLOB

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NCLOB.

public static final int
NULL

The constant in the Java programming language that identifies the generic SQL value NULL.

public static final int
NUMERIC

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NUMERIC.

public static final int
NVARCHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NVARCHAR.

public static final int
OTHER

The constant in the Java programming language that 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.

public static final int
REAL

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REAL.

public static final int
REF

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REF.

public static final int
REF_CURSOR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REF CURSOR.

public static final int
ROWID

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type ROWID

public static final int
SMALLINT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type SMALLINT.

public static final int
SQLXML

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type XML.

public static final int
STRUCT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type STRUCT.

public static final int
TIME

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIME.

public static final int
TIME_WITH_TIMEZONE

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIME WITH TIMEZONE.

public static final int
TIMESTAMP

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIMESTAMP.

public static final int
TIMESTAMP_WITH_TIMEZONE

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIMESTAMP WITH TIMEZONE.

public static final int
TINYINT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TINYINT.

public static final int
VARBINARY

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type VARBINARY.

public static final int
VARCHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type VARCHAR.

Constructor Summary

AccessConstructor and Description
private

Method Summary

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait

Field Detail

ARRAYback to summary
public static final int ARRAY

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type ARRAY.

Since
1.2
BIGINTback to summary
public static final int BIGINT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BIGINT.

BINARYback to summary
public static final int BINARY

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BINARY.

BITback to summary
public static final int BIT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BIT.

BLOBback to summary
public static final int BLOB

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BLOB.

Since
1.2
BOOLEANback to summary
public static final int BOOLEAN

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BOOLEAN.

Since
1.4
CHARback to summary
public static final int CHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type CHAR.

CLOBback to summary
public static final int CLOB

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type CLOB.

Since
1.2
DATEback to summary
public static final int DATE

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DATE.

DECFLOATback to summary
public static final int DECFLOAT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DECFLOAT.

Since
26
DECIMALback to summary
public static final int DECIMAL

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DECIMAL.

DISTINCTback to summary
public static final int DISTINCT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DISTINCT.

Since
1.2
DOUBLEback to summary
public static final int DOUBLE

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DOUBLE.

FLOATback to summary
public static final int FLOAT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type FLOAT.

INTEGERback to summary
public static final int INTEGER

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type INTEGER.

JAVA_OBJECTback to summary
public static final int JAVA_OBJECT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type JAVA_OBJECT.

Since
1.2
JSONback to summary
public static final int JSON

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type JSON.

Since
26
LONGNVARCHARback to summary
public static final int LONGNVARCHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGNVARCHAR.

Since
1.6
LONGVARBINARYback to summary
public static final int LONGVARBINARY

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGVARBINARY.

LONGVARCHARback to summary
public static final int LONGVARCHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGVARCHAR.

NCHARback to summary
public static final int NCHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NCHAR

Since
1.6
NCLOBback to summary
public static final int NCLOB

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NCLOB.

Since
1.6
NULLback to summary
public static final int NULL

The constant in the Java programming language that identifies the generic SQL value NULL.

NUMERICback to summary
public static final int NUMERIC

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NUMERIC.

NVARCHARback to summary
public static final int NVARCHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NVARCHAR.

Since
1.6
OTHERback to summary
public static final int OTHER

The constant in the Java programming language that 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.

REALback to summary
public static final int REAL

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REAL.

REFback to summary
public static final int REF

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REF.

Since
1.2
REF_CURSORback to summary
public static final int REF_CURSOR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REF CURSOR.

Since
1.8
ROWIDback to summary
public static final int ROWID

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type ROWID

Since
1.6
SMALLINTback to summary
public static final int SMALLINT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type SMALLINT.

SQLXMLback to summary
public static final int SQLXML

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type XML.

Since
1.6
STRUCTback to summary
public static final int STRUCT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type STRUCT.

Since
1.2
TIMEback to summary
public static final int TIME

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIME.

TIME_WITH_TIMEZONEback to summary
public static final int TIME_WITH_TIMEZONE

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIME WITH TIMEZONE.

Since
1.8
TIMESTAMPback to summary
public static final int TIMESTAMP

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIMESTAMP.

TIMESTAMP_WITH_TIMEZONEback to summary
public static final int TIMESTAMP_WITH_TIMEZONE

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIMESTAMP WITH TIMEZONE.

Since
1.8
TINYINTback to summary
public static final int TINYINT

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TINYINT.

VARBINARYback to summary
public static final int VARBINARY

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type VARBINARY.

VARCHARback to summary
public static final int VARCHAR

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type VARCHAR.

Constructor Detail

Typesback to summary
private Types()