Hibernate4与Spring3集成,及问题解决

Hibernate4与Spring3集成,及问题解决

一、配置

1. pom.xml

 

<!-- // Properties -->
<properties>
    <!-- Spring version -->
    <version.spring>3.1.3.RELEASE</version.spring>
    <version.hibernate>4.1.8.Final</version.hibernate>
    <version.hibernate-validator>4.3.1.Final</version.hibernate-validator>
</properties>
<dependencies>
    <!-- // -->
    <!-- // org.springframework -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>${version.spring}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>${version.spring}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${version.spring}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-orm</artifactId>
        <version>${version.spring}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-test</artifactId>
        <version>${version.spring}</version>
        <scope>test</scope>
    </dependency>
    <!-- // -->
    <!-- // org.hibernate -->
    <dependency>
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-core</artifactId>
        <version>${version.hibernate}</version>
    </dependency>
    <dependency>
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-validator</artifactId>
        <version>${version.hibernate-validator}</version>
    </dependency>
    <dependency>
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-validator-annotation-processor</artifactId>
        <version>${version.hibernate-validator}</version>
    </dependency>
    <!-- // -->
    <!-- // hsqldb -->
    <dependency>
        <groupId>hsqldb</groupId>
        <artifactId>hsqldb</artifactId>
        <version>1.8.0.10</version>
    </dependency>
</dependencies>

 

2. applicationContext-orm-hibernate4.xml

 

<!-- // SessionFactory -->
<bean id="sessionFactory"
    class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
    <property name="dataSource" ref="dataSource" />
    <property name="packagesToScan" value="org.feticoolo.todomm.domain" />
    <!-- <property name="schemaUpdate" value="true" /> -->
    <property name="hibernateProperties">
        <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.HSQLDialect</prop>
            <prop key="hibernate.show_sql">true</prop>
            <prop key="hibernate.format_sql">true</prop>
            <prop key="hibernate.hbm2ddl.auto">create-drop</prop>
            <!-- <prop key="hibernate.current_session_context_class">org.springframework.orm.hibernate4.SpringSessionContext</prop> -->
        </props>
    </property>
</bean>

<!-- // Hibernate TransactionManager -->
<bean id="transactionManager"
    class="org.springframework.orm.hibernate4.HibernateTransactionManager">
    <property name="sessionFactory" ref="sessionFactory" />
</bean>

 二、问题

 问题1：

    据以上配置，使用的是Spring3+Hibernate4与hsqldb1.8的集成, 导致出现一下异常信息

      

2013-3-27 9:30:02 org.springframework.test.context.transaction.TransactionalTestExecutionListener startNewTransaction
信息: Began transaction (1): transaction manager [org.springframework.orm.hibernate4.HibernateTransactionManager@6161c9d1]; rollback [true]
2013-3-27 9:30:02 org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
WARN: SQL Error: -20, SQLState: IM001
2013-3-27 9:30:02 org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: This function is not supported
2013-3-27 9:30:02 org.springframework.test.context.transaction.TransactionalTestExecutionListener endTransaction

    查阅资料后发现是hsqldb的问题, 解决办法即为升级hsqldb,如下pom.xml配置:

 

<dependency>
    <groupId>org.hsqldb</groupId>
    <artifactId>hsqldb</artifactId>
    <version>2.2.9</version>
</dependency>

    至此问题解决!

 

问题2：

    集成MySQL, 事务不回滚问题. 配置如下：

     pom.xml

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.22</version>
</dependency>

    添加MySQL依赖

 

     applicationContext-orm-hibernate4.xml

<property name="hibernateProperties">
    <props>
        <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop>
        <prop key="hibernate.show_sql">true</prop>
        <prop key="hibernate.format_sql">true</prop>
        <prop key="hibernate.hbm2ddl.auto">create-drop</prop>
        <!-- <prop key="hibernate.current_session_context_class">org.springframework.orm.hibernate4.SpringSessionContext</prop> -->
    </props>
</property>

    修改hibernate方言 

 

     applicationContext.xml

<!-- enable the configuration of transactional behavior based on annotations -->
<tx:annotation-driven transaction-manager="transactionManager" />

    使用@Transactional注解的方式控制事务

 

     经分析, 是由于MySQL数据库表类型的问题导致的, 添加<prop key="hibernate.hbm2ddl.auto">create-drop</prop>配置后, 每次启动项目, 都会自动重新创建表结构, 而自动创建的表类型为MyISAM类型的, MySQL的MyiSAM类型的表是不支持事务的, 将其改成InnoDB类型即可.

 

     注：

     修改MySQL表类型的方法

     

方法一、修改MySQL配置文件my.ini       #default-storage-engine = MYISAM default-storage-engine = INNODB   方法二、使用DDL ALTER TABLE table_name ENGINE = INNODB;

    

 待续。。。