dimanche 1 mars 2015

how to rollback in entitymanager createNativeMethod

I am using native method of entity manager and I want to rollback when some error occurs.For this I tried @Transactional annotation but this does not rollback.Below is my sample code


controller



@Autowired
ServiceImpl ServiceImpl;

@RequestMapping("/saveinfo")
@ResponseBody
@Transactional
public String saveinfo(Long id)
{
ServiceImpl.saveInfo(id);
}


Service class



@Autowired
DAOImpl daoImpl;

@Transactional
public String saveinfo(Long id)
{
daoImpl.saveInfo1(id);
daoImpl.saveInfo12(id);
daoImpl.saveInfo12(id);

}


DAO class



@Override
public BigInteger saveInfo11() {

Query query = entityManagerUtil.entityManager().createNativeQuery("insert query");
return (BigInteger)query.getSingleResult();
}

@Override
public BigInteger saveInfo12() {

Query query = entityManagerUtil.entityManager().createNativeQuery("insert query");
return (BigInteger)query.getSingleResult();
}

@Override
public BigInteger saveInfo13() {

Query query = entityManagerUtil.entityManager().createNativeQuery("insert query");
return (BigInteger)query.getSingleResult();
}


Now in the above codes,


If I have some runtime error in saveInfo3() then I want to rollback methods of saveInfo1() and saveInfo2()


This is the way I did but it did not rollback,so Please tell me how to do


EDIT


I tried using



@Transactional(rollbackFor=MyException.class,propagation = Propagation.REQUIRED) and @Transactional(propagation = Propagation.REQUIRED) and

@Transactional(rollbackFor=MyException.class))


In all the 3 cases ,it did not rollback


Update



applicationcontext.xml



<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<beans xmlns="http://ift.tt/GArMu6"
xmlns:aop="http://ift.tt/OpNdV1"
xmlns:context="http://ift.tt/GArMu7"
xmlns:jee="http://ift.tt/OpNaZ5"
xmlns:tx="http://ift.tt/OGfeU2"
xmlns:xsi="http://ift.tt/ra1lAU"
xmlns:security="http://ift.tt/1c8inpe"
xmlns:mongo="http://ift.tt/13feL6M"
xmlns:task="http://ift.tt/LFBt0P"
xsi:schemaLocation="http://ift.tt/OpNdV1
http://ift.tt/QEDs1g
http://ift.tt/GArMu6
http://ift.tt/QEDs1e
http://ift.tt/GArMu7
http://ift.tt/QEDs1k
http://ift.tt/13feL6M
http://ift.tt/1iMF6wH
http://ift.tt/OpNaZ5
http://ift.tt/1j5lSTg
http://ift.tt/OGfeU2
http://ift.tt/1cQrvTl
http://ift.tt/1c8inpe
http://ift.tt/1fChGbz
http://ift.tt/LFBt0P
http://ift.tt/1iFJOtt">



<!--<context:annotation-config />-->
<context:spring-configured/>

<bean class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean" id="entityManagerFactory">
<property name="dataSource" ref="dataSource"/>
<property name="persistenceUnitName" value="persistenceUnit"/>
</bean>
<bean id="messageDigestPasswordEncoder" class="org.springframework.security.authentication.encoding.MessageDigestPasswordEncoder">
<constructor-arg value="SHA-256" />
</bean>

<bean class="org.springframework.jdbc.datasource.DriverManagerDataSource" id="dataSource">
<property name="driverClassName" value="${database.driverClassName}"/>
<property name="url" value="${database.url}"/>
<property name="username" value="${database.username}"/>
<property name="password" value="${database.password}"/>


</bean>










<tx:annotation-driven mode="aspectj" transaction-manager="transactionManager"/>
<context:property-placeholder location="classpath*:META-INF/database.properties"/>
<context:property-placeholder location="classpath*:META-INF/project.properties"/>

<bean class="org.springframework.orm.jpa.JpaTransactionManager" id="transactionManager">
<property name="entityManagerFactory" ref="entityManagerFactory"/>
</bean>

<bean id="propertiesUtil" class="com.work.project.utils.PropertiesUtil">

<property name="locations" >
<list>
<value>classpath*:META-INF/*.properties</value>

</list>
</property>

</bean>

<context:component-scan base-package="com.work.project">
<context:exclude-filter expression="org.springframework.stereotype.Controller" type="annotation"/>
</context:component-scan>



<task:executor id="myexecutor" pool-size="5" />
<task:annotation-driven executor="myexecutor"/>








</beans>


modified controller method



@Autowired
ServiceImpl ServiceImpl;

@RequestMapping("/saveinfo")
@ResponseBody
//Now I dont use transactional annotation in controller class
public String saveinfo(Long id)
{
ServiceImpl.saveInfo(id);
}


If any more information is required please ask


Aucun commentaire:

Enregistrer un commentaire