2pc

How can I enlist an ODBC connection in an XA 2PC transaction?

Our application uses ODBC to communicate with a database (Both DB2 and Oracle, if it makes a difference), and delegates business logic to Java by way of JNI (So it uses Java and C). What I'd like to know is what tools / software / libraries are needed to allow the business logic (Java/JDBC) and the application framework (C/ODBC) to part...

Transaction Processing Using PHP and MySQL

Hi, I'm trying to implement two-phase commit using PHP and MySQL, and coming up short. The main block I've found is that I'm unable to store the MySQL connection resource in a place where I can find it again for the second phase. Is it possible to serialize a database handle? Here's the case I'm trying to code for: User sends data Se...

Groovy, How to do 2 phase commit? Is Sql.withTransaction can manage transaction scope accross multiple databases?

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 dif...