Types

AI-generated Key Takeaways

• The Types class in Java provides a set of constants representing standard SQL types for use in JDBC.

• These constants act as type codes, enabling developers to identify and work with SQL data types within their Java code.

• The Types class is never instantiated and primarily serves as a container for these predefined type identifiers.

• While most constants map directly to common SQL types, the OTHER constant is reserved for database-specific types requiring special handling.

• The constants within the Types class facilitate seamless interaction between Java applications and relational databases by standardizing type recognition and mapping.

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.

Constant Summary

int	ARRAY	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type ARRAY.
int	BIGINT	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BIGINT.
int	BINARY	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BINARY.
int	BIT	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BIT.
int	BLOB	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BLOB.
int	BOOLEAN	The constant in the Java programming language, somtimes referred to as a type code, that identifies the generic SQL type BOOLEAN.
int	CHAR	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type CHAR.
int	CLOB	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type CLOB.
int	DATALINK	The constant in the Java programming language, somtimes referred to as a type code, that identifies the generic SQL type DATALINK.
int	DATE	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DATE.
int	DECIMAL	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DECIMAL.
int	DISTINCT	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DISTINCT.
int	DOUBLE	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DOUBLE.
int	FLOAT	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type FLOAT.
int	INTEGER	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type INTEGER.
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.
int	LONGNVARCHAR	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGNVARCHAR.
int	LONGVARBINARY	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGVARBINARY.
int	LONGVARCHAR	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGVARCHAR.
int	NCHAR	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NCHAR
int	NCLOB	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NCLOB.
int	NULL	The constant in the Java programming language that identifies the generic SQL value NULL.
int	NUMERIC	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NUMERIC.
int	NVARCHAR	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NVARCHAR.
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.
int	REAL	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REAL.
int	REF	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REF.
int	ROWID	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type ROWID
int	SMALLINT	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type SMALLINT.
int	SQLXML	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type XML.
int	STRUCT	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type STRUCT.
int	TIME	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIME.
int	TIMESTAMP	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIMESTAMP.
int	TINYINT	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TINYINT.
int	VARBINARY	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type VARBINARY.
int	VARCHAR	The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type VARCHAR.

Inherited Method Summary

From class java.lang.Object

Object	clone() Creates and returns a copy of this Object.
boolean	equals(Object obj) Compares this instance with the specified object and indicates if they are equal.
void	finalize() Invoked when the garbage collector has detected that this instance is no longer reachable.
final Class<?>	getClass() Returns the unique instance of Class that represents this object's class.
int	hashCode() Returns an integer hash code for this object.
final void	notify() Causes a thread which is waiting on this object's monitor (by means of calling one of the wait() methods) to be woken up.
final void	notifyAll() Causes all threads which are waiting on this object's monitor (by means of calling one of the wait() methods) to be woken up.
String	toString() Returns a string containing a concise, human-readable description of this object.
final void	wait(long timeout, int nanos) Causes the calling thread to wait until another thread calls the notify() or notifyAll() method of this object or until the specified timeout expires.
final void	wait(long timeout) Causes the calling thread to wait until another thread calls the notify() or notifyAll() method of this object or until the specified timeout expires.
final void	wait() Causes the calling thread to wait until another thread calls the notify() or notifyAll() method of this object.

Constants

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.

Constant Value: 2003

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.

Constant Value: -5

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.

Constant Value: -2

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.

Constant Value: -7

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.

Constant Value: 2004

public static final int BOOLEAN

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

Constant Value: 16

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.

Constant Value: 1

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.

Constant Value: 2005

public static final int DATALINK

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

Constant Value: 70

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.

Constant Value: 91

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.

Constant Value: 3

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.

Constant Value: 2001

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.

Constant Value: 8

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.

Constant Value: 6

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.

Constant Value: 4

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.

Constant Value: 2000

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.

Constant Value: -16

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.

Constant Value: -4

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.

Constant Value: -1

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

Constant Value: -15

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.

Constant Value: 2011

public static final int NULL

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

Constant Value: 0

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.

Constant Value: 2

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.

Constant Value: -9

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.

Constant Value: 1111

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.

Constant Value: 7

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.

Constant Value: 2006

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

Constant Value: -8

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.

Constant Value: 5

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.

Constant Value: 2009

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.

Constant Value: 2002

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.

Constant Value: 92

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.

Constant Value: 93

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.

Constant Value: -6

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.

Constant Value: -3

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.

Constant Value: 12