Hibernate Configuration

Hibernate configuration properties :-

hibernate.dialect : allows Hibernate to generate SQL optimized for a particular relational database.

hibernate.show_sql : Write all SQL statements to console.

hibernate.format_sql : Pretty print the SQL in the log and console.

hibernate.connection.autocommit : Enables autocommit for JDBC pooled connections (it is not recommended)

hibernate.connection.isolation : Sets the JDBC transaction isolation level.

hibernate.cache.region_prefix : A prefix to use for second-level cache region names

hibernate.cache.use_second_level_cache : Can be used to completely disable the second level cache, which is enabled by default for classes which specify a <cache> mapping.

hibernate.cache.default_cache_concurrency_strategy : Setting used to give the name of the default org.hibernate.annotations.CacheConcurrencyStrategy to use when either @Cacheable or @Cache is used. @Cache(strategy="..") is used to override this default.

hibernate.generate_statistics : If enabled, Hibernate will collect statistics useful for performance.

Hibernate Datasource Properties :-

driverClassName : The fully qualified Java class name of the JDBC driver to be used.

url : database url

username : database user name

password : database

maxIdle : The maximum number of connections that can remain idle in the pool. Default is 8.

maxActive : The maximum number of active connections that can be allocated from the pool. Default is 8.

validationQuery : The SQL query that will be used to validate connections from this pool before returning them to the caller. 

 Configuration settings for abandoned db connections :

logAbandoned : Determines whether or not to log stack traces for application code which abandoned a Statement or Connection. Default is false

removeAbandoned : Whether or not a connection is considered abandoned and eligible for removal if it has been idle longer than the removeAbandonedTimeout. default is false.

removeAbandonedTimeout : Timeout in seconds before an abandoned connection can be removed. Default is 300.

 

Hibernate SQL Dialects :-

Microsoft SQL Server 2000 : org.hibernate.dialect.SQLServerDialect
Microsoft SQL Server 2005 : org.hibernate.dialect.SQLServer2005Dialect
Microsoft SQL Server 2008 : org.hibernate.dialect.SQLServer2008Dialect
Microsoft SQL Server 2012 : org.hibernate.dialect.SQLServer2012Dialect
MySQL : org.hibernate.dialect.MySQLDialect
MySQL with InnoDB : org.hibernate.dialect.MySQLInnoDBDialect
MySQL with MyISAM : org.hibernate.dialect.MySQLMyISAMDialect
MySQL5 : org.hibernate.dialect.MySQL5Dialect
MySQL5 with InnoDB : org.hibernate.dialect.MySQL5InnoDBDialect
Oracle 8i : org.hibernate.dialect.Oracle8iDialect
Oracle 9i : org.hibernate.dialect.Oracle9iDialect
Oracle 10g and later : org.hibernate.dialect.Oracle10gDialect
Oracle TimesTen : org.hibernate.dialect.TimesTenDialect
PostgreSQL 8.1 : org.hibernate.dialect.PostgreSQL81Dialect
PostgreSQL 8.2 : org.hibernate.dialect.PostgreSQL82Dialect
PostgreSQL 9 and later : org.hibernate.dialect.PostgreSQL9Dialect
Progress : org.hibernate.dialect.ProgressDialect

Related posts :-
Hibernate introduction