Transaction Mangement with Spring JTA

[rudresh kumar]

Hi All,

I am trying to persist the data and post a message to MDB (let us say 'responseMDB')

The transaction is started from MDB (Let us say 'request MDB'), within the On message i do persist as well as posting the message.

It works fine but in case of any exceptions the persistance/posting message are not rolled back.

I believe my transaction configuration is not correct.

Following are the details
MDB :- Container managed transaction

Spring Configuration :-

<bean id="myDataSource" class="org.springframework.jndi.JndiObjectFactoryBean" >
		<property name="resourceRef"><value>false</value></property> 
        <property name="jndiName">
            <value>jdbc/test</value>
        </property>
	</bean>	
	<bean id="mySessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource" ref="myDataSource" />
		<property name="mappingResources">
        <list>
            <value>./resource/employee.hbm.xml</value>
        </list>
    </property>
		<property name="hibernateProperties">

			<props>
				<prop key="hibernate.dialect">org.hibernate.dialect.OracleDialect</prop>
				<prop key="hibernate.show_sql">true</prop>
				<prop key="hibernate.transaction.factory_class">
              org.hibernate.transaction.CMTTransactionFactory
			</prop>
			<prop key="hibernate.transaction.manager_lookup_class">
              org.hibernate.transaction.WebSphereExtendedJTATransactionLookup
			</prop>				
			</props>
		</property>
	</bean>
	
	<bean id="myUserDAO" class="javabeat.spring.hibernate.EmployeeDao">
		<property name="hibernateTemplate">
        <ref bean="hibernateTemplate"/>    
    </property>
    </bean>
<bean id="hibernateTemplate" 
class="org.springframework.orm.hibernate3.HibernateTemplate">
    <property name="sessionFactory">
        <ref bean="mySessionFactory"/>
    </property>
</bean>
<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
    <property name="sessionFactory" ref="mySessionFactory"/>
  </bean>

Can i know what is it i am doing wrong

[Mark Spritzler]

Is there a reason why you are using the HibernateTemplate. If you are using Hibernate pre 3.1 version, then the template is helpful to hide boilerplate code. If you are using 3.1 or higher it gives you no benefits at all and writing straight Hibernate/JPA code is actually better and more portable than the template.

When it comes to messaging and transactions, there is only so far the transaction can be wrapped around. So it sound like the message is already sent to a queue before the transaction has rolled back, so therefore no longer available to revert.

But you haven't posted your MDB stuff and where your transaction boundary is or its settings to help more.

Mark

[rudresh kumar]

Hi Marks,

Firstly Thanks for your reply

Can i have the example/guide for the below
"If you are using Hibernate pre 3.1 version, then the template is helpful to hide boilerplate code. If you are using 3.1 or higher it gives you no benefits at all and writing straight Hibernate/JPA code is actually better and more portable than the template."

Following are my MDB settings

<message-driven id="Test">
			<ejb-name>Test</ejb-name>
			<ejb-class>ejbs.TestBean</ejb-class>
			<messaging-type>javax.jms.MessageListener</messaging-type>
			<transaction-type>Container</transaction-type>
			<message-destination-type>javax.jms.Queue</message-destination-type>
		</message-driven>

EJB Code

public void onMessage(javax.jms.Message msg) {
		try {
			SaveEmployee emp = new SaveEmployee();
				emp.save();//saves records		
			MessageSender sender = new MessageSender();			
				sender.run();//sends message
			
		} catch(Throwable t){
			t.printStackTrace();
		}
	}

[Mark Spritzler]

I don't see or understand how an EJB MDB is connected to your Spring configuration. They seem separate and therefore I see the MDB in a transaction from the JTA and App Server but not in the Spring transaction. I am missing something, or that is your problem is that they aren't connected. Also you are swallowing any exception and therefore the transaction won't rollback in the MDB.

Mark