SQLDialect (jOOQ 3.6.4 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

Enum Constant Summary

Enum Constants
Enum Constant and Description
`CUBRID` The CUBRID SQL dialect family.
`DEFAULT` The default SQL dialect.
`DERBY` The Apache Derby SQL dialect family.
`FIREBIRD` The Firebird SQL dialect family.
`H2` The H2 SQL dialect family.
`HSQLDB` The Hypersonic SQL dialect family.
`MARIADB` The MariaDB dialect family.
`MYSQL` The MySQL dialect family.
`POSTGRES` The PostgreSQL dialect family.
`POSTGRES_9_3` The PostgreSQL dialect family.
`POSTGRES_9_4` The PostgreSQL dialect family.
`SQL99` Deprecated. - [#3844] - 3.6.0 - `DEFAULT` will replace this pseudo-dialect.
`SQLITE` The SQLite 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`	`precedes(SQLDialect other)` Whether this dialect precedes an other dialect from the same family.
`SQLDialect`	`predecessor()` The predecessor dialect.
`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 SQL dialect family.
  - DERBY
```
public static final SQLDialect DERBY
```
    The Apache Derby SQL dialect family.
  - FIREBIRD
```
public static final SQLDialect FIREBIRD
```
    The Firebird SQL dialect family.
  - H2
```
public static final SQLDialect H2
```
    The H2 SQL dialect family.
  - HSQLDB
```
public static final SQLDialect HSQLDB
```
    The Hypersonic SQL dialect family.
  - MARIADB
```
public static final SQLDialect MARIADB
```
    The MariaDB dialect family.
  - MYSQL
```
public static final SQLDialect MYSQL
```
    The MySQL dialect family.
  - POSTGRES
```
public static final SQLDialect POSTGRES
```
    The PostgreSQL dialect family.
  - POSTGRES_9_3
```
public static final SQLDialect POSTGRES_9_3
```
    The PostgreSQL dialect family.
  - POSTGRES_9_4
```
public static final SQLDialect POSTGRES_9_4
```
    The PostgreSQL dialect family.
  - SQLITE
```
public static final SQLDialect SQLITE
```
    The SQLite dialect family.
- 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();
 
```
  - 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 {
 }
 
```
  - 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.

Enum SQLDialect

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

H2

HSQLDB

MARIADB

MYSQL

POSTGRES

POSTGRES_9_3

POSTGRES_9_4

SQLITE

Method Detail

values

valueOf

commercial

family

predecessor

precedes

getName

getNameLC

getNameUC

families