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 system Appropriate hibernate.dialect setting
DB2 net.sf.hibernate.dialect.DB2Dialect
FrontBase net.sf.hibernate.dialect.FrontbaseDialect
HSQLDB net.sf.hibernate.dialect.HSQLDialect
Informix net.sf.hibernate.dialect.InformixDialect
Ingres net.sf.hibernate.dialect.IngresDialect
Interbase net.sf.hibernate.dialect.InterbaseDialect
Mckoi SQL net.sf.hibernate.dialect.MckoiDialect
Microsoft SQL Server net.sf.hibernate.dialect.SQLServerDialect
MySQL net.sf.hibernate.dialect.MySQLDialect
Oracle (any version) net.sf.hibernate.dialect.OracleDialect
Oracle 9 ( specifically ) net.sf.hibernate.dialect.Oracle9Dialect
Pointbase net.sf.hibernate.dialect.PointbaseDialect
PostgreSQL net.sf.hibernate.dialect.PostgreSQLDialect
Progress net.sf.hibernate.dialect.ProgressDialect
SAP DB net.sf.hibernate.dialect.SAPDBDialect
Sybase net.sf.hibernate.dialect.SybaseDialect
Sybase Anywhere net.sf.hibernate.dialect.SybaseAnywhereDialect

If you don't see your target database here, check whether support has been added to the latest Hibernate release. The dialects are listed in the 'SQL Dialects' section of the Hibernate reference documentation. If that doesn't pan out, see if you can find a third-party effort to support the database, or consider starting your own!

Hibernate. A Developer's Notebook
Hibernate: A Developers Notebook
ISBN: 0596006969
EAN: 2147483647
Year: 2003
Pages: 65
Authors: James Elliott

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net