Hibernate Configuration Properties

Hibenate configuration parameters

Here is a general hibernate session configuration file:

 

hibernate.cfg.xml

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
  <session-factory>
    <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
    <property name="hibernate.use_outer_join">true</property>
    <property name="hibernate.show_sql">false</property>

    <!-- cache properties -->
    <property name="hibernate.cache.use_query_cache">false</property>
    <property name="hibernate.generate_statistics">false</property>
    <property name="hibernate.format_sql">true</property>
    <property name="hibernate.use_sql_comments">true</property>

    <property name="hibernate.jdbc.batch_size">20</property>

    <property name="hibernate.cache.use_second_level_cache">true</property>
    <property name="hibernate.cache.provider_class">net.sf.ehcache.hibernate.EhCacheProvider</property>
    <property name="net.sf.ehcache.configurationResourceName">/ehcache.xml</property>


    <!-- mapping files -->
    <mapping resource="domain.hbm.xml"/>

     <!--cache entities -->
    <class-cache class="com.wgu.domain.Attribute" usage="read-write"/>
    <collection-cache collection="com.wgu.domain.AttributeType.values" usage="read-write"/>

  </session-factory>
</hibernate-configuration>

 

 

For more details on the meaning of configuration properties,  please rerfer to Hibernate session configuration

specification

.

 

Integrate Hibernate with Spring

You may find out there are some critical properties missed in previous configuration file:

hibernate.connection.driver_class	JDBC driver class
hibernate.connection.url	JDBC URL
hibernate.connection.username	database user
hibernate.connection.password	database user password
hibernate.connection.pool_size	maximum number of pooled connections

That's because we use hibernate with Spring.

 

Configure SessionFactory

 

  <bean id="mySessionFactory" lazy-init="true" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
    <property name="configLocation">
      <value>classpath:/hibernate.cfg.xml</value>
    </property>
    <property name="hibernateProperties">
      <ref bean="hibernateProperties"/>
    </property>
    <property name="dataSource">
      <ref bean="DataSource"/>
    </property>
    <property name="lobHandler">
      <ref bean="LobHandler"/>
    </property>
  </bean>

 

 

Configure Datasource

JDBC Connection Configuration

<bean id="DataSource" lazy-init="true"
	class="org.apache.commons.dbcp.BasicDataSource" autowire="default"
	dependency-check="default">
	<property name="driverClassName">
		<value>oracle.jdbc.driver.OracleDriver
		</value>
	</property>
	<property name="url">
		<value>jdbc:oracle:thin:@${db.host}:${db.port}:${db.service}
		</value>
	</property>
	<property name="username">
		<value>${db.user}</value>
	</property>
	<property name="password">
		<value>${db.password}</value>
	</property>
	<property name="maxActive">
		<value>100</value>
	</property>
	<property name="defaultAutoCommit">
		<value>false</value>
	</property>
	<property name="testOnBorrow">
		<value>true</value>
	</property>
	<property name="minEvictableIdleTimeMillis">
		<value>5000</value>
	</property>
	<property name="timeBetweenEvictionRunsMillis">
		<value>10000</value>
	</property>
	<property name="numTestsPerEvictionRun">
		<value>5</value>
	</property>
	<property name="validationQuery">
		<value>SELECT COUNT(*) FROM DUAL</value>
	</property>
</bean>

 

Datasource JNDI Configuration

  <bean id="hibernateProperties" class="java.util.Properties">
    <constructor-arg index="0">
      <props>
        <prop key="hibernate.show_sql">false</prop>
        <prop key="hibernate.connection.datasource">java:comp/env/jdbc/dataSource</prop>
        <prop key="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.WeblogicTransactionManagerLookup</prop>
      </props>
    </constructor-arg>
  </bean>

  <jee:jndi-lookup id="DataSource" jndi-name="dataSource"/>

 

 

Configure Hibernate use SSL through JDBC connection

<bean id="dataSource" class="oracle.jdbc.pool.OracleDataSource">
    <property name="URL"><value><!-- JDBC URL that specifies SSL connection --></value></property>
    <!-- other relevant properties, like user and password -->
    <property name="connectionProperties>
        <value>
            oracle.net.ssl_cipher_suites: (ssl_rsa_export_with_rc4_40_md5, ssl_rsa_export_with_des40_cbc_sha)
            oracle.net.ssl_client_authentication: false
            oracle.net.ssl_version: 3.0
            oracle.net.encryption_client: REJECTED 
            oracle.net.crypto_checksum_client: REJECTED
        </value>
    </property>
</bean>

 Please refer to 

stackoverflow.com

.