Spring data JPA expression using deleteBy

Question

I am using spring-data-jpa to perform delete operation.

Currently, I have a query like:

@Modifying
@Transactional
@Query("Delete from student s where(:studentName is null Or s.studentName =:studentName) and s.studentId IN(:studentIds)")
int deleteByStudentIdAndRollNo(@Param("studentName") String studentName, @Param("studentIds") List<Integer> studentIds)

The above query is working fine and is returning a count of successfully deleted rows from the table.
But the problem is, now I have to return deleted List<Students> instead of the number of deleted records.

I am aware of the fact that @Query will always return the count of successfully deleted records.

I tried to use deleteBy like below:

List<Student> deleteByStudentIdStudentNameIsNullOrStudentNameIsAndStudentIdIN , But that's not working.
Is there any way to get list of deleted students?

Seldo97 · Accepted Answer · 2020-04-26 20:17:11Z

1

This article show how to return deleted records: Spring Data JPA – Derived Delete Methods

And try maybe this code:

List<Student> deleteAllByStudentNameIsNullOrStudentNameAndStudentIdIn(String studentName, List<Integer> studentIds);

But can't be sure that will be work because I don't know your Student's model structure.

answered Apr 26, 2020 at 20:17

Seldo97

7481 gold badge8 silver badges19 bronze badges

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

2 Comments

mayank bisht Over a year ago

Thanks, it worked. Could you please share a reference document, so that I can also learn?

Seldo97 Over a year ago

What document? What do you mean?

Collectives™ on Stack Overflow

Spring data JPA expression using deleteBy

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related