Querydsl delete query using limit

Question

I have a one question.

I want to use limit for delete query with querydsl. Is there any way?

delete(wedul).where(wedul.id.eq(10)).limit(10)

your database don't allow delete query using limit. check out this question — palbok
– palbok, Commented May 14, 2021 at 7:08

pfranza · Accepted Answer · 2021-05-23 14:10:06Z

1

JPA (on which hibernate and querydsl is built) does not support something like a limit or rownum for deletes, because it is not a universally supported database concept.

A common approach to solving this would be to delete from the table where the 'id' in contained within a subquery, and the place the limits on the subquery.

See this other answer

edited May 23, 2021 at 14:10

answered May 23, 2021 at 14:03

pfranza

3,3672 gold badges23 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

Querydsl delete query using limit

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related