项目启动报-数据库只读：Connection is read-only. Queries leading to data modification are not allowed

最新推荐文章于 2023-08-25 13:45:06 发布

weixin_44159471

最新推荐文章于 2023-08-25 13:45:06 发布

阅读量809

点赞数

文章标签： java mysql

本文链接：https://blog.youkuaiyun.com/weixin_44159471/article/details/106255376

版权

记一次数据插入错误：

在创建service层的时候加入了事务的注解，并设置为了只读模式，在service层中加入了新增的方法，启动的时候报下面的错误

Cause: java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed
	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:200)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)
	at org.activiti.engine.impl.db.DbSqlSession.flushRegularInsert(DbSqlSession.java:649)
	at org.activiti.engine.impl.db.DbSqlSession.flushInsertEntities(DbSqlSession.java:544)
	at org.activiti.engine.impl.db.DbSqlSession.flushInserts(DbSqlSession.java:527)
	at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:417)
	at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:197)

错误原因

在业务层加入了下面的注解

@Service
@Transactional(readOnly = true)

解决方法

在新增加的方法上将只读改成 false 即可

  @Override
    @Transactional(readOnly = false)