org.jooq.impl
Class SQLDataType<T>

java.lang.Object
  org.jooq.impl.AbstractDataType<T>
      org.jooq.impl.SQLDataType<T>

All Implemented Interfaces:

Serializable, DataType<T>

public final class SQLDataType<T>
extends AbstractDataType<T>

The SQL standard data types, as described in Types.

These types are usually the ones that are referenced by generated source code. Most RDBMS have an almost 1:1 mapping between their vendor-specific types and the ones in this class (except Oracle). Some RDBMS also have extensions, e.g. for geospacial data types. See the dialect-specific data type classes for more information.

Author:

Lukas Eder

See Also:

Serialized Form

Field Summary

static SQLDataType<Long>	BIGINT The Types.BIGINT type
static SQLDataType<ULong>	BIGINTUNSIGNED The unsigned Types.BIGINT type
static SQLDataType<byte[]>	BINARY The Types.BINARY type
static SQLDataType<Boolean>	BIT The Types.BIT type
static SQLDataType<byte[]>	BLOB The Types.BLOB type
static SQLDataType<Boolean>	BOOLEAN The Types.BOOLEAN type
static SQLDataType<String>	CHAR The Types.CHAR type
static SQLDataType<String>	CLOB The Types.CLOB type
static SQLDataType<Date>	DATE The Types.DATE type
static SQLDataType<BigDecimal>	DECIMAL The Types.DECIMAL type
static SQLDataType<BigInteger>	DECIMAL_INTEGER The zero-scale Types.DECIMAL type
static SQLDataType<Double>	DOUBLE The Types.DOUBLE type
static SQLDataType<Double>	FLOAT The Types.FLOAT type
static SQLDataType<Integer>	INTEGER The Types.INTEGER type
static SQLDataType<UInteger>	INTEGERUNSIGNED The unsigned Types.INTEGER type
static SQLDataType<DayToSecond>	INTERVALDAYTOSECOND The SQL standard INTERVAL DAY TO SECOND data type
static SQLDataType<YearToMonth>	INTERVALYEARTOMONTH The SQL standard INTERVAL YEAR TO MONTH data type
static SQLDataType<String>	LONGNVARCHAR The Types.LONGNVARCHAR type
static SQLDataType<byte[]>	LONGVARBINARY The Types.LONGVARBINARY type
static SQLDataType<String>	LONGVARCHAR The Types.LONGVARCHAR type
static SQLDataType<String>	NCHAR The Types.NCHAR type
static SQLDataType<String>	NCLOB The Types.NCLOB type
static SQLDataType<BigDecimal>	NUMERIC The Types.NUMERIC type
static SQLDataType<String>	NVARCHAR The Types.NVARCHAR type
static SQLDataType<Object>	OTHER The Types.OTHER type
static SQLDataType<Float>	REAL The Types.REAL type
static SQLDataType<Result<Record>>	RESULT The ResultSet type This is not a SQL or JDBC standard.
static SQLDataType<Short>	SMALLINT The Types.SMALLINT type
static SQLDataType<UShort>	SMALLINTUNSIGNED The unsigned Types.SMALLINT type
static SQLDataType<Time>	TIME The Types.TIME type
static SQLDataType<Timestamp>	TIMESTAMP The Types.TIMESTAMP type
static SQLDataType<Byte>	TINYINT The Types.TINYINT type
static SQLDataType<UByte>	TINYINTUNSIGNED The unsigned Types.TINYINT type
static SQLDataType<byte[]>	VARBINARY The Types.VARBINARY type
static SQLDataType<String>	VARCHAR The Types.VARCHAR type

Method Summary

Methods inherited from class org.jooq.impl.AbstractDataType

asArrayDataType, asConvertedDataType, asEnumDataType, asMasterDataType, convert, equals, getArrayDataType, getArrayType, getCastTypeName, getCastTypeName, getCastTypeName, getDataType, getDataType, getDataType, getDefaultDataType, getDialect, getSQLDataType, getSQLType, getType, getType, getTypeName, getTypeName, hashCode, isArray, isBinary, isDateTime, isInterval, isNumeric, isString, isTemporal, toString

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Field Detail

VARCHAR

public static final SQLDataType<String> VARCHAR

The Types.VARCHAR type

CHAR

public static final SQLDataType<String> CHAR

The Types.CHAR type

LONGVARCHAR

public static final SQLDataType<String> LONGVARCHAR

The Types.LONGVARCHAR type

CLOB

public static final SQLDataType<String> CLOB

The Types.CLOB type

NVARCHAR

public static final SQLDataType<String> NVARCHAR

The Types.NVARCHAR type

NCHAR

public static final SQLDataType<String> NCHAR

The Types.NCHAR type

LONGNVARCHAR

public static final SQLDataType<String> LONGNVARCHAR

The Types.LONGNVARCHAR type

NCLOB

public static final SQLDataType<String> NCLOB

The Types.NCLOB type

BOOLEAN

public static final SQLDataType<Boolean> BOOLEAN

The Types.BOOLEAN type

BIT

public static final SQLDataType<Boolean> BIT

The Types.BIT type

TINYINT

public static final SQLDataType<Byte> TINYINT

The Types.TINYINT type

SMALLINT

public static final SQLDataType<Short> SMALLINT

The Types.SMALLINT type

INTEGER

public static final SQLDataType<Integer> INTEGER

The Types.INTEGER type

BIGINT

public static final SQLDataType<Long> BIGINT

The Types.BIGINT type

DECIMAL_INTEGER

public static final SQLDataType<BigInteger> DECIMAL_INTEGER

The zero-scale Types.DECIMAL type

TINYINTUNSIGNED

public static final SQLDataType<UByte> TINYINTUNSIGNED

The unsigned Types.TINYINT type

SMALLINTUNSIGNED

public static final SQLDataType<UShort> SMALLINTUNSIGNED

The unsigned Types.SMALLINT type

INTEGERUNSIGNED

public static final SQLDataType<UInteger> INTEGERUNSIGNED

The unsigned Types.INTEGER type

BIGINTUNSIGNED

public static final SQLDataType<ULong> BIGINTUNSIGNED

The unsigned Types.BIGINT type

DOUBLE

public static final SQLDataType<Double> DOUBLE

The Types.DOUBLE type

FLOAT

public static final SQLDataType<Double> FLOAT

The Types.FLOAT type

REAL

public static final SQLDataType<Float> REAL

The Types.REAL type

NUMERIC

public static final SQLDataType<BigDecimal> NUMERIC

The Types.NUMERIC type

DECIMAL

public static final SQLDataType<BigDecimal> DECIMAL

The Types.DECIMAL type

DATE

public static final SQLDataType<Date> DATE

The Types.DATE type

TIMESTAMP

public static final SQLDataType<Timestamp> TIMESTAMP

The Types.TIMESTAMP type

TIME

public static final SQLDataType<Time> TIME

The Types.TIME type

INTERVALYEARTOMONTH

public static final SQLDataType<YearToMonth> INTERVALYEARTOMONTH

The SQL standard INTERVAL YEAR TO MONTH data type

INTERVALDAYTOSECOND

public static final SQLDataType<DayToSecond> INTERVALDAYTOSECOND

The SQL standard INTERVAL DAY TO SECOND data type

BINARY

public static final SQLDataType<byte[]> BINARY

The Types.BINARY type

VARBINARY

public static final SQLDataType<byte[]> VARBINARY

The Types.VARBINARY type

LONGVARBINARY

public static final SQLDataType<byte[]> LONGVARBINARY

The Types.LONGVARBINARY type

BLOB

public static final SQLDataType<byte[]> BLOB

The Types.BLOB type

OTHER

public static final SQLDataType<Object> OTHER

The Types.OTHER type

RESULT

public static final SQLDataType<Result<Record>> RESULT

The ResultSet type

This is not a SQL or JDBC standard. This type simulates REF CURSOR types and similar constructs