rajasaur wrote:
Thanks! That's useful but ...
I just tried like was mentioned in there - something is definetelly wrong...
Code:
query must begin with SELECT or FROM: update [update Item ...
Here's the code, if I place the query in the xml the error is identical.
Code:
String hqlUpdate = "update Item set qty = :qty where partipant.id = :paxId and id = :recordId";
Query query = getSession().createQuery( hqlUpdate );
query.setString( "paxId", paxId);
query.setInteger( "qty", qty );
query.setInteger( "recordId", id );
return query.executeUpdate();
Anyone knows why ?
Q