Hibernate delete and update queries with joins

-

From Hibernate 4.1.9 manual - section about bulk update and deletes:

No implicit or explicit joins can be specified in a bulk HQL query. Sub-queries can be used in the where-clause, where the subqueries themselves may contain joins.

Unsupported (implicit join)

DELETE A a WHERE a.relation.property = "dummy";

A way to go

DELETE A a WHERE a.relation.id IN (SELECT r.id FROM Relation r WHERE r.property = "dummy");

Comments

  1. Roger PackMarch 30, 2016 at 12:06 AM

    I presume your example 1 is supposed to be a join with some other table here?

    ReplyDelete
  2. Roger PackMarch 30, 2016 at 12:06 AM

    I presume your example 1 is supposed to be a join with some other table here?

    ReplyDelete
  3. IOOI SqAROctober 17, 2016 at 5:08 PM

    Thanks! I found that post after googling for about one hour and it solved my problem with an update HQL query.

    ReplyDelete
  4. UnknownJune 29, 2018 at 6:09 AM

    Great help. Saved a lot of my time I would have wasted debugging my code.

    ReplyDelete

Post a Comment

Popular posts from this blog

Access application Google Drive account from javascript without client side authorization dialog

-
Use case We want to create a regular Google Drive account owned by an application. The application enables users to upload or view files within that account. Since Google Drive API provides javascript library the goal is to use javascript for all the logic (upload and view files) with minimum engagement of server side processing. For the purpose of creating an application owned account Google provides two options: SERVICE ACCOUNT Application is authorized by .pk12 certificate; the drawback is that only the application can see documents it created - documents cannot be viewed for example through Google Drive UI. REGULAR GOOGLE ACCOUNT used by the application only This option is our choice because we want to access stored files using Google Drive UI too. More information about the two options is available in Google Drive SDK documentation . To access a Google account using Google API we have to ensure correct handling of authentication and authorization procedures - Google A
Read more

How to set width of a table within Twitter Bootstrap

-
All tables within the bootstrap stretch according to their container, which you can easily do by placing your table inside a .span* grid element of your choice. If you wish to remove this property you can create your own table class and simply add it to the table you want to expand with the content within: .table-nonfluid { width: auto; } Taken from: stackoverflow answers .
Read more