Matias Paterlini

Pingback from  funny wallpaper » Hibernate error: “could not execute native bulk manipulation query”

Just as a hint, I would use

session.CreateSqlQuery("DELETE VotableNode vn WHERE vn.votingSetBucketId = :bucketId").SetParameter("bucketId", buckedId).ExecuteUpdate();

that should work

Actually, I am able to do a bulk delete using Hibernate on a PostgreSQL 8.3, but it doesn't work on PostgreSQL 8.0.

Thanks man you saved me from alot of trouble on searching the bloody exception error.

Thank you...

Thanks for your help.

Hi Matias,

This is because your SQL statements points to the name of your hibernate bean.  You need to use the name of you database tables.

VotableNode is a hibernate bean name, and not a tablename.

Good luck,

Pieter Pareit

http://www.art-gallery.be

Thanks a lot for your help. I found your page as the first result from google and saved me tones of time.

Maybe this is only a syntax error, your SQL code is missing a FROM:

DELETE FROM table WHERE condition

Thanks a lot, i found this very useful because the help provided by hibernate is not very complete

Thanks Matias, It solved my problem and saved lot of my time.

Good wishes

Ravi

This is a sql syntax error.

For SQL Server, it is not allowed to use alias for the effected table in delete or update statement.

For DB2, it is allowed.

DELETE FROM table WHERE condition -> ok

DELETE table WHERE condition -> ok

DELETE table as t WHERE condition -> not ok for SQL Server

Verify sql execution request in your favorite db client

If success

Just watch InnerException property

Pingback from  JAVA???????????????» Blog Archive » hibernate3.2??????

Hi...

i am using the hibernate query to update the table but getting the error

sql = hibernate query to update fields

we are using rows = em.createNativeQuery(sql).setParameter("investigatorTerm", codingField.getInvestigatorTerm()).setParameter("name", codingField.getName()).executeupdate()

i am getting the following error:

Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query

at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:629)

at org.hibernate.ejb.QueryImpl.executeUpdate(QueryImpl.java:57)

Please help me over this..any suggestions or solution will be of great help to me.

I was confronted with the same error and could eliminate it without a hastle due to your hint.

Thanks a lot!

Pingback from  ???????????????????????????????????? - Java?????????????????? - [??????:tags] - ????????? | 123Doing

spot on... Thanks a lot!

This error also occurs if input parameters are of different data type. May be a typo. for instance, if you input data of type String instead of int.

Thnaks, saved me loads of time

Great post, it solved my issues :)

You can use CreateSQLQuery for MS Sql Server is you add "MultipleActiveResultSets=True" to you connection string

I had the same problem but on a postgres bulk delete sql statement across multiple tables with a parameter passed in for the id.  Turns out it was not that it cant be done with hibernate SQLQuery, but that the add parameter to the query was making the sql use double quotes.  Postgres native sql requires single quotes for strings and in my case the id is a string.  

Changing my code to do this worked:

String sql = "blah blah :param; blah blah :param";

sql = sql.replaceAll(":param", "'" + id + "'");

session.createSQLQuery(sql).executeUpdate();

-Fred

Remove table alias, such as:

String del = "DELETE VotableNode WHERE votingSetBucketId = " + Integer.toString(bucketId);"

session.createSQLQuery(del).executeUpdate();