SQLDialect (jOOQ 3.3.1 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 SQLSERVER is specialised by its dialects
- SQLSERVER2008
- SQLSERVER2012
Author:

Lukas Eder

Enum Constant Summary

Enum Constants
Enum Constant and Description
`ACCESS` The MS Access SQL dialect family.
`ACCESS2013` The MS Access 2013 SQL dialect.
`ASE` The Sybase Adaptive Server SQL dialect family.
`CUBRID` The CUBRID SQL dialect family.
`DB2` The IBM DB2 SQL dialect family.
`DB2_10` The IBM DB2 10.x SQL dialect.
`DB2_9` The IBM DB2 9.x 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.
`INGRES` The Ingres dialect family.
`MARIADB` The MariaDB dialect family.
`MYSQL` The MySQL dialect family.
`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.
`SQL99` Deprecated. - Do not reference this pseudo-dialect. It is only used for unit testing
`SQLITE` The SQLite dialect family.
`SQLSERVER` The SQL Server dialect family.
`SQLSERVER2008` The SQL Server 2008 dialect.
`SQLSERVER2012` The SQL Server 2012 dialect.
`SYBASE` The Sybase SQL Anywhere dialect family.

Method Summary

Methods
Modifier and Type	Method and Description
`boolean`	`commercial()` Whether this dialect is supported with the jOOQ commercial license only.
`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.
`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. - Do not reference this pseudo-dialect. It is only used for unit testing
    
    The standard SQL dialect family.
  - 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.
  - SQLITE
```
public static final SQLDialect SQLITE
```
    The SQLite dialect family.
  - ACCESS
```
public static final SQLDialect ACCESS
```
    The MS Access SQL dialect family.
    This dialect is available in commercial jOOQ distributions, only.
  - ACCESS2013
```
public static final SQLDialect ACCESS2013
```
    The MS Access 2013 SQL dialect.
    This dialect is available in commercial jOOQ distributions, only.
  - ASE
```
public static final SQLDialect ASE
```
    The Sybase Adaptive Server SQL dialect family.
    This dialect is available in commercial jOOQ distributions, only.
  - DB2
```
public static final SQLDialect DB2
```
    The IBM DB2 SQL dialect family.
    This dialect is available in commercial jOOQ distributions, only.
  - DB2_9
```
public static final SQLDialect DB2_9
```
    The IBM DB2 9.x SQL dialect.
    This dialect is available in commercial jOOQ distributions, only.
  - DB2_10
```
public static final SQLDialect DB2_10
```
    The IBM DB2 10.x SQL 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.
  - SQLSERVER
```
public static final SQLDialect SQLSERVER
```
    The SQL Server dialect family.
    This dialect is available in commercial jOOQ distributions, only.
  - SQLSERVER2008
```
public static final SQLDialect SQLSERVER2008
```
    The SQL Server 2008 dialect.
    This dialect is available in commercial jOOQ distributions, only.
  - SQLSERVER2012
```
public static final SQLDialect SQLSERVER2012
```
    The SQL Server 2012 dialect.
    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.
- 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();
 
```
  - 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.

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

CUBRID

DERBY

FIREBIRD

H2

HSQLDB

MARIADB

MYSQL

POSTGRES

SQLITE

ACCESS

ACCESS2013

ASE

DB2

DB2_9

DB2_10

INGRES

ORACLE

ORACLE10G

ORACLE11G

ORACLE12C

SQLSERVER

SQLSERVER2008

SQLSERVER2012

SYBASE

Method Detail

values

valueOf

commercial

family

getName

getNameLC

getNameUC