querydsl 업데이트 벌크쿼리

public class SnsRepositoryImpl extends QueryDslSupport<Sns, QSns> implements CustomSnsRepository {

    public SnsRepositoryImpl() {
        super(Sns.class);
    }

    @PersistenceContext(unitName = "entityManagerFactory")
    private EntityManager em;


    @Override
    public long updateProfile(Sns sns) throws Exception {


        QSns qSns = QSns.sns;

        JPAUpdateClause updateClause = new JPAUpdateClause(em, qSns);

        long count = updateClause.where(qSns.user.eq(sns.getUser())).set(qSns.profileFl, "N").execute();


        return count;

    }
}