SQLDialect (jOOQ 3.11.12 API)

java.lang.Object
- java.lang.Enum<SQLDialect>
- - org.jooq.SQLDialect

All Implemented Interfaces:

Serializable, Comparable<SQLDialect>
```
public enum SQLDialect
extends Enum<SQLDialect>
```
Dialects and dialect families as supported by jOOQ.
jOOQ supports a variety of dialects, which are grouped into dialect families. For instance, the SQL Server dialect family POSTGRES is specialised by its dialects
- POSTGRES_9_3
- POSTGRES_9_4
Author:

Lukas Eder

Nested Class Summary

Nested Classes
Modifier and Type Class and Description

class SQLDialect.ThirdParty
Third party representations of the enclosing SQLDialect.

Nested Classes
Modifier and Type	Class and Description
`class`	`SQLDialect.ThirdParty` Third party representations of the enclosing `SQLDialect`.

Enum Constant Summary

Enum Constants
Enum Constant and Description
`ACCESS` The MS Access dialect family.
`ACCESS2013` The MS Access 2013 dialect.
`ASE` The Sybase Adaptive Server dialect family.
`AURORA_MYSQL` The Amazon Aurora MySQL Edition dialect family.
`AURORA_POSTGRES` The Amazon Aurora PostgreSQL Edition dialect family.
`CUBRID` The CUBRID dialect family.
`DB2` The IBM DB2 dialect family.
`DB2_10` The IBM DB2 10.x dialect.
`DB2_11` The IBM DB2 11.x dialect.
`DB2_9` The IBM DB2 9.x dialect.
`DEFAULT` The default SQL dialect.
`DERBY` The Apache Derby dialect family.
`FIREBIRD` The Firebird dialect family.
`FIREBIRD_2_5` The Firebird 2.5 dialect.
`FIREBIRD_3_0` The Firebird 3.0 dialect.
`H2` The H2 dialect family.
`HANA` The SAP HANA dialect.
`HSQLDB` The Hypersonic dialect family.
`INFORMIX` The Informix dialect.
`INGRES` The Ingres dialect family.
`MARIADB` The MariaDB dialect family.
`MYSQL` The MySQL dialect family.
`MYSQL_5_7` The MySQL 5.7 dialect.
`MYSQL_8_0` The MySQL 8.0 dialect.
`ORACLE` The Oracle dialect family.
`ORACLE10G` The Oracle 10g dialect.
`ORACLE11G` The Oracle 11g dialect.
`ORACLE12C` The Oracle 12c dialect.
`POSTGRES` The PostgreSQL dialect family.
`POSTGRES_10` The PostgreSQL 10 dialect.
`POSTGRES_9_3` The PostgreSQL 9.3 dialect.
`POSTGRES_9_4` The PostgreSQL 9.4 dialect.
`POSTGRES_9_5` The PostgreSQL 9.5 dialect.
`POSTGRESPLUS` Deprecated. - This dialect is not yet supported by jOOQ.
`REDSHIFT` The Amazon Redshift dialect.
`SQL99` Deprecated. - [#3844] - 3.6.0 - `DEFAULT` will replace this pseudo-dialect.
`SQLDATAWAREHOUSE` The SQL Data Warehouse family.
`SQLITE` The SQLite dialect family.
`SQLSERVER` The SQL Server dialect family.
`SQLSERVER2008` The SQL Server 2008 dialect.
`SQLSERVER2012` The SQL Server 2012 dialect.
`SQLSERVER2014` The SQL Server 2014 dialect.
`SQLSERVER2016` The SQL Server 2016 dialect.
`SQLSERVER2017` The SQL Server 2016 dialect.
`SYBASE` The Sybase SQL Anywhere dialect family.
`TERADATA` The Teradata dialect family.
`VERTICA` The Vertica dialect family.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`boolean`	`commercial()` Whether this dialect is supported with the jOOQ commercial license only.
`static SQLDialect[]`	`families()` Get a list of all `family()` values.
`SQLDialect`	`family()` The dialect family.
`String`	`getName()` The name of this dialect as it appears in related class names.
`String`	`getNameLC()` The name of this dialect as it appears in related package names.
`String`	`getNameUC()` The name of this dialect as it appears in related enum values.
`boolean`	`isFamily()` Whether this dialect is a `family()`.
`boolean`	`precedes(SQLDialect other)` Whether this dialect precedes an other dialect from the same family.
`SQLDialect`	`predecessor()` The predecessor dialect.
`boolean`	`supports(SQLDialect other)` Check whether this dialect supports another one.
`SQLDialect.ThirdParty`	`thirdParty()` Get access to third party representations of this `SQLDialect`.
`static SQLDialect`	`valueOf(String name)` Returns the enum constant of this type with the specified name.
`static SQLDialect[]`	`values()` Returns an array containing the constants of this enum type, in the order they are declared.

Methods inherited from class java.lang.Enum
clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object
getClass, notify, notifyAll, wait, wait, wait

- Enum Constant Detail
  - SQL99
```
@Deprecated
public static final SQLDialect SQL99
```
    Deprecated. - [#3844] - 3.6.0 - DEFAULT will replace this pseudo-dialect.
    
    The standard SQL dialect family.
  - DEFAULT
```
public static final SQLDialect DEFAULT
```
    The default SQL dialect.
    This dialect is chosen in the absence of a more explicit dialect. It is not intended to be used with any actual database as it may combined dialect-specific things from various dialects.
  - CUBRID
```
public static final SQLDialect CUBRID
```
    The CUBRID dialect family.
  - DERBY
```
public static final SQLDialect DERBY
```
    The Apache Derby dialect family.
  - FIREBIRD
```
public static final SQLDialect FIREBIRD
```
    The Firebird dialect family.
  - FIREBIRD_2_5
```
public static final SQLDialect FIREBIRD_2_5
```
    The Firebird 2.5 dialect.
  - FIREBIRD_3_0
```
public static final SQLDialect FIREBIRD_3_0
```
    The Firebird 3.0 dialect.
  - H2
```
public static final SQLDialect H2
```
    The H2 dialect family.
  - HSQLDB
```
public static final SQLDialect HSQLDB
```
    The Hypersonic dialect family.
  - MARIADB
```
public static final SQLDialect MARIADB
```
    The MariaDB dialect family.
  - MYSQL
```
public static final SQLDialect MYSQL
```
    The MySQL dialect family.
  - MYSQL_5_7
```
public static final SQLDialect MYSQL_5_7
```
    The MySQL 5.7 dialect.
  - MYSQL_8_0
```
public static final SQLDialect MYSQL_8_0
```
    The MySQL 8.0 dialect.
  - POSTGRES
```
public static final SQLDialect POSTGRES
```
    The PostgreSQL dialect family.
    While this family (and its dialects) have been observed to work to some extent on Amazon RedShift as well, we strongly suggest you use the official REDSHIFT support, instead.
  - POSTGRES_9_3
```
public static final SQLDialect POSTGRES_9_3
```
    The PostgreSQL 9.3 dialect.
    While this family (and its dialects) have been observed to work to some extent on Amazon RedShift as well, we strongly suggest you use the official REDSHIFT support, instead.
  - POSTGRES_9_4
```
public static final SQLDialect POSTGRES_9_4
```
    The PostgreSQL 9.4 dialect.
    While this family (and its dialects) have been observed to work to some extent on Amazon RedShift as well, we strongly suggest you use the official REDSHIFT support, instead.
  - POSTGRES_9_5
```
public static final SQLDialect POSTGRES_9_5
```
    The PostgreSQL 9.5 dialect.
    While this family (and its dialects) have been observed to work to some extent on Amazon RedShift as well, we strongly suggest you use the official REDSHIFT support, instead.
  - POSTGRES_10
```
public static final SQLDialect POSTGRES_10
```
    The PostgreSQL 10 dialect.
    While this family (and its dialects) have been observed to work to some extent on Amazon RedShift as well, we strongly suggest you use the official REDSHIFT support, instead.
  - SQLITE
```
public static final SQLDialect SQLITE
```
    The SQLite dialect family.
  - ACCESS
```
public static final SQLDialect ACCESS
```
    The MS Access dialect family.
    This dialect is available in commercial jOOQ distributions, only.
  - ACCESS2013
```
public static final SQLDialect ACCESS2013
```
    The MS Access 2013 dialect.
    This dialect is available in commercial jOOQ distributions, only.
  - ASE
```
public static final SQLDialect ASE
```
    The Sybase Adaptive Server dialect family.
    This dialect is available in commercial jOOQ distributions, only.
  - AURORA_MYSQL
```
public static final SQLDialect AURORA_MYSQL
```
    The Amazon Aurora MySQL Edition dialect family.
    This dialect is available in commercial jOOQ distributions, only.
  - AURORA_POSTGRES
```
public static final SQLDialect AURORA_POSTGRES
```
    The Amazon Aurora PostgreSQL Edition dialect family.
    This dialect is available in commercial jOOQ distributions, only.
  - DB2
```
public static final SQLDialect DB2
```
    The IBM DB2 dialect family.
    This dialect is available in commercial jOOQ distributions, only.
  - DB2_9
```
public static final SQLDialect DB2_9
```
    The IBM DB2 9.x dialect.
    This dialect is available in commercial jOOQ distributions, only.
  - DB2_10
```
public static final SQLDialect DB2_10
```
    The IBM DB2 10.x dialect.
    This dialect is available in commercial jOOQ distributions, only.
  - DB2_11
```
public static final SQLDialect DB2_11
```
    The IBM DB2 11.x dialect.
    This dialect is available in commercial jOOQ distributions, only.
  - HANA
```
public static final SQLDialect HANA
```
    The SAP HANA dialect.
    This dialect is available in commercial jOOQ distributions, only.
  - INFORMIX
```
public static final SQLDialect INFORMIX
```
    The Informix dialect.
    This dialect is available in commercial jOOQ distributions, only.
  - INGRES
```
public static final SQLDialect INGRES
```
    The Ingres dialect family.
    This dialect is available in commercial jOOQ distributions, only.
  - ORACLE
```
public static final SQLDialect ORACLE
```
    The Oracle dialect family.
    This dialect is available in commercial jOOQ distributions, only.
  - ORACLE10G
```
public static final SQLDialect ORACLE10G
```
    The Oracle 10g dialect.
    This dialect is available in commercial jOOQ distributions, only.
  - ORACLE11G
```
public static final SQLDialect ORACLE11G
```
    The Oracle 11g dialect.
    This dialect is available in commercial jOOQ distributions, only.
  - ORACLE12C
```
public static final SQLDialect ORACLE12C
```
    The Oracle 12c dialect.
    This dialect is available in commercial jOOQ distributions, only.
  - POSTGRESPLUS
```
@Deprecated
public static final SQLDialect POSTGRESPLUS
```
    Deprecated. - This dialect is not yet supported by jOOQ.
    
    The Postgres Plus dialect family.
    This dialect is available in commercial jOOQ distributions, only.
  - REDSHIFT
```
public static final SQLDialect REDSHIFT
```
    The Amazon Redshift dialect.
    This dialect is available in commercial jOOQ distributions, only.
  - SQLSERVER
```
public static final SQLDialect SQLSERVER
```
    The SQL Server dialect family.
    Use this family (or its dialects) for SQL Server or Azure SQL Database.
    This dialect is available in commercial jOOQ distributions, only.
  - SQLSERVER2008
```
public static final SQLDialect SQLSERVER2008
```
    The SQL Server 2008 dialect.
    Use this family (or its dialects) for SQL Server or Azure SQL Database.
    This dialect is available in commercial jOOQ distributions, only.
  - SQLSERVER2012
```
public static final SQLDialect SQLSERVER2012
```
    The SQL Server 2012 dialect.
    Use this family (or its dialects) for SQL Server or Azure SQL Database.
    This dialect is available in commercial jOOQ distributions, only.
  - SQLSERVER2014
```
public static final SQLDialect SQLSERVER2014
```
    The SQL Server 2014 dialect.
    Use this family (or its dialects) for SQL Server or Azure SQL Database.
    This dialect is available in commercial jOOQ distributions, only.
  - SQLSERVER2016
```
public static final SQLDialect SQLSERVER2016
```
    The SQL Server 2016 dialect.
    Use this family (or its dialects) for SQL Server or Azure SQL Database.
    This dialect is available in commercial jOOQ distributions, only.
  - SQLSERVER2017
```
public static final SQLDialect SQLSERVER2017
```
    The SQL Server 2016 dialect.
    Use this family (or its dialects) for SQL Server or Azure SQL Database.
    This dialect is available in commercial jOOQ distributions, only.
  - SQLDATAWAREHOUSE
```
public static final SQLDialect SQLDATAWAREHOUSE
```
    The SQL Data Warehouse family.
    This dialect is available in commercial jOOQ distributions, only.
  - SYBASE
```
public static final SQLDialect SYBASE
```
    The Sybase SQL Anywhere dialect family.
    This dialect is available in commercial jOOQ distributions, only.
  - TERADATA
```
public static final SQLDialect TERADATA
```
    The Teradata dialect family.
    This dialect is available in commercial jOOQ distributions, only.
  - VERTICA
```
public static final SQLDialect VERTICA
```
    The Vertica dialect family.
    This dialect is available in commercial jOOQ distributions, only.
- Method Detail
  - values
```
public static SQLDialect[] values()
```
    Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:
```
for (SQLDialect c : SQLDialect.values())
    System.out.println(c);
```
    Returns:
    
    an array containing the constants of this enum type, in the order they are declared
  - valueOf
```
public static SQLDialect valueOf(String name)
```
    Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)
    
    Parameters:
    
    name - the name of the enum constant to be returned.
    
    Returns:
    
    the enum constant with the specified name
    
    Throws:
    
    IllegalArgumentException - if this enum type has no constant with the specified name
    
    NullPointerException - if the argument is null
  - commercial
```
public final boolean commercial()
```
    Whether this dialect is supported with the jOOQ commercial license only.
  - family
```
public final SQLDialect family()
```
    The dialect family.
    This returns the dialect itself, if it has no "parent family". E.g.
```
 SQLSERVER == SQLSERVER2012.family();
 SQLSERVER == SQLSERVER2008.family();
 SQLSERVER == SQLSERVER.family();
 
```
  - isFamily
```
public final boolean isFamily()
```
    Whether this dialect is a family().
  - predecessor
```
public final SQLDialect predecessor()
```
    The predecessor dialect.
    If this is a dialect version (e.g. POSTGRES_9_4) within a family (e.g. POSTGRES), then the predecessor will point to the historically previous dialect version (e.g. POSTGRES_9_3) within the same family, or to the dialect itself if there was no predecessor explicitly supported by jOOQ.
  - precedes
```
public final boolean precedes(SQLDialect other)
```
    Whether this dialect precedes an other dialect from the same family.
    This returns:
    - true if this dialect is the same as the other dialect
    - true if this dialect precedes the other dialect via any number of calls to predecessor()
    The above also implies that:
    - false if the two dialects do not belong to the same family
    This is useful to see if some feature is supported by "at least" a given dialect version. Example:
```
 // Do this block only if the chosen dialect supports PostgreSQL 9.4+ features
 if (POSTGRES_9_4.precedes(dialect)) {
 }

 // Do this block only if the chosen dialect supports PostgreSQL 9.3+ features
 else if (POSTGRES_9_3.precedes(dialect)) {
 }

 // Fall back to pre-PostgreSQL 9.3 behaviour
 else {
 }
 
```
  - supports
```
public final boolean supports(SQLDialect other)
```
    Check whether this dialect supports another one.
    This is:
    - false if dialects don't belong to the same family
    - true if either dialect isFamily()
    - true if other dialect precedes this dialect
    The other argument dialect is typically referenced from a Support annotation, whereas this dialect is the user dialect.
  - getName
```
public final String getName()
```
    The name of this dialect as it appears in related class names.
  - getNameLC
```
public final String getNameLC()
```
    The name of this dialect as it appears in related package names.
  - getNameUC
```
public final String getNameUC()
```
    The name of this dialect as it appears in related enum values.
  - families
```
public static final SQLDialect[] families()
```
    Get a list of all family() values.
  - thirdParty
```
public final SQLDialect.ThirdParty thirdParty()
```
    Get access to third party representations of this SQLDialect.

Enum SQLDialect

Nested Class Summary

Enum Constant Summary

Method Summary

Methods inherited from class java.lang.Enum

Methods inherited from class java.lang.Object

Enum Constant Detail

SQL99

DEFAULT

CUBRID

DERBY

FIREBIRD

FIREBIRD_2_5

FIREBIRD_3_0

H2

HSQLDB

MARIADB

MYSQL

MYSQL_5_7

MYSQL_8_0

POSTGRES

POSTGRES_9_3

POSTGRES_9_4

POSTGRES_9_5

POSTGRES_10

SQLITE

ACCESS

ACCESS2013

ASE

AURORA_MYSQL

AURORA_POSTGRES

DB2

DB2_9

DB2_10

DB2_11

HANA

INFORMIX

INGRES

ORACLE

ORACLE10G

ORACLE11G

ORACLE12C

POSTGRESPLUS

REDSHIFT

SQLSERVER

SQLSERVER2008

SQLSERVER2012

SQLSERVER2014

SQLSERVER2016

SQLSERVER2017

SQLDATAWAREHOUSE

SYBASE

TERADATA

VERTICA

Method Detail

values

valueOf

commercial

family

isFamily

predecessor

precedes

supports

getName

getNameLC

getNameUC

families

thirdParty