IT 개발/에러 2024. 7. 22. 19:43

InvalidDataAccessApiUsageException: Executing an update/delete query 오류

Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed: org.springframework.dao.InvalidDataAccessApiUsageException: Executing an update/delete query] with root cause

jakarta.persistence.TransactionRequiredException: Executing an update/delete query
at org.hibernate.internal.AbstractSharedSessionContract.checkTransactionNeededForUpdateOperation(AbstractSharedSessionContract.java:517) ~[hibernate-core-6.4.4.Final.jar:6.4.4.Final]
at org.hibernate.query.sqm.internal.QuerySqmImpl.executeUpdate(QuerySqmImpl.java:671) ~[hibernate-core-6.4.4.Final.jar:6.4.4.Final]
at cohttp://m.querydsl.jpa.impl.JPAUpdateClause.execute(JPAUpdateClause.java:76) ~[querydsl-jpa-5.1.0-jakarta.jar:na]

 

위와 같은 오류가 발생했을 때 transaction이 없어서 발생하는 오류로 update queryDSL에 @Transactional 선언을 하면 해결된다.

반응형
저작자표시 비영리 변경금지 (새창열림)

'IT 개발 > 에러' 카테고리의 다른 글

XML -> JAVA Class 매핑 시 발생한 에러  (0) 2024.05.09
Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.Reason: Failed to determine suitable jdbc url - spring boot 3 datasource 설정  (1) 2024.04.28
오류: org.springframework.web.util.NestedServletException: Handler dispatch failed; nested exception is java.lang.NoClassDefFoundError: org/reactivestreams/Publisher  (0) 2023.03.09
오류: java.lang.ArithmeticException: Rounding needed with the rounding mode being set to RoundingMode.UNNECESSARY  (0) 2023.03.09
오류:org.springframework.dao.InvalidDataAccessApiUsageException: For input string: "XXX"; nested exception is java.lang.NumberFormatException: For input string: "XXX"  (0) 2023.03.08