From feac983565c42f87f8fa57a9f8d729d4ccd286c3 Mon Sep 17 00:00:00 2001
From: "gu.martinm@gmail.com" <gu.martinm@gmail.com>
Date: Wed, 4 Mar 2015 11:58:41 +0100
Subject: [PATCH] Pseudo batch update with CASE should work on any data base.

---
 .../resources/de/example/mybatis/repository/mapper/AdCustomMapper.xml  | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/MyBatis/MyBatis-Spring/src/main/resources/de/example/mybatis/repository/mapper/AdCustomMapper.xml b/MyBatis/MyBatis-Spring/src/main/resources/de/example/mybatis/repository/mapper/AdCustomMapper.xml
index b51bd4a..6ad3b3f 100644
--- a/MyBatis/MyBatis-Spring/src/main/resources/de/example/mybatis/repository/mapper/AdCustomMapper.xml
+++ b/MyBatis/MyBatis-Spring/src/main/resources/de/example/mybatis/repository/mapper/AdCustomMapper.xml
@@ -20,7 +20,8 @@
   		</foreach>
   </update>
   
-    <update id="updateAdsBatchWithCase" parameterType="List">		
+    <update id="updateAdsBatchWithCase" parameterType="List">
+    	<!-- The same as updateAdsBatch but it doesn't require allowMultiQueries=true -->
     		UPDATE ad
     			SET
     			company_id = CASE id
-- 
2.1.4