org.springframework.dao.InvalidDataAccessApiUsageException:

LCG454872006 2014-07-31 12:17:33

1目录结构

2、springContext.xml文件



<?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:p="http://www.springframework.org/schema/p"     

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

    xmlns:mvc="http://www.springframework.org/schema/mvc"     

    xsi:schemaLocation="      

           http://www.springframework.org/schema/beans      

           http://www.springframework.org/schema/beans/spring-beans-3.0.xsd      

           http://www.springframework.org/schema/context      

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

           http://www.springframework.org/schema/mvc      

           http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">  

 	<context:component-scan base-package="com.dlsz.foods"></context:component-scan>

 	<import resource="spring/springContext-hibernate.xml"/>

 </beans>

springContext-hibernate.xml文件



<?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:p="http://www.springframework.org/schema/p"

	xmlns:jee="http://www.springframework.org/schema/jee"

	xmlns:aop="http://www.springframework.org/schema/aop" 

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

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

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

						http://www.springframework.org/schema/beans/spring-beans-3.0.xsd

						http://www.springframework.org/schema/jee  

						http://www.springframework.org/schema/jee/spring-jee-3.0.xsd

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

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

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

    

    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"

		destroy-method="close">

		 <property name="driverClass" value="com.mysql.jdbc.Driver" />

		<property name="jdbcUrl" value="jdbc:mysql://localhost:3306/test" />

		<property name="user" value="root" />

		<property name="password" value="root" /> 

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

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

		<property name="maxPoolSize" value="20" />

		<property name="maxIdleTime" value="60" />

		<property name="acquireIncrement" value="5" />

		<property name="idleConnectionTestPeriod" value="60" />

	</bean>

	<bean id="sessionFactory"

		class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">

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

		<property name="packagesToScan">

			<list>

				<value>com.dlsz.foods.*</value>

			</list>

		</property>

		<property name="hibernateProperties">

			<value>

				hibernate.dialect=org.hibernate.dialect.MySQLDialect

				hibernate.hbm2ddl.auto=create 

				hibernate.show_sql=true

				hibernate.connection.autocommit=false

				hibernate.format_sql=false

            </value>

		</property>

	</bean>

	

	

	<bean id="baseDAO" class="com.dlsz.foods.base.db.HibernateDAO">

		<property name="sessionFactory" ref="sessionFactory"></property>

	</bean>

	

	<bean id="transactionManager" 

		class="org.springframework.orm.hibernate4.HibernateTransactionManager">

		<property name="sessionFactory"><ref bean="sessionFactory"></ref></property>

	</bean>

	<tx:annotation-driven transaction-manager="transactionManager"/> 

	<tx:advice id="txAdvice" transaction-manager="transactionManager"> 

	<tx:attributes> 

	<tx:method name="save*" propagation="REQUIRED"/> 

	<tx:method name="add*" propagation="REQUIRED"/> 

	<tx:method name="create*" propagation="REQUIRED"/> 

	<tx:method name="insert*" propagation="REQUIRED"/> 

	<tx:method name="*" read-only="false" /> 

	</tx:attributes> 

	</tx:advice> 

	<aop:config proxy-target-class="true"> 

	<aop:advisor advice-ref="txAdvice" pointcut="execution(* com.dlsz.foods..service.*.*(..))" /> 

	</aop:config>

	

</beans>

HibernateDao类文件



package com.dlsz.foods.base.db;

import org.apache.log4j.Logger;

import org.springframework.orm.hibernate4.support.HibernateDaoSupport;



/**

 * 用于实现hibernate作为持久手段的dao

 * 

 * @author stylewolf

 * 

 */

public class HibernateDAO extends HibernateDaoSupport {



	private static final Logger LOG = Logger.getLogger(HibernateDAO.class);



	public void save(Object entity) {

		try {

			getHibernateTemplate().save(entity);

		} catch (Exception e) {

			LOG.error("执行数据保存失败！", e);

			e.printStackTrace();

//			throw new DatabaseException("执行数据保存失败！");

		}	

	}

	

	

}

TestController.java类文件



package com.dlsz.foods.test.controller;



import javax.annotation.Resource;



import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.RequestMapping;



import com.dlsz.foods.test.service.TestService;



@Controller

@RequestMapping("/springmvctest")

public class TestController {



	@Resource

	private TestService testService;

	

	@RequestMapping("/test")

	public String test(){

		System.out.println("mytest hell world");

		testService.saveUser();

		return "/test";

	}

}

TestService.java类文件



@Service

@Transactional

public class TestService {

	@Resource

	private HibernateDAO hibernateDAO;

	/**

	 * 保存用户

	 */

	public void saveUser(){

		User user = new User();

		user.setPassword("111");

		user.setUserName("liu");

		hibernateDAO.save(user);

	}

}

项目启动后出现如下错误



org.springframework.dao.InvalidDataAccessApiUsageException: Write operations are not allowed in read-only mode (FlushMode.MANUAL): Turn your Session into FlushMode.COMMIT/AUTO or remove 'readOnly' marker from transaction definition.

	at org.springframework.orm.hibernate4.HibernateTemplate.checkWriteOperationAllowed(HibernateTemplate.java:1135)

	at org.springframework.orm.hibernate4.HibernateTemplate$12.doInHibernate(HibernateTemplate.java:620)

	at org.springframework.orm.hibernate4.HibernateTemplate$12.doInHibernate(HibernateTemplate.java:617)

	at org.springframework.orm.hibernate4.HibernateTemplate.doExecute(HibernateTemplate.java:340)

	at org.springframework.orm.hibernate4.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:308)

	at org.springframework.orm.hibernate4.HibernateTemplate.save(HibernateTemplate.java:617)

	at com.dlsz.foods.base.db.HibernateDAO.save(HibernateDAO.java:79)

	at com.dlsz.foods.test.service.TestService.saveUser(TestService.java:26)

	at com.dlsz.foods.test.controller.TestController.test(TestController.java:20)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

	at java.lang.reflect.Method.invoke(Method.java:606)

	at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)

	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)