Hibernate HQL delete query

Question

Im looking for information but I didnt find how.

I have two tables:

Remesas

|codigo_prod|  nombre   |codigo_proveedor|
-----------------------------------------
|    1001   | product1  |     EST        |
|    1002   | product2  |     ASM        |

- Proveedores 

|codigo_proveedor|  mail         |
----------------------------------
|    EST        | pro@mail.com  |
|    ASM        | pro2@mail.com |  
|    DAM        | pro3@mail.com |

I have to delete from Proveedores the row that dont have codigo_proveedor on Remesas in this case delete DAM that its not on Remesas.

Thank you!

I didnt understand your tables but you can write any query you want with `session.CreateSQLQuery(YorQueryString)` method. — Behnam Safari, Feb 28 '14 at 17:31

score 1 · Answer 1 · answered Feb 28 '14 at 17:49

1

How about this?

    delete Proveedores pr  where pr.codigo_proveedor not in 
                      (select re.codigo_proveedor from Remesas re)

answered Feb 28 '14 at 17:49

Elbek

3,434
6
37
49

Behnam Safari · Accepted Answer · 2014-03-01T11:27:25.390

0

try this:

    Session s= HibernateUtil.getSession();
    s.beginTransaction();
    s.CreateSQLQuery("delete Proveedores where codigo_proveedor not in 
                      (select codigo_proveedor from Remesas)");
    s.getTransaction().commit();

I know it for Java!

edited Mar 01 '14 at 11:27

answered Feb 28 '14 at 18:01

Behnam Safari

2,941
6
27
42

Throw me that error: node to traverse cannot be null! Maybe thats why this is SQL not HQL? – Feb 28 '14 at 18:04
I changed it with Elbek Query. I think this should works – Behnam Safari Feb 28 '14 at 18:11
1

Sorry was problem of my database It worked! THank you :) – Feb 28 '14 at 19:02

Hibernate HQL delete query

2 Answers2

Linked