Hibernate4与Spring3集成,及问题解决

最新推荐文章于 2025-12-02 21:20:38 发布

最新推荐文章于 2025-12-02 21:20:38 发布 · 157 阅读

文章标签：

#java #数据库

Spring 同时被 2 个专栏收录

1 篇文章

订阅专栏

Hibernate

1 篇文章

订阅专栏

本文介绍了Spring3与Hibernate4的集成配置，并解决了在使用hsqldb和MySQL时遇到的问题，包括异常信息处理和事务回滚等。

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;

待续。。。