我在 SpringBoot 中使用 JPARepository 并使用@Query注釋，但出現錯誤org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet當使用nativeQuery=true這是我的功能：@Query(value = "select * from table1 where status = ?1 and time <= ?2 LIMIT 2", nativeQuery = true)
List<MyModel> findScheduledSmsMessages(Status status, LocalDateTime time);
1 回答
瀟湘沐
TA貢獻1816條經驗 獲得超6個贊
我在查詢上方添加了以下代碼并且
@Modifying
@Transactional
像這樣 ：
@Modifying
@Transactional
@Query(value = "DELETE FROM played_sheet WHERE user_id = ?1 AND sheet_music_id = ?2", nativeQuery = true)
void deleteByUserIdAndSheetMusicId(Integer userId,Integer sheetMusicId);
添加回答
舉報
0/150
提交
取消