Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

bulk update with native sql queries

Description

Hibernate Annotations 3.2 does not support bulk update/deletes using native queries,

if I have something like:

@NamedNativeQuery(name = "testQuery", query = "delete from tb_test where id = ?")

in one of my entities, there will be following exception during build of SessionFactory :

Exception in thread "main" org.hibernate.cfg.NotYetImplementedException: Pure native scalar queries are not yet supported
at org.hibernate.cfg.annotations.QueryBinder.bindNativeQuery(QueryBinder.java:118)
at org.hibernate.cfg.annotations.QueryBinder.bindNativeQueries(QueryBinder.java:197)
at org.hibernate.cfg.AnnotationBinder.bindQueries(AnnotationBinder.java:281)
at org.hibernate.cfg.AnnotationBinder.bindClass(AnnotationBinder.java:404)
at org.hibernate.cfg.AnnotationConfiguration.processArtifactsOfType(AnnotationConfiguration.java:452)
at org.hibernate.cfg.AnnotationConfiguration.secondPassCompile(AnnotationConfiguration.java:268)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1210)

------
I made a mistake and I reported this issue as as an issue about Hibernate core!

Activity

Show:

Brett MeyerJune 29, 2013 at 5:32 PM

Brett MeyerMarch 6, 2013 at 4:49 PM

Thanks to for the pull request!

Janario OliveiraFebruary 1, 2013 at 8:37 PM

arjan tijmsApril 22, 2012 at 5:19 PM

Any updates here? We're slowly approaching the 6 year milestone that this issue is open.

Didier LoiseauMarch 29, 2012 at 5:09 PM
Edited

Since this is supported by Hibernate Core, it would probably be as much simple to just implement this part of the JPA 1 spec, instead of changing the exception…

I also wanted to use this feature (for performing a native select count(…)) and I ended up using createNativeQuery instead…

Maybe the issue should be modified to have an "Affects Version" properly set, and remove the "Fixed Version" so that it appears more clearly in the Jira searches.

Fixed

Details

Assignee

Reporter

Components

Fix versions

Priority

Created October 19, 2006 at 3:01 AM
Updated April 22, 2015 at 6:24 PM
Resolved March 6, 2013 at 4:49 PM