I am running an HSQL update command and it is generating this SQL:
Code:
update TableA set x=13216 where (id) IN (select id from HT_TableA);
What is HT_TableA? I can't run that query straight from mysql.
If I change from HSQL to straight SQL, it crates the query as I would expect
Code:
update TableA set x=13216 where id = 123;
Here's my my code:
Code:
final String hql = "update TableA a set a.x.id = :to where a.id = :from";
final Query query = query(hql);
query.setParameter("from", from.getId());
query.setParameter("to", to.getId());
Login
FAQ
Search
