Register / Login
this forum made possible by our volunteer staff, including ...
Roel De Nijs
Stephan van Hulst
Object Relational Mapping
hibernate HQL update mutliple tables
posted 8 years ago
I trying to write an sql to update 2 columns, each columns is in another table.
I need an hql.
update A.col='rr', B.col='aa' from toto as A inner join bobo as B on A.a=B.b
I found somethong for an SELECT but I don't knwo how to adapt it to an update.
from table1 as a inner join a.patient as b where a.source='aaaaa'
For instance, this one does not works:
update table1 as a set a.source='llll', b.source='aaaaa' inner join a.patient as b where a.source='mmmmm'
Please, any ideas. I realy need this query, quickly
Did you see how Paul
cut 87% off of his electric heat bill with 82 watts of micro heaters
Boost this thread!
IN clause filtering on OneToMany/ManyToMany associations in JPQL
Oracle update query question
SQL to HQL
question on Hibernate version property again