How to specify a conditional new value in JPA bulk update

[Stephen Suen]

Hi there,

I'm learning JPA. I wonder how to specify a conditional new value in a bulk update. For example:

UPDATE myentity 
SET prop1 = CASE  WHEN prop1 > 0 THEN prop1 + 1 ELSE prop1 - 1 END 
WHERE prop2 >= 0

With JPQL, I can only implement the above native query with two bulk update. Is there any way to do this in a single query?

Thanks for any help.

Stephen