org.hibernate.exception.SQLGrammarException: could not insert/select ids for bulk delete

Asked Jan 28 '13 at 17:41

Active Apr 03 '15 at 13:42

Viewed 1,771 times

There are the following java-code:

EntityTransaction myTransaction = myManager.getTransaction();
myTransaction.begin();
System.out.println(myManager.createQuery("delete from UserProfile where id > 16787504").executeUpdate());
myTransaction.commit();

After run, the error occurs:

javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not insert/select ids for bulk delete
    at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)
    at org.hibernate.ejb.QueryImpl.executeUpdate(QueryImpl.java:60)

Any solutions?

asked Jan 28 '13 at 17:41

abg

2,002
7
39
63

1

Have you seen the generated SQL ? – Xavi López Jan 28 '13 at 18:01
1

Have you tried adding an alias for the object? Try the following "DELETE FROM UserProfile up WHERE up.id > 16787504" – Manuel Quinones Jan 28 '13 at 18:36

org.hibernate.exception.SQLGrammarException: could not insert/select ids for bulk delete

0 Answers0