com.univocity.api.entity.jdbc
Enum DatabaseDialect

java.lang.Object
  extended by java.lang.Enum<DatabaseDialect>
      extended by com.univocity.api.entity.jdbc.DatabaseDialect
All Implemented Interfaces:
Serializable, Comparable<DatabaseDialect>

public enum DatabaseDialect
extends Enum<DatabaseDialect>

Database dialects supported by uniVocity to produce table creation scripts from any data entity available in a DataIntegrationEngine.

Author:
uniVocity Software Pty Ltd - dev@univocity.com

Enum Constant Summary
Access
          Microsoft Access dialect
Cache71
          Caché 2007.1 dialect
Cloudscape_10
          Cloudscape 10 dialect
CUBRID
          CUBRID (8.3.x and later) dialect
DB2
          DB2 dialect
DB2_390
          DB2/390 dialect
DB2_400
          DB2/400 dialect
Derby
          Derby dialect (pre-10.7)
Derby_10_7
          Derby 10.7 dialect
Firebird
          Firebird dialect
FrontBase
          FrontBase dialect
H2
          H2 database dialect
HANAColumnStore
          SQL dialect for SAP HANA column tables
HANARowStore
          SQL dialect for SAP HANA row tables
HSQLDB
          HSQLDB (HyperSQL) dialect
HyperSQL
          HSQLDB (HyperSQL) dialect
Informix
          Informix Dynamic Server dialect
Ingres
          Ingres dialect (up to 9.2)
Ingres_10
          Ingres 10 dialect
Ingres_9
          Ingres 9.3 dialect
Interbase
          Interbase dialect
JDataStore
          JDataStore dialect
McKoi
          McKoi SQL dialect
MimerSQL
          Mimer SQL dialect
MySQL
          MySQL dialect for versions prior to 5.x
MySQL_5
          MySQL 5.x dialect
MySQL_5_InnoDB
          Dialect for MySQL 5 using InnoDB engine
MySQL_5_MyISAM
          Dialect for MySQL 5 using MyISAM engine
MySQL_InnoDB
          Dialect for MySQL using InnoDB engine (for versions prior to 5.x)
MySQL_MyISAM
          Dialect for MySQL using the MyISAM engine (for versions prior to 5.x)
Oracle_10g
          Dialect for Oracle 10g
Oracle_8i
          Dialect for Oracle 8i
Oracle_9i
          Dialect for Oracle 9i
Pointbase
          Pointbase dialect
PostgresPlus
          Postgres Plus dialect
PostgreSQL_8_1
          Postgres 8.1 dialect
PostgreSQL_8_2
          Postgres 8.2 dialect
PostgreSQL_9
          Postgres 9 dialect
Progress
          Progress dialect
RDMS_2200
          Unisys 2200 Relational Database (RDMS) dialect
SAPDB
          SAP DB dialect
SQLServer_2000
          Microsoft SQL 2000 dialect
SQLServer_2005
          Microsoft SQL 2005 dialect
SQLServer_2008
          Microsoft SQL 2008 dialect
SQLServer_2012
          Microsoft SQL 2012 dialect
Sybase
          Sybase dialect
Sybase_11
          Sybase 11.x dialect
Sybase_Anywhere
          Sybase Anywhere dialect
Sybase_ASE_15
          Sybase Adaptive Server Enterprise (ASE) 15 dialect
Sybase_ASE_15_7
          Sybase Adaptive Server Enterprise (ASE) 15.7 dialect
Teradata
          Teradata database dialect
TimesTen
          TimesTen dialect
Unisys_2200
          Unisys 2200 Relational Database (RDMS) dialect
 
Method Summary
static DatabaseDialect valueOf(String name)
          Returns the enum constant of this type with the specified name.
static DatabaseDialect[] 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

Access

public static final DatabaseDialect Access
Microsoft Access dialect


Cache71

public static final DatabaseDialect Cache71
Caché 2007.1 dialect


Cloudscape_10

public static final DatabaseDialect Cloudscape_10
Cloudscape 10 dialect


CUBRID

public static final DatabaseDialect CUBRID
CUBRID (8.3.x and later) dialect


DB2_390

public static final DatabaseDialect DB2_390
DB2/390 dialect


DB2_400

public static final DatabaseDialect DB2_400
DB2/400 dialect


DB2

public static final DatabaseDialect DB2
DB2 dialect


Derby

public static final DatabaseDialect Derby
Derby dialect (pre-10.7)


Derby_10_7

public static final DatabaseDialect Derby_10_7
Derby 10.7 dialect


Firebird

public static final DatabaseDialect Firebird
Firebird dialect


FrontBase

public static final DatabaseDialect FrontBase
FrontBase dialect


H2

public static final DatabaseDialect H2
H2 database dialect


HANAColumnStore

public static final DatabaseDialect HANAColumnStore
SQL dialect for SAP HANA column tables


HANARowStore

public static final DatabaseDialect HANARowStore
SQL dialect for SAP HANA row tables


HSQLDB

public static final DatabaseDialect HSQLDB
HSQLDB (HyperSQL) dialect


HyperSQL

public static final DatabaseDialect HyperSQL
HSQLDB (HyperSQL) dialect


Informix

public static final DatabaseDialect Informix
Informix Dynamic Server dialect


Ingres_10

public static final DatabaseDialect Ingres_10
Ingres 10 dialect


Ingres_9

public static final DatabaseDialect Ingres_9
Ingres 9.3 dialect


Ingres

public static final DatabaseDialect Ingres
Ingres dialect (up to 9.2)


Interbase

public static final DatabaseDialect Interbase
Interbase dialect


JDataStore

public static final DatabaseDialect JDataStore
JDataStore dialect


McKoi

public static final DatabaseDialect McKoi
McKoi SQL dialect


MimerSQL

public static final DatabaseDialect MimerSQL
Mimer SQL dialect


MySQL_5

public static final DatabaseDialect MySQL_5
MySQL 5.x dialect


MySQL_5_InnoDB

public static final DatabaseDialect MySQL_5_InnoDB
Dialect for MySQL 5 using InnoDB engine


MySQL_5_MyISAM

public static final DatabaseDialect MySQL_5_MyISAM
Dialect for MySQL 5 using MyISAM engine


MySQL

public static final DatabaseDialect MySQL
MySQL dialect for versions prior to 5.x


MySQL_InnoDB

public static final DatabaseDialect MySQL_InnoDB
Dialect for MySQL using InnoDB engine (for versions prior to 5.x)


MySQL_MyISAM

public static final DatabaseDialect MySQL_MyISAM
Dialect for MySQL using the MyISAM engine (for versions prior to 5.x)


Oracle_10g

public static final DatabaseDialect Oracle_10g
Dialect for Oracle 10g


Oracle_9i

public static final DatabaseDialect Oracle_9i
Dialect for Oracle 9i


Oracle_8i

public static final DatabaseDialect Oracle_8i
Dialect for Oracle 8i


Pointbase

public static final DatabaseDialect Pointbase
Pointbase dialect


PostgresPlus

public static final DatabaseDialect PostgresPlus
Postgres Plus dialect


PostgreSQL_9

public static final DatabaseDialect PostgreSQL_9
Postgres 9 dialect


PostgreSQL_8_2

public static final DatabaseDialect PostgreSQL_8_2
Postgres 8.2 dialect


PostgreSQL_8_1

public static final DatabaseDialect PostgreSQL_8_1
Postgres 8.1 dialect


Progress

public static final DatabaseDialect Progress
Progress dialect


RDMS_2200

public static final DatabaseDialect RDMS_2200
Unisys 2200 Relational Database (RDMS) dialect


SAPDB

public static final DatabaseDialect SAPDB
SAP DB dialect


SQLServer_2005

public static final DatabaseDialect SQLServer_2005
Microsoft SQL 2005 dialect


SQLServer_2008

public static final DatabaseDialect SQLServer_2008
Microsoft SQL 2008 dialect


SQLServer_2012

public static final DatabaseDialect SQLServer_2012
Microsoft SQL 2012 dialect


SQLServer_2000

public static final DatabaseDialect SQLServer_2000
Microsoft SQL 2000 dialect


Sybase_11

public static final DatabaseDialect Sybase_11
Sybase 11.x dialect


Sybase_Anywhere

public static final DatabaseDialect Sybase_Anywhere
Sybase Anywhere dialect


Sybase_ASE_15_7

public static final DatabaseDialect Sybase_ASE_15_7
Sybase Adaptive Server Enterprise (ASE) 15.7 dialect


Sybase_ASE_15

public static final DatabaseDialect Sybase_ASE_15
Sybase Adaptive Server Enterprise (ASE) 15 dialect


Sybase

public static final DatabaseDialect Sybase
Sybase dialect


Teradata

public static final DatabaseDialect Teradata
Teradata database dialect


TimesTen

public static final DatabaseDialect TimesTen
TimesTen dialect


Unisys_2200

public static final DatabaseDialect Unisys_2200
Unisys 2200 Relational Database (RDMS) dialect

Method Detail

values

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

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

valueOf

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


Copyright © 2015 uniVocity Software Pty Ltd. All rights reserved.