Class Types

java.lang.Object

java.sql.Types

public class Types
extends Object

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

Fields

Modifier and Type	Field	Description
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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
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.
static final int	NULL	The constant in the Java programming language that identifies the generic SQL value NULL.
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.
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.
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.
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.
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.
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.
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
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.

Method Summary

Methods declared in class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

BIT

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.

See Also:

• Constant Field Values

TINYINT

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.

See Also:

• Constant Field Values

SMALLINT

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.

See Also:

• Constant Field Values

INTEGER

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.

See Also:

• Constant Field Values

BIGINT

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.

See Also:

• Constant Field Values

FLOAT

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.

See Also:

• Constant Field Values

REAL

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.

See Also:

• Constant Field Values

DOUBLE

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.

See Also:

• Constant Field Values

NUMERIC

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.

See Also:

• Constant Field Values

DECIMAL

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.

See Also:

• Constant Field Values

CHAR

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.

See Also:

• Constant Field Values

VARCHAR

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.

See Also:

• Constant Field Values

LONGVARCHAR

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.

See Also:

• Constant Field Values

DATE

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.

See Also:

• Constant Field Values

TIME

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.

See Also:

• Constant Field Values

TIMESTAMP

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.

See Also:

• Constant Field Values

BINARY

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.

See Also:

• Constant Field Values

VARBINARY

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.

See Also:

• Constant Field Values

LONGVARBINARY

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.

See Also:

• Constant Field Values

NULL

public static final int NULL

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

See Also:

• Constant Field Values

OTHER

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.

See Also:

• Constant Field Values

JAVA_OBJECT

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

See Also:

• Constant Field Values

DISTINCT

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

See Also:

• Constant Field Values

STRUCT

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

See Also:

• Constant Field Values

ARRAY

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

See Also:

• Constant Field Values

BLOB

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

See Also:

• Constant Field Values

CLOB

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

See Also:

• Constant Field Values

REF

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

See Also:

• Constant Field Values

DATALINK

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.

Since:

1.4

See Also:

• Constant Field Values

BOOLEAN

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

See Also:

• Constant Field Values

ROWID

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

See Also:

• Constant Field Values

NCHAR

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

See Also:

• Constant Field Values

NVARCHAR

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

See Also:

• Constant Field Values

LONGNVARCHAR

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

See Also:

• Constant Field Values

NCLOB

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

See Also:

• Constant Field Values

SQLXML

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

See Also:

• Constant Field Values

REF_CURSOR

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

See Also:

• Constant Field Values

TIME_WITH_TIMEZONE

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

See Also:

• Constant Field Values

TIMESTAMP_WITH_TIMEZONE

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

See Also:

• Constant Field Values