Custom transaction control with setUserTransaction

public void runStatementsUsingSetUserConnection() 
{

	SqlMapClient sqlMapClient =SqlMapClientConfig.getSqlMapClient();
	Connection conn = null;

	try {

	conn = dataSource.getConnection();
	conn.setAutoCommit(false);
	sqlMapClient.setUserConnection(conn);

	Person p =(Person)sqlMapClient.queryForObject("getPerson", new Integer(9));
	p.setLastName("Smith");
	sqlMapClient.update("updatePerson", p);

	Department d =(Department)sqlMapClient.queryForObject("getDept", new Integer(3));
	p.setDepartment(d);
	sqlMapClient.update("updatePersonDept", p);

	conn.commit();

	} finally {

	sqlMapClient.setUserConnection(null);
	if (conn != null) conn.close();

	}

}