Problem with HQL UPDATE

hi i have folwing HQL query for updating a table but it doesnt run

would b great if somone can help urgent thanks

session.createQuery("update BusRefAccessValues brav set brav.busRefAccessEndDate =:currentdate"

+" where brav.id.busRefId =:busrefid"

+" and brav.id.busRefAccessLabel='CLIENT UNIT NUMBER'"

+" and (brav.id.busRefAccessEffDate is null or "

+"brav.id.busRefAccessEffDate < current_date())"

+" and (brav.busRefAccessEndDate is null or "

+"brav.busRefAccessEndDate > current_date())");

query.setDate("currentdate",new Date ());

query.setInteger("busrefid", brmf.getBusRefId());

int rowcount = query.executeUpdate();

[1006 byte] By [swamy_suna] at [2007-11-27 5:05:22]