File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Spring and the fly likes Transaction ManageMent in Spring with Hibernate Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Frameworks » Spring
Bookmark "Transaction ManageMent in Spring with Hibernate" Watch "Transaction ManageMent in Spring with Hibernate" New topic

Transaction ManageMent in Spring with Hibernate

s vai

Joined: May 29, 2009
Posts: 3
Hi Following are some of relavent code snippets from my project...What i want ot ask is that whether one must use HibernateTransactionManager if he is using Hibernate in DAO classes to fire queries. Because we are accidentally using DatasourceTransactionManager with Hibernate Query Language in DAO implementation classes. Please calrify my doubts .According to me it shouldn't matter which transaction management strategy we are using...wat say??

My applicationcontext.xml

My BasetransactionAction which get a Particular transactionManager Instance and starts the transaction

My BaseAction class which provides various methods to get differenct types of transaction templates and hence different types of transaction managers:

one of my action classes which gives call to UserServiceserviceImpl class

My UserServiceImpl class whioch ultimately gives call to UserDAOImpl

} catch (Exception e) {
throw new BusinessException(e);

return null;
Finally My UserDAO implementation for the above service method
Christian Gossart
Ranch Hand

Joined: Mar 13, 2008
Posts: 34
If I understand correctly your design, we have the following flow:

1. User login submit

is called, which is in fact

because it's not overriden neither in AddFriendAction nor in BaseTransactionAction

3. Call is delegated to

which invoke the BaseTransactionAction version of this method (not overriden in AddFriendAction and abstract in BaseAction)

4. In this method you create an ActionTransactionCallback instance:

5. This callback is then used with the code:

Here, the doInTransaction method of the callback will be invoked, within a transaction exposed by the transaction manager referenced by the given transaction template.
getHibernateTransactionTemplate() returns the Spring bean with id BEAN_HIBERNATE_TRANSACTION_TEMPLATE="transactionManager" which is defined of class org.springframework.orm.hibernate3.HibernateTransactionManager in your Spring application context. This transaction manager manages transactions for its session factory, build on your datasource "neebalDataSource".

Back to the doInTransaction method, the call to

triggers the one from AddFriendAction, calling your UserServiceImpl and the underlying UserDaoImpl.

=> In this scenario, transactions are in fact managed by the HibernateTransactionManager. Well, I might have miss something , but I can't see here where you
are accidentally using DatasourceTransactionManager with Hibernate Query Language in DAO implementation classes

Your Spring application context also declares also a bean named "txManager", of class org.springframework.jdbc.datasource.DataSourceTransactionManager. This one will manage transactions around the JDBC connections opened from your datasource "neebalDataSource". This will be the case if you use Spring JdbcTemplate for example, but not for HibernateTemplate which is automatically managed by the HibernateTransactionManager if present.

To sum up, I would use the following:

Hibernate-only transaction => HibernateTransactionManager
JDBC-only transaction => DataSourceTransactionManager
Mixed Hibernate-JDBC transaction (same datasource) => HibernateTransactionManager
Mixed transactional datasources => JtaTransactionManager

By the way, try to keep data access in your Dao layer, business in your service layer (with transaction management), and presentation in your presentation layer: a Struts action should not know anything about Hibernate or JDBC or whatever; a service can be transactional, but it should be transparent for the caller (your Struts action)... The more a functionality is confined, the easier it is to debug/enhance/implement differently without breaking the whole application.

Hope this helps

Christian Gossart
s vai

Joined: May 29, 2009
Posts: 3
hey Chris

thanks a lot for your input...

actually i made a mistake while posting the post... sorry for that ...but when i replace "getHibernateTransactionTemplate()" with "getTransactionTemplate()" which actually uses datasourcetransactionManager the code and flow works just fine....why??? if i use HibernateTemplate in DAO layer you say i "must" (correct me if i am wrong) use HibernateTransactionTemplate...if yes then i am violating this by using DatasourceTransactionManager.......and still all is well...

where exactly my code would break if i use DatasourceTrnsactionManager instead of HibernateTransactinManager

Please disillusion me from this confusion
Christian Gossart
Ranch Hand

Joined: Mar 13, 2008
Posts: 34
Well transactions are a tricky topic

org.springframework.orm.hibernate3.LocalSessionFactoryBean exposes by default a "transaction-aware" SessionFactory.

Here I assume you extends with your AbstractHibernateDAO, to get access to Spring HibernateTemplate. In that case, when your UserDaoImpl invoke , the current Hibernate Session will participate to any Spring-managed transaction, no matter this transaction management strategy or synchronization mechanism (cf. the LocalSessionFactoryBean javadoc). In your case, even if the transaction comes from a DataSourceTransactionManager, the Hibernate Session used by your DAO is aware of it: transaction is opened, JDBC statement created by the HibernateTemplate in the Session is flushed to the database, connection is closed, Session is closed, and the transaction completes.

That's my own understanding, and I'd be glad to see someone confirm or infirm this

s vai

Joined: May 29, 2009
Posts: 3
hey Chris,

thanks a least i got someone to support what i was thinking abt....lets hope somebody puts more light on it.....

I agree. Here's the link:
subject: Transaction ManageMent in Spring with Hibernate
It's not a secret anymore!