Announcement Announcement Module
Collapse
No announcement yet.
Spring + Hibernate + JTA Problem Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Spring + Hibernate + JTA Problem

    Hi,
    I am using Hibernate + Spring + JTA in my project. I am using JTA because my project deals with multiple databases. When I use the following:

    getHibernateTemplate().save(employee);

    JTA works properly in above case and in case of any exception, Transaction is rolled back.

    But when I use following transaction is not rolled back.

    Session ses =getHibernateTemplate().getSessionFactory().getCur rentSession();
    ses.createQuery("update Employee emp set emp.empName='sonu' where emp.empId=1").executeUpdate();

    Can anybody please help me in understanding the difference and also help me in knowing the solution.

    Following is my configuration:

    <?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
    <beans>
    <!-- Data source bean -->


    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName">
    <value>com.mysql.jdbc.Driver</value>
    </property>
    <property name="url">
    <value>jdbc:mysql://localhost:3306/emp</value>
    </property>
    <property name="username">
    <value>root</value>
    </property>
    <property name="password">
    <value>*****</value>
    </property>
    <property name="defaultAutoCommit" value="true" />
    </bean>


    <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSes sionFactoryBean">
    <property name="dataSource"><ref local="dataSource"/></property>
    <property name="mappingResources">
    <list>
    <value>config/hibernate/Employee.hbm.xml</value>
    </list>
    </property>
    <property name="hibernateProperties">
    <props>
    <prop key="hibernate.dialect">org.hibernate.dialect.MySQ LDialect</prop>
    <prop key="hibernate.show_sql">false</prop>
    <prop key="hibernate.cglib.use_reflection_optimizer">tru e</prop>
    <prop key="hibernate.transaction.flush_before_completion ">true</prop>
    <prop key="hibernate.transaction.auto_close_session">tru e</prop>
    <prop key="hibernate.transaction.factory_class ">org.hibernate.transaction.JTATransactionFact ory</prop>
    <prop key="hibernate.current_session_context_class">thre ad</prop>
    <prop key="jta.UserTransaction ">java:comp/UserTransaction</prop>
    <prop key="hibernate.cache.use_query_cache">true</prop>
    <prop key="hibernate.cache.provider_class">org.hibernate .cache.EhCacheProvider</prop>
    </props>
    </property>

    </bean>


    <!-- Transaction manager for a single Hibernate SessionFactory (alternative to JTA) -->

    <!-- <bean id="transactionManager" class="org.springframework.orm.hibernate3.Hibernat eTransactionManager">
    <property name="sessionFactory">
    <ref local="sessionFactory"/>
    </property>
    </bean>-->

    <bean id="transactionManager" class="org.springframework.transaction.jta.JtaTran sactionManager">
    <property name="userTransaction">
    <bean class="org.springframework.transaction.jta.JotmFac toryBean"/>
    </property>

    </bean>

    <!-- ========================= DAO DEFINITIONS: IBATIS IMPLEMENTATIONS ========================= -->

    <!-- Spring DAO Entries -->




    <bean id="employeeServiceTarget" class="com.dupont.business.impl.EmployeeImpl">
    <property name="employeeDao" ref="employeeDao" />
    </bean>

    <bean id="employeeService" class="org.springframework.transaction.interceptor .TransactionProxyFactoryBean">
    <property name="transactionManager"><ref bean="transactionManager"/></property>
    <property name="target"><ref local="employeeServiceTarget"/></property>
    <property name="transactionAttributes">
    <props>
    <prop key="emp">PROPAGATION_REQUIRED</prop>
    </props>
    </property>
    </bean>

    <bean id="employeeDao" class="com.dupont.hibernate.impl.EmpDaoImpl">
    <property name="sessionFactory"><ref local="sessionFactory"/></property>
    </bean>



    </beans>


    Thanks in advance.

  • #2
    This forum is for the "Spring Integration" project. Please post this question in the Data Access forum.

    Comment


    • #3
      Also please use [ code][/code ] tags when posting code . Use the forum search as this question has been answered numerous times before.

      remove '<prop key="hibernate.current_session_context_class">thre ad</prop>' from your configuration that breaks proper integration.

      Comment

      Working...
      X