Package org.hibernate.dialect

This package abstracts the SQL dialect of the underlying database.

See:
          Description

Interface Summary
DialectFactory.DatabaseDialectMapper For a given database product name, instances of DatabaseDialectMapper know which Dialect to use for different versions.
 

Class Summary
Cache71Dialect Caché 2007.1 dialect.
DataDirectOracle9Dialect  
DB2390Dialect An SQL dialect for DB2/390.
DB2400Dialect An SQL dialect for DB2/400.
DB2Dialect An SQL dialect for DB2.
DerbyDialect Hibernate Dialect for Cloudscape 10 - aka Derby.
DerbyDialect.DerbyTrimFunctionEmulation A specialized function template to emulate the ANSI trim function on Derby DB since it does not support the full trim specification.
Dialect Represents a dialect of SQL implemented by a particular RDBMS.
DialectFactory A factory for generating Dialect instances.
DialectFactory.VersionInsensitiveMapper A simple DatabaseDialectMapper for dialects which are independent of the underlying database product version.
FirebirdDialect An SQL dialect for Firebird.
FrontBaseDialect An SQL Dialect for Frontbase.
H2Dialect A dialect compatible with the H2 database.
HSQLDialect An SQL dialect compatible with HSQLDB (Hypersonic SQL).
HSQLDialect.ReadUncommittedLockingStrategy  
InformixDialect Informix dialect.

Seems to work with Informix Dynamic Server Version 7.31.UD3, Informix JDBC driver version 2.21JC3.
IngresDialect An Ingres SQL dialect.
InterbaseDialect An SQL dialect for Interbase.
JDataStoreDialect A Dialect for JDataStore.
MckoiDialect An SQL dialect compatible with McKoi SQL
MimerSQLDialect An Hibernate 3 SQL dialect for Mimer SQL.
MySQL5Dialect An SQL dialect for MySQL 5.x specific features.
MySQL5InnoDBDialect  
MySQLDialect An SQL dialect for MySQL (prior to 5.x).
MySQLInnoDBDialect  
MySQLMyISAMDialect  
Oracle10gDialect A dialect specifically for use with Oracle 10g.
Oracle8iDialect A dialect for Oracle 8i.
Oracle9Dialect Deprecated. Use either Oracle9iDialect or Oracle10gDialect instead
Oracle9iDialect A dialect for Oracle 9i databases.
OracleDialect Deprecated. Use Oracle8iDialect instead.
PointbaseDialect A Dialect for Pointbase.
PostgresPlusDialect An SQL dialect for Postgres Plus
PostgreSQLDialect An SQL dialect for Postgres
ProgressDialect An SQL dialect compatible with Progress 9.1C

Connection Parameters required: hibernate.dialect org.hibernate.sql.ProgressDialect hibernate.driver com.progress.sql.jdbc.JdbcProgressDriver hibernate.url jdbc:JdbcProgress:T:host:port:dbname;WorkArounds=536870912 hibernate.username username hibernate.password password The WorkArounds parameter in the URL is required to avoid an error in the Progress 9.1C JDBC driver related to PreparedStatements.
RDMSOS2200Dialect  
SAPDBDialect An SQL dialect compatible with SAP DB.
SQLServerDialect A dialect for Microsoft SQL Server 2000 and 2005
Sybase11Dialect A SQL dialect suitable for use with Sybase 11.9.2 (specifically: avoids ANSI JOIN syntax)
SybaseAnywhereDialect SQL Dialect for Sybase Anywhere extending Sybase (Enterprise) Dialect (Tested on ASA 8.x)
SybaseASE15Dialect An SQL dialect compatible with Sybase and MS SQL Server.
SybaseDialect Deprecated. SybaseASE15Dialect or SQLServerDialect should be used instead.
TeradataDialect A dialect for the Teradata database created by MCR as part of the dialect certification process.
TimesTenDialect A SQL dialect for TimesTen 5.1.
TypeNames This class maps a type to names.
 

Package org.hibernate.dialect Description

This package abstracts the SQL dialect of the underlying database.

A concrete Dialect may be specifed using hibernate.dialect.