topic handle transactions externally with hibernate in Alfresco Archive

handle transactions externally with hibernate

gguimezanes — Mon, 04 Feb 2013 15:29:15 GMT

Hello,I am using activiti within an existing application that uses Hibernate, with no JTA, transactions are handled "manually".I would like to use activiti inside our own transactions so that a rollback would work at the same time on our custom code and on activiti.I have seen the transactionsExtern

Re: handle transactions externally with hibernate

jbarrez — Tue, 05 Feb 2013 12:20:19 GMT

If you are using Spring, it makes things easier as you can just pass the transactionmanager to the process engine configuration.

The transactionsExternallyManaged is actually used to determine which transaction factory is used in Ibatis. So my guess it would work, however, I haven't tested it yet with Hibernate alone.

Re: handle transactions externally with hibernate

gguimezanes — Wed, 06 Feb 2013 08:40:19 GMT

The problem is, we don't use Spring. We don't have a TransactionManager, we directly use the hibernate session. That's why I was wondering if we could pass directly the java.sql.Connection to activiti…

Re: handle transactions externally with hibernate

frederikherema1 — Wed, 06 Feb 2013 09:16:29 GMT

Activiti uses a datasource for fetching SQL-connections. If you have a datasource (or proxy) that is aware of the hibernate-transaction and always returns the SQL-connection active in the hibernate-context, this can work perfectly, in combination with the "transactions managed externally".

Re: handle transactions externally with hibernate

ronald_van_kuij — Wed, 06 Feb 2013 18:04:28 GMT

I've tried and achieved sometinhg similar, but can't and won't share the code… Why: if you want integration of frameworks, use the existing solutions for that, a transactionmanager. Waaaaay reasier, portable etc…

Re: handle transactions externally with hibernate

gguimezanes — Thu, 07 Feb 2013 09:14:20 GMT

In fact just using a custom datasource wasn't enough.
The solution that worked for us :
- create a Datasource that always gives the connection of our current hibernate session
- create an engine configuration that overrides initDataSource and initDatabaseType
- set transactionExternallyManaged to true
- create our own TransactionContext that does neither commit nor rollback (but tells our system that the transaction is not committable when the method rollback is called)
- add "closeConnection" = "false" to the properties of the transaction factory

Hope this helps if someone else has the same need…

Re: handle transactions externally with hibernate

ronald_van_kuij — Fri, 08 Feb 2013 20:16:55 GMT

Cool isn't it, these details… Soooo much simpeler than just using a JEE server with a normal TM