Problem with commit in a method marked with @Transactional

[Alexey Saenko]

Hi all,

The problem is in the following. There is Websphere 8.5 application server where is set up XA datasource. And there is an application which is written on Spring 3.2.2 with Hibernate 4.1.7. I have a DAO class which has one persist() method marked with @Transactional annotation and should just persist an object to the database. As a result it returns persisted object with id (hibernate performs request for the new one), but actually the object is not written to the database and there are no stacktraces in the logs. TransactionSynchronizationManager.isActualTransactionActive() returns true in the method persist().

All persistence objects are configured with annotations.

Spring configuration is in xml-form and looks like this:
<jee:jndi-lookup id="datasourceBw" jndi-name="jdbc/oracledatasource_bw_sp" /> <bean id="sessionFactoryBw" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"> <property name="dataSource" ref="datasourceBw" /> <property name="hibernateProperties"> <props> <prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop> <prop key="hibernate.archive.autodetection">class</prop> <prop key="hibernate.show_sql">true</prop> <prop key="hibernate.format_sql">true</prop> <prop key="connection.pool.size">5</prop> <prop key="hibernate.cache.region.factory_class">org.hibernate.cache.ehcache.EhCacheRegionFactory</prop> <prop key="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</prop> <prop key="hibernate.cache.use_second_level_cache">false</prop> <prop key="hibernate.cache.use_query_cache">false</prop> <prop key="hibernate.generate_statistics">true</prop> <prop key="hibernate.enable_lazy_load_no_trans">true</prop> </props> </property> </bean> <bean id="transactionManagerBw" class="org.springframework.orm.hibernate4.HibernateTransactionManager"> <property name="sessionFactory" ref="sessionFactoryBw" /> </bean> <tx:annotation-driven transaction-manager="transactionManagerBw"/>
Do you have any ideas how could I make DAO save an object to the database?

Thanks in advance.

[Kathleen Angeles]

And there are no other transactions in that unit flow? In other words, are there other resources involved, that could have caused a rollback, which cascaded to your persist? E.g. you can have 2 datasources, this one succeeded and the other one failed, and since you are using XA, I guess you are capable of multi-resource rollback.

- k


----------------------------------------------------------------------------------------
[SpringSource Certified Spring Professional (Spring Certification) - Practice Tests]

[Alexey Saenko]

@Kathleen for the moment there is only one datasource.

I've also forgotten to mention that persisting runs as follows

getEntityManager().persist(obj);

[Alexey Saenko]

Finally, it started to work with the following configuration.

persistence.xml
<persistence-unit name="pu_bw" transaction-type="RESOURCE_LOCAL"> <provider>org.hibernate.ejb.HibernatePersistence</provider> <non-jta-data-source>jdbc/oracledatasource_bw_sp</non-jta-data-source> <properties> <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect" /> <property name="hibernate.archive.autodetection" value="class" /> <property name="hibernate.show_sql" value="true" /> <property name="hibernate.format_sql" value="true" /> <property name="connection.pool.size" value="5" /> <property name="hibernate.cache.region.factory_class" value="org.hibernate.cache.ehcache.EhCacheRegionFactory" /> <property name="hibernate.cache.use_second_level_cache" value="false" /> <property name="hibernate.cache.use_query_cache" value="false" /> <property name="hibernate.generate_statistics" value="true" /> <property name="hibernate.enable_lazy_load_no_trans" value="true" /> </properties> </persistence-unit>
web.xml
<persistence-unit-ref> <persistence-unit-ref-name>persistence/pu_bw</persistence-unit-ref-name> <persistence-unit-name>pu_bw</persistence-unit-name> </persistence-unit-ref>
spring-beans.xml
<bean class="org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor"> <property name="persistenceUnits"> <map> <entry key="pu_bw" value="persistence/pu_bw" /> </map> </property> </bean> <jee:jndi-lookup id="entityManagerFactoryBw" jndi-name="persistence/pu_bw"/> <bean id="transactionManagerBw" class="org.springframework.orm.jpa.JpaTransactionManager" p:entityManagerFactory-ref="entityManagerFactoryBw"/> <tx:annotation-driven transaction-manager="transactionManagerBw"/>