title: update query in hibernate
body: <p>I have below <code>update</code> query in hibernate i want to update column of <code>BudgetAllocatedToFormations</code> table when i execute query </p>
  
  <pre><code>this.session.createQuery("UPDATE BudgetAllocatedToFormations batf,BudgetAssignedSubHeadOfAccounts bashoa,BudgetSubHeadOfAccounts bshoa "
      + " SET batf.balanceBudget = "+balanceBudget+""
      + " WHERE batf.budgetAssignedSubHeadOfAccounts.budgetAssignedSubHeadOfAccountId = bashoa.budgetAssignedSubHeadOfAccountId"
      + " AND bashoa.budgetSubHeadOfAccounts.budgetSubHeadOfAccountId = bshoa.budgetSubHeadOfAccountId"
      + " AND bshoa.budgetSubHeadOfAccountId = "+subHeadOfAccountId+""
      + " AND bashoa.budgetFormations.budgetFormationId = "+formationId+""
      + " AND batf.budgetFinancialYear.budgetFinancialYearId = "+financialYearId+""
      + " AND batf.isApproved = 1 AND batf.isLocked = 1 AND batf.isActive = 1").executeUpdate();
  </code></pre>
  
  <p>i get
  <strong>error:</strong> </p>
  
  <pre><code>ERROR [org.hibernate.hql.internal.ast.ErrorCounter] line 1:94: expecting "set", found ','
  ERROR [org.hibernate.hql.internal.ast.ErrorCounter] line 1:94: expecting "set", found ',' 
  line 1:94: expecting "set", found ','
      at antlr.Parser.match(Parser.java:211)
      at org.hibernate.hql.internal.antlr.HqlBaseParser.setClause(HqlBaseParser.java:414)
      at org.hibernate.hql.internal.antlr.HqlBaseParser.updateStatement(HqlBaseParser.java:216)
      at org.hibernate.hql.internal.antlr.HqlBaseParser.statement(HqlBaseParser.java:140)
  </code></pre>
  
  <p>i am using hibernate 4.0 version.</p>