equipment update query deleted; hibernate constraint violation exception & optimistic lock exception added