Hi!
I want to use MySQL with EJB. I know that J2EE supports two phase commit.
As you might know, MySQL doesn't support transactions fully.
I wondering if two phase commit concept in J2EE requires transaction support from database or it can manage transactions even if a database server doesn't support transactions.
If anyone knows please let me know. It will be a great help to me.
- UnicMan
>
> I wondering if two phase commit concept in J2EE
> requires transaction support from database or it can
> manage transactions even if a database server doesn't
> support transactions.
>
I think that 2-phase commit concept in J2EE does not require transaction support from the database. The rationale behind my thinking is that 2-phase commit is used to handle transactions across multiple datasource. To handle 2-phase commits, the J2EE container must perform transaction handling on its own and not depend on the datasource. However, the J2EE container will be using the datasource's implementation of the commit for the second commit in the 2-phase commit process.
I Hope it helps.... I was writing as I was thinking....
