Edit Question - KnowledgeHub

Title Body

I am wondering how to implement batch operations with my insert statements using MyBatis 3 & Spring 3? For example, here is what is currently being done: spring.xml: <bean id="jndiTemplateDatasource" class="org.springframework.jndi.JndiTemplate"> <property name="environment"> <props> <prop key="java.naming.factory.initial">${context.factory}</prop> </props> </property> </bean> <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> <property name="jndiTemplate" ref="jndiTemplateDatasource"/> <property name="jndiName" value="${connectionpool.jndi}"/> </bean> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource"/> </bean> <tx:annotation-driven transaction-manager="transactionManager"/> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="configLocation" value="classpath:mybatis-config.xml"/> </bean> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="com.test" /> </bean> MyService.xml: <insert id="insertMyRecord" parameterType="com.test.MyRecord" > insert into ... // code removed </insert> MyService.java: public interface MyService { public void insertMyRecord (MyRecord); } MyController.java: @Controller public class MyController { @Autowired private MyService myService; @Transactional @RequestMapping( .... ) public void bulkUpload (@RequestBody List<MyRecord> myRecords) { for (MyRecord record : myRecords) { myService.insertMyRecord(record); } } } <

Tags (comma-separated) Cancel