'Could not extract ResultSet' error when using nativeQuery in JPA

Question

I'm using JPARepository in SpringBoot and using the @Query annotation but I get an error

org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet

When using the nativeQuery=true

This is my function:

@Query(value = "select * from table1 where status = ?1 and time <= ?2 LIMIT 2", nativeQuery = true)
    List<MyModel> findScheduledSmsMessages(Status status, LocalDateTime time);

?1 and ?2 are incorrect for native queries. Use ? by itself. — Abra
– Abra, Commented Sep 13, 2019 at 8:21
Pardon me but I couldn't see what DBMS you are using, and the keyword LIMIT is not supported by all of them. — Abra
– Abra, Commented Sep 13, 2019 at 10:31

Appel Taart · Accepted Answer · 2020-06-08 09:42:09Z

1

I added the following code above my query and

@Modifying @Transactional

Like this :

@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);

answered Jun 8, 2020 at 9:42

Appel Taart

782 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

'Could not extract ResultSet' error when using nativeQuery in JPA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related