org.jooq

Enum SQLDialect

java.lang.Object

java.lang.Enum<SQLDialect>

org.jooq.SQLDialect

All Implemented Interfaces:

java.io.Serializable, java.lang.Comparable<SQLDialect>

public enum SQLDialect
extends java.lang.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
CUBRID The CUBRID SQL dialect family.
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.
SQL99 Deprecated. - Do not reference this pseudo-dialect. It is only used for unit testing
SQLITE The SQLite dialect family.

Method Summary

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.
java.lang.String	getName() The name of this dialect as it appears in related class names.
java.lang.String	getNameLC() The name of this dialect as it appears in related package names.
java.lang.String	getNameUC() The name of this dialect as it appears in related enum values.
static SQLDialect	valueOf(java.lang.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.

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(java.lang.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:

java.lang.IllegalArgumentException - if this enum type has no constant with the specified name

java.lang.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 java.lang.String getName()

The name of this dialect as it appears in related class names.

getNameLC

public final java.lang.String getNameLC()

The name of this dialect as it appears in related package names.

getNameUC

public final java.lang.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.