> Newbie question: is there any support for Multi-database transactions
> and if so can you give me an example?

Yes, support of multidatabase transaction is available using XADataSource.
For production you need JTA-compatible distributed transaction coordinator.
If you wish to play with it, see TestXADataSource test case.

Roman