Cannot execute statement in a READ O... - 인프런

재고시스템으로 알아보는 동시성이슈 해결방법

Pessimistic Lock 활용해보기

Cannot execute statement in a READ ONLY transaction. 에러

작성

1.1K

다음과 같이 메소드를 선언하고 test를 수행하면

public interface StockRepository extends JpaRepository<Stock, Long> {

	@Lock(LockModeType.PESSIMISTIC_WRITE)
	@Query("select s from Stock s where s.id =:stockId")
	Optional<Stock> findById(@Param("stockId") Long stockId);
}

Caused by: java.sql.SQLException: Cannot execute statement in a READ ONLY transaction.
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
	... 109 more

위와 같은 에러가 발생하는데요...어떻게 해결할 수 있나요?

spring java 동시성

답변 2