Transaction in Hibernate

Session session = null;
Transaction tx = null;
try {
session = sessionFactory.openSession();
tx = session.beginTransaction();
Query update = session.createSQLQuery("update User set username='XYZ' where userid=123");
update.executeUpdate();
tx.commit();
} catch (Exception e) {
tx.rollback();
} finally {
session.close();
}