hi,
im using hibernate 3.2.6.ga
atm im trying to do a dml-style update to multiple colums per record:
Code:
String update = "update permission set permissionFlag = :v1 , source = :dsd where person.costumer_number = :v3";
Query q = this.getSession().createQuery(update);
q.setInteger("v1", permissionPostFlag);
q.setString("v3", costumerNumber);
q.setParameter("dsd", dsd);
q.executeUpdate();
doing this i get
Code:
org.hibernate.exception.SQLGrammarException: could not execute update query
....
org.postgresql.util.PSQLException: ERROR: syntax error at or near ","
when i log my querystring it seams to be correct:
Code:
update uboot.dwh.objects.core.PermissionPost set permissionFlag = :v1 , source = :dsd where person.costumer_number = :v3
the created query looks like:
Code:
Hibernate: update dwh_test.PERMISSION_POST, set PERMISSION_FLAG=?, SOURCE=? where COSTUMER_NUMBER=?
does hibernate support updating multiple columns at once? is this a known bug?
Login
FAQ
Search
