HI,

My Current Application is using
JBoss 4.0.5
Hibernate 3.0
Spring 2.5
Oracle 10g

In the AS we are using both Hibernate and Normal SQL (both in CMT).
Now i had a problem in committing.
I need to commit only Hibernate transaction.

1) Is it Possible?
2) Other than nested transaction?
Thanks in Advance

Regards
Baskar

In order to can answer, you must first tell which transaction-factory you configure for hibernate,
if plain JDBCTransactionfactory (=default) or JTA- or CMT-Transactionfactory.
If you use JDBCTransactionfactory then a commit in hibernate should just commit the hibernate transaction.


OK, If you use CMT (which uses JTA) with a global transaction then the thing is probably a little bit more complicate,
but also here it should be possible to separate the transactions.
I think it should possible by suspending the current transaction over the suspend method

Then you should be free to initialize a separate new (global) transaction (either for hibernate or your Normal SQL environment ).
(Unfortunately I'm not an expert of CMT, so take my hints not to serious.)

We are using the below configuration