Integrating and Configuring Hibernate - Beginning Hibernate: From Novice to Professional - page 25

Database Name Dialect Class Name

Oracle9 i

Oracle9Dialect

DataDirectOracle9Dialect

Oracle9 i (DataDirect drivers)

Oracle (< 9.x)

OracleDialect

PointbaseDialect PointBase

PostgreSQL

PostgreSQLDialect

ProgressDialect Progress

RDMS for Unisys OS2200

RDMSOS2200Dialect

SAPDBDialect SAP DB

SQL Server

SQLServerDialect

SybaseDialect Sybase

Sybase 11

Sybase11Dialect

SybaseAnywhereDialect

Sybase Anywhere

Times Ten 5.1

TimesTenDialect

Configure your chosen dialect by supplying the fully qualified dialect class name as the
value for the hibernate.dialect configuration property.
Through Hibernate Query Language (HQL), Hibernate provides object-querying function-
ality that is database-independent. Hibernate translates the HQL queries into database-specific
SQL using hints provided by the SQL dialect classes. We discuss HQL in more detail in Chapter 9.
Hibernate also provides a native SQL facility, which is especially useful for porting exist-
ing JDBC applications to Hibernate or for improving the performance of complicated queries.

Summary
In this chapter, we explained how to integrate Hibernate into your Java applications. We also
detailed the configuration options for Hibernate, including the available Hibernate property
settings. We discussed how naming strategies aid in the creation of consistent company- or
application-wide database table-naming conventions, and how they help you to map your
Hibernate classes to databases with existing naming conventions. Finally, we discussed how
Hibernate uses dialects to manage the different behaviors of different database platforms.
In the next chapter, we build and configure a pair of simple Hibernate applications that
illustrate the core Hibernate concepts discussed in the first two chapters.