com.github.drinkjava2.jdialects

Enum Dialect

java.lang.Object

java.lang.Enum<Dialect>

com.github.drinkjava2.jdialects.Dialect

All Implemented Interfaces:

Serializable, Comparable<Dialect>

public enum Dialect
extends Enum<Dialect>

jDialects is a small Java project collect all databases' dialect, most are extracted from Hibernate, usually jDialects is used for build pagination SQL and DDL SQL for cross-databases purpose. Currently jDialects support 75 database dialects include SQLLite and Access. It requires JDK1.7 or above.
Note: most of this "Dialect.java" file is generated by source code generator tool(see jDiagen project), and also there is a Excel file "DatabaseDialects.xls", it's useful if you want know difference of databases.

 How to Use jDialect in project? 
 Download and put "jdialects-1.0.0.jar" in project class folder, or add below lines in pom.xml:
   
      com.github.drinkjava2
      jdialects
     1.0.0
   
  
 In source code:
 1) Build pagination SQL    
    Dialect d=guessDialect(dataSource);
    String result=dialect.paginate(3, 10, "select * from users where id=?");
    
    in MySQL5Dialect,    result is: "select * from users  where id=? limit 20, 10"
    in Oracle8iDialect,  result is: "select * from ( select row_.*, rownum rownum_ from ( select * from users  where id=? ) row_ ) where rownum_ <= 30 and rownum_ > 20"
    in Oracle12cDialect, result is: "select * from users  where id=? offset 20 rows fetch next 10 rows only"
    in Sybase11Dialect, throw a DialectExcepiton with message: "Sybase11Dialect" does not support physical pagination
    ...
    
 2) Build cross-database DDL SQL:       
      Dialect d=guessDialect(dataSource);
                String ddlSql = "create table test("//
                                + "f1 " + d.BIGINT() //
                                + ",f3 " + d.BIT() //
                                + ",f4 " + d.BLOB() //
                                + ",f5 " + d.BOOLEAN() //
                                + ",f6 " + d.CHAR() //
                                + ")" + d.ENGINE();
    if MySql5Dialect, ddlSql will be "create table test(f1 bigint,f3 bit,f4 longblob,f5 bit,f6 char(1))engine=innoDB"
    in SQLServer2012Dialect, will get "create table test(f1 int8,f3 bool,f4 oid,f5 boolean,f6 char(1))"
 
 

Since:

JDK1.7

Version:

1.0.0

Author:

Yong Zhu

Enum Constant Summary

Enum Constants

Enum Constant and Description
AccessDialect
Cache71Dialect
CobolDialect
CUBRIDDialect
DataDirectOracle9Dialect
DB2390Dialect
DB2400Dialect
DB2Dialect
DbfDialect
DerbyDialect Deprecated.
DerbyTenFiveDialect
DerbyTenSevenDialect
DerbyTenSixDialect
ExcelDialect
FirebirdDialect
FrontBaseDialect
H2Dialect
HANAColumnStoreDialect
HANARowStoreDialect
HSQLDialect
Informix10Dialect
InformixDialect
Ingres10Dialect
Ingres9Dialect
IngresDialect
InterbaseDialect
JDataStoreDialect
MariaDB53Dialect
MariaDBDialect
MckoiDialect
MimerSQLDialect
MySQL55Dialect
MySQL57Dialect
MySQL57InnoDBDialect
MySQL5Dialect
MySQL5InnoDBDialect
MySQLDialect
MySQLInnoDBDialect
MySQLMyISAMDialect
Oracle10gDialect
Oracle12cDialect
Oracle8iDialect
Oracle9Dialect Deprecated.
Oracle9iDialect
OracleDialect Deprecated.
ParadoxDialect
PointbaseDialect
PostgresPlusDialect
PostgreSQL81Dialect
PostgreSQL82Dialect
PostgreSQL91Dialect
PostgreSQL92Dialect
PostgreSQL93Dialect
PostgreSQL94Dialect
PostgreSQL95Dialect
PostgreSQL9Dialect
PostgreSQLDialect
ProgressDialect
RDMSOS2200Dialect
SAPDBDialect
SQLiteDialect
SQLServer2005Dialect
SQLServer2008Dialect
SQLServer2012Dialect
SQLServerDialect
Sybase11Dialect
SybaseAnywhereDialect
SybaseASE157Dialect
SybaseASE15Dialect
SybaseDialect
Teradata14Dialect
TeradataDialect
TextDialect
TimesTenDialect
XMLDialect

Field Summary

Fields

Modifier and Type	Field and Description
static String	NOT_SUPPORT

Method Summary

Methods

Modifier and Type	Method and Description
String	BIGINT(int... lengths)
String	BINARY(int... lengths)
String	BIT(int... lengths)
String	BLOB(int... lengths)
String	BOOLEAN(int... lengths)
String	CHAR(int... lengths)
String	CLOB(int... lengths)
String	DATE(int... lengths)
String	DECIMAL(int... lengths)
String	DOUBLE(int... lengths)
String	ENGINE(int... lengths)
String	FLOAT(int... lengths)
static Dialect	guessDialect(Connection jdbcConnection) Guess dialect based on given JDBC connection instance, Note: this method does not close connection
static Dialect	guessDialect(DataSource datasource) Guess dialect based on given JDBC connection instance, Note: this method does not close connection
static Dialect	guessDialect(String databaseName, Object... majorVersionMinorVersion) Guess Dialect by give databaseName, MajorVersion, majorVersion
String	INTEGER(int... lengths)
String	JAVA_OBJECT(int... lengths)
String	LONGNVARCHAR(int... lengths)
String	LONGVARBINARY(int... lengths)
String	LONGVARCHAR(int... lengths)
String	NCHAR(int... lengths)
String	NCLOB(int... lengths)
String	NUMERIC(int... lengths)
String	NVARCHAR(int... lengths)
String	OTHER(int... lengths)
String	paginate(int pageNumber, int pageSize, String sql) Create a pagination SQL by given pageNumber, pageSize and SQL
String	REAL(int... lengths)
String	SMALLINT(int... lengths)
String	TIME(int... lengths)
String	TIMESTAMP(int... lengths)
String	TINYINT(int... lengths)
static Dialect	valueOf(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.
String	VARBINARY(int... lengths)
String	VARCHAR(int... lengths)

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

SQLiteDialect

public static final Dialect SQLiteDialect

AccessDialect

public static final Dialect AccessDialect

ExcelDialect

public static final Dialect ExcelDialect

TextDialect

public static final Dialect TextDialect

ParadoxDialect

public static final Dialect ParadoxDialect

CobolDialect

public static final Dialect CobolDialect

XMLDialect

public static final Dialect XMLDialect

DbfDialect

public static final Dialect DbfDialect

DerbyDialect

@Deprecated
public static final Dialect DerbyDialect

Deprecated.

OracleDialect

@Deprecated
public static final Dialect OracleDialect

Deprecated.

Oracle9Dialect

@Deprecated
public static final Dialect Oracle9Dialect

Deprecated.

Cache71Dialect

public static final Dialect Cache71Dialect

CUBRIDDialect

public static final Dialect CUBRIDDialect

DerbyTenFiveDialect

public static final Dialect DerbyTenFiveDialect

DataDirectOracle9Dialect

public static final Dialect DataDirectOracle9Dialect

DB2Dialect

public static final Dialect DB2Dialect

DB2390Dialect

public static final Dialect DB2390Dialect

DB2400Dialect

public static final Dialect DB2400Dialect

DerbyTenSevenDialect

public static final Dialect DerbyTenSevenDialect

DerbyTenSixDialect

public static final Dialect DerbyTenSixDialect

FirebirdDialect

public static final Dialect FirebirdDialect

FrontBaseDialect

public static final Dialect FrontBaseDialect

H2Dialect

public static final Dialect H2Dialect

HANAColumnStoreDialect

public static final Dialect HANAColumnStoreDialect

HANARowStoreDialect

public static final Dialect HANARowStoreDialect

HSQLDialect

public static final Dialect HSQLDialect

InformixDialect

public static final Dialect InformixDialect

Informix10Dialect

public static final Dialect Informix10Dialect

IngresDialect

public static final Dialect IngresDialect

Ingres10Dialect

public static final Dialect Ingres10Dialect

Ingres9Dialect

public static final Dialect Ingres9Dialect

InterbaseDialect

public static final Dialect InterbaseDialect

JDataStoreDialect

public static final Dialect JDataStoreDialect

MariaDBDialect

public static final Dialect MariaDBDialect

MariaDB53Dialect

public static final Dialect MariaDB53Dialect

MckoiDialect

public static final Dialect MckoiDialect

MimerSQLDialect

public static final Dialect MimerSQLDialect

MySQLDialect

public static final Dialect MySQLDialect

MySQL5Dialect

public static final Dialect MySQL5Dialect

MySQL55Dialect

public static final Dialect MySQL55Dialect

MySQL57Dialect

public static final Dialect MySQL57Dialect

MySQL57InnoDBDialect

public static final Dialect MySQL57InnoDBDialect

MySQL5InnoDBDialect

public static final Dialect MySQL5InnoDBDialect

MySQLInnoDBDialect

public static final Dialect MySQLInnoDBDialect

MySQLMyISAMDialect

public static final Dialect MySQLMyISAMDialect

Oracle8iDialect

public static final Dialect Oracle8iDialect

Oracle9iDialect

public static final Dialect Oracle9iDialect

Oracle10gDialect

public static final Dialect Oracle10gDialect

Oracle12cDialect

public static final Dialect Oracle12cDialect

PointbaseDialect

public static final Dialect PointbaseDialect

PostgresPlusDialect

public static final Dialect PostgresPlusDialect

PostgreSQLDialect

public static final Dialect PostgreSQLDialect

PostgreSQL81Dialect

public static final Dialect PostgreSQL81Dialect

PostgreSQL82Dialect

public static final Dialect PostgreSQL82Dialect

PostgreSQL9Dialect

public static final Dialect PostgreSQL9Dialect

PostgreSQL91Dialect

public static final Dialect PostgreSQL91Dialect

PostgreSQL92Dialect

public static final Dialect PostgreSQL92Dialect

PostgreSQL93Dialect

public static final Dialect PostgreSQL93Dialect

PostgreSQL94Dialect

public static final Dialect PostgreSQL94Dialect

PostgreSQL95Dialect

public static final Dialect PostgreSQL95Dialect

ProgressDialect

public static final Dialect ProgressDialect

RDMSOS2200Dialect

public static final Dialect RDMSOS2200Dialect

SAPDBDialect

public static final Dialect SAPDBDialect

SQLServerDialect

public static final Dialect SQLServerDialect

SQLServer2005Dialect

public static final Dialect SQLServer2005Dialect

SQLServer2008Dialect

public static final Dialect SQLServer2008Dialect

SQLServer2012Dialect

public static final Dialect SQLServer2012Dialect

SybaseDialect

public static final Dialect SybaseDialect

Sybase11Dialect

public static final Dialect Sybase11Dialect

SybaseAnywhereDialect

public static final Dialect SybaseAnywhereDialect

SybaseASE15Dialect

public static final Dialect SybaseASE15Dialect

SybaseASE157Dialect

public static final Dialect SybaseASE157Dialect

TeradataDialect

public static final Dialect TeradataDialect

Teradata14Dialect

public static final Dialect Teradata14Dialect

TimesTenDialect

public static final Dialect TimesTenDialect

Field Detail

NOT_SUPPORT

public static final String NOT_SUPPORT

See Also:

Constant Field Values

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

BIGINT

public String BIGINT(int... lengths)

BINARY

public String BINARY(int... lengths)

BIT

public String BIT(int... lengths)

BLOB

public String BLOB(int... lengths)

BOOLEAN

public String BOOLEAN(int... lengths)

CHAR

public String CHAR(int... lengths)

CLOB

public String CLOB(int... lengths)

DATE

public String DATE(int... lengths)

DECIMAL

public String DECIMAL(int... lengths)

DOUBLE

public String DOUBLE(int... lengths)

FLOAT

public String FLOAT(int... lengths)

INTEGER

public String INTEGER(int... lengths)

JAVA_OBJECT

public String JAVA_OBJECT(int... lengths)

LONGNVARCHAR

public String LONGNVARCHAR(int... lengths)

LONGVARBINARY

public String LONGVARBINARY(int... lengths)

LONGVARCHAR

public String LONGVARCHAR(int... lengths)

NCHAR

public String NCHAR(int... lengths)

NCLOB

public String NCLOB(int... lengths)

NUMERIC

public String NUMERIC(int... lengths)

NVARCHAR

public String NVARCHAR(int... lengths)

OTHER

public String OTHER(int... lengths)

REAL

public String REAL(int... lengths)

SMALLINT

public String SMALLINT(int... lengths)

TIME

public String TIME(int... lengths)

TIMESTAMP

public String TIMESTAMP(int... lengths)

TINYINT

public String TINYINT(int... lengths)

VARBINARY

public String VARBINARY(int... lengths)

VARCHAR

public String VARCHAR(int... lengths)

ENGINE

public String ENGINE(int... lengths)

guessDialect

public static Dialect guessDialect(DataSource datasource)

Guess dialect based on given JDBC connection instance, Note: this method does not close connection

Parameters:

jdbcConnection -

Returns:

dialect or null if not found

guessDialect

public static Dialect guessDialect(Connection jdbcConnection)

Guess dialect based on given JDBC connection instance, Note: this method does not close connection

Parameters:

jdbcConnection -

Returns:

dialect or null if not found

guessDialect

public static Dialect guessDialect(String databaseName,
                   Object... majorVersionMinorVersion)

Guess Dialect by give databaseName, MajorVersion, majorVersion

Parameters:

databaseName - database name

majorVersion - major version, Optional

minorVersion - minor version, Optional

Returns:

dialect or null if not found

paginate

public String paginate(int pageNumber,
              int pageSize,
              String sql)

Create a pagination SQL by given pageNumber, pageSize and SQL

Parameters:

pageNumber - started from 0

pageSize - page size

sql - the original sql

Returns:

the pagination SQL String