nested exception is org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
for the exception above is due to I hava used "INNER JOIN" in my sql for delete , for example as follow:
delete from A
INNER JION B ON A.id = B.a_id
where B.tag='Y'
for this problem we can fix it as follow:
delete from A
where exists(select 1 from B where A.id = B.a_id AND B.tag='Y')
that's all
for the exception above is due to I hava used "INNER JOIN" in my sql for delete , for example as follow:
delete from A
INNER JION B ON A.id = B.a_id
where B.tag='Y'
for this problem we can fix it as follow:
delete from A
where exists(select 1 from B where A.id = B.a_id AND B.tag='Y')
that's all