I am considering integrating Hibernate with a third party CMP engine (actually, Vitria 3.1.7), which has Oracle behind it.

Both Vitria and Hibernate will update the underlying database within the same transactions but Vitria will control the transactions boundaries and Hibernate will be passive. I presume I need to provide some glue (a Transaction Manager, perhaps) so that Hibernate knows whether Vitria has committed/rolled back, and when to flush, etc.

I can get a JDBC Connection handle from Vitria, and there are a couple of classes that I may be able to override to notify be when a commit or rollback happens, so it looks possible, but I'd like an idea as to how much work this is, how I can be sure that it is likely to work reliably at the end and what I need to implement for Hibernate.

thanks