Hibernate Hql for bulk update using two entity tables

Greenhorn

Posts: 16

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I am using this query in mysql for updating multiple values for the column2 in Table1 with the values in the column2 in Table2 on certain condition. but i am not able to give two entity names in the hibernate update hql. can i know how i have to write the query below in hql so that it supports all database.

UPDATE Table1 A, Table2 B SET A.column2 = B.column2 WHERE A.column1 = B.column1

Thanks,
hfz

With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.