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

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`	`DECFLOAT`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `DECFLOAT`.
`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`	`JSON`	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type `JSON`.
`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 Object

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

Modifier and Type	Method	Description
`protected Object`	`clone()`	Creates and returns a copy of this object.
`boolean`	`equals(Object obj)`	Indicates whether some other object is "equal to" this one.
`protected void`	`finalize()`	Deprecated, for removal: This API element is subject to removal in a future version. Finalization is deprecated and subject to removal in a future release.
`final Class<?>`	`getClass()`	Returns the runtime class of this `Object`.
`int`	`hashCode()`	Returns a hash code value for this object.
`final void`	`notify()`	Wakes up a single thread that is waiting on this object's monitor.
`final void`	`notifyAll()`	Wakes up all threads that are waiting on this object's monitor.
`String`	`toString()`	Returns a string representation of the object.
`final void`	`wait()`	Causes the current thread to wait until it is awakened, typically by being notified or interrupted.
`final void`	`wait(long timeoutMillis)`	Causes the current thread to wait until it is awakened, typically by being notified or interrupted, or until a certain amount of real time has elapsed.
`final void`	`wait(long timeoutMillis, int nanos)`	Causes the current thread to wait until it is awakened, typically by being notified or interrupted, or until a certain amount of real time has elapsed.

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

NULL

public static final int NULL

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

See Also:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

DECFLOAT

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:

See Also:

JSON

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:

See Also:

© 1993, 2025, Oracle and/or its affiliates. All rights reserved.
Documentation extracted from Debian's OpenJDK Development Kit package.
Licensed under the GNU General Public License, version 2, with the Classpath Exception.
Various third party code in OpenJDK is licensed under different licenses (see Debian package).
Java and OpenJDK are trademarks or registered trademarks of Oracle and/or its affiliates.