Enhance TransactionManager to support multi-table transaction

Transaction Manager should be database timeline-aware and return a transaction instance when a transaction is started, which can be used with dataframe writes as below.
{code:java}
val transaction = HoodieTransactionManager.beginTransaction()
df1.write.format("hudi").withTransaction(transaction).options(opts1).save(basePath1)
df2.write.format("hudi").withTransaction(transaction).options(opts2).save(basePath2)
// All success, go ahead and commit or finish rollback (ROLLED_BACK state on timeline is written in that case)
transaction.commit() {code}
 

## JIRA info

- Link: https://issues.apache.org/jira/browse/HUDI-6748
- Type: Task
- Epic: https://issues.apache.org/jira/browse/HUDI-6709
- Fix version(s):
- 1.1.0