Skip to Main Content
Hibernate: A Developer's Notebook
book

Hibernate: A Developer's Notebook

by James Elliott
May 2004
Intermediate to advanced content levelIntermediate to advanced
192 pages
4h 46m
English
O'Reilly Media, Inc.
Content preview from Hibernate: A Developer's Notebook

C.1. Getting Fluent in the Local SQL

Hibernate ships with detailed support for many commercial and free relational databases. While most features will work properly without doing so, it's important to set the hibernate.dialect configuration property to the right subclass of net.sf.hibernate.dialect.Dialect, especially if you want to use features like native or sequence primary key generation or session locking. Choosing a dialect is also a very convenient way of setting up a whole raft of Hibernate configuration parameters you'd otherwise have to deal with individually.

Database systemAppropriate hibernate.dialect setting
DB2net.sf.hibernate.dialect.DB2Dialect
FrontBasenet.sf.hibernate.dialect.FrontbaseDialect
HSQLDBnet.sf.hibernate.dialect.HSQLDialect
Informixnet.sf.hibernate.dialect.InformixDialect
Ingresnet.sf.hibernate.dialect.IngresDialect
Interbasenet.sf.hibernate.dialect.InterbaseDialect
Mckoi SQLnet.sf.hibernate.dialect.MckoiDialect
Microsoft SQL Servernet.sf.hibernate.dialect.SQLServerDialect
MySQLnet.sf.hibernate.dialect.MySQLDialect
Oracle (any version)net.sf.hibernate.dialect.OracleDialect
Oracle 9 (specifically)net.sf.hibernate.dialect.Oracle9Dialect
Pointbasenet.sf.hibernate.dialect.PointbaseDialect
PostgreSQLnet.sf.hibernate.dialect.PostgreSQLDialect
Progressnet.sf.hibernate.dialect.ProgressDialect
SAP DBnet.sf.hibernate.dialect.SAPDBDialect
Sybasenet.sf.hibernate.dialect.SybaseDialect
Sybase Anywherenet.sf.hibernate.dialect.SybaseAnywhereDialect

If you don't see your target database ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Getting Started with Hibernate 3

Getting Started with Hibernate 3

James Elliott

Publisher Resources

ISBN: 0596006969Supplemental ContentCatalog PageErrata