The CUBRID dialect family.

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.

The Apache Derby dialect family.

The Firebird dialect family.

This family behaves like the versioned dialect FIREBIRD_3_0.

The H2 dialect family.

The Hypersonic dialect family.

The Apache Ignite dialect family.

The MariaDB dialect family.

This family behaves like the versioned dialect MARIADB_10_5.

The MySQL dialect family.

This family behaves like the versioned dialect MYSQL_8_0_31.

The PostgreSQL dialect family.

This family behaves like the versioned dialect POSTGRES_15.

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.

The SQLite dialect family.

This family behaves like the versioned dialect SQLITE_3_39.

The YugabyteDB dialect family.

The dialect category.

Annotations

@NotNull

Whether this dialect is supported with the jOOQ commercial license only.

Get a list of all SQLDialect#family() values.

Annotations

@NotNull

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();

Annotations

@NotNull

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

Annotations

@NotNull

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

Annotations

@NotNull

The name of this dialect as it appears in related enum values.

Annotations

@NotNull

Whether this dialect is a family().

Whether this dialect is a versioned dialect or a family with versioned dialects.

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()

• 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 {
}

Whether this dialect strictly precedes an other dialect from the same family.

This returns:

• false 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()

• 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 was before PostgreSQL 9.3-
if (dialect.precedesStrictly(POSTGRES)) {
}

// Do this block only if the chosen dialect was before PostgreSQL 9.4-
else if (dialect.precedesStrictly(POSTGRES)) {
}

// Fall back to post-PostgreSQL 9.4+ behaviour
else {
}

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.

Annotations

@NotNull

Get a set of dialects preceding a given set of dialects.

The resulting set of dialects contain all the families and dialect versions that precede the argument dialects, including the argument dialects.

Annotations

@NotNull

The predecessor dialects.

Recursively calls predecessor() and finds all the preceding dialects to this one, including this one.

Annotations

@NotNull

Whether this dialect is supported by jOOQ as an output dialect.

Unsupported, non-output dialects include:

• DEFAULT: A hypothetical dialect used for QueryPart#toString() calls of unattached query parts.
• POSTGRESPLUS: A not yet supported dialect.

Get a set of supported dialect versions and successors given a dialect version.

The resulting set of dialects contain all the families and dialect versions that support the argument dialect, i.e. that succeed it, including the argument dialect.

Annotations

@NotNull

Get a set of supported dialect versions and successors given a set of dialect versions.

The resulting set of dialects contain all the families and dialect versions that support the argument dialects, i.e. that succeed them, including the argument dialects.

Annotations

@NotNull

Get a set of supported dialect versions and predecessors given a dialect version.

The resulting set of dialects contain all the families and dialect versions that precede the argument dialect, including the argument dialect.

Annotations

@NotNull

Get a set of supported dialect versions and predecessors given a dialect version.

The resulting set of dialects contain all the families and dialect versions that precede the argument dialect, including the argument dialects.

Annotations

@NotNull

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.

Check whether this dialect supports any dialect from the argument collection.

Annotations

@Deprecated

forRemoval:true

since:3.14

Check if this SQLDialect supports a JDBC DatabaseMetaData#getDatabaseMajorVersion(), DatabaseMetaData#getDatabaseMinorVersion(), patch version.

Get access to third party representations of this SQLDialect.

Annotations

@NotNull