//reportSessionFactory points to Report database.
//transactionSessionFactory points to Business database.

reportSession = reportSessionFactory.openSession();
transactionSession = transactionSessionFactory.openSession();

reportSession.beginTransaction();
transactionSession.beginTransaction();

try
{
reportSession.saveOrUpdate(aReportEntity);
transactionSession.update(aTransactionEntity);

reportSession.commit();
transactionSession.commit();
}
catch (Exception)
{
reportSession.rollback();
transactionSession.rollback();
}
finally
{
if (reportSession != null) reportSession.close();
if (transactionSession != null) transactionSession.close();
}