Hello
We are starting with Hibernate, and I would like to know if it is possible to use 2 phase commit ? I read some posts on it, but it seams that a session is connected to 1 DB and as the transaction object is derived from the session, I assume there is no way to use 2 phase commit.

Some posts use 2 transactions, but of cours, that's no 2 phase commit.

We ar working on 2 oracle DB's (10G) with OC4J container from the Oracle application server.

Using JTA, without hibernate , i can commit to 2 tables on different DB's in 1 transaction. So.... can the last version of hibernate do this to ? ( as it is build on top of JTA, i think)

grtz,

Chris.

2 PC is handled by the jta/jdbc layer not hibernate; as hibernate uses jta/jdbc it works.

Max,

That's what i'm saying, using JTA it works. And because Hibernate is build on top of JTA......
But I find no Hibernate API that gives me the possibility commit 2 sessions from different databases in 1 transaction. I see your are from the Hibernate Team, so i'm sure you can supply me with a link to some example where the 2PC is used through hibernate api's :-) ?

Grtz,
Chris.

Hibernate has no 2 PC API and it doe's not it it, it is "transparent". Just deploy your application to j2ee container. More "transparent" way is to use multiple databases as distributed database (You will se it as single database). 2 PC is more usefull for stuff like JMS.

Hibernate is not build on top of JTA, it is build on top of a connection which itself is registred in a JTA Tx.