Hibernate Hql for bulk update using two entity tables
posted 2 years ago
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