Session s = openSession();
Transaction tx = s.beginTransaction();

s.doReturningWork(new ReturningWork<Void>() {
	@Override
	public Void execute(Connection connection) throws SQLException {
		StatelessSession sls = sessionFactory().openStatelessSession(connection);
		SQLQuery q = sls.createSQLQuery("INSERT INTO simple_entity (id) values (1)");
		q.executeUpdate();
		return null;
	}
});

tx.commit();
s.close();