Hi there,
Well, I think my question says it all. I need to know if Groovy SQL supports two phase commits. I'm actually programming a Grails Service where I want to define a method which does the following:
Get SQL instance for Database 1, Get SQL instance for Databsae 2,
Open a transaction some how: Within the transaction call two different stored procedures on each database respectively. Then commit some how or rollback on both connection if needed.
I didn't find any useful information yet about this anywhere on the web.
I've to program two phase commits any way, so even if this is supported by some other means (e.g. getting help from spring artifacts and use them in grails), please guide me. This has become a show stopper for me at the moment.
Note: I'm using MySQL and mysql-connector driver. Thanks, Alam Sher