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"    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"    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 logExceptionsWARN: SQL Error: -20, SQLState: IM0012013-3-27 9:30:02 org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptionsERROR: This function is not supported2013-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. 待续...

?