hibernate 配置参数详解
3.4.1. SQL方言

你应当总是为你的数据库将hibernate.dialect属性设置成正确的?org.hibernate.dialect.Dialect子类. 如果你指定一种方言, Hibernate将为上面列出的一些属性使用合理的默认值, 为你省去了手工指定它们的功夫.

表 3.8. Hibernate SQL方言 (hibernate.dialect)

RDBMS方言DB2org.hibernate.dialect.DB2DialectDB2 AS/400org.hibernate.dialect.DB2400DialectDB2 OS390org.hibernate.dialect.DB2390DialectPostgreSQLorg.hibernate.dialect.PostgreSQLDialectMySQLorg.hibernate.dialect.MySQLDialectMySQL with InnoDBorg.hibernate.dialect.MySQLInnoDBDialectMySQL with MyISAMorg.hibernate.dialect.MySQLMyISAMDialectOracle (any version)org.hibernate.dialect.OracleDialectOracle 9i/10gorg.hibernate.dialect.Oracle9DialectSybaseorg.hibernate.dialect.SybaseDialectSybase Anywhereorg.hibernate.dialect.SybaseAnywhereDialectMicrosoft SQL Serverorg.hibernate.dialect.SQLServerDialectSAP DBorg.hibernate.dialect.SAPDBDialectInformixorg.hibernate.dialect.InformixDialectHypersonicSQLorg.hibernate.dialect.HSQLDialectIngresorg.hibernate.dialect.IngresDialectProgressorg.hibernate.dialect.ProgressDialectMckoi SQLorg.hibernate.dialect.MckoiDialectInterbaseorg.hibernate.dialect.InterbaseDialectPointbaseorg.hibernate.dialect.PointbaseDialectFrontBaseorg.hibernate.dialect.FrontbaseDialectFirebirdorg.hibernate.dialect.FirebirdDialect

表 3.9. Hibernate日志类别

类别功能org.hibernate.SQL在所有SQL DML语句被执行时为它们记录日志org.hibernate.type为所有JDBC参数记录日志org.hibernate.tool.hbm2ddl在所有SQL DDL语句执行时为它们记录日志org.hibernate.pretty在session清洗(flush)时，为所有与其关联的实体(最多20个)的状态记录日志org.hibernate.cache为所有二级缓存的活动记录日志org.hibernate.transaction为事务相关的活动记录日志org.hibernate.jdbc为所有JDBC资源的获取记录日志org.hibernate.hql.AST在解析查询的时候,记录HQL和SQL的AST分析日志org.hibernate.secure为JAAS认证请求做日志org.hibernate为任何Hibernate相关信息做日志 (信息量较大, 但对查错非常有帮助)

表 3.10. JTA TransactionManagers

Transaction工厂类应用程序服务器org.hibernate.transaction.JBossTransactionManagerLookupJBossorg.hibernate.transaction.WeblogicTransactionManagerLookupWeblogicorg.hibernate.transaction.WebSphereTransactionManagerLookupWebSphereorg.hibernate.transaction.WebSphereExtendedJTATransactionLookupWebSphere 6org.hibernate.transaction.OrionTransactionManagerLookupOrionorg.hibernate.transaction.ResinTransactionManagerLookupResinorg.hibernate.transaction.JOTMTransactionManagerLookupJOTMorg.hibernate.transaction.JOnASTransactionManagerLookupJOnASorg.hibernate.transaction.JRun4TransactionManagerLookupJRun4org.hibernate.transaction.BESTransactionManagerLookupBorland ES