io.micronaut.data.model.query.builder.sql

Enum Dialect

java.lang.Object

java.lang.Enum<Dialect>

io.micronaut.data.model.query.builder.sql.Dialect

All Implemented Interfaces:

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

public enum Dialect
extends java.lang.Enum<Dialect>

The SQL dialect to use.

Since:

1.0.0

Author:

graemerocher

Enum Constant Summary

Enum Constants

Enum Constant and Description
ANSI Ansi compliant SQL.
H2 H2 database.
MYSQL MySQL 5.5 or above.
ORACLE Oracle 12c or above.
POSTGRES Postgres 9.5 or later.
SQL_SERVER SQL server 2012 or above.

Method Summary

Modifier and Type	Method and Description
boolean	allowBatch() Some drivers and dialects do not support JDBC batching.
DataType	getDataType(DataType type) Returns compatible dialect dataype.
boolean	requiresStringUUID(DataType type) Determines whether the data type requires string based UUIDs.
boolean	supportsArrays() Some databases support arrays and the use of Connection.createArrayOf(String, Object[]).
static Dialect	valueOf(java.lang.String name) Returns the enum constant of this type with the specified name.
static Dialect[]	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

H2

public static final Dialect H2

H2 database.

MYSQL

public static final Dialect MYSQL

MySQL 5.5 or above.

POSTGRES

public static final Dialect POSTGRES

Postgres 9.5 or later.

SQL_SERVER

public static final Dialect SQL_SERVER

SQL server 2012 or above.

ORACLE

public static final Dialect ORACLE

Oracle 12c or above.

ANSI

public static final Dialect ANSI

Ansi compliant SQL.

Method Detail

values

public static Dialect[] 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 (Dialect c : Dialect.values())
    System.out.println(c);

Returns:

an array containing the constants of this enum type, in the order they are declared

valueOf

public static Dialect 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

allowBatch

public final boolean allowBatch()

Some drivers and dialects do not support JDBC batching. This allows customization.

Returns:

True if batch is supported.

supportsArrays

public final boolean supportsArrays()

Some databases support arrays and the use of Connection.createArrayOf(String, Object[]).

Returns:

True if arrays are supported.

getDataType

public final DataType getDataType(@NonNull
                                  DataType type)

Returns compatible dialect dataype.

Parameters:

type - the type

Returns:

The dialect compatible DataType

Since:

2.0.1

requiresStringUUID

public final boolean requiresStringUUID(@NonNull
                                        DataType type)

Determines whether the data type requires string based UUIDs.

Parameters:

type - the type

Returns:

True if a string UUID is required

Since:

1.1.3