Write operations are not allowed in read-only mode (FlushMode.MANUAL) 错误解决

最新推荐文章于 2024-06-20 10:13:16 发布

袁扣

最新推荐文章于 2024-06-20 10:13:16 发布

阅读量1.3k

点赞数

本文链接：https://blog.csdn.net/qq_23124557/article/details/80168519

版权

错误信息：

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:1128)
	at org.springframework.orm.hibernate4.HibernateTemplate$22.doInHibernate(HibernateTemplate.java:762)
	at org.springframework.orm.hibernate4.HibernateTemplate.doExecute(HibernateTemplate.java:341)
	at org.springframework.orm.hibernate4.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:309)
	at org.springframework.orm.hibernate4.HibernateTemplate.merge(HibernateTemplate.java:758)

解决方法：

1.查看配置文件，打头的方法是否为readOnly

<bean id="baseTransaction" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean" abstract="true">
		<property name="transactionManager" ref="transactionManager" />
		<property name="proxyTargetClass" value="true" />
		<property name="transactionAttributes">
			<props>
				<prop key="get*">PROPAGATION_REQUIRED,readOnly</prop>
				<prop key="find*">PROPAGATION_REQUIRED,readOnly</prop>
				<prop key="load*">PROPAGATION_REQUIRED,readOnly</prop>
				<prop key="save*">PROPAGATION_REQUIRED</prop>
				<prop key="add*">PROPAGATION_REQUIRED</prop>
				<prop key="update*">PROPAGATION_REQUIRED</prop>
				<prop key="remove*">PROPAGATION_REQUIRED</prop>
				<prop key="merge*">PROPAGATION_REQUIRED</prop>
			</props>
		</property>
	</bean>

2.检查接口有没有配置@Transactional(readOnly = true)，

如果有配置需要在单独的方法前配置@Transactional(readOnly = false)，如下图所示