Transaction transaction = session.beginTransaction(); int a = session.createSQLQuery(sql).executeUpdate(); transaction.commit();