org.jooq.impl

Class SQLDataType

java.lang.Object

org.jooq.impl.SQLDataType

public final class SQLDataType
extends Object

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

Field Summary

Fields

Modifier and Type	Field and Description
static DataType<Long>	BIGINT The Types.BIGINT type.
static DataType<ULong>	BIGINTUNSIGNED The unsigned Types.BIGINT type.
static DataType<byte[]>	BINARY The Types.BINARY type.
static DataType<Boolean>	BIT The Types.BIT type.
static DataType<byte[]>	BLOB The Types.BLOB type.
static DataType<Boolean>	BOOLEAN The Types.BOOLEAN type.
static DataType<String>	CHAR The Types.CHAR type.
static DataType<String>	CLOB The Types.CLOB type.
static DataType<Date>	DATE The Types.DATE type.
static DataType<BigDecimal>	DECIMAL The Types.DECIMAL type.
static DataType<BigInteger>	DECIMAL_INTEGER The zero-scale Types.DECIMAL type.
static DataType<Double>	DOUBLE The Types.DOUBLE type.
static DataType<Double>	FLOAT The Types.FLOAT type.
static DataType<Integer>	INTEGER The Types.INTEGER type.
static DataType<UInteger>	INTEGERUNSIGNED The unsigned Types.INTEGER type.
static DataType<DayToSecond>	INTERVALDAYTOSECOND The SQL standard INTERVAL DAY TO SECOND data type.
static DataType<YearToMonth>	INTERVALYEARTOMONTH The SQL standard INTERVAL YEAR TO MONTH data type.
static DataType<java.time.LocalDate>	LOCALDATE The Types.DATE type.
static DataType<java.time.LocalDateTime>	LOCALDATETIME The Types.TIMESTAMP type.
static DataType<java.time.LocalTime>	LOCALTIME The Types.TIME type.
static DataType<String>	LONGNVARCHAR The Types.LONGNVARCHAR type.
static DataType<byte[]>	LONGVARBINARY The Types.LONGVARBINARY type.
static DataType<String>	LONGVARCHAR The Types.LONGVARCHAR type.
static DataType<String>	NCHAR The Types.NCHAR type.
static DataType<String>	NCLOB The Types.NCLOB type.
static DataType<BigDecimal>	NUMERIC The Types.NUMERIC type.
static DataType<String>	NVARCHAR The Types.NVARCHAR type.
static DataType<java.time.OffsetDateTime>	OFFSETDATETIME The Types.TIMESTAMP_WITH_TIMEZONE type.
static DataType<java.time.OffsetTime>	OFFSETTIME The Types.TIME_WITH_TIMEZONE type.
static DataType<Object>	OTHER The Types.OTHER type.
static DataType<Float>	REAL The Types.REAL type.
static DataType<Record>	RECORD The Types.STRUCT type.
static DataType<Result<Record>>	RESULT The ResultSet type.
static DataType<Short>	SMALLINT The Types.SMALLINT type.
static DataType<UShort>	SMALLINTUNSIGNED The unsigned Types.SMALLINT type.
static DataType<Time>	TIME The Types.TIME type.
static DataType<Timestamp>	TIMESTAMP The Types.TIMESTAMP type.
static DataType<java.time.OffsetDateTime>	TIMESTAMPWITHTIMEZONE The Types.TIMESTAMP_WITH_TIMEZONE type.
static DataType<java.time.OffsetTime>	TIMEWITHTIMEZONE The Types.TIME_WITH_TIMEZONE type.
static DataType<Byte>	TINYINT The Types.TINYINT type.
static DataType<UByte>	TINYINTUNSIGNED The unsigned Types.TINYINT type.
static DataType<UUID>	UUID The UUID type.
static DataType<byte[]>	VARBINARY The Types.VARBINARY type.
static DataType<String>	VARCHAR The Types.VARCHAR type.

Method Summary

Methods inherited from class java.lang.Object

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

Field Detail

VARCHAR

public static final DataType<String> VARCHAR

The Types.VARCHAR type.

CHAR

public static final DataType<String> CHAR

The Types.CHAR type.

LONGVARCHAR

public static final DataType<String> LONGVARCHAR

The Types.LONGVARCHAR type.

CLOB

public static final DataType<String> CLOB

The Types.CLOB type.

NVARCHAR

public static final DataType<String> NVARCHAR

The Types.NVARCHAR type.

NCHAR

public static final DataType<String> NCHAR

The Types.NCHAR type.

LONGNVARCHAR

public static final DataType<String> LONGNVARCHAR

The Types.LONGNVARCHAR type.

NCLOB

public static final DataType<String> NCLOB

The Types.NCLOB type.

BOOLEAN

public static final DataType<Boolean> BOOLEAN

The Types.BOOLEAN type.

BIT

public static final DataType<Boolean> BIT

The Types.BIT type.

TINYINT

public static final DataType<Byte> TINYINT

The Types.TINYINT type.

SMALLINT

public static final DataType<Short> SMALLINT

The Types.SMALLINT type.

INTEGER

public static final DataType<Integer> INTEGER

The Types.INTEGER type.

BIGINT

public static final DataType<Long> BIGINT

The Types.BIGINT type.

DECIMAL_INTEGER

public static final DataType<BigInteger> DECIMAL_INTEGER

The zero-scale Types.DECIMAL type.

TINYINTUNSIGNED

public static final DataType<UByte> TINYINTUNSIGNED

The unsigned Types.TINYINT type.

SMALLINTUNSIGNED

public static final DataType<UShort> SMALLINTUNSIGNED

The unsigned Types.SMALLINT type.

INTEGERUNSIGNED

public static final DataType<UInteger> INTEGERUNSIGNED

The unsigned Types.INTEGER type.

BIGINTUNSIGNED

public static final DataType<ULong> BIGINTUNSIGNED

The unsigned Types.BIGINT type.

DOUBLE

public static final DataType<Double> DOUBLE

The Types.DOUBLE type.

FLOAT

public static final DataType<Double> FLOAT

The Types.FLOAT type.

REAL

public static final DataType<Float> REAL

The Types.REAL type.

NUMERIC

public static final DataType<BigDecimal> NUMERIC

The Types.NUMERIC type.

DECIMAL

public static final DataType<BigDecimal> DECIMAL

The Types.DECIMAL type.

DATE

public static final DataType<Date> DATE

The Types.DATE type.

TIMESTAMP

public static final DataType<Timestamp> TIMESTAMP

The Types.TIMESTAMP type.

TIME

public static final DataType<Time> TIME

The Types.TIME type.

INTERVALYEARTOMONTH

public static final DataType<YearToMonth> INTERVALYEARTOMONTH

The SQL standard INTERVAL YEAR TO MONTH data type.

INTERVALDAYTOSECOND

public static final DataType<DayToSecond> INTERVALDAYTOSECOND

The SQL standard INTERVAL DAY TO SECOND data type.

LOCALDATE

public static final DataType<java.time.LocalDate> LOCALDATE

The Types.DATE type.

LOCALTIME

public static final DataType<java.time.LocalTime> LOCALTIME

The Types.TIME type.

LOCALDATETIME

public static final DataType<java.time.LocalDateTime> LOCALDATETIME

The Types.TIMESTAMP type.

OFFSETTIME

public static final DataType<java.time.OffsetTime> OFFSETTIME

The Types.TIME_WITH_TIMEZONE type.

OFFSETDATETIME

public static final DataType<java.time.OffsetDateTime> OFFSETDATETIME

The Types.TIMESTAMP_WITH_TIMEZONE type.

TIMEWITHTIMEZONE

public static final DataType<java.time.OffsetTime> TIMEWITHTIMEZONE

The Types.TIME_WITH_TIMEZONE type.

An alias for OFFSETTIME

TIMESTAMPWITHTIMEZONE

public static final DataType<java.time.OffsetDateTime> TIMESTAMPWITHTIMEZONE

The Types.TIMESTAMP_WITH_TIMEZONE type.

An alias for OFFSETDATETIME

BINARY

public static final DataType<byte[]> BINARY

The Types.BINARY type.

VARBINARY

public static final DataType<byte[]> VARBINARY

The Types.VARBINARY type.

LONGVARBINARY

public static final DataType<byte[]> LONGVARBINARY

The Types.LONGVARBINARY type.

BLOB

public static final DataType<byte[]> BLOB

The Types.BLOB type.

OTHER

public static final DataType<Object> OTHER

The Types.OTHER type.

RECORD

public static final DataType<Record> RECORD

The Types.STRUCT type.

RESULT

public static final DataType<Result<Record>> RESULT

The ResultSet type.

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

UUID

public static final DataType<UUID> UUID

The UUID type.

This is not a SQL or JDBC standard. This type handles UUID types where they are supported