hebernate

/** 

 * Copyright (C) 2013 Winbons Technology Software Co.,Ltd

 * All Rights Reserved.

 * Development of this softwareWinbons Technology Software Co.,Ltd.

 * Without the formal written consent of the Company, 

 * any other individuals, groups may not use, 

 * copy, modify, or distribute this software

 * @Title: HibernateSessionFactoryBean.java 

 * @Package saas.framework.dao 

 * @Description: TODO(用一句话描述该文件做什么) 

 * @author yxx

 * @date 2014-3-17 上午11:29:50 

 * @version 1.0 

 */

 

package saas.framework.dao;

 

import java.util.Iterator;

 

import org.hibernate.HibernateException;

import org.hibernate.cfg.AnnotationConfiguration;

import org.hibernate.mapping.PersistentClass;

import org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean;

 

import saas.framework.mutitenant.TenantTable;

import saas.framework.mutitenant.sql.TableCache;

 

/**

 * @ClassName: HibernateSessionFactoryBean

 * @Description: TODO(这里用一句话描述这个类的作用)

 * @author yxx

 * @date 2014-3-17 上午11:29:50

 */

 

public class HibernateSessionFactoryBean extends AnnotationSessionFactoryBean {

 

@SuppressWarnings({ "rawtypes", "unchecked" })

@Override

protected void postProcessAnnotationConfiguration(AnnotationConfiguration config) throws HibernateException {

Iterator<PersistentClass> its = config.getClassMappings();

for (Iterator<PersistentClass> iterator = its; iterator.hasNext();) {

PersistentClass rootClass = iterator.next();

Class entityName = rootClass.getMappedClass();

String tableName = rootClass.getTable().getName();

TenantTable tenantTable = (TenantTable) entityName.getAnnotation(TenantTable.class);

if (tenantTable != null) {

TableCache.addTable(tenantTable.value(), tableName);

}

}

}

 

@Override

protected void scanPackages(AnnotationConfiguration config) {

super.scanPackages(config);

}

}

 

 

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop"

xmlns:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context"

xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd

       http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd

       http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd 

       http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd"

default-autowire="byName" default-lazy-init="false">

 

<!-- <tx:annotation-driven transaction-manager="transactionManagerBasic" proxy-target-class="true" /> -->

<tx:annotation-driven transaction-manager="transactionManagerHibernate" proxy-target-class="true" />

 

<bean id="stat-filter" class="com.alibaba.druid.filter.stat.StatFilter">

<!--慢SQL统计，如果SQL执行时间超过一定时间则记录为慢SQL -->

<property name="slowSqlMillis" value="3000" />

<!--慢SQL统计日志输出 -->

<property name="logSlowSql" value="true" />

<!--合并SQL统计 例如select * from table t where t.id =1，会被变为select * from table t where t.id =？来统计 -->

<property name="mergeSql" value="true" />

</bean>

 

<bean id="log-filter" class="com.alibaba.druid.filter.logging.Slf4jLogFilter">

<property name="statementLogEnabled" value="true"></property>

<property name="statementLoggerName" value="winbons.statementsql"></property>

</bean>

 

<bean id="sql-filter" class="saas.framework.mutitenant.SqlParseFilter"></bean>

 

<bean id="lobHandler" class="com.alibaba.druid.support.spring.DruidLobHandler"></bean>

 

<bean id="wall-filter-config" class="com.alibaba.druid.wall.WallConfig" init-method="init">

<!-- 指定配置装载的目录 -->

      <property name="dir" value="META-INF/druid/wall/mysql" />

      <property name="commentAllow" value="true" />

      <property name="multiStatementAllow" value="true" />

      <property name="noneBaseStatementAllow" value="true" />

      <property name="selectWhereAlwayTrueCheck" value="false" />

      <property name="conditionAndAlwayTrueAllow" value="true" />

</bean>

<bean id="wall-filter" class="com.alibaba.druid.wall.WallFilter">

      <property name="dbType" value="mysql" />

      <property name="config" ref="wall-filter-config" />

      <property name="logViolation" value="true" />

<property name="throwException" value="true" />

  </bean>

 

<bean id="saasDataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">

<!-- 基本属性 url、user、password -->

<property name="url" value="${jdbc.url}" />

<property name="username" value="${jdbc.username}" />

<property name="password" value="${jdbc.password}" />

<!-- 配置初始化大小、最小、最大 -->

<property name="initialSize" value="10" />

<property name="minIdle" value="10" />

<property name="maxActive" value="50" />

<!-- maxWait获取连接等待超时的时间 -->

        <property name="maxWait" value="60000" />

<!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->

<property name="timeBetweenEvictionRunsMillis" value="60000" />

<!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->

<property name="minEvictableIdleTimeMillis" value="300000" />

<property name="validationQuery" value="SELECT 'x'" />

<property name="testWhileIdle" value="true" />

<property name="testOnBorrow" value="false" />

<property name="testOnReturn" value="false" />

<property name="poolPreparedStatements" value="false" />

<property name="proxyFilters">

<list>

<ref bean="stat-filter" />

<ref bean="log-filter" />

<ref bean="sql-filter" />

<ref bean="wall-filter" />

</list>

</property>

</bean>

 

<!-- Hibernate SessionFactory -->

<bean id="sessionFactory" class="saas.framework.dao.HibernateSessionFactoryBean">

<property name="dataSource">

<ref bean="saasDataSource" />

</property>

<property name="packagesToScan">

<list>

<value>saas.**.model</value>

</list>

</property>

<property name="hibernateProperties">

<props>

<prop key="hibernate.dialect">${hibernate.dialect}</prop>

<prop key="hibernate.show_sql">${hibernate.show_sql}</prop>

<prop key="hibernate.format_sql">${hibernate.format_sql}</prop>

<prop key="hibernate.cache.use_second_level_cache">${hibernate.cache.use_second_level_cache}</prop>

<prop key="hibernate.cache.use_query_cache">${hibernate.cache.use_query_cache}</prop>

<prop key="hibernate.bytecode.use_reflection_optimizer">${hibernate.bytecode.use_reflection_optimizer}</prop>

<prop key="hibernate.query.factory_class">${hibernate.query.factory_class}</prop>

<prop key="hibernate.generate_statistics">false</prop>

</props>

</property>

</bean>

 

<!-- 用Hibernate的事务，使用了MyCat，任务模块，添加任务，如果有标签的时候，保存不了，找不出原因 -->

<bean id="transactionManagerHibernate" class="org.springframework.orm.hibernate3.HibernateTransactionManager">

<property name="dataSource" ref="saasDataSource" />

</bean>

 

<!-- 发现选择两个或以上的客户进行批量删除时，事务是autocommit为true，没有进行到事务管理 -->

<!-- <bean id="transactionManagerBasic" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

<property name="dataSource" ref="saasDataSource" />

</bean> -->

</beans>