vendredi 17 avril 2015

Spring MVC JdbcTemplate Transactional Annotation does not work

I have two insert operation in one http post request. something like



@Service
public class StudentService {

@Transactional(rollbackFor = Exception.class, propagation = Propagation.REQUIRED)
public int create(final Student student) {
// insert into table 1

// insert into table 2 using id return from insert 1, but something BAD happen here
}
}


so, I added @Transactional at method level as shown above.


In order to make it work, I added this tx:annotation-driven



<tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true"/>


so my app-servlet.xml looks like



<?xml version="1.0" encoding="UTF-8"?>
<beans
xmlns="http://ift.tt/GArMu6"
xmlns:mvc="http://ift.tt/1bHqwjR"
xmlns:tx="http://ift.tt/OGfeU2"
xmlns:xsi="http://ift.tt/ra1lAU"
xmlns:p="http://ift.tt/1jdM0fE"
xmlns:context="http://ift.tt/GArMu7"
xsi:schemaLocation="
http://ift.tt/GArMu6
http://ift.tt/1cnl1uo
http://ift.tt/GArMu7
http://ift.tt/1ldEMZY
http://ift.tt/1bHqwjR
http://ift.tt/1kF4x7W
http://ift.tt/OGfeU2
http://ift.tt/KC395X">

<mvc:annotation-driven />
<mvc:resources mapping="/res/**" location="/res/" />

<context:component-scan base-package="com.app" />

<bean id="viewResolver" class="org.springframework.web.servlet.view.UrlBasedViewResolver">
<property name="viewClass" value="org.springframework.web.servlet.view.JstlView" />
<property name="prefix" value="/WEB-INF/jsp/" />
<property name="suffix" value=".jsp" />
</bean>

<bean id="dataSource" name="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://xxx:3306/AppDb" />
<property name="username" value="username" />
<property name="password" value="password" />
</bean>

<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>

<tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true"/>
</beans>


the component-scan will basically scan all class include controller, service, model, viewmodel, helper class etc.


If I remove the tx:annotation-driven, the @transactional won't work. But once I add this tx:annotation-driven, some error starts to appear, like



Error creating bean with name 'homeController': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private com.app.service.StudentService com.app.controller.HomeController.studentRepository; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'studentService' defined in file [/path/workspace/.metadata/.plugins/http://ift.tt/1Hzsbw2]: Initialization of bean failed; nested exception is java.lang.NoClassDefFoundError: org/springframework/cglib/transform/impl/MemorySafeUndeclaredThrowableStrategy



How can I make this @transactional work.


Aucun commentaire:

Enregistrer un commentaire