Types

TopBlend: Here is the first difference. There are 9 differences.

~~is old.~~

is new.

java.sql
Class Types


java.lang.Object
  java.sql.Types

public class Types
extends Object
extends Object

The class that defines the constants that are used to identify generic SQL types, called JDBC types. ~~The actual type constant values are equivalent to those in XOPEN.~~

This class is never instantiated.

Field Summary
static int	ARRAY The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type ARRAY.
static int	BIGINT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BIGINT.
static int	BINARY The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BINARY.
static int	BIT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BIT.
static int	BLOB The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BLOB.
static int	BOOLEAN The constant in the Java programming language, somtimes referred to as a type code, that identifies the generic SQL type BOOLEAN.
static int	CHAR The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type CHAR.
static int	CLOB The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type CLOB.
static int	DATALINK The constant in the Java programming language, somtimes referred to as a type code, that identifies the generic SQL type DATALINK.
static int	DATE The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DATE.
static int	DECIMAL The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DECIMAL.
static int	DISTINCT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DISTINCT.
static int	DOUBLE The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DOUBLE.
static int	FLOAT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type FLOAT.
static int	INTEGER The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type INTEGER.
static 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 int*	*LONGNVARCHAR* *The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGNVARCHAR.*
static int	LONGVARBINARY The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGVARBINARY.
static int	LONGVARCHAR The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGVARCHAR.
static int	*NCHAR* ~~NULL~~ The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type *NCHAR* ~~NULL.~~
*static int*	*NCLOB* *The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NCLOB.*
*static int*	*NULL* *The constant in the Java programming language that identifies the generic SQL value NULL.*
static int	NUMERIC The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NUMERIC.
*static int*	*NVARCHAR* *The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NVARCHAR.*
static 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 int	REAL The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REAL.
static int	REF The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REF.
*static int*	*ROWID* *The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type ROWID*
static int	SMALLINT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type SMALLINT.
*static int*	*SQLXML* *The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type XML.*
static int	STRUCT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type STRUCT.
static int	TIME The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIME.
static int	TIMESTAMP The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIMESTAMP.
static int	TINYINT The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TINYINT.
static int	VARBINARY The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type VARBINARY.
static 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 inherited from class java.lang. Object
clone , equals , finalize , getClass , hashCode , notify , notifyAll , toString , wait , wait , wait

Field Detail

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 ~~language, sometimes referred to as a type code,~~ that identifies the generic SQL value ~~type~~ 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, somtimes 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, somtimes 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

java.sql Class Types

BIT